User Account

All Pages

What is the maximum car payment and mortgage payment

Assignment Help Financial Management
Reference no: EM13305161

The scenario is designed to help you determine and evaluate the payment amount of a car loan and a mortgage, based on the assumption that your household income is $36,000 per year or $3,000 per month. Based on your income, you may spend 28% of your monthly income on housing, and 10% on a car loan. You are to put a 3% down payment on the house and a 10% down payment on the car.

1. What is the maximum car payment and mortgage payment you can afford with the following conditions: your monthly household income, 10% for the car payment, and 28% for the mortgage payments?

2. Assume a 10% down payment on the car and a 3% down payment on the house. Also, assume that you can get financing for the car at 7% for 60 months, and the house can be financed at 5% for 30 years.

How much could you spend on the car and the house? You must submit your calculations in a Microsoft Excel document showing how answers were reached.

3. Create a complete amortization schedule for the car, using the information in questions 1 and 2.

4. Discuss the distributions of principal, interest and the balance over the life of the loan.

Over the life of the loan, the amount of the $300 that goes to interest gets smaller and the amount that goes to principal gets larger.

Attachment:- Assignment.rar

Verified Expert

Reference no: EM13305161

Questions Cloud

Construct a decision tree to help analyze this problem : In the absence of any market data, the best the physicians can guess is that there is a 50-50 chance the clinic will be successful. Construct a decision tree to help analyze this problem. What should the medical professionals do?
Find the length of the rod at the freezing point of water : An aluminum-alloy rod has a length of 10.007 cm at 16.600 °C and a length of 10.023 cm at the boiling point of water. find the length of the rod at the freezing point of water
What is the speed of the ball when it strikes the ground : A 150g ball is thrown vertically upward from a window 10m above the ground at speed of 30 m/s What is the speed of the ball when it strikes the ground
Should caroline candles buy the equipment at this time : The candle-making equipment is expected to increase the cash flows by $27,000 in the first year, $48,000 in the second year, and $69,000 a year for the following two years. Should Caroline's Candles buy the equipment at this time? Why or why not?
What is the maximum car payment and mortgage payment : What is the maximum car payment and mortgage payment you can afford with the following conditions: your monthly household income, 10% for the car payment, and 28% for the mortgage payments?
Determine the force in each member of the truss and state : Determine the force in each member of the truss and state if it is in tension or compression. Set P=400 lb and d=4 ft.
Determine the electric potential induced across the rod : A small conductive rod of length 1.4 m moves with a constant velocity v=11 m/s in a direction parallel to a long wire carrying a current of 34 A. Calculate the electric potential induced across the rod
Estimate travel time for water to flow between piezometers : The piezometers are 280 m apart. The difference in piezometric head bewteen the two is 1.4 m. The aquifer hydraulic conductivity is 50 m/d and the porosity is 20%.
Find the speed of the block after being hit by the bullet : A .005 kg block having a velocity of 500 m/s hits a 5 kg wooden block at rest on a horizontal at an angle of 30 degrees from the horizontal

Reviews

Write a Review

Financial Management Questions & Answers

  Nowc and dcf analysis

Calculate the required investment in NOWC for the three years of the project.  Use these estimates of NOWC to calculate the Cash Flow from NOWC.

  Explain what is securitization

What is securitization? What are the benefits that banks can get from it? What impact is securitization likely to have on the quality of assets that banks keep in their portfolio?

  How current and projected future economic conditions

Examine how current and projected future economic conditions affected your selections for the portfolio. Discuss at least three specific, relevant economic factors.

  Prepare the financial statements

Prepare a three page paper that responds to the coca-cola research case questions Using the web, access the Coca-Cola Company's 2010 financial statements

  Nominal and real interest rates

Write a short essay of 350-400 words for each of the following questions. Where possible, illustrate with an appropriate example in your answer. You must support your discussion with appropriate references.

  Explain manage potential conflicts of interest

Financial Analysis (called Security Analysis on Wall Street) can be less than totally objective. How big a problem do you think this is? What can be done to manage potential conflicts of interest? Maybe we just have to live with it and search out ..

  Stock valuation and revenue recognition

The validity of the Financial Director's proposed treatment of stock valuation and revenue recognition, referring to relevant International Accounting Standards as appropriate.

  Evaluate the value of leased assets

Estimate the value of leased assets. If you misestimate the average life to be 10 years, how large will the valuation error be?

  Compare the hedging alternatives for the myr

Compare the hedging alternatives for the MYR with a scenario under which Yankee remains unhedged. Do you think Yankee should hedge or remain unhedged? If Yankee should hedge, which hedge is most appropriate?

  How did the backgrounds of both geithner and bernanke serve

How did the backgrounds of both Geithner and Bernanke serve to assist or hinder them in understanding and acting to solve the problems?

  What is the default risk premium on corporate bonds

There are questions on Financial Management and Markets. Like What is the default risk premium on corporate bonds?

  How much of this will be debt and equity

Compute the weighted average cost of capital on the first $250 million of funds and saven Travel will need to raise $150 of additional capital for expansion. How much of this will be debt and equity?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd