Scenario: Loan Amortization

A company takes out a loan of $200,000 with an annual interest rate of 5%, to be paid back over 5 years with annual payments.

Requirements:

1. Create an amortization schedule for the loan.
2. Calculate the total interest paid over the life of the loan.
3. Determine the principal paid in the third year.
4. Calculate the remaining balance after the fourth payment.