Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Fred Smith
 
Posts: n/a
Default How to calculate total interest on 12 month loan with early payments

You want XIRR (it's in the Analysis Toolpak -- if you haven't loaded it,
goto ToolsAddins)

Assume A1:A7 has your seven cash flows (-25 plus your 6 repayments)
Assume B1:B7 has your seven dates (eg, 1/15/05, 7/15/05, 8/15/05, etc)

Result = XIRR(a1:a7,b1:b7)

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"KG" wrote in message
news:E40Dd.721967$%k.504818@pd7tw2no...
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate total interest earned on a loan and monthly payment Matt Stanley Excel Worksheet Functions 4 May 4th 23 03:42 AM
Loan amortization schedule with bi-monthly payments McCarthy_MF Excel Worksheet Functions 0 December 9th 04 10:45 PM
how to calculate total months from month/year patti Excel Discussion (Misc queries) 1 December 8th 04 10:50 PM
calculate month from week number ankman Excel Worksheet Functions 2 November 24th 04 02:27 AM
Total number of each month in a column of dates GeorgeF. Excel Worksheet Functions 1 November 19th 04 07:10 PM


All times are GMT +1. The time now is 10:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"