Good morning! I need help calculating the NPV$,$IRR and Breakeven analysis of this information. PROBLEM $2-3$

Given

Growth rate in EBIT for years $1-55\%$

EBIT $($year $1)$ $ $100,000$

CAPEX for year $0$ $ $400,000$

Depreciable life of fixed assets $5$ years

Tax rate $30\%$

New working capital for years $1-520\%$ of EBIT

Solution

Year

$012345$

EBIT $ $100,000$ $ $105,000$ $ $110,250$ $ $115,763$ $ $121,551$

Taxes $(30,000)(31,500)(33,075)(34,729)(36,465)$

NOPAT $ $70,000$ $ $73,500$ $ $77,175$ $ $81,034$ $ $85,085$

Plus: Depreciation $80,00080,00080,00080,00080,000$

Less: CAPEX $(400,000)-----$

Less: Net working capital needs $($See Note $1)(20,000)(1,000)(1,050)(1,103)(1,158)24,310$

Plus: Salvage value of the fixed assets in year $5-$

Firm Free Cash Flow $($FFCF$)$ $ $(420,000)$ $ $149,000$ $ $152,450$ $ $156,073$ $ $159,876$ $ $189,396$

Net Fixed Assets $($beginning of the year$)$ $ $-$ $ $400,000$ $ $320,000$ $ $240,000$ $ $160,000$ $ $80,000$

Plus: CAPEX $400,000-----$

Less: Depreciation Expense for the Year $-(80,000)(80,000)(80,000)(80,000)(80,000)$

Net Fixed Assets $($end of the year$)400,000\mathrm{.}00320,000\mathrm{.}00240,000\mathrm{.}00160,000\mathrm{.}0080,000\mathrm{.}000\mathrm{.}00$

Discount Rate $18\mathrm{.}00\%$

NPV $$964,506\mathrm{.}17$

IRR #NUM!

Break Even Analysis variable Expected Value Critical Value $\%$ of Change

EBIT Growth $5\%`$

EBIT $(1)100,000$

Tax Rate $30\%$

NWC$/$EBIT $(0)$

Discount Rate $18\mathrm{.}00\%$

CAPEX for year $0400,000$

Please identify the top $3$ value drivers. The pictures will probably help much more than this texxt.