Problem 5: You borrow $285,000 for 30 years. You get a 4.6% APR compounded monthly. Complete...

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

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