Question



Chapter 4 Case Problem 1: 

KELLY'S BOUTIQUE 

Kelly's Boutique owned the following fixed assets as of December 31, 2018: 

image.png

Part 1 Excel for Account You are to create a fixed asset depreciation summary and indivi above. Be sure to pay close attention ation worksheets for Kellys Boutique using the straight-line d sheet is correct 5 t o the date of purchase for each asset so that your summ The method based on the information tabulated above. Be sure to e summary sheet need only include depreciation from 20 preciation over their entire useful life. Follo ividual assets must show de text examples fo Asset 101 SL, Asset 102 SL, and Asset 103 SL r formatting. Label your worksheets as follows: Summ SL, he same workbook, create Kellys Boutiques fixed asset depreciation In t summary and individual depreciation worksheets using the double declining ance method and based on the tabulated information. Again, pay close at to the date of purchase for each asset so that your summary sheet is correct Label your worksheets: Summary DDB, Asset 101 DDB, Asset 102 DDB Asset 103 DDB. and the same workbook, next create Kellys Boutiques fixed asset deprecia- tion summary and individual depreciation worksheets using the sum-of-the- years digits method and based on the tabulated information. Pay close attention to the date of purchase for each asset so that your summary sheet is co rrect Label your worksheets: Summary SYD, Asset 101 SYD, Asset 102 SYD, and Asset 103 SYD. In the same workbook, you should now create a chart of Asset 101s depreci- ation (over its 25-year estimated useful life) that compares the straight-line, dou ble declining balance, and sum-of-the-years digits methods of calculating depreciation. Label this worksheet: Chart. Choose any 2D line chart and chart Save the workbook as ch4-03_student name (replacing student name with layout that you like your name). Print all worksheets in Value view, with your name and d printed in the lower left footer and the file name in the lower right foote

