Welcome to Westonci.ca, your ultimate destination for finding answers to a wide range of questions from experts. Get detailed and accurate answers to your questions from a community of experts on our comprehensive Q&A platform. Get precise and detailed answers to your questions from a knowledgeable community of experts on our Q&A platform.

pat radigan wants to purchase a new home for $312,500. pat puts 20% down and will finance the remainder of the purchase. compare the following two mortgage options he has: 20 years at 6.5% or 25 years at 7.0%.

Sagot :

Difference in interest paid = $82,740.52

Total interest paid for 25 year loan interest - Total interest paid for 20 year loan interest

According to the given information

A.

Monthly payment for 20 year mortgage [tex]& $=$ PMT $\left(6.5 \% / 12,20^* 12,-312500^* 0.8\right)$ & $=$ PMT $($ rate, nper, $-$ pv $)$ \[/tex]\

Monthly payment for 25 year mortgage [tex]& $=$ PMT $\left(7 \% / 12,25^* 12,-312500^* 0.8\right)$ & $=$ PMT(rate,nper,-pv) \\[/tex]

B

Total cost of interest for 20 year mortgage [tex]& $=(\mathrm{B} 2 * 20 * 12)-(312500 * 0.8)$ \\[/tex]

Total cost of interest for 25 year mortgage [tex]$=(\mathrm{B} 3 * 25 * 12)-(312500 * 0.8)$ &[/tex]

C.

Difference in interest paid [tex]& $=\mathrm{B} 7-\mathrm{B} 6$ &[/tex] = Total interest for 25 year loan-total interest for 20 years

A.

Monthly payment for 20 year mortgage [tex]& $\$ 1,863.93$ & $=$ PMT(rate,nper,-pv) \\[/tex]

Monthly payment for 25 year mortgage [tex]& $\$ 1,766.95$ & $=$ PMT(rate,nper,-pv) \\[/tex]

B.

Total cost of interest for 20 year mortgage = [tex]& $\$ 197,343.88$ & $=$[/tex]  total monthly payments-loan taken

Total cost of interest for 25 year mortgage = [tex]& $\$ 280,084.40$ & $[/tex] = total monthly payments-loan taken

C.

Difference in interest paid = $82,740.52

Total interest paid for 25 year loan interest - Total interest paid for 20 year loan interest

To know more about Interest

https://brainly.com/question/29480777

#SPJ4