Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need a formula that will calculate the rate of return of an investment for
any period with multiple additions and withdrawals. For example: 7/31/06 $100,000 Beginning balance of investment 7/04/06 (5,000) Withdrawal 7/11/06 10,000 Deposit 7/16/06 (1,250) Withdrawal 7/27/06 $ 1,900 Deposit 8/31/06 $106,125 Ending value of investment (includes appreciation of $475) What is the rate of return for the month? or if this was for any period of time (6-months, year etc)? Thanks...Craig |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why Does This Formula Return an Error?? | New Users to Excel | |||
help needed for Internal rate of return | Excel Worksheet Functions | |||
bank cal for interest on cd | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions |