Expert answer:Need accounting help with a Homework about the eff
Answer & Explanation:CHAPTER15.PDF CHAP.PDF CHAP-2.PDF PR 15-4B-Hamilton.xls The first three pdf files is just the copy of the assignment. The PR 15-4B is the spreadsheet I need help with. I started it, so there isn’t much left to do.
chapter15.pdf
chap.pdf
chap_2.pdf
pr_15_4b_hamilton.xls
Unformatted Attachment Preview
Problem 15(14)-4B
Name: Angela Hamilton
Section: ACC-120
Score: 44%
Key Code:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
Current Assets
1.
Working capital:
$3,690,000
Ratio
Numerator
2.
Current ratio
$3,690,000
3.
Quick ratio
4.
Accounts receivable
turnover
$
10,000,000
Number of days’
sales in receivables
$
625,000
6.
Inventory turnover
$
7.
Number of days’
sales in inventory
8.
Ratio of Fixed assets to
long-term liabilities
9.
Ratio of liabilities to
stockholders’ equity
10.
Number of times
interest charges earned
$
5.
Current
Liabilities
–
=
$900,000
÷
Denominator
$900,000
Calculated Value
$2,790,000
=
Calculated Value
4.1
$
625,000
16.0
5,350,000
$
1,070,000
5.0
1,300,000
$
170,000
7.6
11.
12.
13.
14.
Number of times
preferred dividends earned
$
900,000
Ratio of net sales to
assets
$
10,000,000
Rate earned on total
assets
$
1,070,000
$
9,267,500
11.5%
Rate earned on stockholders’ equity
$
900,000
$
6,777,500
13.3%
$
50,000
15.
Rate earned on common
stockholders’ equity
16.
Earnings per share
on common stock
17.
Price-earnings ratio
18.
Dividends per share
of common stock
19.
Dividend yield
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades