AutoSave ABC Home Insert Draw Page Layout Formulas Data Review View Automate X Paste Aptos Narrow...

Transcribed Image Text:

AutoSave ABC Home Insert Draw Page Layout Formulas Data Review View Automate X Paste Aptos Narrow (Bod... v BIU V 12 Wrap Text v Tell me Book2 General Av Merge & Center V $ % 9 13 fx A B C D E F G Table 1 1 Projected Unit Sales and Price for Lazy Mower 2 Year 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Find NPV and IRR S76222222222223523333224 18 Sheet1 Sheet2 + Ready Accessibility: Investigate V Insert v Delete v Conditional Format Cell Formatting as Table Styles Format v WEA H < < Comments Share Sort & Filter Find & Select Add-ins Analyze Data D J K L M N VC per unit TAX rate Unit Sales Unit price sale revenue Varible cost 1 200,000 700 140000000 80000000.00 2 240,000 700 168000000 96000000.00 3 288,000 700 201600000 115200000.00 Contribution Margin 60000000.00 2000000 72000000.00 2000000 86400000.00 2000000 FC DEP 0.33 Taxable Income + Taxes NPV 400 44.44 14.82 4 280,000 650 182000000 112000000.00 5 260,000 650 169000000 6 260,000 650 169000000 7 255,000 650 165750000 104000000.00 104000000.00 102000000.00 8 250,000 600 9 245,000 10 240,000 600 600 150000000 147000000 144000000 100000000.00 50000000.00 70000000.00 2000000 65000000.00 2000000 2000000 65000000.00 2000000 63750000.00 2000000 7.41 0.00 0.00 0.00 0.00 98000000.00 96000000.00 49000000.00 2000000 48000000.00 2000000 #N/A #N/A MacBook Pro B + 100% AutoSave ABC Home Insert Draw Page Layout Formulas Data Review View Automate X Paste Aptos Narrow (Bod... v BIU V 12 Wrap Text v Tell me Book2 General Av Merge & Center V $ % 9 13 fx A B C D E F G Table 1 1 Projected Unit Sales and Price for Lazy Mower 2 Year 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Find NPV and IRR S76222222222223523333224 18 Sheet1 Sheet2 + Ready Accessibility: Investigate V Insert v Delete v Conditional Format Cell Formatting as Table Styles Format v WEA H < < Comments Share Sort & Filter Find & Select Add-ins Analyze Data D J K L M N VC per unit TAX rate Unit Sales Unit price sale revenue Varible cost 1 200,000 700 140000000 80000000.00 2 240,000 700 168000000 96000000.00 3 288,000 700 201600000 115200000.00 Contribution Margin 60000000.00 2000000 72000000.00 2000000 86400000.00 2000000 FC DEP 0.33 Taxable Income + Taxes NPV 400 44.44 14.82 4 280,000 650 182000000 112000000.00 5 260,000 650 169000000 6 260,000 650 169000000 7 255,000 650 165750000 104000000.00 104000000.00 102000000.00 8 250,000 600 9 245,000 10 240,000 600 600 150000000 147000000 144000000 100000000.00 50000000.00 70000000.00 2000000 65000000.00 2000000 2000000 65000000.00 2000000 63750000.00 2000000 7.41 0.00 0.00 0.00 0.00 98000000.00 96000000.00 49000000.00 2000000 48000000.00 2000000 #N/A #N/A MacBook Pro B + 100%