FV formula

W

wd

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 are:
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?
 
J

John C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top