View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Capital Calculation


Loan: $170,710
Interest rate: 13.00 %
Term: 20 years
Payments per year: 12
Number of payments: 240
Payment at end of period.
Payment: $2,000.00
Total payments: $480,000
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(see the Calculate Payments add-in)



"EricB"

wrote in message
Hi
I need to calculate capital from a given repayment, term and interest rate.
i.e.
Repayment 2.000
Term 240 months
Interest 13% Per annum
Result ?? (+/- 172,560)
Any takers?
Regards
EricB