Daniel Sawyer, the CEO of the Sawyer Group, is initiating planning for the company's operations next year, and he wants you to forecast the firm's additional funds needed (AFN). The firm is operating at full capacity. Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Dollars are in millions.

Select the correct answer.

Problem 12-03
AFN Equation

Broussard Skateboard's sales are expected to increase by 20% from $7.0 million in 2016 to $8.40 million in 2017. Its assets totaled $5 million at the end of 2016. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2016, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 4%. Assume that the company pays no dividends. Under these assumptions, what would be the additional funds needed for the coming year? Do not round intermediate calculations. Round your answer to the nearest dollar.
$

Why is this AFN different from the one when the company pays dividends?
I. Under this scenario the company would have a higher level of retained earnings which would increase the amount of additional funds needed.
II. Under this scenario the company would have a higher level of retained earnings but this would have no effect on the amount of additional funds needed.
III. Under this scenario the company would have a lower level of retained earnings which would reduce the amount of additional funds needed.
IV. Under this scenario the company would have a lower level of retained earnings but this would have no effect on the amount of additional funds needed.
V. Under this scenario the company would have a higher level of retained earnings which would reduce the amount of additional funds needed.
-Select-IIIIIIIVV

You have been asked to forecast the additional funds needed (AFN) for Houston, Hargrove, & Worthington (HHW), which is planning its operation for the coming year. The firm is operating at full capacity. Data for use in the forecast are shown below. However, the CEO is concerned about the impact of a change in the payout ratio from the 10% that was used in the past to 65%, which the firm's investment bankers have recommended. Based on the AFN equation, by how much would the AFN for the coming year change if HHW increased the payout from 10% to the new and higher level? All dollars are in millions.

Select the correct answer.

Problem 12-07
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, 2016, is shown here (millions of dollars):

Sales for 2016 were $450 million and net income for the year was $13.5 million, so the firm's profit margin was 3.0%. Upton paid dividends of $5.4 million to common stockholders, so its payout ratio was 40%. Its tax rate was 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 2017. Do not round intermediate calculations.

1. If sales are projected to increase by $50 million, or 11.11%, during 2017, 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
   
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.
   %
   
3. Use the forecasted financial statement method to forecast Upton's balance sheet for December 31, 2017. 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 2017 as they were in 2016. What is the amount of the line of credit reported on the 2017 forecasted balance sheets? (Hint: You don't need to forecast the income statements because the line of credit is taken out on 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 2017 addition to retained earnings for the balance sheet without actually constructing a full income statement.) Round your answers to the nearest cent.

   Upton Computers Pro Forma Balance Sheet December 31, 2017 (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	$

Flo's Frozen Yogurt shop is evaluating new dispensing machines.

The Flownator has a first cost of $31665 and annual expenses of $9985 that will increase by $402 per year. It will require an overhaul at the end of year 5 at a cost of $5098. The Flownator will save $19666 per year in labor costs. The Flownator has a salvage value of $9706 and a lifespan of 11 years.

The YogGoo300 has a first cost of $22414 and annual expenses of $3837 that will increase by 3% per year. The YogGoo300 will save Flo's $10246 per year in labor costs. The YogGoo300 has a lifespan of 5 years.

What must the salvage value of the YogGoo30 be to make it equally desirable to the Flownator? Use a MARR of 3% to make your calculation.

1) How does a CMO differ from a CDO?

2) What does a CDO offer to someone with credit risk from lending that is not available otherwise.

Please provide a well-written/detailed answer for both please!

WRITE A RESPONSE TO THE FOLLOWING

