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:

1. $(15,000,000.00)

2. $1,500,000.00

3 $1,530,000.00

4. $1,560,600.00

5. $1,591,812.00

6 $1,623,648.24

7. $1,656,121.20

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 projects payback period and discounted payback period.

B. Using Excels financial functions, calculate each projects net present value, internal rate of return, and modified internal rate of return.