Explore BrainMass
Share

Upton Computers Bulk Purchases

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 24, 2018, 8:44 pm ad1c9bdddf

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.

\$2.19

Pro Forma Statements and Ratio

Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, and ships them to its chain of retail stones. Upton's balance sheet as of December 31, 2007, is shown here (millions of dollars).
Cash...........................\$ 3.5 Accounts payable.....................\$ 9.0
Receivables.................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 2007 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 ratios remain constant.

(a) What will Upton Computer's external capital requirements be if sales increase by \$70 million?

View Full Posting Details