Can a Company with this Financial Analysis of Data be successful with obtaining a $500.0 million loan? Justify.Image Attached. 2021Ratio AnalysisIndustryAverageEst.20202019Liquidity RatiosCurrent Ratio (times)2.343.233.684.2Quick Ratio (times)0.911.241.802.1Asset Management RatiosAverage sales/day10.968.227.81Inventory Tumover Ratio (times)4.433.745.06Days Sales Outstanding (days)38.3345.6340.3436Fixed Assets Turmover Ratio (times)2.122.523.28Total Asset Tumover Ratio1.321.371.701.8Debt Management RatiosTotal Debt to Total Assets (%)59.1048.5847.6240Times Interest Eamed (times)7.906.82116Debt to Equity Ratio (%)1.5111Profitability RatiosProfit Margin on Sales (%)10.2510.1112.49Eaming Power (%)26.0827.3939.2917.2Retum on Total Assets (%)13.5413.8521.1912Return on Common Equity (%)34.1927.9242.3825Market Value Ratios Price/Earnings RatioPrice/Eamings Ratio (times)3.413.793.6512.5Price/Cash Flow Ratio (times)2.692.852.916.8Market /Book Value Ratio (times)1.171.061.551.7en

Answered: Can a Company with this Financial…

Business

Accounting

Can a Company with this Financial Analysis of Data be successful with obtaining a $500.0 million loan? Justify.

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter6: Merchandising Transactions

Section: Chapter Questions

Problem 19Q: The following is select account information for Sunrise Motors. Sales: $256,400; Sales Returns and...

See similar textbooks

Similar questions

