Question: Upton Computers makes high-volume purchases of small computers, stores them in well-located warehouses, and ships them to its chain of distributors. Your balance sheet for

Upton Computers makes high-volume purchases of small computers, stores them in well-located warehouses, and ships them to its chain of distributors. Your balance sheet for December 31, 2005 (in millions of dollars) is attached here.

Cash

$ 3.5

Accounts payable

$ 9.0

Receivable

26.0

Notes payable

18.0

Inventories

58.0

Accruals

8.5

Total current assets

$87.5

Total current liabilities

$ 35.5

Net fixed assets

35.0

Mortgage loan

6.0

Common stock

15.0

Retained earnings

66.0

Total assets

$122.5

Total liabilities and equity

$122.5

In 2005, sales amounted to $ 350 million, while net income was $ 10.5 million. The company paid dividends of $ 4.2 million to common stockholders. It is working at full capacity. Assume that all ratios remain constant. to.

a. If according to the estimates, sales will increase by $ 70 million (20%) during 2006, with the FAN equation determine the projected external needs for external capital.

b. Construct the pro forma balance sheet for December 31, 2006. Suppose external capital needs are met by bank loans and that are reflected in the documents payable. Assume that the profit margin and dividend yield ratio are held constant.

Step by Step Solution

3.37 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

excel formulas is given below the answer Existing profit margin 105350 Dividend payout ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!