| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate IRR from a monthly income stream
Trying to get an irr for an 18 month income stream, with all the income in
the last 3 months. Thanks for your help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to calculate IRR from a monthly income stream
Put the investment in cell A1 AS A NEGATIVE
Fill the next 18 rows with the actual cash flows. If there are none for the first 15, just enter zeros. Then use =IRR(a1:A19)*12 "rflegeis" wrote: Trying to get an irr for an 18 month income stream, with all the income in the last 3 months. Thanks for your help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to calculate IRR from a monthly income stream
"Duke Carey" wrote:
"rflegeis" wrote: Trying to get an irr for an 18 month income stream, with all the income in the last 3 months [....] =IRR(a1:A19)*12 Do financial analysts simply multiply by 12, as you did? Or if they compute the effective annual rate compounded monthly: =FV(IRR(A1:A19),12,,-1)-1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate total interest earned on a loan and monthly payment | Excel Worksheet Functions | |||
| Earn $100,000.00 monthly income with only $5.99 investment | Links and Linking in Excel | |||
| how to use if function to calculate common cost in income stateme. | Excel Worksheet Functions | |||
| How do you calculate rate of return on monthly cash flows | Excel Worksheet Functions | |||
| Vlookup and Indexing in excel | Excel Worksheet Functions | |||
Linear Mode