BlackRock lowered its global growth outlook, based on expectations that trade and geopolitical frictions will continue. The outlook for U.S stocks remains positive, and the firm upgraded European stocks from negative to neutral. Bolvin believes that tariffs are making costs higher for corporations and forcing some companies to change their supply chains altogether. The U.S economy is adjusted for a lowered pace of growth, at about 1.8% in the second half of the year. The firm said central banks are responding to the weaker outlook, and are loosening policy, creating a constructive environment for U.S. and European stocks. The firm said central banks are responding to the weaker outlook, and are loosening policy, creating a constructive environment for U.S. and European stocks. This outlook weakens the economy as a result of the geopolitical and trade frictions. In turn it has increases the potential for easier policy by central banks, including the Federal Reserve and European Central Bank. Bolvin, head of the BlackRock Investment Institute, states “China has become less positive , as a result we were expecting in Europe is not in the cards anymore. It is a downgrade in the broader global picture, and it is directly driven by European and China view.” The firm believes that it is risky but central banks are providing a backstop. BlackRock upgraded emerging market debt but no longer favors emerging market equities, lowering them to neutral from overweight as the outlook for global growth dimmed. The BlackRock investment Institute has downgraded its global growth outlook for the second half, and while it is still sees a good environment for U.S. stocks, it no longer favors market equities. There is a lowered risk of recession, based on that the market looks constructive for the next few months. For that reason, inflation could be a surprise the markets aren’t expecting, at some point after this year.

A local machine shop is requesting a $50,000 5 year term loan to purchase a piece of equipment for its operation. What financial information would you, as the credit analyst, require the commercial loan officer to obtain from the business in order for you to analyze the request?

Consider the following information on Huntington Power Co.

Debt: 4,000, 7% semiannual coupon bonds outstanding, $1,000 par value, 18 years to maturity, selling for 102 percent of par; the bonds make semiannual payments.

Preferred Stock: 10,000 outstanding with par value of $100 and a market value of 105 and $10 annual dividend.

Common Stock: 84,000 shares outstanding, selling for $56 per share, the beta is 2.08

The market risk premium is 5.5%, the risk free rate is 3.5% and Huntington’s tax rate is 32%.

Huntington Power Co. is evaluating two mutually exclusive project that is somewhat riskier than the usual project the firm undertakes; management uses the subjective approach and decided to apply an adjustment factor of +2.1% to the cost of capital for both projects.

Project A is a five-year project that requires an initial fixed asset investment of $2.4 million. The fixed asset falls into the five-year MACRS class. The project is estimated to generate $2,050,000 in annual sales, with costs of $950,000. The project requires an initial investment in net working capital of $285,000 and the fixed asset will have a market value of $225,000 at the end of five years when the project is terminated.

Project B requires an initial fixed asset investment of $1.0 million. The marketing department predicts that sales related to the project will be $920,000 per year for the next five years, after which the market will cease to exist. The machine will be depreciated down to zero over four-year using the straight-line method (depreciable life 4 years while economic life 5 years). Cost of goods sold and operating expenses related to the project are predicted to be 25 percent of sales. The project will also require an addition to net working capital of $150,000 immediately. The asset is expected to have a market value of $120,000 at the end of five years when the project is terminated.

Use the following rates for 5-year MACRS: 20%, 32%, 19.2%, 11.52%, 11.52%, and 5.76%

Please show your work.

1. Calculate project B’s cash flows for year 0-5

Consider the following information on Huntington Power Co.

Debt: 4,000, 7% semiannual coupon bonds outstanding, $1,000 par value, 18 years to maturity, selling for 102 percent of par; the bonds make semiannual payments.

Preferred Stock: 10,000 outstanding with par value of $100 and a market value of 105 and $10 annual dividend.

Common Stock: 84,000 shares outstanding, selling for $56 per share, the beta is 2.08

The market risk premium is 5.5%, the risk free rate is 3.5% and Huntington’s tax rate is 32%.

Huntington Power Co. is evaluating two mutually exclusive project that is somewhat riskier than the usual project the firm undertakes; management uses the subjective approach and decided to apply an adjustment factor of +2.1% to the cost of capital for both projects.

Project A is a five-year project that requires an initial fixed asset investment of $2.4 million. The fixed asset falls into the five-year MACRS class. The project is estimated to generate $2,050,000 in annual sales, with costs of $950,000. The project requires an initial investment in net working capital of $285,000 and the fixed asset will have a market value of $225,000 at the end of five years when the project is terminated.

Project B requires an initial fixed asset investment of $1.0 million. The marketing department predicts that sales related to the project will be $920,000 per year for the next five years, after which the market will cease to exist. The machine will be depreciated down to zero over four-year using the straight-line method (depreciable life 4 years while economic life 5 years). Cost of goods sold and operating expenses related to the project are predicted to be 25 percent of sales. The project will also require an addition to net working capital of $150,000 immediately. The asset is expected to have a market value of $120,000 at the end of five years when the project is terminated.

