You are a manager at Percolated Fiber, which is considering expanding its operations in synthetic fiber manufacturing. Your boss comes into your office, drops a consultant's report on your desk, and complains, "We owe these consultants $ 1.1 million for this report, and I am not sure their analysis makes sense. Before we spend the $19 million on new equipment needed for this project, look it over and give me your opinion." You open the report and find the following estimates (in millions of dollars):
| Project Year | |||||
| Earnings Forecast ($000,000s) | 1 | 2 | . . . | 9 | 10 |
| Sales revenue | 28 | 28 | 28 | 28 | |
| - Cost of goods sold | 16.8 | 16.8 | 16.8 | 16.8 | |
| Gross profit | 11.2 | 11.2 | 11.2 | 11.2 | |
| - Selling, general, and administrative expenses | 1.52 | 1.52 | 1.52 | 1.52 | |
| - Depreciation | 1.9 | 1.9 | 1.9 | 1.9 | |
| Net operating income | 7.78 | 7.78 | 7.78 | 7.78 | |
| - Income tax | 2.723 | 2.723 | 2.723 | 2.723 | |
| Net unlevered income | 5.057 | 5.057 | 5.057 | 5.057 |
All of the estimates in the report seem correct. You note that the consultants used straight-line depreciation for the new equipment that will be purchased today (year 0), which is what the accounting department recommended. The report concludes that because the project will increase earnings by $5.057 million per year for ten years, the project is worth $ 50.57 million. You think back to your halcyon days in finance class and realize there is more work to be done!
First, you note that the consultants have not factored in the fact that the project will require $12 million in working capital upfront (year 0), which will be fully recovered in year 10. Next, you see they have attributed $ 1.52 million of selling, general and administrative expenses to the project, but you know that $ 0.76 million of this amount is overhead that will be incurred even if the project is not accepted. Finally, you know that accounting earnings are not the right thing to focus on!
a. Given the available information, what are the free cash flows in years 0 through 10 that should be used to evaluate the proposed project?
b. If the cost of capital for this project is 8% what is your estimate of the value of the new project?
In: Finance
A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that yields a rate of 7%. The probability distribution of the risky funds is as follows: Expected Return Standard Deviation Stock fund (S) 22 % 32 % Bond fund (B) 12 19 The correlation between the fund returns is 0.11. You require that your portfolio yield an expected return of 11%, and that it be efficient, on the best feasible CAL. a. What is the standard deviation of your portfolio? (Round your answer to 2 decimal places.) b. What is the proportion invested in the T-bill fund and each of the two risky funds? (Round your answers to 2 decimal places.)
In: Finance
National Business Machine Co. (NBM) has $4.4 million of extra cash after taxes have been paid. NBM has two choices to make use of this cash. One alternative is to invest the cash in financial assets. The resulting investment income will be paid out as a special dividend at the end of three years. In this case, the firm can invest in Treasury bills yielding 2.2 percent or a 4.6 percent preferred stock. IRS regulations allow the company to exclude from taxable income 50 percent of the dividends received from investing in another company’s stock. Another alternative is to pay out the cash now as dividends. This would allow the shareholders to invest on their own in Treasury bills with the same yield, or in preferred stock. The corporate tax rate is 24 percent. Assume the investor has a 38 percent personal income tax rate, which is applied to interest income and preferred stock dividends. The personal dividend tax rate is 10 percent on common stock dividends. Suppose the company reinvests the $4.4 million and pays a dividend in three years. What is the total aftertax cash flow to shareholders if the company invests in T-bills?
|
What is the total aftertax cash flow to shareholders if the company invests in preferred stock?
|
In: Finance
| Using the schedule of cash flows and other information below, estimate the firm's value of operations | ||||||||
| by discounting the cash flows back to the present (time value of money formula) | ||||||||
| Compute the value of operations a second way by using the NPV formula in Excel | ||||||||
| FCFF | See cash flow schedule | |||||||
| WACC | 18% | |||||||
| Debt | 75 | million | ||||||
| Number of shares | 100 | million | ||||||
| show excel formulas | ||||||||
| Time | FCFF, millions | |||||||
| 0 | ||||||||
| 1 | -2 | |||||||
| 2 | 10 | |||||||
| 3 | 18 | |||||||
| 4 | 30 | |||||||
| 5 | 52 | |||||||
| 6 | 56 | |||||||
| 7 | 59 | |||||||
| 8 | 61 | growing at 2% per year | ||||||
| 9 | ||||||||
| 10 | ||||||||
In: Finance
Assume that your father is now 50 years old, plans to retire in 10 years, and expects to live for 25 years after he retires - that is, until age 85. He wants his first retirement payment to have the same purchasing power at the time he retires as $50,000 has today. He wants all his subsequent retirement payments to be equal to his first retirement payment. (Do not let the retirement payments grow with inflation: Your father realizes that if inflation occurs the real value of his retirement income will decline year by year after he retires). His retirement income will begin the day he retires, 10 years from today, and he will then receive 24 additional annual payments. Inflation is expected to be 5% per year from today forward. He currently has $50,000 saved and expects to earn a return on his savings of 8% per year with annual compounding. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet How much must he save during each of the next 10 years (with equal deposits being made at the end of each year, beginning a year from today) to meet his retirement goal? (Note: Neither the amount he saves nor the amount he withdraws upon retirement is a growing annuity.) Do not round intermediate calculations. Round your answer to the nearest dollar.
| Father's current age | 50 | |
| Number of years until retirement | 10 | |
| Number of years living in retirement | 25 | |
| 1st retirement payment, same purchasing power today as | $60,000 | |
| Inflation rate | 6.00% | |
| Current savings at t = 0 | $75,000 | |
| Percentage return earned | 4.00% | |
| Step 1. Calculate retirement payments, beginning at t = 10 | Formulas | |
| Fixed retirement payments | #N/A | |
| Step 2. Calculate the value of current savings at t = 10 | ||
| Value of current savings, 10 years from today | #N/A | |
| Step 3. Calculate the value of the annuity due of retirement payments at t = 10 | ||
| Value of annuity due | #N/A | |
| Step 4. Calculate the net amount that must be accumulated at t = 10 to receive desired retirement payments | ||
| Net amount needed in 10 years | #N/A | |
| Step 5. Calculate the value of annual deposit needed to meet desired retirement goal | ||
| Value of annual deposit to meet retirement goal | #N/A |
In: Finance
You are considering a 20-year, $1,000 par value bond. Its coupon rate is 11%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.
Open spreadsheet
If you require an "effective" annual interest rate (not a nominal rate) of 7.63%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent.
In: Finance
The Miller Corporation is considering a new product. An outlay of $255 million is required for equipment to produce the new product and additional net working capital of $31 million is required to support production. The equipment will be depreciated on a straight-line basis to a zero book value over 10 years. Although the depreciable life is 10 years, the project is expected to have a productive life of only 8 years, and it is expected to have a zero salvage value at that time (scrap value = removal cost). Revenues minus expenses are expected to be $61.761 million per year for the productive life of the project. The corporation's marginal tax rate is 23% and the cost of capital for this investment is 8.3%. Compute the NPV of Miller's potential new product. (In $millions with 3 decimals.)
In: Finance
Cusic Music Company is considering the sale of a new sound board used in recording studios. The new board would sell for $24,300, and the company expects to sell 1,600 per year. The company currently sells 1,950 units of its existing model per year. If the new model is introduced, sales of the existing model will fall to 1,620 units per year. The old board retails for $22,700. Variable costs are 55 percent of sales, depreciation on the equipment to produce the new board will be $1,275,000 per year, and fixed costs are $3,150,000 per year. If the tax rate is 25 percent, what is the annual OCF for the project?
In: Finance
(Bond valuation) A bond that matures in 17years has a $1 comma 000par value. The annual coupon interest rate is 8percent and the market's required yield to maturity on a comparable-risk bond is 16 percent. What would be the value of this bond if it paid interest annually? What would be the value of this bond if it paid interest semiannually?
a. The value of this bond if it paid interest annually would be
.
(Round to the nearest cent.)
In: Finance
Sarah is buying a home. Her loan will be $100,000. She will make annual payments for the next 30 years to retire this loan. The interest rate on the loan is 4 %.
A. How much will her annual payments be?
B. How much interest will she pay over the life of the loan?
C. How much of her first payment will be applied to principal?
D. How much will she still owe on the loan after 10 years?
In: Finance
|
The Cornchopper Company is considering the purchase of a new harvester. |
|
The new harvester is not expected to affect revenue, but operating expenses will be reduced by $14,600 per year for 10 years. |
|
The old harvester is now 5 years old, with 10 years of its scheduled life remaining. It was originally purchased for $91,000 and has been depreciated by the straight-line method. |
| The old harvester can be sold for $22,600 today. |
| The new harvester will be depreciated by the straight-line method over its 10-year life. |
| The corporate tax rate is 21 percent. |
| The firm’s required rate of return is 14 percent. |
|
The initial investment, the proceeds from selling the old harvester, and any resulting tax effects occur immediately. |
|
All other cash flows occur at year-end. |
|
The market value of each harvester at the end of its economic life is zero. |
|
Determine the break-even purchase price in terms of present value of the harvester. This break-even purchase price is the price at which the project’s NPV is zero. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
NOTE*** answer is not 91309.2 or 109154.41 or 110898.7 or 119875.42 or 117742.56
In: Finance
|
Suppose you have been hired as a financial consultant to Defense Electronics, Inc. (DEI), a large, publicly traded firm that is the market share leader in radar detection systems (RDSs). The company is looking at setting up a manufacturing plant overseas to produce a new line of RDSs. This will be a five-year project. The company bought some land three years ago for $3.8 million in anticipation of using it as a toxic dump site for waste chemicals, but it built a piping system to safely discard the chemicals instead. The land was appraised last week for $4.6 million. In five years, the aftertax value of the land will be $5 million, but the company expects to keep the land for a future project. The company wants to build its new manufacturing plant on this land; the plant and equipment will cost $31.44 million to build. The following market data on DEI’s securities is current: |
| Debt: |
111,000 7 percent coupon bonds outstanding, 26 years to maturity, selling for 107 percent of par; the bonds have a par value of $2,000 and make semiannual payments. |
| Common stock: |
8,100,000 shares outstanding, selling for $70.30 per share; the beta is 1.3. |
| Preferred stock: |
443,000 shares of 5.9 percent preferred stock outstanding, selling for $80.30 per share and having a par value of $100. |
| Market: |
6 percent expected market risk premium; 4.8 percent risk-free rate. |
|
DEI uses G.M. Wharton as its lead underwriter. Wharton charges DEI spreads of 6 percent on new common stock issues, 5 percent on new preferred stock issues, and 4 percent on new debt issues. Wharton has included all direct and indirect issuance costs (along with its profit) in setting these spreads. Wharton has recommended to DEI that it raise the funds needed to build the plant by issuing new shares of common stock. DEI’s tax rate is 22 percent. The project requires $1,125,000 in initial net working capital investment to get operational. Assume Wharton raises all equity for new projects externally. |
| a. |
Calculate the project’s initial Year 0 cash flow, taking into account all side effects. Assume that the net working capital will not require flotation costs. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole dollar amount, e.g., 1,234,567.) |
| b. | The new RDS project is somewhat riskier than a typical project for DEI, primarily because the plant is being located overseas. Management has told you to use an adjustment factor of 1 percent to account for this increased riskiness. Calculate the appropriate discount rate to use when evaluating DEI’s project. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
| c. | The manufacturing plant has an eight-year tax life, and DEI uses straight-line depreciation. At the end of the project (that is, the end of Year 5), the plant and equipment can be scrapped for $3.8 million. What is the aftertax salvage value of this plant and equipment? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole dollar amount, e.g., 1,234,567.) |
| d. | The company will incur $6,100,000 in annual fixed costs. The plan is to manufacture 15,300 RDSs per year and sell them at $10,450 per machine; the variable production costs are $9,050 per RDS. What is the annual operating cash flow (OCF) from this project? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole dollar amount, e.g., 1,234,567.) |
| e. | DEI’s comptroller is primarily interested in the impact of DEI’s investments on the bottom line of reported accounting statements. What will you tell her is the accounting break-even quantity of RDSs sold for this project? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) |
| f. | Finally, DEI’s president wants you to throw all your calculations, assumptions, and everything else into the report for the chief financial officer; all he wants to know is what the RDS project’s internal rate of return (IRR) and net present value (NPV) are. (Do not round intermediate calculations. Enter your NPV answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89. Enter your IRR answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
In: Finance
1. The face value for Karen’s Limited bonds is $100,000 and has a 2 percent annual coupon. The percent annual coupon bonds matures in 2022, and it is now 2012. Interest on these bonds is paid annually on December 31 of each year, and new annual coupon bonds with similar risk andmaturity are currently yielding 12 percent. How much should Karen sell her bonds today?
2. What is the semi-annual coupon bond’s nominal yield to maturity (YTM), if the years to maturity is 15 years, and sells for 119% with coupons rate of 10%? Assume the par value of the bond is $1,000.
3. MJI Corporation bonds mature in 6 years and have a yield to maturity of 8.5 percent. The par value of the bonds is $1,000. The bonds have a 10 percent coupon rate and pay interest on a semi-annual basis. Assuming there are no changes to interest rates during the course of the year, what are the current yield and capital gains yield on the bonds for this year?
In: Finance
In what ways is IRR more useful than NPV? In what ways is NPV more useful than IRR? Or you could view this question as asking for the pros and cons of each calculation.
In: Finance
We decided that we need to specify the type of retirement income we want and make plans to accomplish our goal. Our goal is to plan for 25 years of retirement, at $150,000 per year, but we want to receive the
$150,000 at the beginning of each year of our retirement. So, to reach our objective, for the next 30 years, we need to set aside the right amount of money as an annual constant contribution into a retirement fund at the end of each of those years. So in total, there will be 25 annual payments (withdrawals) of 150,000 each received at the beginning of each month, preceded by 30 annual contributions made at the end of each period. (The last contribution time may correspond with that of the first withdrawal time).
We discussed this in general terms with another pension adviser, and she advised us to assume an average nominal annual rate of return of 8.50%, compounded annually, for the entire 55-year period.
Ques 1) How much money would we need in our pension plan when we retire after 30 years of work to make our pension dream come true? Please use (display + name) the excel function/ formula used for each yellow cell.
|
Answer 1. amount needed at beginning of retirement |
|
|
APR |
8.50% |
|
period rate |
|
|
annual pension |
-$150,000.00 |
|
#periods |
25 |
|
Amount needed at BEG of retirement: |
|
Ques 2) In order to accumulate this amount of money, how much would we need to deposit in our pension plan at the end of each year, for each of the next 30 years of work, if we contributed a constant amount each year? Please use (display + name) the excel function/ formula used for each yellow cell.
|
Answer 2. required annual contribution |
|
|
period rate |
|
|
#periods |
30 |
|
Required annual contribution: |
Ques 3) If the inflation rate for the next 30 years were to be 2% per year (assuming country’s Bank manages to meet its target inflation of about 2%), what annual income now would provide the same purchasing power as a $150,000 annual income in 30 years? Please use (display + name) the excel function/ formula used for each yellow cell.
|
Answer 3. inflation impact after 30 years |
|
|
inflation rate |
0.02 |
|
payment in 30 years |
$150,000.00 |
|
equivalent amount in today's dollars: |
In: Finance