I am not sure if this is the appropriate forum for the
question.Hopefully any discussion will be of use to C# developers
involved in financial systems.
I have calculated monthly payment (Capital And Interest payments) for a
bank loan. Below is the formula:
Double dIntRate= 6.5/100;
Double dYears = 20;
Double dV= 1/1-dIntRate;
Double dX= Math.Pow(dV,dYears);
Double dA = (1-dX)/(dIntRate/100);
Double dAnnualCapAndInterestPayment = dLoanValue/dA;
Double dMonthlyPayment = dAnnualCapAndInterestPayment/12;
I need to list, for each of the (20*12) months, the amount of interest
for each monthly payment. Can someone help me with the formula I might
need to achieve this (alternatively how much capital contibutes to each
monthly payment.
Thanks in advance.