solve question number 5 and 7 Part 1: Complete the following showing your set-up
ID: 2588150 • Letter: S
Question
solve question number 5 and 7
Explanation / Answer
a) Buying price $220,000.00 Less: 20% Down Payment $44,000.00 Mortgage amount $176,000.00 b) Loan (PV) $176,000.00 Period = 30 x 12 360 Rate = 6.5%/12 0.54% Monthly payment = PMT(rate,period,-PV) $1,112.44 c) Loan (PV) $176,000.00 Period = 15 x 12 180 Rate = 6.5%/12 0.54% Monthly payment = PMT(rate,period,-PV) $1,533.15 d) Total Interest = ($1,112.44 x 360 ) - $176000 $224,478.30 e) Total Interest = ($1,533.15 x 180 ) - $176000 $99,966.81 f) Savings = ($224,478.30 - $99,966.81) $124,511.49
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.