ch12qz01a

# ch12qz01a - Residual(Salvage Value Length of Service(yrs...

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

BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 12 - Quiz 01 \$7,800 \$1,000 3 \$6,800 \$2,266.67 Year 1 2266.67 2266.67 \$5,533 2 2266.67 4533.34 \$3,267 3 2266.67 6800.01 \$1,000 Directions: a. Enter a formula in Cell C7 to calculate the Depreciable Base. c. Copy the Annual Depreciation amount down Column B. d. Enter the formulas in Column C to calculate Accumulated Depreciation. f. Correct the Annual Depreciation in Year 3, if necessary. g. Format answers for Currency, 0 Decimal places, and \$. Depreciation Schedule Straight-line Method Cost of Asset:
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Residual (Salvage) Value: Length of Service (yrs): Depreciable Base: Annual Depreciation: Annual Depreciation Accumulated Depreciation End-of-Year Book Value b. Enter a formula in Cell C8 to calculate the Annual Depreciation. Round to the nearest whole number. Use absolute cell references. The formula should be =ROUND((\$C\$7/\$C\$6),0). e. Enter formulas in Column D to calculate the End-of-Year Book Value. Use an absolute cell reference for Cost of Asset. h. Save the file as ch12qz01a.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...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online