Mortgage Calculation using C# .Net

  • Thread starter Thread starter Grant_S
  • Start date Start date
G

Grant_S

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.
 
Hi Grant,

The following web pages demonstrates an Amortization calendar, and has links
to documentation that explains how the formulas are derived and applied in
it:

http://ray.met.fsu.edu/~bret/amortize.html

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
If you push something hard enough,
it will fall over.
- Fudd's First Law of Opposition
 
Back
Top