Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FV formula
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FV formula
"A"
"John C" wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FV formula
I was using sarcasm, sorry. Read your MS help on the FV function, I think you
will eventually get it. As a 'rule', albeit there are exceptions, this Help community is for people who need help in jobs and at home, insofaras students go, however, that is why they are in a class, and they are supposed to learn on their own, otherwise it would be akin to cheating. sorry. -- ** John C ** "wd" wrote: "A" "John C" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|