Question: Problem 5: You borrow $285,000 for 30 years. You get a 4.6% APR compounded monthly. Complete the Excel table using the PMT function, the
Problem 5: You borrow $285,000 for 30 years. You get a 4.6% APR compounded monthly. Complete the Excel table using the PMT function, the PPMT function, and any other formulas you need to fill in columns B, C, D, E. Then complete cells E364 and E365 by filling in the totals. payment month amount 1 2 3 4 5 amount you pay towards principle this month interest you pay this month new balance Problem 6: You borrow $285,000 for 20 years. You get a 4.6% APR compounded monthly. Complete the Excel table using the PMT function, the PPMT function, and any other formulas you need to fill in columns H, 1, JK Then complete cells K364 and K365 by filling in the totals. payment month amount 1 2 3 4 5 amount you pay towards principle this month Interest you pay this month new balance
Step by Step Solution
3.38 Rating (151 Votes )
There are 3 Steps involved in it
Monthly payment is PMT PV i1H1h 111 where PV is the loan am non ... View full answer
Get step-by-step solutions from verified subject matter experts