Solution to Ratio Analysis Questions Selected ratios formulars Unilever 2021 BOPP 2021 ROCE PBIT / net assets * 100 (32,424/39,406 *100 = - 82% 102,154 / 192,758 *100 =53% Net Assets Turnover Revenue / Net Assets 526,912 / 39,406 = 13 times 214,174 / 192,758 = 1 time Gross Profit Margin Gross profit / revenue *100 97,046 / 526,912 *100 18.4% 115,462 / 214,174 * 100 54% Net Profit Before Tax PBT / revenue * 100 (35,005) / 526,912* 100 = -6.6% 104,778 / 214,174* 100 =48.9% Current Ratio Current assets / current liabilities 214,665/341,171 = 0.5 139,104 / 30,368 = 4.5 Quick Ratio Current assets – inventory / current liabilities 214,665-91,627 /341,171 = 0.4 139,104 -13,248/ 30,368 = 4.1 Inventory Days Inventory / cost of sales * 365 days 91,627/ 429,866 *365 = 77 days 13,248 / 101,397 *365 = 47 days Receivable Days Receivables / cost of sales * 365 days 24,515 / 429,866 *365 =20 days 92,860 /…
Analyze the ratios and give you a report on the same. Gross Profit Ratio = Gross Income/ Sales = 3073.7/10577 = 29.06% Net Profit Ratio = Net Income/ Sales = 80.3/10577 = 0.76% Current Ratio = Current Assets/ Current Liabilities Liquid Ratio = 3581.3/6150 = 58.23% = 7439.2/6150 = 1.21
Q. Calculate the current assets and current liabilities from the data given below. Current ratio. 1.8 Quick ratio. 1.2 Inventory turnover ( on c.g.s). 12 Gross profit rate. 25% Credit period. 1month Working capital. 640000
GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL AND VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - -…
How do you calculate net sales? Also... Do you only look at current year data or do you factor previous year data and current year? Thx
i. Use the information available in Income and Financial position statementin Part A and calculate the following ratios for DavidCompetitors Average• Net profit margin 28%• Gross profit margin 65%• Current ratio 2.10x• Acid test ratio 1.50x• Accounts receivable collection period 47 days• Accounts payable payment period 65 days Net Profit Margin = Net Income/ Sales = 350/2300 = 15.22% Gross Profit = Sales Revenue + Ending Inventory - Purchases less purchase returns = 2300 + 250 - 1100 = 1450 Gross Profit Margin = Gross Profit/ Sales = 1450/2300 = 63.04% Current Ratio = Current Assets/ Current Liabilities Current Assets = Cash + Bank + Accounts Receivable + Inventory = 4050 + 17100 + 400 + 250 = 21800 Current Liabilities = Accounts Payable = 700 Current Ratio = 21800/700 = 31.14:1 please answer this QUESTION :ii. Assuming David’s competitor’s ratio averages are as stated above:Analyse his performance with reference to each of the ratios calculatedin comparison to those of her…
B. Below is the Statement of Comprehensive Income of Q & A Trading Company: Percentage 2020 P1,939,500 900,000 1,039,500 445,500 37,575 P 556,425 2019 Percentage Revenue Cost of Goods Sold Gross Profit Selling and General Experses Other Experses Net Income P1,674,675 843,975 830,700 409,725 30,825 P 390,150 Requirements: Prepare a vertical aralysis for Q & A Trading Compary.
Required information Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 (The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2020 2019 Sales $ 442,035 $ 338,635 212,324 126, 311 $ 235,000 Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes 266, 105 150,400 175,930 62,769 39,783 102,552 73,378 13,648 $ 59,730 84,600 31,020 46,732 29,800 76,532 49,779 19,505 50,525 34,075 Income tax expense 10, 205 6,917 Net income $ 39,574 $ 27,158 KORBIN COMPANY Comparative Balance Sheets December 31 2021 2020 2019 Assets Current assets $ 55,578 $ 37, 199 $ 49,726 Long-term investments Plant assets, net 900 4,570 56,095 104,820 $ 160,398 95,143 Total assets $ 133, 242 $ 110,391 Liabilities and Equity Current liabilities $ 19,853 $ 23,418 68,000 8,500…
The following financial results are shown for Smith, Inc. and Jones, Inc. RatiosSmith, Inc.Jones, Inc.Current ratio2.31.9Acid test ratio1.2.9Accounts receivable turnover8.4 times6.8 timesInventory turnover4.7 times3.1 timesDays sales in inventory64 days799 daysDays sales uncollected34.2 days39.7 daysProfit margin ratio3.2% 4.8% Total asset turnover1.11.8 Return on common stockholder' equity 4.6 %6.1% Price earnings ratio18.310.7Dividend yield.89%.90Debt ratio.62.47Times interest earned2.6 times6.2 times From the above financial data, prepare two separate memos. In the first memo, determine which of the two companies would be the better short-term credit risk and explain why. In the second memo, determine which of the two companies the better investment is and explain why. Your explanations must mention the exact ratios and numbers compared to support your choice. ******Answers and memos must be logically written and no grammatical errors.******* Memo #1: The company I selected as the…
1. Angel Trading presents the following sales figures in terms of units. 2014 10 000 2015 11 650 2016 12 395 2017 14 670 2018 18 485 2019 Required: Determine the projected sales on 2019 using either simple moving average or arithmetic geometric curve.
GIVE THE COMPARATIVE INCOME STATEMENT VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…
QUESTION 7 Р18.3А P18.ЗА (LO 3) Jergan Corporation are presented here. Perform ratio analysis, and discuss changes in financial position and operating results. Jergan Corporation Condensed balance sheet and income statement data for Balance Sheets December 31 2020 2019 2018 Cash $ 30,000 $ 20,000 $ 18,000 Accounts receivable (net) 50,000 45,000 48,000 Other current assets 90,000 95,000 64,000 Investments 55,000 70,000 45,000 Plant and equipment (net) 500,000 370,000 358,000 $725,000 $600,000 $533,000 Current liabilities $ 85,000 $ 80,000 $ 70,000 Long-term debt Common stock, $10 par 145,000 85,000 50,000 320,000 310,000 300,000 Retained earnings 175,000 125,000 113,000 $725,000 $600,000 $533,000 Jergan Corporation Income Statements For the Years Ended December 31 2020 2019 Sales revenue $740,000 $600,000 Less: Sales returns and allowances 40,000 30,000 Net sales 700,000 570,000 Cost of goods sold Gross profit 425,000 350,000 275,000 220,000 Operating expenses (including income taxes)…