5. (4 pts) Depreciation: The equipment is assumed to have an 8-year life with a salvage value of $40,000 at the end of that 8 year period. There is a separate worksheet named Depreciation that contains the cells needed for this depreciation calculation. Please assume that you can use the Straight Line Depreciation (SLN) formula. Name each of the cells containing the original equipment cost (B3), the salvage value (B4), and the expected life of the equipment, B5, as Capital, Salvage and Life respectively. For the "Capital" cell, B3, have this cell refer to cell J3 on the CashFlow worksheet so that if the loan amount changes on the front page this depreciation calculation automatically updates as well. After naming these 3 cells, back on the cash flow worksheet on row 16, calculate the depreciation for this new equipment using the Straight Line depreciation method. Make sure to format the cells so that negative cashflows are calculated as negative numbers and appear in parentheses. Hint, these values should be negative since we get to deduct the cost of the depreciation of this piece of equipment for each of these 4 years. 5 $ - % 00 Formats Table Cell Styles Styles Delete Format - Alignment Number Cells f D E F es. Save 1 Depreciation Values 2 Range Name Value 3 Capital 4 Salvage 5 Life 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Close CashFlow + Depreciation Display Settings Stv P G Save $ 64.750.00 450N Loan Information Original Loan machine installation terest Rate Loan curation Number of periods per year Ending Value of loss 12 D 1 Teus Tumbler Project Proleted 4. Year Cath Faw Estimate 2 Year amber 3 Income 2 3 4 4 Sales Volume 457000 4470.00 1910.00 5190.00 5 Selling Price per Tumbler 19.50 19.93 2013 20.25 5 Gros Revene 5279.355.00 5 38.997.70 5.99.820.50 511189640 7 8pca 9 Variable Expenses amounts per unit Bach 10 Cost of Goods Sold 111101 17.00 6412100 06.00 11 Marketing Cost 11.15 5494.50 601450 1641203 Z250 Shipping cost (165) 16715.50 0737550) (3101.501 18993.501 Cost Savines per ble from new 13 augment 1.50 610500 670500 7365.00 605.00 14 Tired penses amounts per year) 15 pense 2004 1910 1011 14244 16 Decreto 17 Taxable income 517338.44 24.125.475 26.95 29.5 32.777.97 TB Corporate Time ZON 19 State Federal Oued 4764102-61111160021-912261 20 Income After Taxe Add Back Depreciation Subtraction Payments 23 Proiected Cashflow tatimai M 25 25 20 lose Cash Flow Depreciation Amortization Personal Extra Credit
