Microsoft Office Tutorials and References
In Depth Information
Extend Your Knowledge
8. Change the document properties as specifi 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 fi 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 specifi ed by your instructor.
Extend Your Knowledge
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 fi 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
employee
investment
percentages
future value
formula
column of
different
annual return
percentages
Figure 4–67
Continued >
 
 
Search JabSto ::




Custom Search