Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A.) Refer to Problem 7-16. Suppose Cary CorporaTon is considering installing a new computer system that would provide Tghter control of inventories, accounts receivable, and

A.)

Refer to Problem 7-16. Suppose Cary CorporaTon is considering installing a new computer system that would provide Tghter control of inventories, accounts receivable, and accounts payable. If the new system is installed, the following data are projected (rather than the data given in Problem 7-16) for the indicated balance sheet and income statement accounts:

Accounts receivable $ 395,000

Inventories $ 700,000

Other Fxed assets $ 150,000

Accounts and notes payable $ 275,000

Accruals $ 120,000

Cost of goods sold $ 3,450,000

AdministraTve and selling expenses $ 248,775

P/E ratio 6.0X

How do these changes aect the projected raTos and the comparison with the industry averages? (Note that any changes to the income statement will change the amount of retained earnings; therefore, the model is set up to calculate 2016 retained earnings as 2015 retained earnings plus net income minus dividends paid. he model also adjusts the cash balance so that the balance sheet balances.)

B)

If the new computer system were even more effcient than Carys management had estimated and thus caused the cost of goods sold to decrease by $125,000 from the projections in part (a), what effect would it have on the companies financial position?

C)

If the new computer system were less effcient than Carys management had estimated and caused the cost of goods sold to increase by $125,000 from the projections in part (a), what effect would it have on the company's financial position?

D)

Change, one by one, the other items in part (a) to see how each change affects the ratio analysis. Then think about and write a paragraph describing how computer models such as this one can be used to help make better decisions about the purchase of such items as a new computer system.

INPUT DATA:
2013
Cash $72,000
A/R 439,000
Inventories 894,000
Land and bldg 238,000
Machinery 132,000
Other F.A. 61,000
Accts & Notes Pay. $432,000
Accruals 170,000
Long-term debt 404,290
Common stock 575,000
Retained earnings 254,710
Total assets $1,836,000
Total claims $1,836,000
2011 Ret. earnings 168,152
Income statement
Sales $4,290,000
Cost of G.S. 3,580,000
Adm. & sales exp. 236,320
Depreciation 159,000
Misc. 134,000
Net income $108,408
P/E ratio 5.0

No. of shares

23,000
Cash dividend

$0.95

KEY OUTPUT:
Cary Industry
Quick 0.8 1.0
Current 2.3 2.7
Inv. turn. 4.0 5.8
DSO 37 32
FA turnover 10.0 13.0
TA turnover 2.3 2.6
ROA 5.9% 9.1%
ROE 13.1% 18.2%
TD/TA 54.8% 50.0%
PM 2.5% 3.5%
EPS $4.71 n.a.
Stock Price $23.57 n.a.
P/E ratio 5.0 6.0
M/B 0.65 n.a.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Credit Derivatives Handbook Global Perspectives Innovations And Market Drivers

Authors: Greg Gregoriou, Paul Ali

1st Edition

0071549528, 978-0071549523

More Books

Students also viewed these Finance questions

Question

Create the relational diagram for the database shown in Figure.

Answered: 1 week ago

Question

2. Define identity.

Answered: 1 week ago

Question

1. Identify three communication approaches to identity.

Answered: 1 week ago

Question

4. Describe phases of majority identity development.

Answered: 1 week ago