Review View Developer Sample Ratios Solved - Word (Product Activation Failed) Tell me what you want...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Review View Developer Sample Ratios Solved - Word (Product Activation Failed) Tell me what you want to do... PRACTICE QUESTION WITH SOLUTION 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 31st December 2015 2016 (Rs.) 2017 (Rs.) Sales CGS 29,00,500 Sales 22,19,300 17,30,000 CGS 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 EBT MPS 12.06/Share & MPS 11.96/Share Total Dividends 240,000 Total Dividends 260,000 ATX Co. Statement of Financial Position As at 31st December 2015 2016 (Rs.) 2017 (Rs.) Current Assets Current Assets Cash in Hand 5,60,000 Cash in Hand 4,50,000 Cash at Bank 7,65,000 Cash at Bank 5,65,000 Marketable Securities 7,23,900 Marketable Securities 7,23,900 Accounts Receivable 7,01,300 Accounts Receivable 6,01,300 Inventory 2,65,000 Inventory 2,75,000 Non-Current Assets Non-Current Assets Land 56,00,000 Land 56,00,000 Building 25,00,000 Building 25,00,000 Machines 38,00,000 Machines 38,00,000 TOTAL ASSETS 14,915,200 TOTAL ASSETS 14,515,200 Current Liabilities Current Liabilities Accounts Payable 13,39,200 Accounts Payable 13,35,000 Short term Loan 7,06,000 Short term Loan 7,06,200 Accruals 8,90,000 Accruals 8,04,000 Non-Current Liabilities Non-Current Liabilities Long Term Loan 32,00,000 Long Term Loan 28,90,000 Capital Capital Issued, Subscribed & Paid-Up Capital (8,78,000 at Rs. 10 par value) TOTAL LIABILITIES & CAPITAL Q Search 87,80,000 14,915,200 Issued, Subscribed & Paid-Up Capital (8,78,000 at Rs. 10 par value) 87,80,000 TOTAL LIABILITIES & CAPITAL 14,515,200 W H PE fg f5 f6 f7 f10 num lk f11 Review View Developer Sample Ratios Solved - Word (Product Activation Failed) Tell me what you want to do... Solution Liquidity Analysis 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 Decrease Quick Ratio [(CA-Inventory)/CL] 0.936972 Absolute Liquid Ratio (Cash and 0.9191621 Unfavorable 0.8225081 Decrease Unfavorable 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 2016 Interest Coverage Ratio (EBIT/Interest) Debt Ratio (TD/TA) Equity Ratio (TE/TA) Dividend Payout Ratio (Dividends/Net Profit) Activity Analysis 2017 Sign Result 15.77885 18.597059 Increase 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 Collection Period (in Days) 88.25 3.69 Decrease Unfavorable 98.89 Increase Inventory Turnover 6.53 Unfavorable 4.69 Decrease Unfavorable Age of Inventory (in Days) 55.91 Operating Cycle (in Days) 144.16 77.81 176.70 Increase Unfavorable Increase Unfavorable Payable Turnover Payment Period Cash Conversion Cycle Profitability Analysis Profit margins and returns anaysis www Q Search % 16 5 6 7 7 H x 8 9 8 9 P f10 f11 num lk ngs Review View Developer Table of Results: Sample Ratios Solved - Word (Product Activation Failed) Tell me what you want to do... Ratios 2016 2017 Sign Result Gross Profit Margin (GP/SALES) Increase Favorable 0.4036 0.4187 Operating (OP/SALES) Profit Margin Increase Favorable 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 Earnings Per Share (NP/# of Decrease Unfavorable Decrease Unfavorable shares) 0.7878 0.6133 Q Search W P 5 55 % f6 6 7 f10 num lk 7 8 9 ) OC 8 9 ((g) Review View Developer Sample Ratios Solved - Word (Product Activation Failed) Tell me what you want to do... PRACTICE QUESTION WITH SOLUTION 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 31st December 2015 2016 (Rs.) 2017 (Rs.) Sales CGS 29,00,500 Sales 22,19,300 17,30,000 CGS 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 EBT MPS 12.06/Share & MPS 11.96/Share Total Dividends 240,000 Total Dividends 260,000 ATX Co. Statement of Financial Position As at 31st December 2015 2016 (Rs.) 2017 (Rs.) Current Assets Current Assets Cash in Hand 5,60,000 Cash in Hand 4,50,000 Cash at Bank 7,65,000 Cash at Bank 5,65,000 Marketable Securities 7,23,900 Marketable Securities 7,23,900 Accounts Receivable 7,01,300 Accounts Receivable 6,01,300 Inventory 2,65,000 Inventory 2,75,000 Non-Current Assets Non-Current Assets Land 56,00,000 Land 56,00,000 Building 25,00,000 Building 25,00,000 Machines 38,00,000 Machines 38,00,000 TOTAL ASSETS 14,915,200 TOTAL ASSETS 14,515,200 Current Liabilities Current Liabilities Accounts Payable 13,39,200 Accounts Payable 13,35,000 Short term Loan 7,06,000 Short term Loan 7,06,200 Accruals 8,90,000 Accruals 8,04,000 Non-Current Liabilities Non-Current Liabilities Long Term Loan 32,00,000 Long Term Loan 28,90,000 Capital Capital Issued, Subscribed & Paid-Up Capital (8,78,000 at Rs. 10 par value) TOTAL LIABILITIES & CAPITAL Q Search 87,80,000 14,915,200 Issued, Subscribed & Paid-Up Capital (8,78,000 at Rs. 10 par value) 87,80,000 TOTAL LIABILITIES & CAPITAL 14,515,200 W H PE fg f5 f6 f7 f10 num lk f11 Review View Developer Sample Ratios Solved - Word (Product Activation Failed) Tell me what you want to do... Solution Liquidity Analysis 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 Decrease Quick Ratio [(CA-Inventory)/CL] 0.936972 Absolute Liquid Ratio (Cash and 0.9191621 Unfavorable 0.8225081 Decrease Unfavorable 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 2016 Interest Coverage Ratio (EBIT/Interest) Debt Ratio (TD/TA) Equity Ratio (TE/TA) Dividend Payout Ratio (Dividends/Net Profit) Activity Analysis 2017 Sign Result 15.77885 18.597059 Increase 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 Collection Period (in Days) 88.25 3.69 Decrease Unfavorable 98.89 Increase Inventory Turnover 6.53 Unfavorable 4.69 Decrease Unfavorable Age of Inventory (in Days) 55.91 Operating Cycle (in Days) 144.16 77.81 176.70 Increase Unfavorable Increase Unfavorable Payable Turnover Payment Period Cash Conversion Cycle Profitability Analysis Profit margins and returns anaysis www Q Search % 16 5 6 7 7 H x 8 9 8 9 P f10 f11 num lk ngs Review View Developer Table of Results: Sample Ratios Solved - Word (Product Activation Failed) Tell me what you want to do... Ratios 2016 2017 Sign Result Gross Profit Margin (GP/SALES) Increase Favorable 0.4036 0.4187 Operating (OP/SALES) Profit Margin Increase Favorable 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 Earnings Per Share (NP/# of Decrease Unfavorable Decrease Unfavorable shares) 0.7878 0.6133 Q Search W P 5 55 % f6 6 7 f10 num lk 7 8 9 ) OC 8 9 ((g)
Expert Answer:
Related Book For
Business and Administrative Communication
ISBN: 978-0073403182
10th edition
Authors: Kitty o. locker, Donna s. kienzler
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
In the given circuit, the inductor (L 5 H) and a 50-V battery of negligible resistance are connected with resistors R 10 W and R2 30 W, and Rg - 20 W as shown. The switch was closed at t 0 and kept...
-
A 12-year bond has an annual coupon rate of 9%. The par value of the bond is $1,000 and the bond has a yield to maturity of 7%. Which of the following statements is correct? If the market interest...
-
In Problems, a PDF for a continuous random variable X is given. Use the PDF to find (a) P(X ¥ 2), (b) E(X), (c) The CDE 1. 2. (x) = , if 0 20 f(x)otherwise f r)40 if 0, otherwise
-
What motivation need is met by listing all 18,000 names in the companys annual report? a. Equity theory b. Intrinsic reward c. Over-reward d. Extrinsic reward
-
Acne Medication and Gastrointestinal Injury Since 1999, Kamie Kendall had experienced ongoing abdominal pain, and she was eventually diagnosed with ulcerative colitis and irritable bowel syndrome...
-
For Lodes Company, the relevant range of production is 4080% of capacity. At 40% of capacity, a variable cost is $4,000 and a fixed cost is $6,000. Diagram the behavior of each cost within the...
-
You become interested in AT&T. Download the file PS4 from canvas. It contains monthly market returns (from CRSP) and monthly risk-free returns (from Fama and French). a. What is the AT&T beta? To...
-
The underlying argument is that the company will receive only OMR 800,000 from the debtors as bill receivable and not OMR 1,200,000 as it would have been, had the changing price been taken into...
-
Joseph Inc. acquired 10% of Thomp Corp.'s common shares at the beginning of the year for $500,000. Undistributed income was $10,000. During the second year, the company earned income of $120,000 and...
-
What role does globalization play in exacerbating or mitigating global inequalities, as wealth and resources become increasingly concentrated within transnational corporations and affluent regions,...
-
yright-UT 8 FALL CS1083- F Replace the variables highlighted in yellow public class FA20Q6S1{ AAA static void BBB String[] args) { String greeting = "Hi"; String farewell = "Bye" CCC int x = 0; if (x...
-
Nash's Trading Post, LLC's trial balance reported the following balances at the end of its first year: Cash $10360 Prepaid insurance 520 Accounts receivable 2590 Accounts payable 2070 Notes payable...
-
Address Hexadecimal ASCII ===== =========== ===== === 0 200003 JUMP 3 1 6 6 2 1 1 3 a02001 LOAD @1 4 b88001 STORE BX 5 c02002 SUB @2 6 2b000c JZ 12 7 b88006 STORE CX 8 f08001 MUL BX 9 b88001 STORE BX...
-
What does it mean if we have developed a multiple regression model and have concluded that the model is apt?
-
Saccharin is an artificial sweetener that is used in diet beverages. In order for it to be metabolized by the body, it must pass into cells. Below are shown the two forms of saccharin. Saccharin has...
-
Discuss four important risk and tax-related considerations that are relevant to Omos portfolio. With most of Omos personal net worth tied up in his software company, he is asset rich but cash poor....
-
Determine the most appropriate strategy that can generate liquidity and accomplish Omos goals. Justify your response. Jing asks Omo about his plans for the shares of his previous employers company....
-
Recommend, for both Enlows niece and nephew, the most tax-efficient wealth transfer option (lifetime gift or testamentary bequest). Show your calculations. Recommend, for both Enlow's niece and...
Study smarter with the SolutionInn App