Question

Number Font Al XV Wine Depot, Inc G HI Wine Depot Inc. Income Statennt for the period ended December-2020 %Sales December-2021 %Sales %Change 6 Sales 7 Less: Cost of Goods Sold 8 Gross Margin 9 Expenses: 10 Advertising 11 Marketing 12 Depreciation 13 Interest 14 Salary 15 Wages s 375,000 150,000 225,000 S 425,000 191,250 S 8,000 6,000 9,000 3,000 52,000 18,000 1,200 s 18,250 3,000 8,000 1,500 85,000 15,000 7,000 Supplies 17 Utilities 18 Net income before taxes 19 Income taxes 0 Net income 2,800 100,000 125,000 37,500 S 87,500 8.500146,250 87,500 26,250 S 61,250 28 30 32 Income Statement alance Sheet Ratio Analysis O Type here to search 0峊eoa Φ @粗
v Wine Depot, Inc. Wine Depot, Inc Balance Stheet as of December 2021 %Assets %Change December-2020 %Assets Assets Current Assets: S 7,000 3,500 8,500 10,500 500 S 5,000 7 Cash Short-Term Investments 6,000 9 Accounts Receivable 6,500 1,800 22,000 85,000 10 Inventory 11 Prepaid Expenses 12 Supplies 13 2.300 32.300 1 03,700 14 Equipment 15 Less: Accumulated Depreciation 8,000 77000 16,000 87.700 $120,000 16 Total 17 18 Liabilities and Stockholders Equity 9 Liabilities 20 Current Liabilities 21 Accounts Payable 22 Income Tax Payable 3 Notes Payable Equipment 24 Notes Payable- Other S 3,000 1,000 S 16,000 9,000 18,000 3,000 3,75010,750 Payroll Liabilities 2,00051,000 Stockholders Equity 27 Common Stock 28 Retained Earnings 29 Total 1,000 1,000 47.000 48,000 $ 99,000 10.250 109.250 $ 120,000 31 Income Statement Balance Sheet Ratio Analysis O Type here to search
b Copy Format Painter Number Alignment Clipboard A4 Wine Depot, Inc. Ratio Analysis December 2021 5 Profitability 6 Return on owners investment Return on total investment 8 Profit margin 9 Gross margin 10 Liquidity 11 Current ratio 12 Quick ratio 13 Receivable tumover 14 Inventory tumover 15 Solvency 16 Debt-to-equity 17 Liability 18 23 28 30 31 e Statement Balance Sheet Ratio Analysis O 0 Type here to search
Chapter 3 Case Problem 2: WINE DEPOT You are to create Wine Depots financial analyses as of December 31, 2020 and as of December 31, 2021. Following the Chapter 3 examples, use the stu- dent file ch3-05.xls to create a vertical and horizontal analysis of the balance sheet and income statement in the columns provided. (Note: The horizontal analysis will compare December 31, 2020 with December 31, 2021.) Also cre- ate a pi chart of expenses for the years ended December 31, 2020, and December 31, e chart of expenses for the year ended December 31, 2021; a column
2021; and a ratio analysis as of December 31, 2021. Save the file as ch3-05_student name.xls (replacing student_name with your name). Note: You will have to use Excels help feature to create the column chart, because the columns are not adjacent to one another as in the chapter example. Use what- ever chart layout you prefer. Print each completed worksheet in Value view, with landscape orientation, scaling to fit to 1 page wide by 1 page tall, and with your name and date printed in the lower left footer and the file name in the lower right footer. Use Excels help feature to move charts on your worksheet so that they print on a separate page.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Wine Depot Inc

Ratio Analysis

December 2021

Profitability ratios :

Profit Margin Ratio= Net income / Net Sales=$26250/$425000*100=6.176%

Gross Margin Ratio = Gross Margin/ Net Sales=$233750/$425000*100=55%

Liquidity Ratios :

Current Ratio =Current Assets/Current Liabilities=$32300/$10750=3

Quick Ratio=Cash+Cash Equivalents+Short term investments+Current receivables

