ch12ex11a - 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 - Exercise 11 $59,000 $6,000 7 $53,000 28 Year 1 53000 1/ 4 $13,250.00 $13,250.00 $45,750.00 2 53000 3/14 $11,357.14 $24,607.14 $34,392.86 3 53000 5/28 $9,464.29 $34,071.43 $24,928.57 4 53000 1/ 7 $7,571.43 $41,642.86 $17,357.14 5 53000 3/28 $5,678.57 $47,321.43 $11,678.57 6 53000 1/14 $3,785.71 $51,107.14 $7,892.86 7 53000 1/28 $1,892.86 $53,000.00 $6,000.00 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 for Fraction and Up to two digits. 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 $. PRECISION MACHINE SHOP Drill Press 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 ch12ex11a.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 26 27 28 29...
View Full Document

Ask a homework question - tutors are online