Overview
Assignment :
Using the formulas given in the Mathematics of Interest section in the Module 4 – Instructor handout, develop an Excel Workbook containing the following worksheets (tabs):
Worksheet with formulas to generate tables of time value of money factors. The worksheet must have the capability of generating the table for any interest rate. The design and number of years are based on your interest.
Worksheet that can be used to generate tables of present worth for single cash flow.
- Worksheet that can be used to generate tables of recurrent cash flow.
- Worksheet that can be used to generate tables of cash flow that escalates.