To compute:
The following ratios for last year and this year −
Answer to Problem 15P
Solution:
Ratios | This year | Last year | |
a | Working capital | 39,00,000 | 31,80,000 |
b | Current Ratio | 2 | 2.15 |
c | Acid-test ratio | 0.94 | 1.22 |
d | Average collection period | 52.14 | 49.13 |
e | Average sale period | 91.25 | 79.69 |
f | Operating cycle | 143.39 | 128.82 |
g | Total asset turnover | 0.99 | 0.9 |
Explanation of Solution
The ratios are calculated as under −
For last year −
- Current assets = $ 5,940,000
- Current Liabilities = $ 2,760,000
For last year −
- Current assets = $ 5,940,000
- Current Liabilities = $ 2,760,000
For last year − Given,
- Cash = $ 1,260,000
- Marketable securities = $ 300,000
- Accounts receivables, net = $ 1,800,000
- Current liabilities = 2,760,000
For last year − Given,
- Sales on account = $ 12,480,000
- Accounts receivables, beginning = $ 1,560,000
- Accounts receivables, ending = $ 1,800,000
For last period − Given,
- Cost of goods sold = $ 9,900,000
- Inventory, Beginning = $ 1,920,000
- Inventory, Ending = $ 2,400,000
For last year − Given,
- Average sale period = 49.13 days
- Average collection period = 79.64 days
For last year − Given,
- Sales = $ 12,480,000
- Average total assets = $ 13,920,000
Thus, all the ratios have been calculated.
Requirement 4
To prepare:
A brief memo that summarizes how Lydex is performing relative to its competitors
Answer to Problem 15P
Solution:
The performance of Lydex can be explained as −
- The Lydex Company is doing fine in terms of current ratio and acid-test ratio but for sales period and collection period, it is far behind the industry averages.
- The return on total assets is also less when compared with the industry averages.
- Debt-to-equity ratio was appropriate till last year, but this year it deteriorated.
- The times-interest-earned ratio is also low as compared to industry averages
- Similarly, the price-earnings ratio is low when compared with industry’s price earnings ratio. Overall, the performance of the company is not up to to the mark as it should be as per the industry.
Explanation of Solution
The above answer can be explained as under −
The table is prepared to compare the ratios of the company for this year and last year −
Ratios | This year | Last year | Industry |
Current Ratio | 2 | 2.15 | 2.3 |
Acid-test ratio | 0.94 | 1.22 | 1.2 |
Average collection period | 52.14 | 49.13 | 30 days |
Average sale period | 91.25 | 79.69 | 60 days |
Return on total assets | 5.25% | 3.62% | 9.50% |
Debt-to-equity ratio | 0.78 | 0.63 | 0.65 |
Times interest earned ratio | 4.33 | 3.4 | 5.7 |
Price-earnings ratio | 8.57 | 7.94 | 10 |
Further it can be explained as −
- For the sales period, the average period is 30 days, while it is 52.14 days for this year and 49.13 days for last year. The collection period is very long for the company. The company should change its policies for the collections of accounts receivables.
- Similarly, for the sales period, it is far behind the industry averages.
- The return on total assets is also less when compared with the industry averages. The industry is earning more on total assets, while the company is again behind the industry averages. But from the last year to this year, it improved.
- Debt-to-equity ratio was appropriate till last year, but this year it deteriorated.
- The times-interest-earned ratio is also low as compared to industry averages. The industry is earning more to cover its interest obligations, when compared with the company.
- Similarly, the price-earnings ratio is low when compared with industry’s price-earnings ratio. The industry’s price-earnings ratio is 10, while for company it is low, but for this year it improved.
Thus, the brief memo for the performance of the company has been prepared.
Want to see more full solutions like this?
Chapter 14 Solutions
Introduction To Managerial Accounting
- Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an accounting intern, who has asked for your guidance on how to prepare an income statement format that will be distributed to management. Subtotals and totals are included in the information, but you will need to calculate the values. A. In the correct format, prepare the income statement using the following information: B. Calculate the profit margin, return on investment, and residual income. Assume an investment base of $100,000 and 6% cost of capital. C. Prepare a short response to accompany the income statement that explains why uncontrollable costs are included in the income statement.arrow_forwardFinancial information for Lighthizer Trading Company for the fiscal year-ended September 30, 20xx, was collected. As part of a management training session, you have been asked to prepare an income statement format that will be used to distribute to management. Subtotals and totals are included in the information, but you will need to calculate the values. A. In the correct format, prepare the income statement using this information: B. Calculate the profit margin, return on investment, and residual income. Assume an investment base of $42,000 and 8% cost of capital. C. Prepare a short response to accompany the income statement that explains why uncontrollable costs are included in the income statement.arrow_forwardRequired information Skip to question [The following information applies to the questions displayed below.] You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,020,000 $ 1,260,000 Marketable securities 0 300,000 Accounts receivable, net 2,940,000 2,040,000 Inventory 3,660,000 2,100,000 Prepaid expenses 270,000 210,000 Total current assets 7,890,000 5,910,000 Plant and equipment, net 9,640,000 9,110,000 Total assets $ 17,530,000 $ 15,020,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,070,000…arrow_forward
- You have been asked by your CEO to evaluate, analyze and calculate commonly used ratios relating to a company’s profitability, liquidity, solvency and management efficiency. Requirement: Complete the balance sheet and sales data (fill in the blanks), using the following financial data: Debt/net worth 60% x 37,000 = 22,200 (debt) = AP Acid test ratio 1.2 x 22,200 = 26,640 Asset turnover 1.5 times Day sales outstanding in accounts receivable 40 days Gross profit margin 30% Inventory turnover 6 times Balance sheet Cash…arrow_forwardYour Task… Using your assigned financial statements calculate the required ratios below Indicate if the change from year to year is favorable or unfavorable. All values should be accurate to at least two decimal places. The expectation is to submit a professional report free of grammar and spelling errors and easy to read. Think of this as a menu you would be handing to a customer. All calculations are to be represented. Analysis of Profitability Gross Profit Ratio Operating Profit Ratio Net Profit Ratio Sales to Total Assets Ratio Return on Total Assets Return on Equity Earnings Per Sharearrow_forwardYou are tasked with performing a detailed financial analysis of two Jamaican companies: Honey Bun Ltd and Consolidated Bakeries Ltd. More specifically, you are to prepare a single comprehensive report which addresses the following requirements: 8. You are also to prepare a summary comparing and contrasting the general liquidity, solvency, profitability, asset management, and investment performance of BOTH companies. The comparative discussion for each ratio category should span one to two welldeveloped paragraphs. ▪ You are to use the Jamaica Stock Exchange website or the respective company websites to retrieve the annual reports for the companies for 2020 and 2021, as these reports contain the financial statements and other background information which will form the basis of your analysis. You will also be expected to pull on other research sources to support your analysis and to meet the requirements of the task.arrow_forward
- Common-Size Financial Statement Analysis Using Excel Completing this activity will help you learn to: 1. create Excel formulas using cell references. 2. create absolute cell references to perform calculations efficiently and correctly. 3. apply conditional formatting to highlight cells based on criteria that you specify. Case scenario: You are working at a small business that has been mostly stable. You want to analyze the financial statements of the past five years to examine the trends over time and compare the percentages of income statement items relative to overall sales. You also want to highlight cells according to whether the calculated ratio increases or decreases more than a specified amount. Required: Download spreadsheet CommonSizeCaseData-52d586.xlsx You will build a spreadsheet that performs common-size analysis using five years of a company's income statements. Specifically, you will create two sheets within the workbook, one for the horizontal analysis and one for the…arrow_forwardRiver Valley Production Inc. seeks to increase its market share and improve its results. The company takes as a starting point the current scenario and the results obtained in 2018 and 2019. Like other companies, River Valley uses financial ratios (ratios) as tools for analyzing the results obtained at the end of the period. Consider the data presented in the financial statements below and analyze the company's results based on the financial ratios.1. Use the financial statements to calculate the following financial ratios for the years 2018 and 2019:1.1 Current Ratio1.2 Quick Ratio1.3 Inventory Turnover Ratio 1.4 Days Sales Outstanding (DSO)1.5 Assets Turnover Ratio1.6 Return on Assets (ROA)1.7 Return on Equity (ROE)1.8 Return on Investment (ROI)1.9 Profit Margin1.10 Debt to Equity Ratio1.11 Price/Earning Ratio Balance Sheet 2018 2019 Cash $63,000 $201,000 Accounts Receivable 199,000 305,000 Marketable Securities 81,000 42,000 Inventories…arrow_forwardRiver Valley Production Inc. seeks to increase its market share and improve its results. The company takes as a starting point the current scenario and the results obtained in 2018 and 2019. Like other companies, River Valley uses financial ratios (ratios) as tools for analyzing the results obtained at the end of the period. Consider the data presented in the financial statements below and analyze the company's results based on the financial ratios.1. Use the financial statements to calculate the following financial ratios for the years 2018 and 2019: 1.1 Days Sales Outstanding (DSO)1.2 Assets Turnover Ratio1.3 Return on Assets (ROA)1.4 Return on Equity (ROE) Balance Sheet 2018 2019 Cash $63,000 $201,000 Accounts Receivable 199,000 305,000 Marketable Securities 81,000 42,000 Inventories 441,000 455,000 Prepaids 5,000 9,000 Total Current Assets 789,000 1,012,000 Property, Plant, and Equipment, net 858,000 858,000…arrow_forward
- As the financial analysts of Mezza Holding Company you are required to write a Memo to the Financial Manager describing the performance of the company and your suggestions on future improvements based on the following financial statements. . State the purpose of your Memo. Describe and interpret ratio results and provide company’s performance analysis based on them. Describe the weaknesses and strength of the company’s financial data. Provide suggestions on how to improve company’s performance.arrow_forwardRiver Valley Production Inc. seeks to increase its market share and improve its results. The company takes as a starting point the current scenario and the results obtained in 2018 and 2019. Like other companies, River Valley uses financial ratios (ratios) as tools for analyzing the results obtained at the end of the period. Consider the data presented in the financial statements below and analyze the company's results based on the financial ratios.1. Use the financial statements to calculate the following financial ratios for the years 2018 and 2019:1.8 Return on Investment (ROI)1.9 Profit Margin1.10 Debt to Equity Ratio1.11 Price/Earning Ratio Balance Sheet 2018 2019 Cash $63,000 $201,000 Accounts Receivable 199,000 305,000 Marketable Securities 81,000 42,000 Inventories 441,000 455,000 Prepaids 5,000 9,000 Total Current Assets 789,000 1,012,000 Property, Plant, and Equipment, net 858,000 858,000…arrow_forward(Preparing common-size financial statements) As the newest hire to the financial analysis group at Patterson Printing Company, you have been asked to perform a basis financial analysis of the company's most recent financial statements. The 2016 balance sheet and income statement for the Patterson are shown here: LOADING... . a. After discussing your training asignment with a fellow analyst who was hired last year, you learn that the first step in your completing the assignment is to prepare a common-size balance sheet for Patterson. b. The second step is to prepare a common-size income statement for the firm. a. After discussing your training asignment with a fellow analyst who was hired last year, you learn that the first step in your completing the assignment is to prepare a common-size balance sheet for Patterson. Complete the common-size balance sheet below: (Round to one decimal place.) Common-Size Balance Sheet 2016 Cash…arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning