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
Assignment 3. Financial Calculations and Data Table Models Overview: Build a workbook to write an Excel user defined function and three unique Data Table…