Please show work in excel with all the formulas like the excel posted thanks. 
A B D F G - K * L L M z H N o P Q R S T U COLD AND SWEET COMPANY 900,000 0 10 Corporate tax rate Cost of capital 30% 14% 100,000 0 3 1 600,000 1.3 2 600,000 1.3 600.000 1.3 4 600,000 1.3 5 600.000 1.3 0.5 0.5 0.5 0.5 0.5 1 2 Chocolate covering machine: 3 Cost 4 Salvage value 5 Depreciation schedule (years) 6 => annual depreciation 7 8 Sell the machine after 5 year for g Net book value of the machine at selling point 10 Capital gains from selling the machine: 11 Tax shield on capital gains loss 12 Net after-tax terminal value 13 14 Year 15 Additional bars sold 16 Bar price (S/unit) 17 Additional revenues on bars sold 18 Production cost per bar (S/unit) 19 Production costs on bars sold 20 Other costs 21 Marketing expenses 22 Depreciation 23 Earings before taxes 24 Corporate tax 25 Net operating profit after tax 26 Capital investment and terminal value) 27 Add back depreciation 28 Free cash flow 29 30 Section b. NPV calculations 31 32 Section c. 33 Minimum bar price (S/unit) 34 Year 35 Additional bars sold 36 Bar price ($/unit) 37 Additional revenues on bars sold 38 Production cost per bar (S/unit) 39 Production costs on bars sold 40 Other costs 41 Marketing expenses 42 Depreciation 43 Earnings before taxes 44 Corporate tax 45 Net operating profit after tax 46 Capital investment 47 Add back depreciation 48 Free cash flow 49 50 NPV III Annual depreciation 900,000 0 10 Corporate tax rate Cost of capital 145 100,000 0 Sel the machine aher 5 year for Netbook value of the machine at selling point Capital gains tomling the machines Tee Shield on capital gains oss Nekatertaxminal value Yet 0 2 1 800,000 1.3 100,000 1.3 5 800,000 1.3 1.3 05 0.5 0.5 05 15 5 Adetonal basso 16 Bar price (Sun 17 Addtional revenues on ben sold 18 Production cost per bar (bunt) 10 Production costs on an sold 20 Omer costs 21 Marting expens 22 Depreciation 2a Eamngs before as 24 Corporate tax 23 Net Operating proft after tax 2 Capital investment and terminal value) 27 Add back depreciation 28 Free cash fow Becton NPV calculations calculated using goaleek 2 3 4 5 Harpnoun Minimum bar price Year 25 Addbone old Additional revenues on band Produtoscou per bar) Paduction costs on bons sold 40 Other Manering expenses Deprecate Camisetas 4 Capaal van Net operating profesor tax 41 Add back preco Corporate SONY 126 x fe Formatting as Table Styles B D E J L V Net operating profit after tax Capital investment Add back depreciation Free cash flow NPV calculated using gok Section Minimum number of additional bars old Year Additional bars old Bar price (Sun) Additional venues on bars sold Production com per bar (unt) Production costs on bassord Other costs Marketing expenses Depreciation Earings before taxes Corporate tax Net operating profe after tax Capital investment Add back depreciation NV Annuai unt ales - Unt price 12 13 14 1. 1.0 1.7 400,000 450.000 500,000 550,000 600,000 850,000 700,000 750,000 800,000 850,000 990,000
