Business, 16.04.2020 03:17 DiamondSharp9860

Use excel for all calculations

Mortgage Analysis You are planning to purchase a house that costs $747,500. You plan to put 20% down and borrow the remainder. You have been pre-approved, based on your credit score and income, for a 30-year loan with an interest rate of 4.03%.

1. Use function "PV" to calculate the loan amount given a payment of $2900 per month. What is the most that you can borrow?

2. Use function "PMT" to calculate your mortgage payment.

3. Use function "RATE" to calculate the interest rate given a payment of $2600 and a loan amount of $598,000.

4. For each scenario, calculate the total interest that will have been paid once the mortgage is paid off. (There is not a function for this, enter the formula into the cell.)

5. For each scenario, calculate the total cost of the home purchase. (Down payment plus principle (loan amount) plus interest.)

6. Assume that you plan to pay an extra $500 per month on top of yoiur mortgage payment, calculate how long it will take you to pay off the loan given the higher payment. (Use interest rate of 4.03%). Calculate how much interest you will pay in total. Compare this to the total interest value that you calculated for #2. You want to determine whether or not you should save some of your money and put only 10% down on my house. Because you are only putting 10% down, lenders require that you purchase private mortgage insurance (PMI). Assume that your annual PMI premium is .52% of the mortgage amount. Divide this by 12 to get the monthly payment. Use Excel for all calculations.

7. Calculate your total monthly payment (mortgage payment plus PMI). (The mortgage amount will be 90% of the price of the home,

8. Calculate the total cost of financing your home purchase (interest plus PMI).

9. Assume that you can stop paying mortgage insurance after 8 years given that the value of your house will appreciate and the balance of your mortgage will decrease. Calculate the total cost of the home purchase. (Down payment plus principle (loan amount) plus interest plus PMI.)

10. Compare this to the costs associated with a 20% down payment.

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 03:00

Match each item to check for while reconciling a bank account with the document to which it relates. (there's not just one answer) 1. balancing account statement 2. balancing check register a. nsf fees b. deposits in transit c. interest earned d. bank errors

Answers: 3

Answer

Business, 22.06.2019 08:30

An employer who is considering hiring eva has asked donna, eva’s former supervisor, for a report on eva. in truth, eva’s work for donna has been only average. however, eva is donna’s friend, and donna knows that eva probably will not get the job if she says anything negative about eva, and donna knows that eva desperately needs the job. further, donna knows that if the situation were reversed, she would not want eva to mention her deficiencies. nevertheless, it has been donna’s policy to reveal the deficiencies of employees when she has been asked for references by employers, and she knows that some of eva’s faults may be bothersome to this particular employer. finally, this employer has leveled with donna in the past when donna has asked for a report on people who have worked for him. should donna reveal deficiencies in eva’s past performance? (remember to use one of the three moral theories acceptable for this test to solve this dilemma. any discussion of any personal opinion, religious perspective, or theory other than the moral theories acceptable for this test will result in a score of "0" for this question.)

Answers: 1

Answer

Business, 22.06.2019 14:30

United continental holdings, inc., (ual), operates passenger service throughout the world. the following data (in millions) were adapted from a recent financial statement of united. sales (revenue) $38,901 average property, plant, and equipment 17,219 average intangible assets 8,883 1. compute the asset turnover. round your answer to two decimal places.

Answers: 2

Answer

Business, 22.06.2019 19:40

An increase in the market price of men's haircuts, from $16 per haircut to $26 per haircut, initially causes a local barbershop to have its employees work overtime to increase the number of daily haircuts provided from 20 to 25. when the $26 market price remains unchanged for several weeks and all other things remain equal as well, the barbershop hires additional employees and provides 40 haircuts per day. what is the short-run price elasticity of supply? nothing (your answer should have two decimal places.) what is the long-run price elasticity of supply? nothing (your answer should have two decimal places.)

Answers: 1

Answer

You know the right answer?

Use excel for all calculations

Mortgage Analysis You are planning to purchase a house th...

Questions