Transcribed Image Text
Upton Computers makes bulk purchases of small computers, stocksthem in conveniently located warehouses, ships them to its chain ofretail stores, and has a staff to advise customers and help themset up their new computers. Upton's balance sheet as of December31, 2018, is shown here (millions of dollars):Cash$ 3.5Accounts payable$ 9.0Receivables26.0Notes payable18.0Inventories58.0Line of credit0Total current assets$ 87.5Accruals8.5Net fixed assets35.0Total current liabilities$ 35.5Mortgage loan6.0Common stock15.0Retained earnings66.0Total assets$122.5Total liabilities and equity$122.5Sales for 2018 were $300 million and net income for the year was$9 million, so the firm's profit margin was 3.0%. Upton paiddividends of $3.6 million to common stockholders, so its payoutratio was 40%. Its tax rate was 40%, and it operated at fullcapacity. Assume that all assets/sales ratios, (spontaneousliabilities)/sales ratios, the profit margin, and the payout ratioremain constant in 2019. Do not round intermediatecalculations.If sales are projected to increase by $80 million, or26.666667%, during 2019, use the AFN equation to determine Upton'sprojected external capital requirements. Enter your answers inmillions. For example, an answer of $10,550,000 should be enteredas 10.55. Round your answer to two decimal places.$ millionUsing the AFN equation, determine Upton's self-supportinggrowth rate. That is, what is the maximum growth rate the firm canachieve without having to employ nonspontaneous external funds?Round your answer to two decimal places. %Use the forecasted financial statement method to forecastUpton's balance sheet for December 31, 2019. Assume that alladditional external capital is raised as a line of credit at theend of the year and is reflected (because the debt is added at theend of the year, there will be no additional interest expense dueto the new debt).Assume Upton's profit margin and dividend payout ratio will be thesame in 2019 as they were in 2018. What is the amount of the lineof credit reported on the 2019 forecasted balance sheets?(Hint: You don't need to forecast the income statementsbecause the line of credit is taken out on last day of the year andyou are given the projected sales, profit margin, and dividendpayout ratio; these figures allow you to calculate the 2019addition to retained earnings for the balance sheet withoutactually constructing a full income statement.) Round your answersto two decimal places.Upton ComputersPro Forma Balance SheetDecember 31, 2019(Millions of Dollars)Cash$ Receivables$ Inventories$ Total current assets$ Net fixed assets$ Total assets$ Accounts payable$ Notes payable$ Line of credit$ Accruals$ Total current liabilities$ Mortgage loan$ Common stock$ Retained earnings$ Total liabilities and equity$
Other questions asked by students
The population of an island is currently 1000 people The population is expected to grow...
Overproduction of uric acid in the body can be an indication of cell breakdown. This may...
Discuss the composition of bone and name 5 type Add reference
e are choosing material for a round rod. The material must be a metal or alloy....
A) The order of first 3 harmonics on the output voltage of a controlled 3-phase rectifier...
My Courses Course Home Syllabus Scores Purchase Options Pearson eText Study Area KHW 8 Mitosis...
In the box below list the names and types of 4 real fossils shown in...
Consider the following vectors LOT Which of the following statements are true select all correct...
6. How is the nursing care for clients who have dementia related to quality? To...
An investor requiring a guaranteed return should invest in the following: Select one: a....
Reem Company has total assets of $ 430,000, and total liabilities of $ 220,000, on...