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.

Financial & Managerial Accounting

13th Edition

ISBN:9781285866307

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 15.17EX: Profitability ratios The following selected data were taken from the financial statements of...

See similar textbooks

Similar questions

Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Price-earnings ration
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 / 101,397 *365 =334 days Payable Days…
9 - The income statement of a Business for the period 2019 is as follows: 31.12.2019 % Gross sales 45.200 TL 102.72 Discounts From Sales 1.200 TL 2.72 Net Sales 44,000 TL 100.00 Cost of sales 12.500 TL 28.41 Gross Profit on Sales 31,500 TL 71.59 This table was prepared according to which of the following analysis methods? a) Technical analysis B) Analysis with Vertical Percentage Method NS) Ratio Analysis D) Comparative Tables Analysis TO) Trend Percentages Analysis
Vertical analysis (common-size) percentages for Cullumber Company’s sales revenue, cost of goods sold, and expenses are listed here. Vertical Analysis 2022 2021 2020 Sales revenue 100.0 % 100.0 % 100.0 % Cost of goods sold 60.0 64.2 65.6 Expenses 24.7 27.1 29.5 Calculate Cullumber’s net income as a percent of sales. (Round answers to 1 decimal place, e.g. 5.2.) 2022 2021 2020 Net income Enter percentages rounded to 1 decimal place. Enter percentages rounded to 1 decimal place. Enter percentages rounded to 1 decimal place. Did Cullumber’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period? Cullumber’s net income as a percent of sales Choose the correct answer increaseddecreasedremained unchanged
How do you calculate the TTM? Particulars 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 TTM Sales ₱ 32,067.00 ₱ 35,422.00 ₱ 70,881.00 ₱ 95,519.00 ₱ 122,128.00 ₱ 165,654.00 ₱ 188,793.00 ₱ 232,834.00 ₱ 263,159.00 ₱ 273,046.00 ₱ 269,693.00 ₱ 294,619.00
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 /…
Industry Financial Ratios (2019)Quick ratio 1.0Current ratio 2.7Inventory turnover 7.0Total assets turnover 2.6Return on assets 9.1%Return on equity 18.2%Debt ratio 50.0%Gross Profit margin 20%Net Profit margin 3.5%P/E ratio 6.0RequiredCalculate Walton’s 2019 ratios, interpret and compare them with the industry averagedata, and comment briefly on Walton’s strengths and weaknesses.
Selected comparative statement data for Oriole Company are presented below. All balance sheet data are as of December 31. 20222021Net sales$1,165,000 $1,125,000Cost of goods sold705,000 645,000Interest expense20,000 15,000Net income154,945 145,000Accounts receivable145,000 125,000Inventory105,000 100,000Total assets785,000 700,000Preferred stock (6%)205,000 200,000Total stockholders’ equity635,000 525,000 Compute the following ratios for 2022. (Round answers to 1 decimal place, e.g. 1.8 or 2.5%) (a)Profit marginenter the profit margin in percentages %(b)Asset turnoverenter the asset turnover in times times(c)Return on assetsenter the return on assets in percentages %(d)Return on common stockholders’ equityenter the return on common stockholders' equity in percentages %
Choose the correct letter of answer and provide a solution. Thanks The financial ratios of a firm are as follows: Current Ratio=1.33; Acid-test ratio=0.80; Current liabilities=P40,000.00; Inventory turnover ratio=6 times. What is the sales/cost of good sold of the firm? *a. P57,200.00b. P77,200.00c. P97,20000d. P117,200.00e. P127,200.00
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%…
Computing and analyzing trend percents LO P1 2021 2020 2019 2018 2017 Sales $ 446,122 $ 293,501 $ 242,563 $ 173,880 $ 128,800 Cost of goods sold 221,100 145,365 122,206 87,101 63,112 Accounts receivable 21,592 17,140 16,664 10,137 8,784 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.
Randall Corporation reported the following revenue data:Year Net revenues (in millions)$$$$6,8007,0046,7327,2762016201720182019Use 2016 as the base year. The trend percentage in 2019 is closest toa. 93%.b. 104%.c. 107%.d. 112%