Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Management Expert

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. a. If sales are projected to increase by $60 million, or 30%, 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 b. 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. % c. 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 $

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M92091548

Have any Question?


Related Questions in Financial Management

Conduct preliminary research on the 2008 lehman brothers

Conduct preliminary research on the 2008 Lehman Brothers Bankruptcy and its various effects on world financial markets, business management, the credit crisis and individual wealth. Your research and resulting reviews sh ...

Answer each question in 75 words a piece use references if

Answer EACH question in 75 words A PIECE. Use references, if needed and cite. 1. Embark on a virtual field trip. Researching online, explore different career fields that interest you. Share with your classmates which car ...

Corporate finance amp financial management assignment -task

CORPORATE FINANCE & FINANCIAL MANAGEMENT ASSIGNMENT - TASK - Question 1 - Y Ltd Shares have a beta of 1.6 and an expected return of 21.0%. Shares in Z Ltd have a beta of 1.03 and an expected return of 13.5%. If the risk- ...

Question under what circumstances are price factors more

Question : Under what circumstances are price factors more important than non-price factors during a source selection? Under what circumstances are non-price factors more important? Use headings to compare and contrast t ...

Case analysis questions1 explain in 175 words what makes a

Case Analysis Questions 1. Explain in 175 words what makes a company a “multinational corporation”. 2. Complete the chart in a total of 350 words using 3 to 5 examples of multinational corporations. 3. Reading through th ...

Case discussion questionshow does a franchise system such

Case Discussion Questions How does a franchise system such as the one used by Two Men and a Truck create value for its global partners? Two Men and a Truck points to the size of the middle class in a country and the popu ...

1 in week four the focus was on analysis tools for

1. In week four, the focus was on analysis tools for determining solutions. In week five, we discussed groups and you also completed an assignment on analysis tools used for groups/teams. This week, one of the topics is ...

Assignmentdescribe a work task a hobby or another activity

Assignment Describe a work task, a hobby, or another activity that you regularly do, and sequentially list the various actionsyou take in orderto complete this activity. Consider thecomplexity of your list and the amount ...

Part 1 conduct internet research sources must be documented

Part 1. Conduct Internet research, (sources must be documented using MLA format), and write a brief analysis of the current status of the U.S. economy. Include current values and trends for at least three of the followin ...

Video balance sheet and income statement relationship

Video : Balance sheet and income statement relationship (khanacademy) After watching this video, explain the relationship between the balance sheet and income statement in your own words, assuming that you are talking to ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As