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 project's IRR by using IRR function as follows:

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.