468,765 Members | 801 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,765 developers. It's quick & easy.

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.

Thanks in advance.

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
news:11**********************@g44g2000cwa.googlegr oups.com...
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.

Nov 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by cameron | last post: by
1 post views Thread by phjones | last post: by
1 post views Thread by phjones | last post: by
3 posts views Thread by ghostrider | last post: by
1 post views Thread by dylbin | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.