Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

B6 Excel for Accounting Chapter 6: Depreciation Schedule Extend Your Skills BAG.4 Complete a Depreciation Schedule for Bill's Babe In this exercise, you will complete

image text in transcribed
B6 Excel for Accounting Chapter 6: Depreciation Schedule Extend Your Skills BAG.4 Complete a Depreciation Schedule for Bill's Babe In this exercise, you will complete a depreciation schedule for Bill's Bakery. You will use the techniques from this chapter to enter fixed-asset data in an Excel table, calculate depreciation expense, and analyze the table data. A primary goal is to ensure that the depreciation schedule can be easily understood by the end user. Use this information (provided as of 8/31/2015) to create the depreciation schedule as of 8/31/2016 for Bill's Bakery using appropriate headers and a table in which all pertinent infor mation is displayed. Fixed Asset Cost Date of Acquisition 9/1/2013 Salvage Value $200 Useful Life (years) Accumulated Depreciation $1,000 Office Furniture $3,700 Oven 10 3/1/2012 9/1/2014 $12,400 $24,000 $2,400 $0 $3,500 $2,000 Equipment Balls Bakery uses the straight-line method of depreciation. In addition to the fixed assets shown, Bakery acquired a new refrigerator on 3/1/2016. It cost $7,700, has an estimated seven year useful life, and has an estimated salvage value of $700. create the table so there is a column for each item (note that some figures may appear one in your 8/31/2016 table than they do in the 8/31/2013 e than they do in the 8/31/2015 chart). Include columns for the annual and year-end book value. Use a function to calculate depreciation expense, rences when calculating the year-end book value. Sort the table by deprecia, tion expense in descending order. Filter the table to display only assets for w le table to display only assets for which the estimated cater than $0. Last, use Quick Analysis to apply data bars to the figures in the depreciation expense and year-end book value and structured references when calculating the year- salvage value is greater than $0. Last, use Quick Accumulated Depreciation column. EA6-E2 Complete

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services

Authors: Louwers, Timothy Louwers

5th Edition

0078025443, 978-0078025440

More Books

Students also viewed these Accounting questions