Use excel for all calculations
Mortgage Analysis You are planning to purchase a house th...
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
Other questions on the subject: Business
Business, 21.06.2019 21:30, Ayomide19
Daniel owns 100 shares of abc corporation's common stock. abc uses the fair value option, and recent declines in the firm's credit rating have caused the value of the firm's outstanding bonds payable to drop by 10%. daniel feels this is good news, but he wants to know what you think about the situation. which of the following represents your best response? a : "this situation may be positive for you in that the change in abc's credit standing indicates that the value of the firm's assets is likely increasing. however, the drop in bond value may negate any positive effects on your bottom line, because it means your claim on the firm's assets is simultaneously decreasing." b : "actually, this is bad news all around. the drop in the value of abc's bonds payable means shareholders' claims on the firm's assets have decreased. moreover, abc's declining credit rating means that the firm's assets are probably also dropping in value, thus magnifying your losses even more." c : "on the surface, this seems like good news because it means your claim on the firm's assets has increased. however, the drop in creditworthiness may also indicate that abc's assets are declining in value, thus offsetting any gains associated with the drop in bonds payable." d : "you're right! this is good news because it means that abc's debtholders have a decreased claim on the firm's assets. as a result, the firm's existing shareholders"like you"have seen their claim on the firm's assets increase."
Answers: 2
Business, 22.06.2019 04:30, lizdeleon248
Jennifer purchased a house in a brand new development in the outskirts of town. when her house was built, the nearest fire department was nearly 20 miles away. as her neighborhood developed, the density of the community called for a new fire department 1.5 miles away. what effect will the new fire station have on her homeowners insurance premium? a. a new fire department will be more demanding on local taxes. her annual premium will go up. b. the location of a fire department has no bearing on the value of her house. her annual premium will stay the same. c. the new fire department will reduce the risk of financial loss in her home. her annual premium should decrease. d. with a fire department so close (less than 5 miles), financial risk on jennifer’s home practically disappears. she will not need to pay insurance anymore.
Answers: 1
Business, 22.06.2019 11:30, laylay120
You've arrived at the pecan shellers conference—your first networking opportunity. naturally, you're feeling nervous, but to avoid seeming insecure or uncertain, you've decided to a. speak a little louder than you would normally. b. talk on your cell phone as you walk around. c. hold an empowered image of yourself in your mind. d. square your shoulders before entering the room.
Answers: 2
Do you know the correct answer?
Questions in other subjects:
Mathematics, 18.03.2020 02:57
Social Studies, 18.03.2020 02:57
