2.3-2.4 (Excel): You have been offered a unique investment opportunity. If you invest $1 million at t=0, you will receive $20,000 from t=1 to t=40, plus a balloon payment of $1.5 million at t=40.

2.3 What is the NPV of the investment, assume your expected rate of return in the investment is 5%?

2.4 What is the internal rate of return of the investment?

write formula for each question!