Construct uptons pro forma balance sheet for december 31

Assignment Help Business Management
Reference no: EM131376042

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

Cash

$3.5

Accounts Payable

$9.0

Receivables

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

Sales for 2006 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 percent, during 2007, use the AFN equation to determine Upton's projected external capital requirements.

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

Reference no: EM131376042

Questions Cloud

What would be additional funds needed for the coming year : Under these assumptions, what would be the additional funds needed for the coming year? Why is this AFN different from the one you found in given Problem?
Internal revenue service : The Federal Unemployment Tax Act(or FUTA, I.R.C. ch. 23) is a United States federal law that imposes a federal employer tax used to help fund state workforce agencies. Employers report this tax by filing an annual Form 940 with the Internal Revenu..
Labor and marginal product of capital for capitalberg : Production in the country of CapitalBerg can be characterized by the following function: Y = 2K0.2L0.8 and that CapitalBerg initially has 200 units of labor and 1000 units of capital. a) Calculate the marginal product of labor and marginal product ..
How large a sales increase can the company achieve : Pierce's profit margin is 5 percent, and its payout ratio is 60 percent. How large a sales increase can the company achieve without having to raise funds externally?
Construct uptons pro forma balance sheet for december 31 : Construct Upton's pro forma balance sheet for December 31, 2007. 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.
Discuss about the administrative discretion : Do you think that public administrators should be restricted to only laid down rules in the discharge of their duties as espoused by Max Weber or should they have some amount of discretion. Provide the likely benefits and disadvantages of each sce..
Negative effects of the imposed price ceiling : What are some alternative possibilities to alleviating the negative effects of the imposed price ceiling?
Joe advertising expense : Where P is the price of Joe's coffee. Pc is the price of Starbuck, and A is Joe's advertising expense. Currently joe's and Starbucks Coffee are priced at $2.00 per cup, and income is $400.00
How successful the author was in convincing you to accept : Evaluate how successful the author was in convincing you to accept the validity of the "surprise ending" that was different from what you expected.

Reviews

Write a Review

Business Management Questions & Answers

  Explain the process of strategic retail planning

Explain the process of strategic retail planning. Conclude the challenges retailers face in adjusting their strategic plans in response to immediate changes in the business environment for example natural disasters and economic downturns

  Discuss the differences between translation

Discuss the differences between translation, transaction and economic exposure and what managers can do to manage each type of exposure.

  Describe the internal and external environments of companies

Write a 1,050- to 1,400-word paper in which you complete the following: Research and describe the internal and external environments of 2 to 3 real-world companies using an environmental scan

  You essential to submit your choice in the form

You essential to submit your choice in the form of a 2-5 paragraph statement of the topic as well as how you will approach it.

  Manager of an organisation that sells and delivers

You are the manager of an organisation that sells and delivers IT training. You predominantly offer courses in the Maxihard Office suite and you know that Maxihard are bringing out a new version called Ultimo in six months.

  Examples of roles that are filled by employees

What are specific examples of roles that are filled by employees and others that are filled by independent contractors? Use examples from your employer, industry, or an employer or industry with which you are familiar. What do the employees and indep..

  Growing eps-growing dividend yield

As an investor what ratio would you be more interested in and why? Explain what potentially could be happening in each case.

  Implement an se approach to achieve project success

Provide good example with detail data supporting both sides of the given argument and suggestion as to how we would implement an SE approach to achieve assignment success.

  Depreciation charge of an equipment purchased

What is the depreciation charge of an equipment purchased five years ago for $200,000, and a expected life of 10 years if it is depreciated using the MACRS method?

  Offer and acceptance

Offer and acceptance

  Books and supplies at the rival college

After graduating from high school, Steve had three choices, listed in order of preference: (1) matriculate at our campus, (2) work in a printed circuit board factory, or (3) attend a rival college. His opportunity cost of going to college here inc..

  Spot rate between us and japanese yen

Find out the cross rate between US$ and British Pound Sterling(£) if the spot rate between British Pound Sterling and Japanese Yen(¥) is ¥121/£ and the spot rate between US$ and Japanese Yen is ¥85/$.

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!

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