accuntinng
Using the Excel template in the Financial Ratios lesson page, compute the following financial ratios of Bank of America for the year 2015.
| 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
Answer(1)
Purchase the answer to view it
NOT RATED
- financialratiosanalysisexampleinexcel-4.xls
Bids(1)