It is the "PV" formula shown in Excel help.
("Returns the present value of an investment")

=PV(rate, nper, pmt, fv, type)
=PV(0.13/12, 240, -2000, 0, 0)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"EricB"
wrote in message
Hi Jim
Can you assist with the actual formula?
Regards
EricB



"Jim Cone" wrote:
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