ch12ex09a - QUICK-WRAP PACKAGING Converor Depreciation...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 12 - Exercise 09 $43,500 $3,500 5 $40,000 $8,000 Year 1 $8,000 $8,000 $35,500 2 $8,000 $16,000 $27,500 3 $8,000 $24,000 $19,500 4 $8,000 $32,000 $11,500 5 $8,000 $40,000 $3,500 Directions: a. Enter a formula in Cell C7 to calculate the Depreciable Base. b. Enter a formula in Cell C8 to calculate the Annual Depreciation. c. Copy the Annual Depreciation amount down Column B. d. Enter formulas in Column C to calculate the Accumulated Depreciation. f. Format answers for Currency, 0 Decimal places, and $.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: QUICK-WRAP PACKAGING Converor Depreciation Schedule Straight-line Method Cost of Asset: Residual (Salvage) Value: Length of Service (yrs): Depreciable Base: Annual Depreciation: Annual Depreciation Accumulated Depreciation End-of-Year Book Value e. Enter formulas in Column D to calculate the End-of-Year Book Value. Use an absolute cell reference for Cost of Asset. g. Save the file as ch12ex09a.xls. A B C D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24...
View Full Document

Ask a homework question - tutors are online