C SCENARIO: The ABC Corporation is acquiring a new warehouse by borrowing $800,000 long-term notes payable...

Transcribed Image Text:

C SCENARIO: The ABC Corporation is acquiring a new warehouse by borrowing $800,000 long-term notes payable from a commercial bank. The annual interest rate is 4.25% and the loan duration is 20 years. TASK: Using Excel calculate the monthly payment on the new warehouse and complete a full amortization schedule for all 240 payments. Include columns showing: PMT#, Monthly PMT, Monthly Interest, Cumulative Interest, Monthly Principal, and Remaining Principal Balance. Create a new tab and new amortization schedule showing 3.5% interest and compare total interest paid to total interest paid on the 4.25% loan. Create a new tab and new amortization schedule showing 7.5% interest and compare total interest paid to total interest paid on the 4.25% loan Create a new tab with 4.25% interest but a loan duration of only 15 years and compare total interest to total interest paid on the initial 20-yr loan with 4.25% interest. Submit Excel file in the AMORTIZATION SUBMISSION LINK by Sunday at 11:59pm. C SCENARIO: The ABC Corporation is acquiring a new warehouse by borrowing $800,000 long-term notes payable from a commercial bank. The annual interest rate is 4.25% and the loan duration is 20 years. TASK: Using Excel calculate the monthly payment on the new warehouse and complete a full amortization schedule for all 240 payments. Include columns showing: PMT#, Monthly PMT, Monthly Interest, Cumulative Interest, Monthly Principal, and Remaining Principal Balance. Create a new tab and new amortization schedule showing 3.5% interest and compare total interest paid to total interest paid on the 4.25% loan. Create a new tab and new amortization schedule showing 7.5% interest and compare total interest paid to total interest paid on the 4.25% loan Create a new tab with 4.25% interest but a loan duration of only 15 years and compare total interest to total interest paid on the initial 20-yr loan with 4.25% interest. Submit Excel file in the AMORTIZATION SUBMISSION LINK by Sunday at 11:59pm.