Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FV Formula
Results of Property Investment
Dollars Invested $1,750,000 Years Holding Property 3 Investment Growth Rate (6 Months) 15% Value of Investment in 3 Years $5,315,898 Formula I used: =FV(B20/12,B19,-B18,,0) I can't figure out where does the 6months fit in the equation. Can someone assist? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FV Formula
Please don't double post, and do we get the passing grade if we answer it?
-- ** John C ** "wd" wrote: Results of Property Investment Dollars Invested $1,750,000 Years Holding Property 3 Investment Growth Rate (6 Months) 15% Value of Investment in 3 Years $5,315,898 Formula I used: =FV(B20/12,B19,-B18,,0) I can't figure out where does the 6months fit in the equation. Can someone assist? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FV Formula
Hi,
I presume they mean the the 6 month rate is 15% so the monthly rate would be 15%/6 -- Thanks, Shane Devenshire "wd" wrote: Results of Property Investment Dollars Invested $1,750,000 Years Holding Property 3 Investment Growth Rate (6 Months) 15% Value of Investment in 3 Years $5,315,898 Formula I used: =FV(B20/12,B19,-B18,,0) I can't figure out where does the 6months fit in the equation. Can someone assist? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FV Formula
*sigh*, thought there was group etiquette of not giving answers to students?
-- ** John C ** "ShaneDevenshire" wrote: Hi, I presume they mean the the 6 month rate is 15% so the monthly rate would be 15%/6 -- Thanks, Shane Devenshire "wd" wrote: Results of Property Investment Dollars Invested $1,750,000 Years Holding Property 3 Investment Growth Rate (6 Months) 15% Value of Investment in 3 Years $5,315,898 Formula I used: =FV(B20/12,B19,-B18,,0) I can't figure out where does the 6months fit in the equation. Can someone assist? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|