Computing 14 Financial Ratios from Financial Statements
Not what you're looking for?
Please help compute the following ratios in Excel. Provide formulas. See attached file for data.
Current Ratio
Acid-Test Ratio
Accounts Receivable Turnover
Inventory Turnover
Profit Margin
Asset Turnover
Return on Assets
Return on Common Shares
EPS
Price Earnings Ratio
Payout Ratio
Debt to Assets
Times Interest Earned
Purchase this Solution
Solution Summary
This solution provides the computations for 14 ratios from the Balance Sheet and Income Statement. Ratios computed involve: current ratio, acid-test ratio, accounts receivable turnover, inventory turnover, and profit margin. It provides all formulae definition and excel paths to solution.
Solution Preview
Good afternoon,
Please find attached file with your answers. I have computed 2013 as well since it was just a formula copy. I included all the formulae to make it clear.
Hope this helps.
Paul Cerisano MBA, MEd
Ratios
2014 2013 Formulae
Current Ratio 1.5 :1 1.4 Current Assets (CA) / Current Liabilites (CL)
Acid-Test Ratio 0.93 :1 0.89 (CA-Inv) / CL
Accts Rec Turnover 5.9 x 5.6 Sales / Accounts ...
Purchase this Solution
Free BrainMass Quizzes
Operations Management
This quiz tests a student's knowledge about Operations Management
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.