91.2k views
3 votes
Create amortization table in Microsoft Excel. Please make sure there are loan, interest and term input by the user. 2) Create sinking fund table in Microsoft Excel. Please make sure there are loan, interest and term input by the user. 3) Compare the amortization and sinking fund table in Microsoft Excel and give your explanation on the comparison. Please make sure there are loan, interest and term input by the user.A man made a loan of $20,000 to be paid in equal payments at the end of each year

for 6 vears. If the interest is 7 % compounded annuallv, construct an amortization schedule.
In order to accumulate at the end of 5 vears an education fund for his son, a father
deposits $10,000 in a bank at the end of each vear. Find the final amount of the fund if it is
invested at 7% compounded annually. Make a sinking fund schedule.

1 Answer

3 votes

Answer:

Explanation:-

User LJP
by
7.9k points