Current Liabilities

=$7000+$0+$3500+$8500

$10750

=1.767

Receivables Turnover Ratio=Net Credit Sales/Average Accounts Receivables=$425000/$7250=58.62

Inventory Turnover Ratio=Cost of Goods Sold/Average Inventory=$191250/$8500=22.5

Solvency Ratios :

Debt to Equity Ratio=Total Liabilities/Total Equity=$120000/$109250=1.098

Add a comment
Know the answer?
Add Answer to:
Number Font Al XV Wine Depot, Inc G HI Wine Depot Inc. Income Statennt for the...
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
  • ch3-04 student_name.xis (h Print each completed worksheet in Vallle printed in the lower left footer and...

    ch3-04 student_name.xis (h Print each completed worksheet in Vallle printed in the lower left footer and the file name in the lower right foote Chapter 3 Case Problem 2: WINE DEPOT You are to create Wine Depot's financial analyses as of December 31, 2020, and as of December 31, 2021. Following the Chapter 3 examples, use the stu- dent file ch3-05.xls to create a vertical and horizontal analysis of the balance sheet and income statement in the columns provided. (Note:...

  • 2020; and a ch3-03 student ame. printed in the lower left footer and the HI footer...

    2020; and a ch3-03 student ame. printed in the lower left footer and the HI footer Print each completed worksheet in Chapter 3 Case Problem 1: KELLY'S BOUTIQUE ou are to create Kelly's Boutique's financial analyses as of D You file ch3-04 xls to create a vertical and horizontal analysis l compare December 31, 2018, with December 31 chart of expenses for the years ended December 31, 2018, and Dec December 31, examples, use the of the balance 2019.) Also...

  • can you help me with the T account, income statement,Balance sheet, earnings per share and Owners...

    can you help me with the T account, income statement,Balance sheet, earnings per share and Owners equity table . for the Year 2021. i added the info for the year 2020 to help Do not worry about the question in the text, i just need help with the income statement2021, Balance sheet 2021, Taccount 2021, eps and owner equity 2021. the first pocture are juste the info for 2020 1,000 Assets Current Assets Cash Inventory Total Current Assets 35,400 36,400...

  • The financial statements of Carla Vista Inc. are presented here: CARLA VISTA INC. Income Statement Year...

    The financial statements of Carla Vista Inc. are presented here: CARLA VISTA INC. Income Statement Year Ended December 31, 2021 Service revenue $2,171,500 Expenses Operating expenses $1,885,500 Interest expense 95,000 1,980,500 Income before income tax 191,000 Income tax expense 40,000 Net income $151,000 CARLA VISTA INC. Statement of Financial Position December 31, 2021 Assets Current assets Cash $62,100 Trading investments 51,000 Accounts receivable 263,800 Supplies 25,000 Property, plant, and equipment Total assets $401,900 591,300 $993,200 $136,500 Liabilities and Shareholders' Equity...

  • The financial statements of Carla Vista Inc. are presented here: CARLA VISTA INC. Income Statement Year...

    The financial statements of Carla Vista Inc. are presented here: CARLA VISTA INC. Income Statement Year Ended December 31, 2021 Service revenue $2,171,500 Expenses Operating expenses $1,885,500 Interest expense 95,000 1,980,500 Income before income tax 191,000 Income tax expense 40,000 Net income $151,000 CARLA VISTA INC. Statement of Financial Position December 31, 2021 Assets Current assets Cash $62,100 Trading investments 51,000 Accounts receivable 263,800 Supplies 25,000 Property, plant, and equipment Total assets $401,900 591,300 $993,200 $136,500 Liabilities and Shareholders' Equity...

  • 2020 Question #3 Springhill Corporation Balance Sheet December 31, 2021, and December 31", 2020 (in thousands)...

    2020 Question #3 Springhill Corporation Balance Sheet December 31, 2021, and December 31", 2020 (in thousands) 2021 Assets Current Assets: Cash $90,000 Accounts Receivable 60,000 Inventory 18,000 Prepaid Expenses 2,000 Total Current Assets 170,000 Capital Assets (PP&E) 50,000 Total Assets $220,000 $57,000 40,000 10,000 1,000 108,000 30,000 $138,000 Liabilities: Accounts Payable Accrued Liabilities Income Taxes Payable Total Current Liabilities Long Term Debt Total liabilities $11,000 6,000 5,000 22,000 40,000 362,000 $4,000 3,000 8,000 15,000 8,000 S23,000 Shareholders' Equity Common Shares...

  • ACME, Inc. Income Statement Month Ended July 31, 2018 Revenues:    Sales                           &nbsp

    ACME, Inc. Income Statement Month Ended July 31, 2018 Revenues:    Sales                                                                                    99,000 Expenses:    Wages Expense                                           25,000    Rent Expense                                               12,000    Gasoline Expense                                          2,400    Utilities Expense                                             6,000    Supplies Expense                                              400    Depreciation Expense-Del Van                      3,000    Depreciation Expense-Equip                       10,000 Total Expenses                                                                       58,800 Net Income                                                                             40,200                                                              ACME, Inc. Statement of Retained Earnings Month Ended July 31, 2018 Retained Earnings, July 1, 2012                                                         39,100 Plus:    Net Income for July                                         40,200             Less:   Dividends                                                           6,000 Increase in Retained Earnings                                                            34,200                                                 Retained Earnings, July 31, 2012                                                       73,300                         ACME, Inc. Balance Sheet July 31, 2018                         Assets                                                                               Liabilities Current Assets:                                                                                Current Liabilities:   Cash                                                                          42,000           Accounts Payable                      4,000   Accounts Receivable                                                   8,000           Sales Tax Payable                     4,500   Inventory                                                                         800             Total...

  • 2020 Question #3 Springhill Corporation Balance Sheet December 31, 2021, and December 31", 2020 (in thousands)...

    2020 Question #3 Springhill Corporation Balance Sheet December 31, 2021, and December 31", 2020 (in thousands) 2021 Assets Current Assets: Cash $90,000 Accounts Receivable 60,000 Inventory 18,000 Prepaid Expenses 2,000 Total Current Assets 170,000 Capital Assets (PP&E) 50,000 Total Assets $220,000 $57,000 40,000 10,000 1,000 108,000 30,000 $138,000 Liabilities: Accounts Payable Accrued Liabilities Income Taxes Payable Total Current Liabilities Long Term Debt Total liabilities $11,000 6,000 5,000 22,000 40,000 362,000 $4,000 3,000 8,000 15,000 8,000 S23,000 Shareholders' Equity Common Shares...

  • Below are incomplete financial statements for Cyclone, Inc. Required: Calculate the missing amounts. CYCLONE, INC. Income...

    Below are incomplete financial statements for Cyclone, Inc. Required: Calculate the missing amounts. CYCLONE, INC. Income Statement Year ended Dec. 31, 2021 Revenues Expenses: Salaries $ 12,000 Rent 6,000 Advertising 4,000 Net income CYCLONE, INC. Statement of Stockholders' Equity Year ended Dec. 31, 2021 Common Stock Retained Earnings Total Stockholders' Equity $ 19,000 13,000 $ 6,000 Beginning balance Issuances of stock Add: Net income Less: Dividends Ending balance 4,000 4,000 $ 15,000 $ 7,000 $ 22,000 Assets $ CYCLONE, INC....

  • Presented below is the 2021 income statement and comparative balance sheet information for Tiger Enterprises. $...

    Presented below is the 2021 income statement and comparative balance sheet information for Tiger Enterprises. $ 8,000 $ 3,600 260 200 2,000 6,060 1,940 (776) $ 1,164 Dec. 31, 2020 Dec. 31,2021 TIGER ENTERPRISES Income Statement For the Year Ended December 31, 2021 ($ in thousands) Sales revenue Operating expenses: Cost of goods sold Depreciation expense Insurance expense General and administrative expense Total operating expenses Income before income taxes Income tax expense Net income Balance Sheet Information ($ in thousands)...

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