Excel work

2. If you haven t already, go to IoolsaOptionsateditor, and Check: Require Variable Declaration Uncheck: Auto Syntax Check 3. Make sure that the current workbook is highlighted in the Project Explorer and then Click: InsertModule 4. Click: InsertProcedure Give your procedure the name MONEY 5. Let's create a program to calculate your pretax expected lifetime earnings (assuming that you never retire because you love working and using Excel so much). Remember that all of your code will go in between the Public Sub MONEYO line and the End Sub line. 6. We'll create four variables: Dim Current as Long Dim Death as Long Dim Income as Double Dim Inflation as Double 7. Create an input box that asks for the user's current age: Current = InputBox("What is your current age?", "Current Age") 8. Similarly, create three more input boxes that ask, respectively, for the expected age of death, the expected firstyear salary after graduation, and the expected average salary inflation rate (including regular cost-of-living increases and promotion increases). These should be assigned to the variables Death, Income, and Inflation, respectively. (In other words, the left-hand side of the next three lines changes to Death, then Income, then Inflation.) 9. Report the results in a message box: MsgBox WorksheetFunction.FV(Inflation,DeathCurrent,-Income) 10. To test your program, enter a current age of 22 , a death age of 25 , a first-year salary of $50,000, and a salary inflation rate of .05. You should see an earnings of $157,625