What are the annual cashflows, terminal cash flows, and initial cash flows? CA Home Insert Draw Page

What are the annual cashflows, terminal cash flows, and initial cash flows?

Transcribed Image Text:

CA Home Insert Draw Page Layout Formulas Data Review 1 C42 234567890mmuuuuuu1202 AutoSave OFF Paste 11 4 Annual Net Working Capital A Change NWC-cash Flow Sales Revenue NWC (10 % of sales) 13 Investment capital outlay 15 Total Investment 16 Investment recovery: 20 sales revenue 14 Net working capital (10% sales) 21 22 SG & A (5% Sales) Calibri B I cost of goods sold (75% sales) 27 EBIT 28 Taxes (40%) 29 NOPAT 30 31 Depreciation 32 investment 23 Operating savings 24 Ddepreciation (18000/6) 25 Total cost and expenses 26 33 Free cash flow 34 35 IRR 12.1% 36 NPV=9.7% = $1483 37 38 39 Ready NPV fx 40 41 Annual Incermental Cash Flow 42 43 44 45 46 47 48 49 50 U v V V 11 V WACC + Accessibility: Investigate V B A^ A Equipment salvage (10 % total x (1-.4 for taxes) Net Working capital ((full recovery) View case #4 .xlsx Repaired - Saved to my Mac Automate ab Wrap Text E Merge & Center C D worldwide raper company Developer 2007 0 0 0 F 2008 4000 400 600 18000 G General 2010 10000 1000 0 2007 16000 0 16000 -16000 -16000 V H Tell me % 9 Years 2011 10000 1000 0 2008 2000 400 2400 4000 3000 200 2000 3000 -200 80 -120 3000 -2400 480 2012 10000 1000 0 2009 0 620 620 10200 7650 510 3570 3000 .00 0 J 2013 10000 1000 0 Years 2010 0 20 20 Conditional Format Formatting as Table K 2011 0 21 21 V L 3000 21 2012 0 21 21 Cell Styles M 2013 0 22 22 1080 1104 10404 10612.08 10824.32 11040.81 7959.06 8118.241 8280.606 7803 520.2 530.604 541.2161 552.0404 3641.4 3714.228 3788.513 3864.283 3000 3000 3000 3000 2610 2722.2 2836.644 2953.377 3072.444 1044 1088.88 1134.658 1181.351 1228.978 1566 1633.32 1701.986 1772.026 1843.467 3000 3000 3000 3000 620 20 21 2162 3946 4613.32 4680.986 4751.026 7005.467 N Insert v Delete v Format v O 0.02 P 8 V V O V Sort & Filter Q 6 Or Find & Select I R Comments Analyze Sensitivity Data S T Share + U 100% CA Home Insert Draw Page Layout Formulas Data Review 1 C42 234567890mmuuuuuu1202 AutoSave OFF Paste 11 4 Annual Net Working Capital A Change NWC-cash Flow Sales Revenue NWC (10 % of sales) 13 Investment capital outlay 15 Total Investment 16 Investment recovery: 20 sales revenue 14 Net working capital (10% sales) 21 22 SG & A (5% Sales) Calibri B I cost of goods sold (75% sales) 27 EBIT 28 Taxes (40%) 29 NOPAT 30 31 Depreciation 32 investment 23 Operating savings 24 Ddepreciation (18000/6) 25 Total cost and expenses 26 33 Free cash flow 34 35 IRR 12.1% 36 NPV=9.7% = $1483 37 38 39 Ready NPV fx 40 41 Annual Incermental Cash Flow 42 43 44 45 46 47 48 49 50 U v V V 11 V WACC + Accessibility: Investigate V B A^ A Equipment salvage (10 % total x (1-.4 for taxes) Net Working capital ((full recovery) View case #4 .xlsx Repaired - Saved to my Mac Automate ab Wrap Text E Merge & Center C D worldwide raper company Developer 2007 0 0 0 F 2008 4000 400 600 18000 G General 2010 10000 1000 0 2007 16000 0 16000 -16000 -16000 V H Tell me % 9 Years 2011 10000 1000 0 2008 2000 400 2400 4000 3000 200 2000 3000 -200 80 -120 3000 -2400 480 2012 10000 1000 0 2009 0 620 620 10200 7650 510 3570 3000 .00 0 J 2013 10000 1000 0 Years 2010 0 20 20 Conditional Format Formatting as Table K 2011 0 21 21 V L 3000 21 2012 0 21 21 Cell Styles M 2013 0 22 22 1080 1104 10404 10612.08 10824.32 11040.81 7959.06 8118.241 8280.606 7803 520.2 530.604 541.2161 552.0404 3641.4 3714.228 3788.513 3864.283 3000 3000 3000 3000 2610 2722.2 2836.644 2953.377 3072.444 1044 1088.88 1134.658 1181.351 1228.978 1566 1633.32 1701.986 1772.026 1843.467 3000 3000 3000 3000 620 20 21 2162 3946 4613.32 4680.986 4751.026 7005.467 N Insert v Delete v Format v O 0.02 P 8 V V O V Sort & Filter Q 6 Or Find & Select I R Comments Analyze Sensitivity Data S T Share + U 100%