### Recent Question/Assignment

Assignment 3. Financial Calculations and Data Table Models
Overview: Build a workbook to write an Excel user defined function and three unique Data Table examples. The ideas, models and design of this workbook project must be 100% your own as discussed in class. Collaboration with others is strictly prohibited. Begin by downloading the Assignment3Starter workbook. Create the PVGOFA user defined function then use the three sheets supplied to complete the one-, two-, and three-way data tables described below. Unless otherwise instructed, be sure not to copy anything electronically from another workbook, including your own, the instructor’s, or someone else’s into the starter workbook. If you completed a similar assignment in a previous semester do not copy from it and paste it into the starter book. Rather, use the same examples and formulas by entering them without using move/copy/paste type commands.
1. Open the Assignment3Starter.xlsm workbook and complete the instructions given in class to copy the User Defined Functions into the workbook. Apply the steps shown in lecture to record the keystroke macro.
2. Now create the User Defined Function in the starter workbook to calculate the present value of a growing ordinary finite annuity named PVGOFA. The arguments should be C, g, r, and n (in that order). See page 18 of your text, the Chapter 1 workbook, and the class lecture notes if you need help with formulas. The function should be capable of computing a value for any reasonable set of inputs, including the special case where r = g. (Hint: If r is not equal to g then the book formula used in class works. If r = g then you need to derive a different but simple formula to calculate PVGOFA. For help with similar VBA code see the ADDING3 function in the Example Function.xlsm workbook.
For help on creating functions see the textbook, Chapters 0 and 36, and/or the web. Example Function.xlsm shows how to use If-Then-Else in VBA code. Another useful site: http://www.wikihow.com/Create-a-User-Defined-Function-in-Microsoft-Excel
Document your PVGOFA function within the VBA Module copiously and accurately with comments to explain what the function does, the definition of each input parameter, and what key sections of the VBA code accomplish.