Answer this Part $1)$Problem $1$

The Lost in Space corporation is trying to finally build as pace ship that won't end up stranding everyoneon itin

some random part of the galaxy. To do so they are considering a new three$-$year project that will require an

initial investment of $$175$m illion. The se initial assets will be de preciated straight$-$line to zero overtheir three$-$

yeartax life. The firm will be able to sell these asse ts at the end ofthe project for $$75,975,500.$

The project is es timated to generate the following revenues duringit's three year life: $$95,546,280$ in year one,

and then revenues that increase ata growth rate of $35\%$ for every year after that. The firmexpects that the ir

costs will be equal to $37\mathrm{.}25\%$ of the projectssame year revenues. They expect that project net working capital $($in

the form of inventory required$)$ willbe equal to $7\mathrm{.}25\%$ of the next year's revenue. The firms tax$-$rate is $21\%.$ What

are the project'scash flows fromassets foryears $0-3?$ What is the IRR on this project?

Use available Excel template and completeusing "best practices" $($use formulas$-$no hardcoding in model$).$ This

means that every cell must be calculated inside of excel! Do not use your calculator and then just type in

numbers. If you need help use the excel help function or youtube!Problem $1$

The Lost in Space corporation is trying to finally build as pace ship that won't end up stranding everyoneon itin

some random part of the galaxy. To do so they are considering a new three$-$year project that will require an

initial investment of $$175m$ illion. The se initial assets will be de preciated straight$-$line to zero overtheir three$-$

yeartax life. The firm will be able to sell these asse ts at the end ofthe project for $$75,975,500.$

The project is es timated to generate the following revenues duringit's three year life: $$95,546,280$ in year one,

and then revenues that increase ata growth rate of $35\%$ for every year after that. The firmexpects that the ir

costs will be equal to $37\mathrm{.}25\%$ of the projectssame year revenues. They expect that project net working capital $($in

the form of inventory required$)$ willbe equal to $7\mathrm{.}25\%$ of the next year's revenue. The firms tax$-$rate is $21\%.$ What

are the project'scash flows fromassets foryears $0-3?$ What is the IRR on this project?

Use available Excel template and completeusing "best practices" $($use formulas$-$no hardcoding in model$).$ This

means that every cell must be calculated inside of excel! Do not use your calculator and then just type in

numbers. If you need help use the excel help function or youtube!