ch12ex12A

ch12ex12A - Format for Percentage and 2 Decimal places c In...

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

BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 12 - Exercise 12 \$145,000 5-year Class Year 1 20.00% \$145,000 \$29,000 \$29,000 \$116,000 2 32.00% \$145,000 \$46,400 \$75,400 \$69,600 3 19.20% \$145,000 \$27,840 \$103,240 \$41,760 4 11.52% \$145,000 \$16,704 \$119,944 \$25,056 5 11.52% \$145,000 \$16,704 \$136,648 \$8,352 6 5.76% \$145,000 \$8,352 \$145,000 \$0 Total \$145,000 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 \$. TOUR AMERICA BUS LINES LINES Bluebird Bus 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 5-year class from Table 12-2.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Format for Percentage and 2 Decimal places. 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-6, the Accumulated Depreciation equals the previous year’s Accumulated Depreciation plus the current year’s Annual Depreciation.) h. Save the file as ch12ex12a.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...
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