Question

You've decided to buy a house that is valued at $1 million. You have $250,000 to use as a down payment on the house, and want to take out a mortgage for the remainder of the purchase price. Your bank has approved your $750,000 mortgage, and is offering a standard 30-year mortgage at a 12% fied nominal interest rate (caled the loan's annual percentage rate or APR). Under this loan proposal, your mortgage payment will be month. (Note: Round the final value of any interest rate used to four decimal places.) per Your friends suggest that you take a 15-year mortgage, because a 30-year mortgage is too long and you will pay a lot of money on interest. If your bank approves a 15-year, $750,000 loan at a fixed nominal interest rate of 12% (APR), then the difference in the monthly payment of the 15-year mortgage and 30-year mortgage will be ? (Note: Round the final value of any interest rate used to four decimal places.) It is likely that you von't like the prospect of paying more money each month, but if you do take out a 15-year mortgage, you will make far fewer payments and will pay a lot less in interest. How much more total interest will you pay over the life of the loan if you take out a 30-year mortgage instead of a 15-year mortgage? $1,157,025.60 O $1,365,290.21 O $1,480,992.77 O $1,596,695.33 Which of the following statements is not true about mortgages? O Every payment made toward an amortized loan consists of two parts-interest and repayment of principal. O If the payment is less than the interest due, the ending balance of the loan will decrease O Mortgages are examples of amortized loans. O The ending balance of an amortized loan contract will be zero.

I'm struggling with formulas on mortgages so please show the work, thank you

Answer 1

30 Year mortgage 15 Year mortgage Amount saved Monthly payment 7,714.59 $ 9,001.26 -PMT(12%/12,30*12,-750000,0)| -PMT(12%/12,15*12;750000,0) Total number of payments 360 -30*12 180 -15*12 Total monthly payments value 2,777,252$ 1,620,2217 -180*9001.26 -360*7714.59 Less: Loan value 750,000.00 S 750,000.00 Total interest paid 2,027,252 $ 870,227 1,157,025.60 Monthly payment - 30 Years Monthly pavment- 15 Years S More interest paid "If the payment is less than the interest due, the ending balance of the loan will decrease 7,714.59 9,001.26 $1,157,025.60 2027252.4-870226.8