Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Microsoft Excel please help with functions Al fx Chloe's Coffee Shop A B D E F 1 Chloe's Coffee Shop 2 3 Cost of Asset

image text in transcribedimage text in transcribedimage text in transcribed

Microsoft Excel please help with functions

Al fx Chloe's Coffee Shop A B D E F 1 Chloe's Coffee Shop 2 3 Cost of Asset 4 Salvage Value 5 Useful Life $24,000.00 $9,000.00 5 6 7 Straight Line Depreciation Depreciation Accumulated expense for depreciation at year end of year 1 Book value at end of year End of Year 8 9 10 11 12 3 4 5 13 14 15 16 Declining-Balance Depreciation Depreciation Accumulated expense for depreciation at End of Year year end of year 1 Book value at end of year 2 3 4 5 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 14 On the Depreciation worksheet, in cell B9, use the SLN function to calculate the straight line depreciation amount for year 1. AutoFill the function down to B13. 15 In cell C9, calculate the accumulated depreciation at the end of year 1. In cell C10, calculate the accumulated depreciation at the end of year 2. AutoFill the calculation down to C13. 16 In cell D9, calculate the book value at the end of year 1. AutoFill the calculation down to D13. 17 In cell B18, use the DB function to calculate the declining-balance depreciation amount for year 1. AutoFill the function down to B22. 18 In cell C18, calculate the accumulated depreciation at the end of year 1. In cell C19, calculate the accumulated depreciation at the end of year 2. AutoFill the calculation down to C22. 19 In cell D18, calculate the book value at the end of year 1. AutoFill the calculation down to D22. Chloe's Coffee Shop Cost of Asset Salvage Value Useful Life $24,000.00 $9,000.00 5 Straight Line Depreciation Depreciation Accumulated expense for depreciation at year end of year 1 2 3 Book value at end of year End of Year 4 5 Declining-Balance Depreciation Depreciation Accumulated expense for depreciation at End of Year year end of year Book value at end of year 1 2 3 4 5

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

Im A Auditor If You Dont Want A Sarcastic Answer Dont Ask A Stupid Question

Authors: Tim Hansen

1st Edition

B088Y3ZP2D, 979-8618443227

More Books

Students also viewed these Accounting questions

Question

How autonomous should the target be left after the merger deal?

Answered: 1 week ago