I need some guidence. i am suppose to use this spreadsheet to create a project analysis.

Addis Home Insert Get Add-ins Link Comment Page Layout Formulas Data Review View SmartArt Screenshot Pictures Online Shapes Icons 3D Models > Bing People Maps Graph HTLINIE dhe Line Column Wind Slicer Timeline Recommended - LOSS Tours Charts Spardines Filters Maps P vor Chart My Add-ins - Charts Links Comments ble Recommended Table Pivottables stations 250000000 Key Seed Varia Investment required for the project in fixed assets Expected useful life of the project Expected salvare value of the project Cost of the capital Fixed costs Variable cast as percent of revenues initial expected number of unit sale oth of the sales Cash Flow Estimation Number of expected unit sales Sales Price GOS Depreciation other cost 9 Laxes 10 Net Income 11 Add back depreciation 12 Operating cash flow 14 Working capital requirements 15 nange in working capital 16 Cash flow due to working capital 19 Expeced value of the assets at the termination of the projet 320 Cash flow related with the salvace value 21 Total investment cash flow 2 Total Cash Flow (12-16 NIN Payback period Discounted Payback period How many units the company should sell to have the operating profit to be zero if the unit sales ist rowing out the i n t erne How many units the company should sell to have the NPV to be zero if the unit sales is growing, put the intial number of units as the answer at ye Sensitivity Analysis can NPV NPV Calc m ince 1.pagereport C 781-2747 Pyrotek Minuntve PS Tours Charts Add-ins Sparklines Illustrations bles 250000000 ey Seed Variables vestment required for the project in fixed assets xpected useful life of the project xpected salvage value of the project Cost of the capital Fixed costs Variable cost as percent of revenues Initial expected number of unit sales Growth of the sales Tax rate Year 0 Cash Flow Estimation Number of expected unit sales Sales price Revenues Variable costs Fixed costs 5 Depreciation 7Other costs EBIT 9 Taxes Net Income 1 Add back depreciation 2 Operating cash flow 19 Working Capital requirements 5 Change in working capital 16 Cash flow due to working capital 171 18 Investment in fixed assets for the project 19 Expeced value of the assets at the termination of the project 20 Cash flow related with the salvage value 21 Total investment cash flow 23 Total Cash Flow (12.16+21) NPV IRR Payback period Discounted Payback period Break-even unit sales thenswer at Wear 11 How many units the company should sell to have the operatine profit to be zero if the unit sales is growing, put the intial number of units as the answer a year How many units the company should sell to have the NPV to be zero (if the unit sales is growing, put the intial number of units as the answer a year Sensitivity Beciulate NPV for all of the following scenarios Ne ronor Addis Home Insert Get Add-ins Link Comment Page Layout Formulas Data Review View SmartArt Screenshot Pictures Online Shapes Icons 3D Models > Bing People Maps Graph HTLINIE dhe Line Column Wind Slicer Timeline Recommended - LOSS Tours Charts Spardines Filters Maps P vor Chart My Add-ins - Charts Links Comments ble Recommended Table Pivottables stations 250000000 Key Seed Varia Investment required for the project in fixed assets Expected useful life of the project Expected salvare value of the project Cost of the capital Fixed costs Variable cast as percent of revenues initial expected number of unit sale oth of the sales Cash Flow Estimation Number of expected unit sales Sales Price GOS Depreciation other cost 9 Laxes 10 Net Income 11 Add back depreciation 12 Operating cash flow 14 Working capital requirements 15 nange in working capital 16 Cash flow due to working capital 19 Expeced value of the assets at the termination of the projet 320 Cash flow related with the salvace value 21 Total investment cash flow 2 Total Cash Flow (12-16 NIN Payback period Discounted Payback period How many units the company should sell to have the operating profit to be zero if the unit sales ist rowing out the i n t erne How many units the company should sell to have the NPV to be zero if the unit sales is growing, put the intial number of units as the answer at ye Sensitivity Analysis can NPV NPV Calc m ince 1.pagereport C 781-2747 Pyrotek Minuntve PS Tours Charts Add-ins Sparklines Illustrations bles 250000000 ey Seed Variables vestment required for the project in fixed assets xpected useful life of the project xpected salvage value of the project Cost of the capital Fixed costs Variable cost as percent of revenues Initial expected number of unit sales Growth of the sales Tax rate Year 0 Cash Flow Estimation Number of expected unit sales Sales price Revenues Variable costs Fixed costs 5 Depreciation 7Other costs EBIT 9 Taxes Net Income 1 Add back depreciation 2 Operating cash flow 19 Working Capital requirements 5 Change in working capital 16 Cash flow due to working capital 171 18 Investment in fixed assets for the project 19 Expeced value of the assets at the termination of the project 20 Cash flow related with the salvage value 21 Total investment cash flow 23 Total Cash Flow (12.16+21) NPV IRR Payback period Discounted Payback period Break-even unit sales thenswer at Wear 11 How many units the company should sell to have the operatine profit to be zero if the unit sales is growing, put the intial number of units as the answer a year How many units the company should sell to have the NPV to be zero (if the unit sales is growing, put the intial number of units as the answer a year Sensitivity Beciulate NPV for all of the following scenarios Ne ronor