100% Original, Plagiarism Free, Tailored to your instructions

Order Now!

Excel project #2

Excel project #2
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

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

Our Service Charter

  1. Excellent Quality / 100% Plagiarism-Free

    We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers.
  2. Free Revisions

    We keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed.
  3. Confidentiality / 100% No Disclosure

    We make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service.
  4. Money Back Guarantee

    If the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit.
  5. 24/7 Customer Support

    We have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.

Excellent Quality
Zero Plagiarism
Expert Writers

Instant Quote

Single spaced
approx 275 words per page
Urgency (Less urgent, less costly):
Total Cost: NaN

Get 10% Off on your 1st order!