Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, and ships them to its chain of retail stores. Uptons balance

Question

96 users unlocked this solution today!

Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, and ships them to its chain of retail stores. Upton’s balance sheet as of December 31, 2007, is shown here (millions of dollars).

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. If sales are projected to increase by $70 million, or 20%, during 2008, use the AFN equation to determine Upton’s projected external capital requirements.

b. Construct Upton’s pro forma balance sheet for December 31, 2008. 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.

Cash Receivables Inventories Total current assets Net fixed assets Total assets $ 3.5 26.0 58.0 $ 87.5 35.0 $122.5 Accounts payable Notes payable Accruals Total current liabilities Mortgage loan Common stock Retained earnings Total liabilities and equity $9.0 18.0 8.5 $35.5 6.0 15.0 66.0 $122.5