FIRST, DOWNLOAD THE EXCEL WORKBOOK POSTED TO BLACKBOARD, NAMING IT APPROPRIATELY:

Lastname.Firstname.Excel1, or Lastname.Lastname.Lastname.Excel1 (for those working in a group of 3 people).   Examples: Kaciuba.Gail.Excel1 or Kaciuba.Eynon.Smith.Excel1

You are to prepare two depreciation schedules using Excel.  Proper use of relative and absolute cell referencing, as demonstrated in class, is expected.  Each student will use a different cost, salvage value, and useful life.  This information is posted to Blackboard.  Be sure to use the cost, salvage value, and useful life for the asset assigned to you. Assume the asset was purchased on January 1 of Year 1.

You must create the template to calculate Depreciation Expense Accumulated Depreciation, and net Book Value for each year of the asset’s life for (1) the straight line method and (2) the double declining balance method. Show both depreciation schedules on one tab. At the top of this tab, put the given information:

Cost of machine    This cell will contain a cell reference to the given info

Salvage value    This cell will contain a cell reference to the given info

Depreciation value    This cell will contain a cell reference to the given info

Useful life    This cell will contain a cell reference to the given info

DDB rate    This cell will contain a formula

Each of your depreciation schedules will look like this:

Year    Depreciation Expense    Accumulated Depreciation    Net Book Value

1

2

3

€¢

€¢

€¢

Every shaded cell will contain a formula or a cell reference. You must use absolute cell referencing where possible. Each schedule should have a row for every year of the asset’s life. All cells must be appropriately formatted as well. Additionally, format the spreadsheet for proper printing (even though you don’t have to print it out). Just use the print preview button to make sure that a printout would be usable and look good.

Name     Cost      Salvage     Life

Almanza     $340,000      $27,200     13 years

Alvarez     $343,400      $27,472     14 years

Alzahrani     $346,834      $27,747     15 years

Dockery     $350,302      $28,024     13 years

Gamez & Moreno     $353,805      $28,304     14 years

Gavin     $357,343      $28,587     15 years

Gutierrez     $360,917      $28,873     13 years

Martinez     $364,526      $29,162     14 years

Pena     $368,171      $29,454     15 years

Zamora     $371,853      $29,748     13 years

Zamudio     $375,572      $30,046     14 years