(Answered) Instructionsusing the excel template in the financial

Accounting

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

View complete question

Financial Accounting, Accounting

Category:- Financial Accounting
Reference No.:- M91889366
Price:- $50

Verified Expert

Priced at $100 Now at $50, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Financial Accounting

Highway express has paid annual dividends of 132 133 138

Highway Express has paid annual dividends of $1.32, $1.33, $1.38, $1.40, and $1.42 over the past five years, respectively. What is the average divided growth rate?

In its first year of operations cullumber company

In its first year of operations, Cullumber Company recognized $31,800 in service revenue, $6,600 of which was on account and still outstanding at year-end. The remaining $25,200 was received in cash from customers. The c ...

Assessment -part a -saturn petcare australia and new

Assessment - Part A - Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since opening their firs ...

Lease classification considering firm guidance issues

Lease Classification, Considering Firm Guidance (Issues Memo) Facts: Tech Startup Inc. ("Lessee") is entering into a contract with Developer Inc. ("Landlord") to rent Landlord's newly constructed office building located ...

What has been strides position on dividend payouts in the

What has been Strides' position on dividend payouts in the past (pattern, relationship with earnings, etc.)? What factors affected its dividend policy?

Scenario assume that a manufacturing company usually pays a

Scenario: Assume that a manufacturing company usually pays a waste company (by the pound to haul away manufacturing waste. Recently, a landfill gas company offered to buy a small portion of the waste for cash, saving the ...

Ww productswith new productssales revenue

Without New Products With New Products Sales revenue $11,686,200 $16,263,600 Net income $486,300 $878,400 Average total assets $5,917,600 $13,539,700 (a) Compute the company's return on assets, profit margin, and asset t ...

Assessment task 1question no 1assessment taskbilby cos

Assessment Task 1 Question no. 1 Assessment Task: Bilby Co's income statement for the year ended 31 December 2015 and statements of financial position at 31 December 2014 and 31 December 2015 were as follows: Bilby co's ...

An investment offers 6800 per year with the first payment

An investment offers $6,800 per year, with the first payment occurring one year from now. The required return is 7 percent. a. What would the value be today if the payments occurred for 20 years? b. What would the value ...

Supply and demand graphto complete this assignment address

Supply and Demand Graph To complete this assignment, address the following requests: 1. Based on the information from the US Energy Information Administration, create the supply and demand graph in the space below. This ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Accounting Expert