ch12qz03a - g. Enter a formula in Cell F10 to calculate...

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 03 $7,800 $1,000 3 $6,800 6 Year 1 6800 1/2 $3,400 $3,400 $4,400 2 6800 1/3 $2,267 $5,667 $2,133 3 6800 1/6 $1,133 $6,800 $1,000 Directions: a. Enter a formula in Cell D7 to calculate the Depreciable Amount. b. Calculate the Sum of the Year’s Digits In Cell D8. c. Copy the Depreciable Amount into each of the cells in Column B. d. Enter the Fractions for the Years Remaining in Column C. Format Column C for Fraction and Up to one digit. e. Enter a formula in Cell D10 to calculate the Annual Depreciation. Copy the formula down Column D. f. Enter a formula in Cell E10 to calculate the Accumulated Depreciation. For the first year it equals the Annual Depreciation.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: g. Enter a formula in Cell F10 to calculate End-of-Year Book Value. Copy the formula down Column F. h. Enter a formula in Cell E11 to calculate the Accumulated Depreciation for the second year. Copy the formula down Column E. i. Format dollar entries to Currency, 0 Decimal places, and $. Depreciation Schedule Sum-of-the-Years-Digits Method Cost of Asset: Residual (Salvage) Value: Length of Service (yrs.): Depreciable Amount: Sum of the Years Digits: Depreciable Amount Fraction for the Years Remaining Annual Depreciation Accumulated Depreciation End-of-Year Book Value j. Save the file as ch12qz03a.xls. A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25...
View Full Document

Ask a homework question - tutors are online