10 points) Calculate the NPV and IRR of the main project without the expansion.

4. (10 points) Calculate the NPV and IRR of the project including the expansion (i.e., the main

project and the expansion together)

You have the option to invest in the project now. This will cost you $55 million today. The project will generate cash flows for six years fgiven in the table), and you can salvage the project at the end of year six for an additional $20 million. Moreover, after fwo years, you will have the option to invest in an expansion (that is, expand the same project) by spending an additional 533 milion at the beginning of year four. The expansian project will generate more cash flows for three years (given in the table) and you will salvage the expansion at the end of year six for an additional $30 million. 2. Answer the following questions in Excelusing the apscepriafe fynctions Download the provided Excel file and enter your Excel code in the file. Find the discount rete (ri which bs Page 1 assipned to you frem the Fxoelfiles it appears in cell B3 (renamed to "ud Rate") in front of. "Assinged Rate" atter wou enter your fxcel code. - You can check the file "FINA 3103 Principles of Finance_ NPY" oo eCourses for examples. 3. (10 points) Calculate the NPV and IPG of the main project without the expansion. 4. (10 points) Calculate the NPV and anR of the project including the expansion fie., the main proiect and the exansion together). Notes and Guidelines - This assignment has a total of 20 points. - Use the provided Microraft Excel file to complete and submit your assignment. It automatically shows your grade, so you have the chance to correct your answer before submitting the file. You need to enter a unique code (for each student] in the Encel file. You can find your code in the Excel Codes file in the "Assignments Information" page on eCourses. - Submit the assignment through eCourses. No email submissions will be accepted. - Complete/submit your assignment by the deadline, as posted on eCourses. The deadline