User Account

All Pages

Determine upton self-supporting growth rate

Assignment Help Financial Accounting
Reference no: EM132555045

Forecasted Statements and Ratios

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, 2019, is shown here (millions of dollars):

Cash$ 3.5

Accounts payable$ 9.0

Receivables26.0

Notes payable18.0

Inventories 58.0

Line of credit 0

Total current assets $ 87.5

Accruals 8.5

Net fixed assets35.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 2019 were $375 million and net income for the year was $11.25 million, so the firm's profit margin was 3.0%. Upton paid dividends of $4.5 million to common stockholders, so its payout ratio was 40%. Its tax rate was 25%, 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 2020. Do not round intermediate calculations.

Question 1: If sales are projected to increase by $86.25 million, or 23%, during 2020, use the AFN equation to determine Upton's projected external capital requirements. Enter your answers in millions.

Question 2: 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.

Question 3: Use the forecasted financial statement method to forecast Upton's balance sheet for December 31, 2020. 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 2020 as they were in 2019. What is the amount of the line of credit reported on the 2020 forecasted balance sheets? (Hint: You don't need to forecast the income statements because the line of credit is taken out on the last day of the year and you are given the projected sales, profit margin, and dividend payout ratio; these figures allow you to calculate the 2020 addition to retained earnings for the balance sheet without actually constructing a full income statement.) Enter your answers in millions.

Reference no: EM132555045

Questions Cloud

How much is the relevant income effect of accepting : The company has sufficient capacity to produce the additional units. How much is the relevant income effect of accepting the special order?
How much is the relevant cost of the wicket : The fixed overhead is an allocated common cost. How much is the relevant cost of the wicket? Bramble, Inc. currently manufactures a wicket as its main product.
Compare applications of oral and visual presentations : Compare and contrast the types and applications of oral and visual presentation. Describe which applications you will be using for your presentation.
Describe the four functions of management : Describe the four functions of management. What role do these play in the strategic decision making process?
Determine upton self-supporting growth rate : Determine Upton self-supporting growth rate. That is, what is the maximum growth rate the firm can achieve without having to employ nonspontaneous
Difference between quantitative and qualitative research : Explain the difference between quantitative and qualitative research and describe a sample situation in which each would be appropriate.
What tools or strategies to use during a presentation : Describe a "best practice" for designing effective written, visual, and oral presentation materials to share with organizational stakeholders.
Total cost to company abc to consummate : Company ABC (bidder) just completed a M&A project and the target was Company XYZ. This project was
Inflation has suddenly increased substantially : Assume that the United States invests in government and corporate securities of Country K. In addition, residents

Reviews

Write a Review

Financial Accounting Questions & Answers

  Discuss purpose of depreciation vs an impairment loss

What considerations should be made regarding a potential impairment in the financial statements? What financial statement balances may be impacted?

  The accrual basis of accounting

The accrual basis of accounting:

  Concept of required return proposed capital investments

China is a manufacturing superpower. Assume that you are CFO of an automobile manufacturer looking to build a $U.S.800 million plant in China. You are discussing this project with your spouse, who is intelligent, but has no background in finance. You..

  Estimate of the total monthly fixed manufacturing cost

Babuca Corporation has provided the following production and total cost data for two levels of monthly production volume. The company produces a single product. The best estimate of the total monthly fixed manufacturing cost is:

  Assets and liabilities come into existence at different time

The statement of financial position is another name for the income statement. The income statement only statement dated as of a point in time. Assets and liabilities come into existence at different times and are not affected the same way by inflatio..

  Received at the end of the accounting period

If a resource has been consumed but a bill has not been received at the end of the accounting period,

  How many units were started into production during month

A process began the month with 3,000 units in the beginning work in process inventory and ended the month with 2,000 units in the ending work in process. If 12,000 units were completed and transferred out of the process during the month, how many ..

  Make the journal entries necessary to record transactions

Prepare the journal entries necessary to record the above transactions when they occurred and any adjusting journal entries relative to the transactions.

  Propose a diagram depicting the various interactions

Propose a diagram/illustration depicting the various interactions taking place among the three chart of accounts (and their subaccounts)

  Analyze the changes and the differences in the profitability

Analyze the changes and the differences in the profitability of these two hotel chains to the deepest levels available given the data provided. Compare and contrast the ROAs and ROCEs of both companies.

  Why the old partners pay a bonus to the new partner

In general, when a new partner enters a partnership, why would the new partner pay a bonus to the old partners, or why the old partners pay a bonus to the new partner?

  Treatment of petty cash and journal entrya petty cash fund

treatment of petty cash and journal entry.a petty cash fund was originally established with a check for 150. in the

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd