ch12qz04a - 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 ______________________________ $2,900 3-year Class Year 1 33.33% 2900 967 967 $1,933 2 44.45% 2900 1289 2256 $644 3 14.81% 2900 429 2685 $215 4 7.41% 2900 215 2900 $0 Total 2900 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 D, 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 ch12qz04a.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

Ask a homework question - tutors are online