Question: Saved Question 2 (40 points) Fountain Corp will take a loan of 330,000.00 that is to be amortized by making payments at the end of
Saved Question 2 (40 points) Fountain Corp will take a loan of 330,000.00 that is to be amortized by making payments at the end of quarter for 26 years. Interest on the debt is 12% compounded quarterly, Note: the number in brackets shows the points value for that blank. 1 - Calculate the amount of the semi-annual loan payments. Round to 2 decimal places 2-Using the AMORT function, find the values for the blanks in the table below, Amount paid Interest paid Principal Paid Balance Payment # 0 1 per calculation 9,900.00 479.87 329,520.13 2 15 9654.02 per calculation 321074.94 27 9344.99 3 per calculation 1034.88 47 per calculation 1869.11 281822.73 5 FINAL 8 9 Total Interest Paid
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
