Microsoft Office Tutorials and References
In Depth Information
Extend Your Knowledge
8. 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. Save the
workbook using the ﬁ le name, Apply 4–1 Monthly Loan Payment Complete.
9. Determine the monthly payment and print the worksheet for each data set: (a) Item = Home; Price
= $310,000.00; Down Payment = $62,000.00; Interest Rate = 6.75%; Years = 20; (b) Item = Jacuzzi;
Price = $19,000.00; Down Payment = $0.00; Interest Rate = 8.80%; Years = 5. You should get the
following monthly payment results: (a) $1,885.70; (b) $392.57.
10. Submit the assignment as speciﬁ ed by your instructor.
Extend the skills you learned in this chapter and experiment with new skills. You may need to
use Help to complete the assignment.
Two–Input Data Table
Instructions: Start Excel. Open the workbook Extend 4–1 401(k) Planning Sheet from the Data Files
for Students. See the inside back cover of this topic for instructions for downloading the Data Files
for Students or see your instructor for information on accessing the ﬁ les required in this topic. You
have been asked to include a two–input data table (Figure 4–67) on the existing 401(k) Planning Sheet
worksheet that shows the future value that results from varying the expected annual return (cell C8) and
employee percent invested (cell C5). Complete the following tasks to create the two–input data table.
row of different