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

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

1 Expert Approved Answer
Step: 1 Unlock

Monthly payment is PMT PV i1H1h 111 where PV is the loan am non ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!