Use the following rates for 5-year MACRS: 20%, 32%, 19.2%, 11.52%, 11.52%, and 5.76%

Please show your work.

1. What is the appropriate discount rate for project A and project B (Risk adjusted rate)?

2. Calculate project A’s cash flows for years 0-5

Consider the following information on Huntington Power Co.

Debt: 4,000, 7% semiannual coupon bonds outstanding, $1,000 par value, 18 years to maturity, selling for 102 percent of par; the bonds make semiannual payments.

Preferred Stock: 10,000 outstanding with par value of $100 and a market value of 105 and $10 annual dividend.

Common Stock: 84,000 shares outstanding, selling for $56 per share, the beta is 2.08

The market risk premium is 5.5%, the risk free rate is 3.5% and Huntington’s tax rate is 32%.

Huntington Power Co. is evaluating two mutually exclusive project that is somewhat riskier than the usual project the firm undertakes; management uses the subjective approach and decided to apply an adjustment factor of +2.1% to the cost of capital for both projects.

Project A is a five-year project that requires an initial fixed asset investment of $2.4 million. The fixed asset falls into the five-year MACRS class. The project is estimated to generate $2,050,000 in annual sales, with costs of $950,000. The project requires an initial investment in net working capital of $285,000 and the fixed asset will have a market value of $225,000 at the end of five years when the project is terminated.

Project B requires an initial fixed asset investment of $1.0 million. The marketing department predicts that sales related to the project will be $920,000 per year for the next five years, after which the market will cease to exist. The machine will be depreciated down to zero over four-year using the straight-line method (depreciable life 4 years while economic life 5 years). Cost of goods sold and operating expenses related to the project are predicted to be 25 percent of sales. The project will also require an addition to net working capital of $150,000 immediately. The asset is expected to have a market value of $120,000 at the end of five years when the project is terminated.

Use the following rates for 5-year MACRS: 20%, 32%, 19.2%, 11.52%, 11.52%, and 5.76%

1. Calculate NPV, IRR and PI for project B

Consider the following information on Huntington Power Co.

Debt: 4,000, 7% semiannual coupon bonds outstanding, $1,000 par value, 18 years to maturity, selling for 102 percent of par; the bonds make semiannual payments.

Preferred Stock: 10,000 outstanding with par value of $100 and a market value of 105 and $10 annual dividend.

Common Stock: 84,000 shares outstanding, selling for $56 per share, the beta is 2.08

The market risk premium is 5.5%, the risk free rate is 3.5% and Huntington’s tax rate is 32%.

Huntington Power Co. is evaluating two mutually exclusive project that is somewhat riskier than the usual project the firm undertakes; management uses the subjective approach and decided to apply an adjustment factor of +2.1% to the cost of capital for both projects.

Project A is a five-year project that requires an initial fixed asset investment of $2.4 million. The fixed asset falls into the five-year MACRS class. The project is estimated to generate $2,050,000 in annual sales, with costs of $950,000. The project requires an initial investment in net working capital of $285,000 and the fixed asset will have a market value of $225,000 at the end of five years when the project is terminated.

Project B requires an initial fixed asset investment of $1.0 million. The marketing department predicts that sales related to the project will be $920,000 per year for the next five years, after which the market will cease to exist. The machine will be depreciated down to zero over four-year using the straight-line method (depreciable life 4 years while economic life 5 years). Cost of goods sold and operating expenses related to the project are predicted to be 25 percent of sales. The project will also require an addition to net working capital of $150,000 immediately. The asset is expected to have a market value of $120,000 at the end of five years when the project is terminated.

Use the following rates for 5-year MACRS: 20%, 32%, 19.2%, 11.52%, 11.52%, and 5.76%

Please show your work.

1. Calculate NPV, IRR and PI for project A

Barrison is investigating the possible acquisition of Soulmaster. The two firms have the following basic data:

                                                                  Barrison                     Soulmaster

      Number of shares                             3,000,000                   1,200,000

      Current stock price                           $75.00                        $25.00

The combined firm will result in a synergy gains of $15m.

a.         What is the value of of the combined firm?

b.         What is the NPV of acquisition if Barrison pays $30 in cash for each share of Soulmaster?

c.         What is the NPV of the acquisition if Barrison offers one share of Barrison for every two shares of Soulmaster?