Please help!
Computer lab
Accounting 202 COMPUTER LAB-Retirement Retirement-How soon? How MUCH $$$? Name Go to Excel. (Click on the Excel icon or search for the Excel program). Using the function wizard fx) button on your menu bar, practice calculating future value and present value problems. See below for the first one, and then see if you can do the rest. (Calculate the data using function wizard ONLY Rate: .08 (8% per year) Sper: 3 (years) Pymt: 0 PV: $7938 (input as a negative) Answer should be $9,999.59 Solution (can you get to this solution Future Value of an annuity of $2,000, 3 years, compounded aS1E You win the lotto and can choose to receive $10,000 3 taking the present value of it today. If you received it today, what at use the You bought a car, with 5 annual payments of S6,000, How mch $21,628.68 Now, after practicing..let's get on with the Retirement Calculation. DO ALL THESE SPREADSHEETS ON ONE WORKSHEET IN EXCEL I. Spreadsheet 1: Calculate how much you want (desire, need) for your retirement fund the Caleulate Future l value of Annual SS Retirement fund SS goal retirernent (use | nuainterest | (the Binasofmuner or the ..nes1 cgg". You will live on its interest. (D/F) desired now same numberincome adjusted fortate upon 2% annual inflation retirement 50,000 1,04 Low Medium 7% In column B, mput your assumptions regarding your desired annual moome now (for you to retire in comfort now, m today's dollars) Input a low, medium, and high scenario (one per line). In column C,input your estimated years to retirement: use the SAME number for each row In column D, caleulate the Future Value of your annual income (for each scenario) Use EXCEL! In column F, we input an assumed average annual interest rate you will earn as Interest Income on your retirement account, upon retirement. (Assime you will be earning interest at a mixed rate of 7%) . In column G, calculate E/F Accounting 202 COMPUTER LAB-Retirement Retirement-How soon? How MUCH $$$? Name Go to Excel. (Click on the Excel icon or search for the Excel program). Using the function wizard fx) button on your menu bar, practice calculating future value and present value problems. See below for the first one, and then see if you can do the rest. (Calculate the data using function wizard ONLY Rate: .08 (8% per year) Sper: 3 (years) Pymt: 0 PV: $7938 (input as a negative) Answer should be $9,999.59 Solution (can you get to this solution Future Value of an annuity of $2,000, 3 years, compounded aS1E You win the lotto and can choose to receive $10,000 3 taking the present value of it today. If you received it today, what at use the You bought a car, with 5 annual payments of S6,000, How mch $21,628.68 Now, after practicing..let's get on with the Retirement Calculation. DO ALL THESE SPREADSHEETS ON ONE WORKSHEET IN EXCEL I. Spreadsheet 1: Calculate how much you want (desire, need) for your retirement fund the Caleulate Future l value of Annual SS Retirement fund SS goal retirernent (use | nuainterest | (the Binasofmuner or the ..nes1 cgg". You will live on its interest. (D/F) desired now same numberincome adjusted fortate upon 2% annual inflation retirement 50,000 1,04 Low Medium 7% In column B, mput your assumptions regarding your desired annual moome now (for you to retire in comfort now, m today's dollars) Input a low, medium, and high scenario (one per line). In column C,input your estimated years to retirement: use the SAME number for each row In column D, caleulate the Future Value of your annual income (for each scenario) Use EXCEL! In column F, we input an assumed average annual interest rate you will earn as Interest Income on your retirement account, upon retirement. (Assime you will be earning interest at a mixed rate of 7%) . In column G, calculate E/F
