How to calculate total interest on 12 month loan with early payments

K

KG

I would like to calculate the total interest earned on a 12 month loan that
gets paid back in 6 equal, monthly payments in months 7-12. Each of the 6
equal, monthly payments will include 1/6 of the return on investment. Here
is a scenario:

Capital Invetsted = $25,000
Return on Investment (20%) = $5,000
Total Repayment = $30,000
6 Equal Payments = $5,000 ($30,000 / 6)

Payment schedule:
Month
1 $0
2 $0
3 $0
4 $0
5 $0
6 $0
7 $5,000
8 $5,000
9 $5,000
10 $5,000
11 $5,000
12 $5,000
 
R

Rich Carreiro

KG said:
I would like to calculate the total interest earned on a 12 month loan that
gets paid back in 6 equal, monthly payments in months 7-12. Each of the 6
equal, monthly payments will include 1/6 of the return on investment. Here
is a scenario:

Capital Invetsted = $25,000
Return on Investment (20%) = $5,000
Total Repayment = $30,000
6 Equal Payments = $5,000 ($30,000 / 6)

The total interest is obviously $5000. You lent $25000 and were
paid back $30000. Or are you asking about what the annualized
rate of return is? If the latter, just use the XIRR() function
of Excel or something similar in another spreadsheet or financial
calculator. Anyhow, for the scenario you specify, the annualized
rate of return is 25.998%.
 

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

Top