Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for payout & interest
I have a question of which formula works for this example:
I have the following: Invest $650,000.00 put in money-market which compounds monthly pays interest of 5.5%-annually. What is my 20 year earnings?Yes if all stays the same for 20 years -- Learning is uphill & I am just a climbing |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for payout & interest
Hi,
=650000*(1+0.055/12)^12*20 Mike "Atreyu" wrote: I have a question of which formula works for this example: I have the following: Invest $650,000.00 put in money-market which compounds monthly pays interest of 5.5%-annually. What is my 20 year earnings?Yes if all stays the same for 20 years -- Learning is uphill & I am just a climbing |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for payout & interest
"Atreyu" wrote:
Invest $650,000.00 put in money-market which compounds monthly pays interest of 5.5%-annually. What is my 20 year earnings? Yes if all stays the same for 20 years Depends on whether 5.5% is an annual interest rate or annual yield. The latter is typical in the US. If annual interest rate: =fv(5.5%/12, 20*12, 0, -650000) If annual yield: =fv(rate(12, 0, -1, 1+5.5%), 20*12, 0, -650000) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for payout & interest
"Mike H" wrote:
=650000*(1+0.055/12)^12*20 Close. You should write 650000*(1+5.5%/12)^(12*20). The key is the parentheses around 12*20. Compare with: =fv(5.5%/12, 20*12, 0, -650000) But as I noted in another posting in this thread, that assumes that 5.5% is the annual interest rate, not the annual yield. In the US, it is common to specify the latter. Even though the OP wrote "pays interest of 5.5", many investors confuse the two. I would not take it for granted. ----- original message ----- "Mike H" wrote in message ... Hi, =650000*(1+0.055/12)^12*20 Mike "Atreyu" wrote: I have a question of which formula works for this example: I have the following: Invest $650,000.00 put in money-market which compounds monthly pays interest of 5.5%-annually. What is my 20 year earnings?Yes if all stays the same for 20 years -- Learning is uphill & I am just a climbing |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
seeking template to track tokens played in arcade game and payout | Setting up and Configuration of Excel | |||
monthy payout on an annuity | Excel Worksheet Functions | |||
Stock Quote Add-inoffer more data (Div. Payout %, 5-YR PE AVG, | Excel Worksheet Functions | |||
How to set up payout for prize fund? | Setting up and Configuration of Excel |