Question

Gary has just retired, and has 1000000 dollars in his retirement account. The account will earn interest at an annual rate of 5 percent, compounded monthly At the end of each month, Gary will withdraw a fixed amount to cover his living expenses. Gary wants his savings to last exactly 20 years. How much money can he withdraw each month? (Give your answer in dollars, correct to the nearest cent.) monthly withdrawal: 2216.30X What is the maximum amount that Gary can withdraw each month if he wants his savings to last indefinitely? monthly withdrawal: 4166.67

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

AS NOTHING WAS MENTIONED, EXCEL USED. IF YOU NEED WIT FORMULA, WILL DO THAT ALSO. THANK YOU

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E " ゴWrap Text ta copy ▼ ,_a. ars-函Merge & Center, $, % , 弼,8 C Paste B l u. Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Alignment Number Cells Editing KY148 KW KX KY kZ LA LB LC LD LE LF LG LH Ll LK 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 11 1 トーCALCULATOR ( LOAN OPTIONS | pv, fv, annuity i CAP STRU VALUE PV= RATE PERIODS IN A YEARS YEARS 1000000 5% 12 20 ANS 1 PM 6599.56 EXCEL PMT(LA132/LA133,LA134 LA133,-LA131) ANS 2 ITIS A CASE OF PERPETUITY PV- A/(r/m) PV = MONTHLY AMOUNT/RATE 1000000-MONTHLY AMOUNT/ (5%/12) MONTHLY AMOUNT 4166.67 [-1000000"(5%)12) ] BOX DILUTIONDOLLAR COST AVG MORTGAGE EXPO SheetiSheet Sh rences: x261 福 130% 02-02-2019