aste A B 3 0 1 2 3 4 5 LB B FV Stocks BIUV Cell Styles X fx You are trying to plan for retirement in 10 years and currently you have 150 000 in a savings account and 250 00 C DE F G H P6 24 Modified see template for modifications to the problem CRECHERCHEHEHEHE PV i nper pmt FV Note there are multiple methods that can be used to solve this problem The template below is laid out for one of those methods A FV Savings Savings PV 1 You are trying to plan for retirement in 10 years and currently you have 150 000 in a savings account and 250 000 in stocks In addition you plan to deposit 8 000 iper year into your savings account at the end of each of the next 5 years and then 10 000 per year at the end of each year for the final five years until you retire a Assuming your savings account returns 8 compounded annually and your investment in stocks will return 12 compounded annually how much will you have at the end of 10 years b If you expect to live for 20 years after you retire and at retirement you deposit all of your savings including stocks in a bank account paying 11 how much can you withdrawal each year after you retire making 20 equal withdrawls beginning one year after you retire so that you end up with a zero balance at death nper pmt FV Hv FV 8K Annuity years 1 5 Step 1 A PV 1 nper pmt 5 150 000 00 8 10 323 838 75 Alignment 250 000 00 Number 12 10 776 462 05 Cells Editing