Financial formulae
Hello!
I have:
A1 Value of loan
B1 annual interest
C1 60 Months (Period)
D1 Loan amortization (to intercalate)
E1 (Formulae to calc montly income of interest)
F1 (Formulae to calc montly income of loan)
G1 =Sum(E1+F1)
Whe
1st income = 100% interest and 0% amortization;
Last income = 0% interest and 100% amortization.
Is it possible with excel formulae, please?
Thanks in advance.
an
|