accounting homework
Instructions
Using the Excel template in the Financial Ratios lesson page, compute the following financial ratios of Bank of America for the year 2013 . (i attatch the file)
Accounts Receivable Turnover |
Average Collection Period |
Inventory Turnover |
Number of days of sales in inventory |
Profit Margin Percentage |
Return on Sales |
Current Ratio |
Quick Ratio |
Cash Ratio |
Asset Turnover |
Debt to Equity Ratio |
Debt to Assets Ratio |
Return on Assets |
Earnings Per Share |
Working Capital |
P/E Ratio
|
In order to compute the Earnings Per Share ratio and the P/E Ratio, you will need the number of shares of stock outstanding and the trading price of each share of stock:
• Number of Shares of Stock Outstanding: 10,520,000,000
• Trading Price of Each Share of Stock: $15.57
Attach your Excel spreadsheet when you are done.
10 years ago
20
Purchase the answer to view it

- financialratiosanalysisexampleinexcel.xls