Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
IRR weekly basis cashflow
I wnt to calculate IRR with weekly basis cash flow in micro financing. Principal investment is $ 5000.00 and weekly installment is $115 for 50 weeks. I want know the formula. simple formula is not working here since in Excel the default is may be yearly basis. -- alimirfarhad ------------------------------------------------------------------------ alimirfarhad's Profile: http://www.excelforum.com/member.php...o&userid=12185 View this thread: http://www.excelforum.com/showthread...hreadid=400751 |
#2
|
|||
|
|||
Use:
=(1+RATE(50,-115,5000))^52-1 will give you 33.87% or simply =RATE(50,-115,5000)*52 will give you 29.25% ... this is an approximation Mangesh "alimirfarhad" wrote in message news:alimirfarhad.1umnyg_1125489941.9302@excelforu m-nospam.com... I wnt to calculate IRR with weekly basis cash flow in micro financing. Principal investment is $ 5000.00 and weekly installment is $115 for 50 weeks. I want know the formula. simple formula is not working here since in Excel the default is may be yearly basis. -- alimirfarhad ------------------------------------------------------------------------ alimirfarhad's Profile: http://www.excelforum.com/member.php...o&userid=12185 View this thread: http://www.excelforum.com/showthread...hreadid=400751 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I display weekly intervals in Excel? | New Users to Excel | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
need to make a template for weekly calendar ASAP that shows pictu. | Excel Discussion (Misc queries) | |||
Teplate to Track sales of multiple products on per client basis. | Excel Discussion (Misc queries) | |||
Weekly data into Calendar Weeks | Excel Worksheet Functions |