Question: Calculate the financial ratios for the year 2016 and 2017, using the following information extracted...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question: Calculate the financial ratios for the year 2016 and 2017, using the following information extracted from Financial Statements of ATX Co., also provide your interpretation: ATX Co. Statement of Financial Performance For the year ended 31" December 2015 2016 (Rs.) 2017 (Rs.) Sales 29,00,500 Sales 22,19,300 CGS 17,10,000 12,90,000 Operating Expenses 3,50,000 Operating Expenses 2,97,000 Interest Expense 52,000 Interest Expense 34,000 Taxes 10% of EBT Taxes 10% of CBT MPS 12.06/Share & MPS 11.96/Share Total Dividends 260,000 Total Dividends 240,000 ATX Co. Statement of Financial Position As at 31 December 2015 2016(Rs.) 2017 (Rs.) Current Assets Current Assets Cash in Hand 5,60,000 Canin Hand 450.000 Cash Bank 7,65,000 Cash at Bank 5,50.000 Marketable Securities 7,23,900 Marketable Securities 1.23,900 Accounts Receivable 7,01,300 Accounts Receivable 6,011,300 Inventory 2,65.000 Inventory 2,75,000 Non Current Assets Non Current Assets Land 56,00,000 Land 560110001 Building 2500,000 25,00,000 Machines 300,000 Machines 38,00,000 TOTAL ASSETS 14,915,200 Current Liabilities TOTAL ASSETS Current Liabilities 14,515,200 Accounts Payable 13.39.200 Accounts Payable 13.35,000 Short term Low 7,00,000 Short term Loan 7,06,200 190000 Accra 8,04,000 Non-Current Liabilities Non-Current Liabilities Long Term Loan 12.00.000 Long Term 28.90.000 Capital and Subscribed & Paid Up Cl 87.80,000 78,000 at 10 para TOTAL LIABILITIES & CAPITAL 14,915,200 Capital Isad Suuribed & Paid Up Capital 18,78,000 at 13 par valve 87,80,000 TOTAL LIABILITIES & CAPITAL 14,515,200 Liquidity Analysis Solution An analysis used to measure a firm's ability to pay off its upcoming short-term debt obligations using their short term and liquid assets. Table of Results: Ratios: 2016 2017 Sign Result Current Ratio (CA/CL) 1.027255 0.9191621 Decrease Unfavorable Quick Ratio [(CA-Inventory)/CL] 0.936972 0.8225081 Decrease Unfavorable Absolute Liquid Ratio (Cash and Decrease Unfavorable equivalents/CL) 0.698044 0.6111697 Working Capital [CA-CL] 80000.00 -230000.00 Decrease Unfavorable Solvency Analysis: Analysis of Financial Position and risks. Debt and Equity ratios and cost of debt and equity i.e. Interest and Dividends. Table of Results: Ratios Interest Coverage Ratio (EBIT/Interest) Debt Ratio (TD/TA) Equity Ratio (TE/TA) Dividend Payout Ratio (Dividends/Net Profit) Activity Analysis 2016 2017 Sign Result 18.597059 Increase 15.77885 Favorable 0.411339 0.3951168 Decrease Favorable 0.588661 0.6048832 Increase Favorable Efficiency analysis in terms of cost and time using cash conversion cycle. Table of Results: Ratios 2016 2017 Sign Result Total Asset Turnover (Sales/TA) 0.19 0.15 Decrease Unfavorable Receivables Turnover 4.14 3.69 Decrease Unfavorable Collection Period (in Days) 88.25 98.89 Increase Unfavorable Inventory Turnover 6.53 4.69 Decrease Unfavorable Age of Inventory (in Days) 55.91 77.81 Operating Cycle (in Days) 144.16 176.70 Increase Increase Unfavorable Unfavorable Payable Turnover Payment Period Cash Conversion Cycle Profitability Analysis Profit margins and returns anaysis Table of Results: Ratios Gross Profit Margin (GP/SALES) 2016 2017 Sign Result Increase Favorable 0.4036 0.4187 Operating Profit Margin Increase Favorable (OP/SALES) 0.2829 0.2849 Net Profit Margin (NP/SALES) Increase Favorable 0.2385 0.2426 Return on Assets (NP/TA) Decrease Unfavorable 0.0464 0.0371 Return on Equity (NP/TE) 0.0788 0.0613 Decrease Unfavorable Earnings Per Share (NP/# of Decrease Unfavorable. shares) 0.7878 0.6133 Question: Calculate the financial ratios for the year 2016 and 2017, using the following information extracted from Financial Statements of ATX Co., also provide your interpretation: ATX Co. Statement of Financial Performance For the year ended 31" December 2015 2016 (Rs.) 2017 (Rs.) Sales 29,00,500 Sales 22,19,300 CGS 17,10,000 12,90,000 Operating Expenses 3,50,000 Operating Expenses 2,97,000 Interest Expense 52,000 Interest Expense 34,000 Taxes 10% of EBT Taxes 10% of CBT MPS 12.06/Share & MPS 11.96/Share Total Dividends 260,000 Total Dividends 240,000 ATX Co. Statement of Financial Position As at 31 December 2015 2016(Rs.) 2017 (Rs.) Current Assets Current Assets Cash in Hand 5,60,000 Canin Hand 450.000 Cash Bank 7,65,000 Cash at Bank 5,50.000 Marketable Securities 7,23,900 Marketable Securities 1.23,900 Accounts Receivable 7,01,300 Accounts Receivable 6,011,300 Inventory 2,65.000 Inventory 2,75,000 Non Current Assets Non Current Assets Land 56,00,000 Land 560110001 Building 2500,000 25,00,000 Machines 300,000 Machines 38,00,000 TOTAL ASSETS 14,915,200 Current Liabilities TOTAL ASSETS Current Liabilities 14,515,200 Accounts Payable 13.39.200 Accounts Payable 13.35,000 Short term Low 7,00,000 Short term Loan 7,06,200 190000 Accra 8,04,000 Non-Current Liabilities Non-Current Liabilities Long Term Loan 12.00.000 Long Term 28.90.000 Capital and Subscribed & Paid Up Cl 87.80,000 78,000 at 10 para TOTAL LIABILITIES & CAPITAL 14,915,200 Capital Isad Suuribed & Paid Up Capital 18,78,000 at 13 par valve 87,80,000 TOTAL LIABILITIES & CAPITAL 14,515,200 Liquidity Analysis Solution An analysis used to measure a firm's ability to pay off its upcoming short-term debt obligations using their short term and liquid assets. Table of Results: Ratios: 2016 2017 Sign Result Current Ratio (CA/CL) 1.027255 0.9191621 Decrease Unfavorable Quick Ratio [(CA-Inventory)/CL] 0.936972 0.8225081 Decrease Unfavorable Absolute Liquid Ratio (Cash and Decrease Unfavorable equivalents/CL) 0.698044 0.6111697 Working Capital [CA-CL] 80000.00 -230000.00 Decrease Unfavorable Solvency Analysis: Analysis of Financial Position and risks. Debt and Equity ratios and cost of debt and equity i.e. Interest and Dividends. Table of Results: Ratios Interest Coverage Ratio (EBIT/Interest) Debt Ratio (TD/TA) Equity Ratio (TE/TA) Dividend Payout Ratio (Dividends/Net Profit) Activity Analysis 2016 2017 Sign Result 18.597059 Increase 15.77885 Favorable 0.411339 0.3951168 Decrease Favorable 0.588661 0.6048832 Increase Favorable Efficiency analysis in terms of cost and time using cash conversion cycle. Table of Results: Ratios 2016 2017 Sign Result Total Asset Turnover (Sales/TA) 0.19 0.15 Decrease Unfavorable Receivables Turnover 4.14 3.69 Decrease Unfavorable Collection Period (in Days) 88.25 98.89 Increase Unfavorable Inventory Turnover 6.53 4.69 Decrease Unfavorable Age of Inventory (in Days) 55.91 77.81 Operating Cycle (in Days) 144.16 176.70 Increase Increase Unfavorable Unfavorable Payable Turnover Payment Period Cash Conversion Cycle Profitability Analysis Profit margins and returns anaysis Table of Results: Ratios Gross Profit Margin (GP/SALES) 2016 2017 Sign Result Increase Favorable 0.4036 0.4187 Operating Profit Margin Increase Favorable (OP/SALES) 0.2829 0.2849 Net Profit Margin (NP/SALES) Increase Favorable 0.2385 0.2426 Return on Assets (NP/TA) Decrease Unfavorable 0.0464 0.0371 Return on Equity (NP/TE) 0.0788 0.0613 Decrease Unfavorable Earnings Per Share (NP/# of Decrease Unfavorable. shares) 0.7878 0.6133
Expert Answer:
Related Book For
Frank Woods Business Accounting An Introduction To Financial Accounting
ISBN: 9781292365435
15th Edition
Authors: Alan Sangster, Lewis Gordon, Frank Wood
Posted Date:
Students also viewed these accounting questions
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
In Exercises show that the function y = (x) is a solution of the differential equation. y = 4e-x y" - y = 0
-
Salalah Manufacturing is considering the purchase of a new machine to replace one it believes is obsolete. The firm has total current assets of US$920,000 and total current liabilities of US$640,000....
-
Distinguish between program services expenses and supporting services expenses. Why is it important that NFPs report expenses for program services separately from those for supporting services?
-
Texas Inpatient Consultants, LLLP, is a partnership that employs physicians to deliver medical care to hospitalized patients of other physicians. Texas Inpatient recruited Julius Tabe, M.D., to work...
-
The owner of a computer store rents printers to some of her preferred customers. She is interested in arriving at a forecast of rentals so that she can order the correct quantities of supplies that...
-
Sales for a new car is expected to grow according to the equation: S = 150000(1-e -0.06t ), where t = months i) Calculate the number of cars sold after one year. ii) Calculate the number of cars sold...
-
As at 1st January 2010 salary outstanding was $128,400 Though during the year ended 31st December 2010 $598,800 was paid as salary, as at 31st December 2010 salary amounting to $142,900 remained...
-
The number of civilians holding government jobs in various federal departments and their monthly payrolls for a certain month are given below. Department: Department of Education Number of Civilian...
-
Consider the following situation. Engineers working for the government of Mexico have recently discovered an offshore area potentially rich in oil and gas. To raise revenue, the Mexican government...
-
Spiritual Intercessors Ministry ( SIM ) Ltd sells A 4 sheets which are received from the wholesaler at different prices. The company issues the A 4 sheets directly from stores to customers. The...
-
Every year, Americans celebrate "Tax Freedom Day." Computed by the tax foundation, tax freedom day represents the date on which the average taxpayer has paid off his or her taxes for the year. It is...
-
Cash balance per bank $4,440.20 Add: NSF check 250.00 Less: Bank service charge Adjusted balance per bank 33.00 $4,657.20 I Cash balance per books $4.755.20 Less: Deposits in transit 970.00 Add:...
-
Solution Manual Behavioral Finance Psychology Decision Making and Markets 1st Edition by Lucy Ackert
-
Perform the operation by first converting the numerator and denominator to scientific notation. Write the answer in scientific notation. 7,200,00/0.000009
-
Robles & Co is a VAT-registered business. During the quarter just ended, it bought goods and services to the value of 51,690 excluding VAT, and its sales were 81,906 including VAT. All of the...
-
A machine was originally purchased for 30,000. It is planned to be used for four years, and then sold for an estimated figure of 7,000. Show the calculations of the figures for depreciation (to the...
-
You are to study the following financial statements for two businesses that operate in the same industry and then answer the questions which follow. Required: (a) Calculate the following ratios for...
-
The business staff of the law firm Frampton, Davis & Smythe has constructed the following report that breaks down the firms overall results for last month into two business segmentsfamily law and...
-
The Excel worksheet form that appears below is to be used to recreate portions of Review Problem 1 relating to Dexter Corporation. Download the workbook containing this form from Connect, where you...
-
Millard Corporation is a wholesale distributor of office products. It purchases office products from manufacturers and distributes them in the West, Central, and East regions. Each of these regions...
Study smarter with the SolutionInn App