Reference no: EM131188328
Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them set up their new computers. Upton's balance sheet as of December 31, 2013, is shown here (millions of dollars): Cash $ 3.5 Accounts payable $ 9.0 Receivables 26.0 Notes payable 18.0 Inventories 58.0 Line of credit 0 Total current assets $ 87.5 Accruals 8.5 Net fixed assets 35.0 Total current liabilities $ 35.5 Mortgage loan 6.0 Common stock 15.0 Retained earnings 66.0 Total assets $122.5 Total liabilities and equity $122.5 Sales for 2013 were $200 million and net income for the year was $6 million, so the firm's profit margin was 3.0%. Upton paid dividends of $2.4 million to common stockholders, so its payout ratio was 40%. Its tax rate is 40%, and it operated at full capacity. Assume that all assets/sales ratios, spontaneous liabilities/sales ratios, the profit margin, and the payout ratio remain constant in 2014. Do not round intermediate calculations. If sales are projected to increase by $40 million, or 20%, during 2014, use the AFN equation to determine Upton's projected external capital requirements. Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answer to two decimal places. $ million Using the AFN equation, determine Upton's self-supporting growth rate. That is, what is the maximum growth rate the firm can achieve without having to employ nonspontaneous external funds? Round your answer to two decimal places. % Use the forecasted financial statement method to forecast Upton's balance sheet for December 31, 2014. Assume that all additional external capital is raised as a line of credit at the end of the year and is reflected (because the debt is added at the end of the year, there will be no additional interest expense due to the new debt). Assume Upton's profit margin and dividend payout ratio will be the same in 2014 as they were in 2013. What is the amount of the line of credit reported on the 2014 forecasted balance sheets? (Hint: You don't need to forecast the income statements because you are given the projected sales, profit margin, and dividend payout ratio; these figures allow you to calculate the 2014 addition to retained earnings for the balance sheet.) Round your answers to the nearest cent. Upton Computers Pro Forma Balance Sheet December 31, 2014 (Millions of Dollars)
Cash $
Receivables $
Inventories $
Total current assets $
Net fixed assets $
Total assets $
Accounts payable $
Notes payable $
Accruals $
Total current liabilities $
Mortgage loan $
Common stock $
Retained earnings $
Total liabilities and equity $
|
What rate of return would she have earned for the past year
: Last year Joan puchased a £100 face value corporate bond with an 13.84 percent annual coupon rate and a 3 year matuiry. At the time of the purchase, it had an expected yield to maturity of 12.21 percent. if joan sold the bond today for £106.18, what ..
|
|
Find the ebit indiffernece level associated
: A group of retired college professors has decided to form a small manufacturing company. The company will produce a full line of traditional office furniture. Two financing plans have been proposed by the investors. find the EBIT indiffernece level a..
|
|
Additional funds needed for the coming year
: The Booth Company's sales are forecasted to double from $1,000 in 2012 to $2,000 in 2013. Booth's after-tax profit margin is forecasted to be 7% and its payout ratio to be 40%. What is Booth's additional funds needed (AFN) for the coming year?
|
|
What is its self-supporting growth rate
: Maggie's Muffins, Inc., generated $2,000,000 in sales during 2013, and its year-end total assets were $1,500,000. Also, at year-end 2013, current liabilities were $1,000,000, consisting of $300,000 of notes payable, $500,000 of accounts payable, and ..
|
|
What is the amount of the line of credit reported
: Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them set up their new computers. What is the amount of the..
|
|
Two alternatives in terms of the effect on price per share
: Galles Corporation is evaluating an extra dividend versus a share repurchase. In either case, $14,000 would be spent. Current earnings are $2.00 per share, and the stock currently sells for $50 per share. There are 2,000 shares outstanding. Evaluate ..
|
|
What is the company total book value of debt
: Jiminy's Cricket Farm issued a 30-year, 7 percent semi-annual bond 9 years ago. The bond currently sells for 89 percent of its face value. The book value of the debt issue is $16 million. The company's tax rate is 31 percent. What is the company's to..
|
|
What is the aftertax salvage value from this sale
: Edward's Manufactured Homes purchased some machinery 2 years ago for $47,000. The assets are classified as 5-year property for MACRS. The company is replacing this machinery today with newer machines that utilize the latest in technology. What is the..
|
|
How much would it be willing to lend the business owner
: A small business owner visits her bank to ask for a loan. The owner states that she can repay a loan at $1,100 per month for the next three years and then $2,200 per month for two years after that. If the bank is charging customers 7.75 percent APR, ..
|