Team, please create an amortization schedule which shows different dollar amounts you borrow at different interest...

 

Transcribed Image Text:

Team, please create an amortization schedule which shows different dollar amounts you borrow at different interest rates. Assumptions are as follows: Assume a 25, 30, 35 and 40 year loan Interest rates from 2.5% to 4.5% in 1/4 increments (2.5% 2.75%, etc) Borrowing starting at 100,000 to 300,000 in 10,000 dollar increments (100,000, 110,000, etc) te: Create and excel table for this exercise. Also refer to chapter 1 for the formula's if needed Team, please create an amortization schedule which shows different dollar amounts you borrow at different interest rates. Assumptions are as follows: Assume a 25, 30, 35 and 40 year loan Interest rates from 2.5% to 4.5% in 1/4 increments (2.5% 2.75%, etc) Borrowing starting at 100,000 to 300,000 in 10,000 dollar increments (100,000, 110,000, etc) te: Create and excel table for this exercise. Also refer to chapter 1 for the formula's if needed

Answer rating: 100% (QA)

solution Introduction Amortization table for 25 years loan has shown on different interest rate and ... View the full answer