468,765 Members | 801 Online

# Mortgage Calculation using C# .Net

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.

Nov 17 '05 #1
1 3810
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

"Grant_S" <su*************@gmail.com> wrote in message
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.