Help me to do the TREND ANALYSIS both please please :( BARRY'S SUPERSTOREBARRY'S SUPERSTOREComparative Year-End Income StatementsComparative Year-End Balance SheetsPrior YearCurrent YearPrior Year Current YearNet Sales$100,000$120,000Assets:50,00050,000Cost of Goods Sold60,000Cash$90,000$110,000Gross Profit60,000Accounts Receivable20,00030,000InventoryShort-Term Investments35,00040,000Rent ExpenseDepreciation ExpenseSalaries ExpenseUtility Expense15,000160,00040,000$200,00020,000200,0005,0005,5002,5003,600Total Current AsstesEquipmentTotal Assets50,000$250,0003,0005,4001,5002,500Operating Income38,00043,000Liabilities:Interest ExpenseIncome Tax ExpenseAccounts PayableUnearned RevenueTotal Current Liabilities$ 60,00010,00070,000$ 75,00025,000100,0003,0002,0005,0006,000Net Income$ 30,000$ 35,000Notes Payable40,000110,00050,000Total Liabilities150,000Stockholder EquityCommon Stock75,00080,000Ending Retained EarningsTotal Stockholder EquityTotal Liabilities and Stockholder Equity15,00090,000$200,00020,000100,000$250,000

The financial statements of any company is usually presented for 2 year comparative statement. This…

BARRY'S SUPERSTORE BARRY'S SUPERSTORE Comparative Year-End Income Statements Comparative Year-End Balance Sheets Prior Year Current Year Prior Year Current Year Net Sales $100,000 $120,000 Assets: Cost of Goods Sold 50,000 60,000 Cash $90,000 $110,000 Gross Profit 50,000 60,000 Accounts Receivable 20,000 30,000 Inventory Short-Term Investments 35,000 40,000 Rent Expense Depreciation Expense Salaries Expense Utility Expense 5,000 5,500 15,000 20,000 2,500 3,600 Total Current Asstes 160,000 200,000 50,000 $250,000 3,000 5,400 Equipment Total Assets 40,000 $200,000 1,500 2,500 Operating Income 38,000 43,000 Liabilities: $ 60,000 10,000 70,000 $ 75,000 Interest Expense Income Tax Expense 3,000 5,000 Accounts Payable Unearned Revenue Total Current Liabilities 25,000 2,000 6,000 $ 35,000 100,000 $ 30,000 Notes Payable Net Income 40,000 110,000 50,000 Total Liabilities 150,000 Stockholder Equity Common Stock 75,000 80,000 Ending Retained Earnings Total Stockholder Equity 15,000 90,000 $200,000 20,000 100,000 Total Liabilities and Stockholder Equity $250,000

BARRY'S SUPERSTORE BARRY'S SUPERSTORE Comparative Year-End Income Statements Comparative Year-End Balance Sheets Prior Year Current Year Prior Year Current Year Net Sales $100,000 $120,000 Assets: Cost of Goods Sold 50,000 60,000 Cash $90,000 $110,000 Gross Profit 50,000 60,000 Accounts Receivable 20,000 30,000 Inventory Short-Term Investments 35,000 40,000 Rent Expense Depreciation Expense Salaries Expense Utility Expense 5,000 5,500 15,000 20,000 2,500 3,600 Total Current Asstes 160,000 200,000 50,000 $250,000 3,000 5,400 Equipment Total Assets 40,000 $200,000 1,500 2,500 Operating Income 38,000 43,000 Liabilities: $ 60,000 10,000 70,000 $ 75,000 Interest Expense Income Tax Expense 3,000 5,000 Accounts Payable Unearned Revenue Total Current Liabilities 25,000 2,000 6,000 $ 35,000 100,000 $ 30,000 Notes Payable Net Income 40,000 110,000 50,000 Total Liabilities 150,000 Stockholder Equity Common Stock 75,000 80,000 Ending Retained Earnings Total Stockholder Equity 15,000 90,000 $200,000 20,000 100,000 Total Liabilities and Stockholder Equity $250,000

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 51E: Juroe Company provided the following income statement for last year: Juroes balance sheet as of...

See similar textbooks

Similar questions

Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.
Required information ($ thousands) Net sales Cost of goods sold Current Year $ 885,182 396,513 Current Year: Prior Year: Determine the Prior Year and Current Year trend percents for net sales using the Prior Year as the base year. (Enter the answers in thousands of dollars.) Prior Year $ 456,779 137,643 Numerator: Trend Percent for Net Sales: Denominator: Trend Percent 0% 0%
Complete the balance sheet and sales information using the following financial data Total assets turnover: 1.5 X Days sales outstanding: 36.5 days (Calculation is based on a 365-day year) Inventory turnover ratio: 5 X Fixed assets turnover: 3.0 X Current ratio: 2.0 X Gross profit margin on sales: (Sales - Cost of goods sold) ∕ Sales = 25% Cash ------------ Current Liabilities -------- Accounts Receivables ------------ Long Term Liabilities 60000 Inventories ------------ Common Stock -------- Fixed Assets ------------ Retained Earnings 97500 Total Assets 300000 Total Liabilities and Equity --------- Sales Cost of goods sold --------- Interpret the current ratio, total assets turnover ratio, inventory turnover ratio and profit margin on sales.
Determining Gross Profit During the current year, merchandise is sold for $11,750,000. The cost of the goods sold is $7,050,000. a. What is the amount of the gross profit?$ b. Compute the gross profit percentage (gross profit divided by sales). Round to the nearest whole number. % c. When will the income statement report net income?
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.2x Days sales outstanding: 36 days Inventory turnover ratio: 7x Fixed assets turnover: 2.5x Current ratio: 1.5x Gross profit margin on sales: (Sales- Cost of goods sold)/Sales = 20% Calculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash Accounts receivable. Inventories Fixed assets Total assets Sales $300,000 Current liabilities Long-term debt Common stock Retained earnings Total liabilities and equity Cost of goods sold 45,000 90,000
Analysis of the statement of financial position of Charon for the year ended 20X9 reveals the following relationships: Current ratio 2:1 Sales: current assets 5:1 Acid test ratio 1.5:1 If the sales for the year were $30 million, what is the value of inventory that will appear in the statement of financial position? A $1.5m B $10.5m C $3.0m D $4.5m
Comparative income statements and balance sheets for F&N are shown below ($ millions): Year 2 Year 1 Income Statement $19,889 6,204 Net sales. $20,092 6,044 Cost of goods Gross profit. Selling, general, and administrative expense Depreciation and amortization expense Interest expense (revenue) 14,048 7,893 803 (308) 13,685 9,221 773 292 3,399 1,222 Income before tax 5,660 1,691 Income tax expense. Net income $ 3,969 $ 2,177 Outstanding shares 3,491 3,481
Assume the following sales data for a company: Line Item Description Amount Current year $883,993 Preceding year 542,076 What is the percentage increase in sales from the preceding year to the current year? a. 63.08% b. 61.32% c. 163.08% d. 38.68%
Assume the following sales data for a company: Current year $896,005 Preceding year 607,844 What is the percentage increase in sales from the preceding year to the current year (rounded to one decimal place)? Oa. 47.4% Ob. 15.3% Oc. 32.2% Od. 79.6%
Supply the missing components of the Statement of Financial Position and Sales information using the following financial data:Debt ratio: 50%Current ratio: 1.8×Total assets turnover: 1.5×Days sales outstanding: 36.5 days*Gross profit margin on sales: (Sales − Cost of goods sold)/Sales = 25%Inventory turnover ratio: 5×*Calculation is based on a 365-day year.Statement of Financial Position(in Thousands)Cash ________Accounts payable_________Accounts receivable ________Long-term debt PhP120,000Inventories ________Common stock_________Fixed assets ________Retained earnings 195,000Total assets PhP600,000Total liabilities and equity _________Sales _______Cost of goods sold _________
Required information For Year Ended December 31 Sales Cost of goods sold Other operating expenses Current Year $ 411, 225 209,550 12, 100 9,525 $ 673,500 642, 400 $31,100 $ 1.90 :. -. - == ....... 9 US Sa M
Given the following: Current Assets $ 18,000 Accounts Receivable $ 3,000 Current Liabilities $ 16,000 Inventory $ 2,000 Net Sales $ 41,000 Total Assets $ 29,000 Net Income $ 6,000 Find the following (round to the nearest hundredth if needed): Current Ratio? Acid test quick ratio? Average days collection ? Asset turover ? Profit Margin on net sales?