A corporation agreed to loan one of its subsidiaries $100,000 for three year. The note states an interest rate of 5% with annual compounding. $25,000 payments are to be made at the end of years 1 and 2, with the remaining balance to be paid at the end of year 3. Calculate the amount of interest the subsidiary will pay each year. Show work on excel