Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Evaluate the future value of the investment in 3 yrs given the 15% grown rate
stated in the problem. The property will be purchased in one lump sum investment at the beginning of the first year. My calculation a Investment $1,750,000 Yrs hold property - 3 Interest growth rate (6months) 15% Value of invest in 3 yrs $ 5,315,898 The formula I used is: =FV(B20/12,B19,-B18,,0) I can't figure out where does the 6month fit in. Can someone assist? |