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?

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?

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?

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?