ch12ex11a

# ch12ex11a - g Enter a formula in Cell F10 to calculate...

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

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.
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-Year’s-Digits Method Cost of Asset: Residual (Salvage) Value: Length of Service (yrs.): Depreciable Amount: Sum of the Year’s 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

## This note was uploaded on 02/19/2012 for the course BUS bus 130 taught by Professor Munoz during the Winter '10 term at Everett CC.

Ask a homework question - tutors are online