ch12qz01a - Residual (Salvage) Value: Length of Service...

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 - 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:
Background image of page 1
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

Ask a homework question - tutors are online