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
Number Font Al XV Wine Depot, Inc G HI Wine Depot Inc. Income Statennt for the...
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 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 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 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 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) 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 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) 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 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. $ 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)...