ch12ex09a

# ch12ex09a - QUICK-WRAP PACKAGING Converor Depreciation...

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

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 \$.
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

{[ snackBarMessage ]}

Ask a homework question - tutors are online