USA: +1(669)289-8683 
Sign in
Would like statements to be prepared in excel spreadsheet and show working. Need to see how answers were derived.
Need by Thursday.
2t5h3
2.
a na l),s is.
Exercise 13-4 Determination af income effects from common-size and trend percents L.O. P1 , P2
Common+ize and lrend percents for Aziz Company’s sales, cost of goods sold, and expenses fidlow.
Sales
Cost of gmds sold
Total expenses
9:’T::”11: l:T:”1:
2012 2011
2010
100.0% 100.0% 100.0%
62.6 61.1 58.3
14.4 13.9
14.2
l'”::l.’::1″::ll:
20′.t2 2011 20’10
104.8% 103.6% 100.0%
102.4 108.5 100.0
106.4 10’t.4 100.0
Determine net income as a percent of sales for the folloiving years. {Round your intermediate
calculations to J decimal place and final ansvvers to 2 decimal places, Omit the “7o” sign in your
response.)
Years
2010
20’11
2012
Should the net income increased, decreased, or remained unchanged in this three’year period.
‘| Net income decreased
‘… Remained unchanged
. Net income increased
Workshaet
Net incorne
o/o
Yo
lo
At December 31
Assets
Cash
Accounts recei\€ble, net
Merchandise inentory
Prepaid expenses
Plant assets, net
Total assets
Liabilities and Equity
Accounts payable
LongFterm notes payable secured by
mortgages on plant assets
Common stock, $10 par \alue
Retained eamings
Total liabilities and equity
Express the balance sheets in
round your final an$/ars to 1 deci
Cash
Accounts receivable, net
Merchandise inv-.ntory
ezto.nheclciJd.nrcg rav*hill.con/hm.tpx
2011 2010
$ 35,079 $ 35,838
58,408 47,306
79,U4 51,4U
8.761 3,982
243,920 223,470
$ 425,712
$362,000
,733 $ 71,945
97,914
163,500
92,353
place. Omit tlre “Yo” sign in your
Sanderson Company
Compaative Balance Sheels
December 31, 2O1O – 20’12
2012
percents. {Do not round i ate calculations and
6.O Yo
’16.s
21.9
$ 46,s50
79,202
163,500
72:s4::
$362,000
2011
8.2 %
13.7
18.7
2010
.9.9 To
13.1
14.2
217
215113 Assignnrent PrintMar
:::J -“9 l’ . , -,,,,..:.-, :i j:: ,jls.
9. 1o.oo points
Problem 13-34 Transactions, vwrking capital, and liquidity ratios L.O. P3
Park Corporation began the month of May with $800,000 of cunent assets, a cunent ratio of2.50:1, and an
aci+test ratio of 1.70:1. During the month, it completed the following transactions (the company uses a
perpetual in\entory system).
May 2 Purchased $60,000 ofmerchandise inrentory on credit.
8 Sold merchandise in\,entory that cost $65,000 for $125,000 cash.
10 Collected $26,000 cash on an account recei\Eble.
15 Paid $23,500 cash to settle an account payable.
17 Wrote ofi a $5,000 bad debt against the Allowance for Ooubtful Accounts account.
22 Declared a $1 per share cash diridend on its 60,000 shares ofoutstanding common stock.
26 Paid the diVdend declared on May 22.
27 Bonowed $100,000 cash by giving the bank a 30day, 10% note.
28 Bonowed $125,000 cash by signing a long-term secured note.
29 Used the $225,000 cash proceeds ftom the notes to buy new machinery.
Required:
Prepare a table showing Park’s (1) cunent ratio, (2) acid-test ratio, and (3) working capital, after each
transaction. (Do not round intermediate calculations, Round your ratios to 2 decimal places and
the working capilals to ne6resf, dollar amount Omit the “$” sign in your response,)
Transaction Cunent Ratio Acid-Test Ratio Working Capital
Beginning
May 2
May 8
May 10
May’15
May 17
May 22
May 26
May 27
May 28
May 29
Wo.ksheel
,,- ‘t’.
J apply ratio
10.
;J:;i;;y””;;naln”nli”l ,t”#””ir
“it”””ro
corporation roltow. (Alt sates were on credit; selected
balance sheet amounts at December 31,2O1O, were inr,entory, $52,900; total assets, $199,400; common
stock, $105,000; and retained eamings, $52,748.)
McCORD CORPORATION
lncome Statement
For Year Ended December 31, 2011
Sales $ 447,600
Cost of goods sold
l|tl*
Gross profit 150,050
Operating expenses 99,000
lnterest expense 4*9
lncome before taxes 46,150
lncome taxes
11:Un]
Net income $ 27,559
MCCORD CORPORA’I’ION
Balance Sheet
ezto.n*eclod.nng rawhill.corvhrntpx 6t7
rFdij-
“/./ L*6
, Cash- Short-tem in\estments
Accounts recehaUe, net
Notes receiwHe (trade)*
Merchandise in\€ntory
Prepaid expenses
Plant assets, net
4tc
215/13 Assigrrrrer* Print View
Decembor 31, 201’l
Liablllfes and Equlty
$ 18,m0 Accounts payaHe $ 12500
8,600 Accruedwage payaHe 4,800
30,200 lncorns taxes payable 2,900
8,000 Long{erm note payable, secured
34,150 by mortgage on dant assets 72,400
2,650 Cornmon stock 105,000
153,300 Retained eamings 52,300
Total assets $ 254,9m Total liabilities and equity $ 254,$0
* These arc short-{onn notes recei\€de arising frorn customer (trade) sales.
Required:
Compute the iClordng. (Use 365 days a year. Do not round intermediate calculations and round your
final answ€rs lo { decimal place, Omit the ‘7o” dgn in your response):
(1) Cunent ratio
(2) Acid-test ratio
(3) Days’sales uncollected
(4) lnvsntory tumo\€r
(5) Days’sates iD inwntory
(6) Debt-toequity ratio
(7) Times interGt 6amed
(8) Proft margin ratio
ito
;to : :
–!
i days
.. .. days
I lto ;
, ,times
,6t
(9) Total asset tumo\er
(10) Retum on total assets
(11) Retum oncoNnmonstockhdders’equity | – “.”._. .,,. :oA
ezto.nteclod.nrg ranrhill.carltrnhx 7n
