After downloading the Excel form on this page, follow the instructions provided below to create your own worksheet version of Example E and Exhibit 13-7.
Instructions:
- Enter formulas in the cells that contain question marks. For example, in cell D19 enter the formula "= −B5".
- Note: The present value factors could be computed using the built-in Excel function PV, but we recommend using the formulas in Appendix 13B.
- Verify that your worksheet matches Example E and Exhibit 13-7 in the text.
Once you have verified that your worksheet matches the text, return to the textbook and complete the requirements as assigned by your instructor.
Chapter 13 Applying Excel Forms |