: % Pasto Conditional Formatting Format as Table Cal Styles Font Alignment Number 122 fx + D TEAT What would be beated with Nire ce were for $15,000, what we heated with this sale! c. If the machine were for $15,000, what would be the bed with this a theoll meine were sold for $12,000, what would be the seed with this? Campes belowig eller en teglver previous call CRNA ale cellerne bally wed to appears awardew or a cell reference and all reference may le preferred a speciale Brendone the wilde werfen. Door al dia celor mail make a reference to the cell in which und Make your company new celle Alhad belowIn all cases, en directed the earlience of the day your formules will the Given s Deco DATA 7. Purchase SOTOCO Expected life 10 Salage value 30 10 Deprecisa S000 TH Tax 219 13 Years from when purchased 5 13 T SOLUTION 15 Accumulated depreciation 36 Book valor 97 1. What would be the new auciated with this sale? 13 20 Selling price $15.000 2 Profilow from sale 22 Times 23 20 hIf the old machine were sold for .000, what would be the ones associated with this a Selling price Profisloss from Soc. If the old machine wereld for SiS., what would be the stered with sale! 13 Selling price $15.000 Proflow from 34 Tanes 35 3 d. If the old machine wereld for $12.000, what would be the taxes sociased with * Selling price 12.00 3 Profisso from a Taxes Requirement Start Excel Dosdunderm wok med eos Mas Prayholm porcelasan Nellten Do NOTA was in the 1114 Ready % Paste Font Alignment Number conditional FC Format as Tab Call Styles 122 x fx 6 39 Profiles from sale 40 Taxes 41 42 Requirements 1. Start Excel Download and open the workbook and Keown Martin Petty Problem - 4 Start Important note: All cakeulation must be shown using cell references. Do NOT numerical values in the cells 43 2. In cell 315, cakatete embled depreciation Note: The spot of the expression or function you typed in this cell is expected as a positive 44 number (Ipolet) 45 3. In cell 16, calculate the book value of the set (1 polit) 45 4. In cel calculate the profilous from the sake of camel (polet) 15. in cell 2. calculate the taxes doe from the sale of these Note: The out of the expression or function you oped in this cell is expected as a posive number if the sale of the awet turns a profit. Oderwise, it is expected negatieve polit) a 6 in cell en calculate the protivloes from the sale of the mette point 3. In cel 112, calculate the taxes de from the sale of the Note: The output of the expression or fation you ped in the cell is expected as a postane number if the sale of the profit. Otherwise, expected as a negative all point 10 K Incell, calculate the protistou from the sale of the act (1 point) s cell 04, calculate e dor from the sale of the aset Note The cup of the expresion or function you Dped in this cellis pead Motive aber if the sake of teachers a profit in expected as a new val. (1 5 point 10 la cell cake the prodit low from the sake of these po Incelli cakulate the taxes de front of me Ne of the expect function you pede pedra number if the sake of the returns a priori 5 point 12 Save the world the workbook and then itxcel Soria decid ST ce 11-4 Ready