Student Instructions 1. Read from the textbook the Example 4.1, the assignment is based on this example. Example 4.1 is going to be used to compute the present value 2. Have available the Microsoft Excel software program. 3. Construct a table in Example 4.1in the Microsoft Excel work sheet as shown below. The instructions are shown in the second table interest rates 0.08 Year Positive Cash flow Negative Cash Flow Net Cash Flow Pre 5310 5310 5310 5310 5310 10000 3000 3000 3000 3000 3000 10000 2310 2310 2310 2310 2310 2138.8 1980.45 1833.75 1697.92 1572.15 9 Present Worth is equal to: 13 14. 15 16 17 18 19 interest rate 0.08 Year Positive Cash flow Negative Cash Flow Net Cash Flow Pre 5310 5310 5310 5310 5310 10000C4+D4 3000C5+D5 3000 CG+D6 30001 =C7+D7 3000C8+D8 30001-c9+09 21 23 Present Worth -SUM(F17:F22