I need help to make a function in Excel to do an annuity table for 218 month
showing each month the monthly payment divided in 2 figures: the down payment
for the loan and amount of the interest. The loan is 100.000 DDK; the annual
interest rate is 5%, the number of payments is 218 and the monthly payment
700 DDK. Ill be happy if you can help me.
Chip