Capital Calculation

E

EricB

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
 
J

Jim Cone

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"
<[email protected]>
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XIRR vs. IRR Function 11
Calculating interest due on late loan payments 1
PMT 2
Turning off automatic calculation 0
Repaymen of loan excel sheet with grace period etc... 7
When amortising a loan based using an IRR rate, the total interestpaid fall short. 0
Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
PPMT Function Repost 12

Top