ch12test04a - c. In Cell D7, enter a formula 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 - Test 04 $3,700 3-year Class Year 1 33.33% 3700 1233 1233 $2,467 2 44.45% 3700 1645 2878 $822 3 14.81% 3700 548 3426 $274 4 7.41% 3700 274 3700 $0 Total 3700 Directions: b. In Cell C7, enter the Cost Basis for the asset. Copy it down Column C. f. In Column F, enter formulas to calculate End-of Year Book Value. g. Format all dollar amounts for Currency, 0 Decimal places, and $. ANGLIN FARMS Race Horse Depreciation Schedule • Modified Accelerated Cost Recovery System Cost of Asset (Cost Basis): Life of Asset: Rate % Cost Basis Annual Depreciation Accumulated Depreciation End-of-Year Book Value a. In Column B, enter the percentage rates for the 3-year class from Table 12-2. Format for Percentage and 2 Decimal places.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: c. In Cell D7, enter a formula to calculate Depreciation for Year 1. Round to the nearest whole number. The formula is =ROUND((B7*C7),0). Copy the formula down Column D. d. Use the AutoSum button to total Column D. If necessary, adjust the Depreciation in Cell D12 to make the Total Depreciation agree with the Cost of Asset. e. In Column E, enter formulas to calculate Accumulated Depreciation. (In Year 1, the Accumulated Depreciation equals the Annual Depreciation. In Years 2-4, the Accumulated Depreciation equals the previous years Accumulated Depreciation plus the current years Annual Depreciation.) h. Save the file as ch12test04a.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...
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