What are the formulas for each cell?

High School Senior Investment Year Net Higher Earnings Cost Net Cash Flow Undiscounted Cummul. Net Cash Flow Year To the right is a table of expected higher earnings, educational costs, etc. for a senior in High School. Fill out the missing elements of the table and calculate the following 15-year investment metrics. Assuming a 4% discount rate (education is a low risk investment which warents a lower discount rate). (10 pts) Payback Period a. Simple Return b. NPV c. B/C d. IRR 0 0 11.3 2264.3 0 0 1 11.6 1 2 2 3 11.8 12.0 3 4 12.2 4 e. 5 5 12.4 12.5 6 6 7 12.6 7 8 12.7 8 9 12.7 9 10 12.7 10 11 12.7 11 12 12.6 12 13 12.5 13 14 12.3 14 15 12.1 15.0 High School Senior Investment Year Net Higher Earnings Cost Net Cash Flow Undiscounted Cummul. Net Cash Flow Year To the right is a table of expected higher earnings, educational costs, etc. for a senior in High School. Fill out the missing elements of the table and calculate the following 15-year investment metrics. Assuming a 4% discount rate (education is a low risk investment which warents a lower discount rate). (10 pts) Payback Period a. Simple Return b. NPV c. B/C d. IRR 0 0 11.3 2264.3 0 0 1 11.6 1 2 2 3 11.8 12.0 3 4 12.2 4 e. 5 5 12.4 12.5 6 6 7 12.6 7 8 12.7 8 9 12.7 9 10 12.7 10 11 12.7 11 12 12.6 12 13 12.5 13 14 12.3 14 15 12.1 15.0