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.
Attachment:- Excel spreadsheet.xls