accuntinng
mr.5rmashoUsing 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.
- 8 years ago
- 20
Answer(1)
Purchase the answer to view it
NOT RATED
- financialratiosanalysisexampleinexcel-4.xls
Bids(1)