Thread: FV formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default FV formula

Do we get the passing grade if we can answer it?
--
** John C **

"wd" wrote:

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?