GLC provide its services for 2 years. The GLC provide its services for world exposition. There are various costs involve regarding this project. The various costs include the initial cost and marketing fee. The initial cost is $160,000 and there are cash inflows of $1 million for two years. Marketing fee of $2 million is paid after two years. Question 1: What is the net cash flow for years 0, 1, and 2? Hint: Use Microsoft Excel or Google Sheets to make a table to help with your calculations. You will have 3 different values, make sure to specify if the number is negative. Paste your table below: Internal rate of return (IRR) is a method of capital budgeting and it is used to evaluate the profitability of the project. IRR is a discount rate, on which NPV of the project is zero. IRR can be calculated by using spreadsheet function given below: = IRR ( values) Where, IRR is internal rate of return, Values are the range of the cash flows including initial cash outflow. Question 2: What is the projects IRR for the cash flows computed in question 1? Hint: Use Excel using the function below, be sure to use the appropriate cells in your function. Paste your table for your answer and be sure to specify the unit of your answer. Excel Formula: It is required to compute projects IRR by using IRR function as follows: B7 fx =IRR(B2:34) A B D NPV can be calculated by using spreadsheet function given below: = NPV (rate, values) Where, NPV is net present value, Values are range of the cash inflows and outflows. Question 3: Assuming a project cost of capital of 10%, what is the projects net present value (NPV)? Hint: Again, use Excel to calculate. Use the formula below but change the cells you are adding to the function