Purchase Solution

Upton Computers Bulk Purchases

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

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

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 ...

Purchase this Solution


Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.