Explore BrainMass

Upton Computers Bulk Purchases

Upton Computers makes bulk purchases of small computers, stock them in conveniently located warehouses, and ship them to its chain of retail stores. Upton's balance sheet as of December 31, 2004, is shown here (millions):

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

Sales for 2004 were $350 million, while net income for the year was $10.5 million. Upton paid dividends of $4.2 million to common stockholders. The firm is operating at full capacity. Assume that all the ratios remain constant.

A. If sales are projected to increase by 70 million, or 20 percent, during 2005, use the Additional Funds Needed equation to determine Upton's projected external capital requirements.

B. Construct Upton's pro forma balance sheet for December 31, 2005. Assume that all external capital requirements are met by bank loans and are reflected in notes payable. Assume Upton's profit margin and dividend payout ratio remain constant.

See attached file for full problem description.


Solution Preview

Funds are spontaneously generated if a liability account increases spontaneously (automatically) as sales increase. An increase in a liability account is a source of funds, thus funds have been generated. Two examples of spontaneous liability ...

Solution Summary

The solution calculates the external capital requirements and constructs a balance sheet for Upton Computers.