You are the financial analyst for the University of South Carolinas athletic department. As part of its master facilities plan, the departments chief financial officer has asked you to analyze capital investment, Project Gamecocks. The project cost $15,000,000, and the cost of capital is 8.75%. The projects expected net cash flows are as follows:

Year Cash Flows

0 $(15,000,000,000.00)

1 $1,500,00.00

2 $1,530,000.00

3 $1,560,600.00

4 $1,591,812.00

5 $1,623,648.24

6 $1,656,121.20

7 $1,689,243.63

8 $1,723,028.50

9 $1,757,489.07

10 $(3,207,361.15)

11 $2,000,000.00

12 $2,040,000.00

13 $2,080,800.00

14 $2,122,416.00

15 $2,164,864.32

16 $2,208,161.61

17 $2,252,324.84

18 $2,297,371.34

19 $2,343,318.76

20 $(3,609,814.86)

21 $2,500,000.00

22 $2,550,000.00

23 $2,601,000.00

24 $2,653,020.00

25 $2,706,080.40

26 $2,760,202.01

27 $2,815,406.05

28 $2,871,714.17

29 $2,929,148.45

30 $2,987,731.42

A. In excel, calculate each project's payback period and discounted payback period.

B. Using excel's financial functions, calculate each project's net present value, internal rate of return, and modified internal rate of return.