Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Provide vertical (common-size) income statements and balance sheet for the three years. EXHIBIT 1: INCOME STATEMENT, July 1 to June 30 (IN THOUSANDS) 2018-2019 100,000
Provide vertical (common-size) income statements and balance sheet for the three years.
EXHIBIT 1: INCOME STATEMENT, July 1 to June 30 (IN THOUSANDS) 2018-2019 100,000 200,000 300,000 180,000 120,000 40,000 2019-2020 150,000 600,000 750,000 450,000 300,000 100,000 2020-2021 200,000 1,000,000 1,200,000 720,000 480,000 200,000 Sales - Cash Sales - Credit Total sales Cost of goods sold Gross profit Selling, general, and administrative expenses Depreciation Operating income Interest expense Income before tax Tax@30% Net income 15,000 65,000 12,000 53,000 15,900 37,100 40,000 160,000 40,000 120,000 36,000 84,000 75,000 205,000 72,000 133,000 39,900 93,100 EXHIBIT 2: BALANCE SHEET (IN THOUSANDS) June 30, 2019 June 30, 2020 June 30, 2021 Assets Cash and cash equivalents Accounts receivable Inventories Current assets Property, Plant and Equipment (net of accumulated depreciation) Total assets 132, 100 40,000 45,000 217,500 150,000 191,100 150,000 120,000 461,100 400,000 154,200 300,000 260,000 714,200 750,000 367,100 861,100 1,464,200 Liabilities and Shareholder's equity Account payable Current portion of LT debt Current liabilities Long-term debt Total liabilities Share capital - common Retained earnings Total shareholders' equity Total liabilities and equity 30,000 50,000 80,000 100,000 180,000 150,000 37,100 187,100 367,100 90,000 100,000 190,000 400,000 590,000 150,000 121,100 271,100 861,100 200,000 200,000 400,000 700,000 1,100,000 150,000 214,200 364,200 1,464,200 EXHIBIT 3: INDUSTRY AVERAGES Current ratio Quick ratio Accounts receivable turnover ratio Average collection period Inventory turnover ratio Days in inventory Financial debt to equity ratio Operating liabilities to equity ratio Gross profit ratio Net profit ratio Return on equity Return on total assets Total asset turnover ratio Fixed asset turnover ratio Times interest earned ratio 2:1 1.5:1 6 times 60.8 days 7 times 50.7 days 120% 30% 40% 12% 40% 24% 2.0 3 5Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started