Answer is
Particulars | 31-Dec-18 | 31-Dec-19 | % of sales | % Change | ||
Sales revenue | 345,274.22 | 400,000.00 | 15.85% | |||
Less: Cost of goods sold | 164,217.74 | 210,000.00 | 47.56% | 27.88% | ||
Gross Margin | 181,056.48 | 190,000.00 | 52.44% | 4.94% | ||
Expenses: | ||||||
Advertising | 25,871.45 | 28,000.00 | 7.49% | 8.23% | ||
Depreciation | 8,431.22 | 7,000.00 | 2.44% | -16.98% | ||
Interest | 15,574.15 | 16,000.00 | 4.51% | 2.73% | ||
Payroll | 105,487.51 | 109,000.00 | 30.55% | 3.33% | ||
Supplier expense | 4,732.84 | 5,000.00 | 1.37% | 5.64% | ||
utilities | 10,847.00 | 9,000.00 | 3.14% | -17.03% | ||
Net income before taxes | 10,112.31 | 16,000.00 | 2.93% | 58.22% | ||
Income taxes | 3,784.44 | 5,000.00 | 1.10% | 32.12% | ||
Net income | 6,327.87 | 11,000.00 | 1.83% | 73.83% | ||
Assets | 31-Dec-18 | 31-Dec-19 | % of assets | % Change | ||
Cash | 8,213.50 | 6,000.00 | 1.49% | -26.95% | ||
Accounts receivable | 35,571.95 | 45,000.00 | 6.47% | 26.50% | ||
Inventory | 60,214.55 | 92,000.00 | 10.95% | 52.79% | ||
Prepaid rent | 700.00 | 1,500.00 | 0.13% | 114.29% | ||
Supplies | 300.00 | 500.00 | 0.05% | 66.67% | ||
Property Plant & Equipment | ||||||
Land | 31,000.00 | 25,000.00 | 5.64% | -19.35% | ||
Building | 400,000.00 | 427,000.00 | 72.73% | 6.75% | ||
Equipment | 35,000.00 | 33,000.00 | 6.36% | -5.71% | ||
Less: Accumulated depreciation | (21,000.00) | (30,000.00) | -3.82% | 42.86% | ||
Total | 550,000.00 | 600,000.00 | 100.00% | 9.09% | ||
Liabilities and Stockholder's Equity | 31-Dec-18 | 31-Dec-19 | ||||
Liabilities | ||||||
Current liabilities | ||||||
Accounts payable | 29,663.39 | 40,000.00 | 5.39% | 34.85% | ||
Income tax payable | 4,124.14 | 5,000.00 | 0.75% | 21.24% | ||
Notes payable | 72,000.00 | 87,000.00 | 13.09% | 20.83% | ||
Payroll liabilities | 3,212.47 | 6,000.00 | 0.58% | 86.77% | ||
Mortgage payable | 120,000.00 | 125,000.00 | 21.82% | 4.17% | ||
Stockholder's equity | ||||||
Common stock | 301,000.00 | 306,000.00 | 54.73% | 1.66% | ||
Retained earnings | 20,000.00 | 31,000.00 | 3.64% | 55.00% | ||
Total | 550,000.00 | 600,000.00 | 100.00% | 9.09% | ||
Profitabiltiy | ||||||
Return on owner's investment | 9.50% | EBIT/Capital employed | ||||
Return on total investment | 7.03% | EBIT/total fixed assets | ||||
Profit margin | 2.75% | Net income/Sales | ||||
Gross margin | 47.50% | Gross profit/Sales | ||||
Liquidity | ||||||
Current ratio | 1.01 | current ratio is calculated by adding short-term investments, and current receivables together then dividing them by current liabilities without debt | ||||
Quick ratio | 1.05 | quick ratio is calculated by adding cash, cash equivalents, short-term investments, and current receivables together then dividing them by current liabilities. | ||||
Receivable turnover | 8.89 | Net credit sales/Receivable | ||||
Inventory turnover | 2.28 | Net cogs/Inventory | ||||
Solvency | ||||||
Debt to equity | 0.41 | Total debt |
2020; and a ch3-03 student ame. printed in the lower left footer and the HI footer...
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:...
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...
deprecaion ror partial periods. Save the worbook as ha-OS student name (replacing student name with your name). Print the newly created worksheet Chapter 4 Case Problem 1: KELLY'S BOUTIQUE Kelly's Boutique owned the following fixed assets as of December 31, 2018: Description 102 103 101 Asset # Building Computer System Phone System Asset Date acquired Cost $625,000 $95,000 $25,000 $4,000 25 years $84,000 $5,000 5 years Salvage value Estimated useful life 4 years Excel for Part 1 08 You are...
Provide a brief summary of what you found in the vertical analysis. For example, comment on what the %s tell you about the company. You don't have to do every item. Simply pick out some of the higher and lower %s that you feel are most important (telling) about the company. Your comments should include the balance sheet and the income statement. Module?-Assignment2-Written Accounting Case VerticalANalysis-Tyler Fitzpatrick ALLENDALE COMPANY Balance Sheets As of December 31 Year 4 Vertical Year 4...
# need ans as soon as possible. B AutoSave C# Assignmente2(CH3) - Word Search Fiza Gang (gargt) EG File Home Insert Design Layout References Mailings Review View Help Share Comments Title Dictate Find Replace Select Editing Sensitivity Copy Peste Format Painter Clipboard Editor Calibri (Dody: 12A A Aa A E AT Aabbceod Aabbccod Aabba Aabbccc AaB AabbCD ABCD BIU*, *' ADA EEE 1 Nommal 1 . 1 1 No Spac, Heading 1 Heading 2 Subtitle Subtle Em Font Paragraph Styles...
AutoSave Off HD Unit 1 Project Fall 2020 (2) - Protected View - Excel guada gucci GG File Home Insert Draw Page Layout Formulas Data Review View Help O Search Share Comments i PROTECTED VIEW Be careful—files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X H16 fox 1 J к L N O P P Q R S т U A B с D E F G...
>Save On DT Ch 9 Student Assign Ch 9 Recording liabilities US Edition at Aug 29_18 (1) (1) - Protected Home Insert Draw Page Layout Formulas Data Review View Help "ROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. ✓ fx A B E F G H Before you begin, print out all the pages in this workbook. The unadjusted trial balance of Morgan Manufacturing Corp. at...
The green box are the directions. please help with #1 and #2 . thanks! 7 Requirements: (See sheet tabs at bottom. Use each sheet for the following requirements.) 6 Use Excel Skills in completing these requirements. You must use formules and functions, cell references, and professional formatting 1. Prepare the Amazing Company multi-step income statement for the year ended December 31, 2019. Include the EPS at the bottom. 8 Also include a vertical analysis column at the right and perform...
Stuck on Income statement Interest Expense and Depreciation Expense Previous year Balance sheet Previous year Income Statement AutoSave Problem1_Student File_F20V2.xlsx - Read-Only - Excel OB 2 Data View Team Review Help Formulas File Home Insert Page Layout - General - 11 - A A 2 Wrap Text Calibri Xcut Copy 3 Format Painter a.A BIU $ - % Merge & Center IM Num! Font Alignment Clipboard D22 1 Sales for 2019 2 Cost of goods sold as percent of sales...
Compute the following ratios. Do not round your calculations. (Always use cell references and formulas where appropriate to receive full credit.) 2019 2018 Working Capital Current Ratio Acid-Test (Quick) Ratio Cash Ratio Accounts Receivable Turnover Days' Sales in Receivables Inventory Turnover Days' Sales in Inventory Gross Profit Percentage Debt Ratio Debt to Equity Ratio Times-Interest- Earned Ratio Profit Margin Ratio Rate of Return on Total Assets Asset Turnover Ratio Rate of Return on Common Stockholders' Equity Earnings per Share (EPS)...