Microsoft Office Tutorials and References
In Depth Information
In the Lab
7. Correct the second and third arguments in the Future Value function in cell C14. Display the
future value as a positive number.
8. Change the Present Value function in cell F14 so that the present value displays as a positive number.
9. Complete the one–input data table in the range B17:I19 that determines the depreciation and rate
of depreciation for varying years of life (cell F4). Format the numbers in the data table so that they
appear as shown in Figure 4–68.
10. Change the document properties as speciﬁ ed by your instructor. Change the worksheet header
with your name, course number, and other information requested by your instructor.
11. Unlock the cells containing data (C2:C3, C5:C6, F2:F4, C11:C13, F11:F13). Protect the
worksheet so that the user can select only cells with data.
12. Save the workbook using the ﬁ le name, Make It Right 4–1 Financial Calculator Complete, and
submit the revised workbook as requested by your instructor.
Create a workbook using the guidelines, concepts, and skills presented in this chapter. Labs
are listed in order of increasing difﬁ culty.
Lab 1: 401(k) Retirement Savings Model
Problem: You have been asked by the human resources department to develop a retirement planning
worksheet that will allow each current and prospective employee to see the effect (dollar accumulation)
of investing a percent of his or her monthly salary over a period of years (Figure 4–69 on the next page).
The plan calls for the company to match an employee’s investment, dollar for dollar, up to 3%. Thus, if an
employee invests 6% of his or her annual salary, then the company matches the ﬁ rst 3%. If an employee
invests only 2% of his or her annual salary, then the company matches the entire 2%. The human resources
department wants a one–input data table to show the future value of the investment for different periods.