3 0
Add a comment Improve this question Transcribed image text
Answer #1
1 Depreciation summary as per Stright-line method (SL )
Asset# 101 102 103 Total ($)
Date acquired 1/1/2015 1/1/2017 1/1/2017
Cost ( $ )                   625,000                      95,000                    84,000
Less: Salvage value ($ )                   (25,000)                      (4,000)                    (5,000)
Depreciable value ($ )                   600,000                      91,000                    79,000
Estimated useful life ( Years ) 25 4 5
Annual depreciatio - SL ($)                     24,000                      22,750                    15,800
Depreciation -2015                     24,000                              -                               -                     24,000
Depreciation -2016                     24,000                              -                               -                     24,000
Depreciation -2017                     24,000                      22,750                    15,800                   62,550
2 Depreciation summary as per Double declaining-balance method (DDB)
Depreciation under double declaining-balance method = 2 x SL depreciation rate x Beginning book value of asset.
Asset# 101 102 103 Total ($)
SL depreciation rate (% ) 4% 25% 20%
Beginning book value of asset for the year 2015                   625,000 0 0
Depreciation (DDB )- 2015                     50,000 0 0                   50,000
Beginning book value of asset for the year 2016                   575,000 0 0
Depreciation (DDB )- 2016                     46,000 0 0                   46,000
Beginning book value of asset for the year 2017                   529,000                      95,000                    84,000
Depreciation (DDB )- 2017                     42,320                      47,500                    33,600                 123,420
3 Depreciation summary as per Sum of years of digit method (SYD)
Depreciation under some of years digit method = (Remaining useful life /Sum of the year's digit) x Depreciable value
Asset# 101 102 103 Total ($)
Depreciable value ($ )                   600,000                      91,000                    79,000
Estimated useful life ( Years ) 25 4 5
Sum of years of digit 325 10 15
Depreciation (SYD )- 2015                46,153.85                              -                               -                46,153.85
Depreciation (SYD)- 2016                44,307.69                              -                               -                44,307.69
Depreciation (SYD)- 2017                42,461.54                36,400.00              26,333.33           105,194.87
Add a comment
Know the answer?
Add Answer to:
Kelly's Boutique owned the following fixed assets as of December 31, 2018:
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • ​​​​​​ During the year ended December 31, 2018, Kelly's Camera Shop had sales revenue of $220,000,...

    ​​​​​​ During the year ended December 31, 2018, Kelly's Camera Shop had sales revenue of $220,000, of which $110,000 was on credit. At the start of 2018, Accounts Receivable showed a $11,000 debit balance and the Allowance for Doubtful Accounts showed a $700 credit balance. Collections of accounts receivable during 2018 amounted to $78,000. Data during 2018 follow: a. On December 10, a customer balance of $2,000 from a prior year was determined to be uncollectible, so it was written...

  • During the year ended December 31, 2018, Kelly's Camera Shop had sales revenue of $170,000, of which $85,000 was on...

    During the year ended December 31, 2018, Kelly's Camera Shop had sales revenue of $170,000, of which $85,000 was on credit. At the start of 2018, Accounts Receivable showed a $10,000 debit balance and the Allowance for Doubtful Accounts showed a $600 credit balance. Collections of accounts receivable during 2018 amounted to $68,000. Data during 2018 follow: a. On December 10, a customer balance of $1,500 from a prior year was determined to be uncollectible, so it was written off....

  • Rotweiler Obedience School’s December 31, 2018, balance sheet showed net fixed assets of $1,745,000, and the...

    Rotweiler Obedience School’s December 31, 2018, balance sheet showed net fixed assets of $1,745,000, and the December 31, 2019, balance sheet showed net fixed assets of $2,080,000. The company’s 2019 income statement showed a depreciation expense of $325,000. What was the company's net capital spending for 2019? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.)

  • (At December 31) 2019 2018 2017 Current assets Tangible fixed assets Intangible assets. Total assets.... $285,000...

    (At December 31) 2019 2018 2017 Current assets Tangible fixed assets Intangible assets. Total assets.... $285,000 662,500 40,000 $987,500 $277,500 575,000 45,000 $897,500 $207,000 563,000 50,000 $820,000 Current liabilities.. Noncurrent liabilities. Common stock. Additional paid-in capital. Retained earnings Stockholders' equity Total liabilities and equity $120,000 266,250 100,000 100,000 400,000 600,000 $986,250 $110,000 242,500 100,000 100,000 345,000 545,000 $897,500 $100,000 220,000 100,000 100,000 300,000 500,000 $820,000 2019 2018 2017 (For the years ended December 31) Revenues Expenses .. Net income $970,000...

  • During the year ended December 31, 2018, Kelly's Camera Shop had sales revenue of $195.000, of...

    During the year ended December 31, 2018, Kelly's Camera Shop had sales revenue of $195.000, of which $97,500 was on credit. At the start of 2018, Accounts Receivable showed a $12,000 debit balance and the Allowance for Doubtful Accounts showed a $650 credit balance Collections of accounts receivable during 2018 amounted to $73.000. Data during 2018 follow: a. On December 10, a customer balance of $1,750 from prior year was determined to be uncollectible, so it was written off. b....

  • During the year ended December 31, 2018, Kelly's Camera Shop had sales revenue of $195.000, of...

    During the year ended December 31, 2018, Kelly's Camera Shop had sales revenue of $195.000, of which $97,500 was on credit. At the start of 2018, Accounts Receivable showed a $12,000 debit balance and the Allowance for Doubtful Accounts showed a $650 credit balance Collections of accounts receivable during 2018 amounted to $73.000. Data during 2018 follow: a. On December 10, a customer balance of $1,750 from prior year was determined to be uncollectible, so it was written off. b....

  • hnny Inc. purchased certain fixed assets under a deferred payment contract on December 31, 2018. The...

    hnny Inc. purchased certain fixed assets under a deferred payment contract on December 31, 2018. The agreement was to pay $20,000 at the time of purchase and $20,000 at the end of each of the next five years. The fixed assets should be valued at: a)The present value of a $20,000 ordinary annuity for 5 years. b)$120,000. c)$120,000 less imputed interest. d)$120,000 plus imputed interest.

  • During the year ended December 31, 2018, Kelly's Camera Shop had sales revenue of $190,000, of...

    During the year ended December 31, 2018, Kelly's Camera Shop had sales revenue of $190,000, of which $95,000 was on credit. At the start of 2018, Accounts Receivable showed a $11,000 debit balance and the Allowance for Doubtful Accounts showed a $640 credit balance. Collections of accounts receivable during 2018 amounted to $72,000. Data during 2018 follow: a. On December 10, a customer balance of $1,700 from a prior year was determined to be uncollectible, so it was written off....

  • The amounts of the assets and liabilities of Journey Travel Agency at December 31, 2018, the...

    The amounts of the assets and liabilities of Journey Travel Agency at December 31, 2018, the end of the year, and its revenue and expenses for the year follow. The retained earnings were $1,341,000 on January 1, 2018, the beginning of the year. During the year, dividends of $75,000 were paid. Accounts payable $ 69,500 Accounts receivable 236,500 Cash 190,500 Common stock 450,000 Fees earned 383,500 Land 1,500,000 Miscellaneous expense 14,500 Rent expense 22,500 Supplies 7,000 Supplies expense 11,300 Utilities...

  • The assets, liabilities, and equities of Darling Design Studio have the following balances at December 31, 2018

    The assets, liabilities, and equities of Darling Design Studio have the following balances at December 31, 2018. The retained earnings was $32,000 at the beginning of the year. At year end, common stock was $21,000 and dividends were $53,000. Prepare the balance sheet for Darling Design Studio as of December 31, 2018.

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT