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
Step: 1
excel formulas is given below the answer Existing profit margin 105350 Dividend payout ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started