SHOW ON EXCEL

create an excel sheet for investments using the information from the savings. first attached is the defintions.

second is my savings

third is what i need help on

and i need a tota of 50 years into retirement.

SHOW ON EXCEL

SHOW ON EXCEL

SHOW ON EXCEL

create your investment sheet, make up your own using the formula in picture 3.

i just need an example and i can then figure and have a guideline to follow

why does my Monthly annuity yield show #Num!

what am i doing wrong

Nest Egg Definition 3.8. A nest egg is a sum of money saved for the future. In our case, it will refer to teh amount we want to have at retirement. Annuity Definition 3.9. An annuity is a fixed sum of money paid to someone on a regular time interval (e.g. monthly, annually) for either a fixed amount of time or for the rest of their life. Monthly Annuity Yield Definition 3.10. The monthly annuity yield is the fixed amount paid each month for some fixed time period. We will not be deriving the formulas in this section, as there is really no benefit to doing so. Instead, here are the two formulas that connect monthly annuity yield and nest egg (note that they are algebraic restatements of each other) Nest Egg and Monthly Annuity Yield Formulas Formula 3.5. Let N denote the nest egg, Y denote the monthly an- nuity yield, r denote the period interest rate, and t denote the number of years. Then we have Y = Nr(1 + r) Y[(1 + r)' - 1] (1 + r) -1 r(1+r) Each of these can be input into Excel as follows the first is the left formula, the second is the right): 95000 991919-1 Years OTUN 00 a 8 BBB Savings Starting balance Interest Earned 1,000.00 $300.00 $1,300.00 $390.00 $1,690.00 $507.00 $2,197.00 $659.10 $2,856.10 $856.83 $3,712.93 $1,113.88 $4,826.81 $1,448.04 8 $6,274.85 $1,882.46 $8,157.31 $2,447.19 $10,604.50 $3,181.35 $13,785.85 $4,135.75 $17,921.60 $5,376.48 $23,298.09 $6,989.43 $30,287.51 $9,086.25 15 $39,373.76 $11,812.13 $51,185.89 $15,355.77 17 | $66,541.66 $19,962.50 18 $86,504.16 $25,951.25 $112,455.41 $33,736.62 $146,192.03 $43,857.61 $190,049.64 $57,014.89 $247,064.53 $74,119.36 23 $321,183.89 $96,355.17 24 $417,539.05 $125,261.72 Ending balance $1,300.00 $1,690.00 $2,197.00 $2,856.10 $3,712.93 $4,826.81 $6,274.85 $8,157.31 $ 10,604.50 $13,785.85 $17,921.60 $23,298.09 $30,287.51 $39,373.76 $51,185.89 $66,541.66 $86,504.16 $112,455.41 $146,192.03 $190,049.64 $247,064.53 $321,183.89 $417,539.05 $542,800.77 NNNNNNN885 o 19 21 corine and File Home Insert Formulas Data Review View Help Calibri Draw Page Layout 11 - AA - A. = = = > General 2. Wrap Text Merge & Center Past BIU - $ - % 48-58 Numbers Alignment Font Clipboard J61 50 $383,022,479.21 $114,906,743.76 Investments 60 Nest egg APR Rate Months Annuity Periods 0.031 64 Annuity Income APR Periods Risto Months Nest Egg 2852 RENRRRRRRR $ 83 Vest egg ate APR APR a te Months Monthly Annuity yield (67 * 1+177 1/((1+17) 720.77 0.02 30 17-1) Deposit APR Rate Months Balance $700.00 $0.02 $0.00 $600,00 S720,728.42 fx =(G7 *(1+17 407)/((1+ 17 )^37 -1) y Nest ega Nest egg APR Rate Months Rate lonthly Annuity yield WNUMI 0. 02 1 2 $0.00 S600.00 522072842 Nest Egg Definition 3.8. A nest egg is a sum of money saved for the future. In our case, it will refer to teh amount we want to have at retirement. Annuity Definition 3.9. An annuity is a fixed sum of money paid to someone on a regular time interval (e.g. monthly, annually) for either a fixed amount of time or for the rest of their life. Monthly Annuity Yield Definition 3.10. The monthly annuity yield is the fixed amount paid each month for some fixed time period. We will not be deriving the formulas in this section, as there is really no benefit to doing so. Instead, here are the two formulas that connect monthly annuity yield and nest egg (note that they are algebraic restatements of each other) Nest Egg and Monthly Annuity Yield Formulas Formula 3.5. Let N denote the nest egg, Y denote the monthly an- nuity yield, r denote the period interest rate, and t denote the number of years. Then we have Y = Nr(1 + r) Y[(1 + r)' - 1] (1 + r) -1 r(1+r) Each of these can be input into Excel as follows the first is the left formula, the second is the right): 95000 991919-1 Years OTUN 00 a 8 BBB Savings Starting balance Interest Earned 1,000.00 $300.00 $1,300.00 $390.00 $1,690.00 $507.00 $2,197.00 $659.10 $2,856.10 $856.83 $3,712.93 $1,113.88 $4,826.81 $1,448.04 8 $6,274.85 $1,882.46 $8,157.31 $2,447.19 $10,604.50 $3,181.35 $13,785.85 $4,135.75 $17,921.60 $5,376.48 $23,298.09 $6,989.43 $30,287.51 $9,086.25 15 $39,373.76 $11,812.13 $51,185.89 $15,355.77 17 | $66,541.66 $19,962.50 18 $86,504.16 $25,951.25 $112,455.41 $33,736.62 $146,192.03 $43,857.61 $190,049.64 $57,014.89 $247,064.53 $74,119.36 23 $321,183.89 $96,355.17 24 $417,539.05 $125,261.72 Ending balance $1,300.00 $1,690.00 $2,197.00 $2,856.10 $3,712.93 $4,826.81 $6,274.85 $8,157.31 $ 10,604.50 $13,785.85 $17,921.60 $23,298.09 $30,287.51 $39,373.76 $51,185.89 $66,541.66 $86,504.16 $112,455.41 $146,192.03 $190,049.64 $247,064.53 $321,183.89 $417,539.05 $542,800.77 NNNNNNN885 o 19 21 corine and File Home Insert Formulas Data Review View Help Calibri Draw Page Layout 11 - AA - A. = = = > General 2. Wrap Text Merge & Center Past BIU - $ - % 48-58 Numbers Alignment Font Clipboard J61 50 $383,022,479.21 $114,906,743.76 Investments 60 Nest egg APR Rate Months Annuity Periods 0.031 64 Annuity Income APR Periods Risto Months Nest Egg 2852 RENRRRRRRR $ 83 Vest egg ate APR APR a te Months Monthly Annuity yield (67 * 1+177 1/((1+17) 720.77 0.02 30 17-1) Deposit APR Rate Months Balance $700.00 $0.02 $0.00 $600,00 S720,728.42 fx =(G7 *(1+17 407)/((1+ 17 )^37 -1) y Nest ega Nest egg APR Rate Months Rate lonthly Annuity yield WNUMI 0. 02 1 2 $0.00 S600.00 522072842