- Autosave Om Assignment 2 Spreadsheet Templatr 1 Search Alt A William Crewder Wc File Home Insert Page Layout Formu 1 (166.62 KiB) Viewed 33 times
correct, or what the Net Cash Flow or Discounted Cash flow would
be. Thanks.
AutoSave OM Assignment #2 Spreadsheet Templatr(1) - Search (Alt+a) William Crewder WC File Home Insert Page Layout Formulas Data Review View Help JMP Acrobat Comments Share Calibri 11AA SOM 95 Wrap Text Custom II 47 0 e Paste BIU Sensitivity A Merge Center $ % 0 % Conditional Format as Cell Formatting Table Styles Insert Delete Format Sort & Find & Filter Select - Analyze Data Number Styles Editing Analysis Sensitivity Unde Cupboard Font Alignment UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps Update now E21 B с D E F G H 1 K Investment: S (750,000) -750000 Base Case $ 750,000 S 25,000 $ 150,000 40,000 S 40.00 Sales $ 1,600,000 $ 1,600,000 $ 1,600,000 $1,600,000 $ 1,600,000 $ 8,000,000 $ 30.00 Expenses: Variable Costs Fixed Costs Depreciation EBT $ 1,200,000 $ 1,200,000 $ 1,200,000 $ 1,200,000 $ 1,200,000 $ 6,000,000 $ 175,000 $ 175,000 $ 175,000 $ 175,000 $ 175,000 $ 875,000 $ $ $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 750,000 $ s 75,000 $ 75,000 S 75,000 $ 75,000 $ 75,000 $ 375,000 $ 175,000 д 4 Inputs 5 Equipment Cost 6 Salvage Value, Year 5 7 Depreciation Per Year 8 Units Sold Every Year 9 Sales price per unit, Year 1 10 TU 11 Variable cost per unit (VC), Year 1 12 13 Fixed Cost (FC), Year 1 14 15 Project Cost of Capital 16 Tax Rate 17 Working Capital as % of next year's sales 18 19 20 21 22 23 24 25 Capital Budget Analysis Extra Credit $ S 16,500 $ 58,500 $ 16,500 $ 58,500 $ 16,500 $ 58,500 $ 16,500 5 58,500 $ 16,500 $ 58,500 $ 82,500 292,500 9.00% Tax (22%) 22.0% Net Income 10.0% Salvage Value Depreciation NOWC Net Cash Flow Discounted Cash Flow DCF NPV IRR Drofitability Index DI $ 19,500 $ 19,500 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 $ 750,000 $ 208,500 $ 208,500 $ 208,500 $ 208,500 $ 208,500 $ 1,042,500 $ $ $ $ $ $ SO $17,655 9.68% 102 GO No Go Edit 77"F Sunny 4x) 5:33 PM 5/16/2022 2