Create the following tables for your project and calculate the NPV:
You are evaluating a project for ‘The Ultimate’ recreational tennis racket, guaranteed to correct a wimpy backhand. You estimate the sales price of ‘The Ultimate’ to be $400 and sales volume to be 1,000 units the 1st year, 1,250 units the 2ndyear and 1,325 units in year 3. The project has a 3-year life. Variable costs amount to $225 per unit and fixed costs are $100,000 per year. The project requires $165,000 of equipment that is depreciated using the 5-year MACRS schedule. The actual market value of the equipment at the end of year 3 is $35,000. Initial net working capital investment is $75,000 and NWC will maintain a level equal to 20% of sales for the first two years. There is no increase in year 3 of the project. The tax rate is 34% and the required return on the project is 10%.
What is the NPV of this project? (Show all your calculations)
In: Finance
Case 2: Evaluate a project with a $25,000 startup cost and annual ongoing costs of $2,500. Cash flows in the first year are estimated to be $1,500 in the first year, $5,500 in the second year, $6,700 in the third year, $9,300 in the fourth year, and $11,500 in the fifth and final year. There is also equipment that is estimated to have a $20,000 salvage value. Assume that the final cash flows and the equipment salvage happen in the same period. |
1. Use the NPV function to help calculate the Net Present Value of the project in Case 2 (NPV plus the startup cost[a negative number]) Use 12% as your required return/cost of capital for Case 2 |
2. Calculate the present value of each cash flow and add the values together. Did the answer match your answer in Q6? |
3. Use the XIRR function to calculate the Internal Rate of Return for the project in Case 2. Use today's date as the start date T0, and the same date a year later for T1 and so on. |
4. What required rate/cost of capital would make you indifferent to the project in Case 1 and Case 2? (What rate makes the Net Present Value equal? |
5. What is the Discounted Payback Period for Case 2? |
6: Using the base required return/cost of capital for cases 1 and 2, which project do you prefer and why? |
In: Finance
Describe the existing needs for cost information in healthcare firms.
In: Finance
NOK Plastics is considering the acquisition of a new plastic injection-molding machine to make a line of plastic fittings. The cost of the machine and dies is $125,000. Shipping and installation is another $8,000. NOK estimates it will need a $10,000 investment in net working capital initially, which will be recovered at the end of the life of the equipment. Sales of the new plastic fittings are expected to be $350,000 annually. Cost of goods sold are expected to be 50% of sales. Additional operating expenses are projected to be $115,000 per year over the machine’s expected 5-year useful life. The machine will depreciated using a 5-year MACRS class life. The equipment will be sold at the end of its useful life (5 years) for $35,000. The tax rate is 25% and the relevant discount rate is 15%. Calculate the net present value (NPV), internal rate of return (IRR), payback period (PB), and profitability index (PI) and state whether the project should be accepted.
In: Finance
In: Finance
Portfolio X consists of 4 stocks which are A, B, C, and D. The information pertaining to the stocks, the portfolio and the market are given below:
Stock | Investment | Beta |
A | $25,000 | 0.8 |
B | $25,000 | 1.2 |
C | $25,000 | Not Available |
D | $25,000 | Not Available |
Portfolio X | $100,000 | 1 |
Expected return of the market = 10%
Risk-free rate = 4%
(a) Calculate the beta of Portfolio Y that is equally invested in stock A and stock B.
b) Compute the beta of Portfolio Z that is equally invested in stock C and stock D.
(c) Suppose you sell all $25,000 invested in Stock A and use the proceeds to invest in Stock B. Calculate the resulting value of the beta of Portfolio X.
(d) Compute the change in the expected return of Portfolio X resulting from your actions in part (c).
(e) Discuss the likely circumstances where you would sell a stock with a lower beta and invest the proceeds in a stock with a higher beta, as in part (c).
In: Finance
Consider the mortgage pool data below for a Mortgage Backed Security (MBS). Beginning balance $800,000,000 WAC 5.750% WAM 354 Passthrough rate 5.250% PSA schedule 150% Please answer the questions below about the first scheduled payment to the investors of this MBS. SHOW YOUR WORK Dollar amounts may be rounded to the nearest dollar. (a) What is the CPR for this payment? (b) What is the SMM for this payment? (c) For this payment, what is the amount of the total scheduled mortgage payment, the gross interest paid with that payment, and the scheduled principal repaid with that payment? (You can use your BA II Plus to calculate this data. Show what you would enter into your calculator to obtain this data.) (d) What is the net interest payment available to the MBS investors after servicing fees have been paid? (e) What is the forecasted prepayment amount based on the SMM calculated in (b) above? (f) What will be the total principal repayment to the MBS investors in the first payment? (g) What will be the total payment made to the MBS investors?
In: Finance
Station WJXT is considering the replacement of its old, fully depreciated sound mixer. Two new models are available. Mixer X costs $216,000, has a five-year expected life, and will generate after-tax cash flow savings of $68,200 per year. Mixer Y costs $345,000, has a ten-year expected life, and generates after-tax cash flow savings of $83,400 per year.
The cost of capital is 10 percent. Should WJXT replace the old mixer with mixer X or Y?
In: Finance
Prokter and Gramble (PKGR) have historically maintained a debt-equity ratio of approximately 0.15. Its current stock price is $ 54 per share, with 2.8 billion shares outstanding. The firm enjoys very stable demand for its products, and consequently, it has a low equity beta of 0.375 and can borrow at 4.0%, just 20 basis points over the risk-free rate of 3.8%. The expected return of the market is 10.5% and PKGR's tax rate is 32%.
a. This year, PKGR is expected to have free cash flows of $6.5 billion. What constant expected a growth rate of free cash flow is consistent with its current stock price?
b. PKGR believes it can increase debt without any serious risk of distress or other costs. With a higher debt-equity ratio of 0.375, it believes its borrowing costs will rise only slightly to 4.3%. If PKGR announces that it will raise its debt-equity ratio to 0.375 through a leveraged recap, determine the increase or decrease in the stock price that would result from the anticipated tax savings.
(round to two decimal places.)
In: Finance
List 3 key components you would consider in making an investment decision. What sources and factors would you review?
In: Finance
In: Finance
QUESTION 3
[04 Marks]
[06 Marks]
[02 Marks]
[03 Marks]
Total 20 Marks
In: Finance
Discounted Cash Flow Valuation
Presented below are data for Boso Audio:
Forecast Year | ||||||
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | Terminal | |
No. of outstanding shares | 500 | 500 | 500 | 500 | 500 | 500 |
Terminal year growth rate | 4% | |||||
Cost of common equity | 9% | 9% | 9% | 9% | 9% | 9% |
Net income | $79 | $94 | $111 | $130 | $150 | $157 |
Beginning of year common equity | $649 | $683 | $720 | $758 | $797 | $839 |
Free cash flow to common equity | $44 | $58 | $73 | $90 | $108 | $115 |
Compute the value of a share of Boso common stock using the discounted cash flow method.
Do not round your computations until your final answer. Round final answer to two decimal places.
In: Finance
Windswept, Inc. |
|||
Net sales |
$ |
10,500 |
|
Cost of goods sold |
7,950 |
||
Depreciation |
370 |
||
Earnings before interest and taxes |
$ |
2,180 |
|
Interest paid |
100 |
||
Taxable income |
$ |
2,080 |
|
Taxes |
624 |
||
Net income |
$ |
1,456 |
Windswept, Inc. |
|||||||||||||
2016 |
2017 |
2016 |
2017 |
||||||||||
Cash |
$ |
370 |
$ |
390 |
Accounts payable |
$ |
1,910 |
$ |
1,800 |
||||
Accounts rec. |
1,110 |
1,010 |
Long-term debt |
1,070 |
1,530 |
||||||||
Inventory |
1,880 |
1,770 |
Common stock |
3,360 |
3,140 |
||||||||
Total |
$ |
3,360 |
$ |
3,170 |
Retained earnings |
650 |
900 |
||||||
Net fixed assets |
3,630 |
4,200 |
|||||||||||
Total assets |
$ |
6,990 |
$ |
7,370 |
Total liab. & equity |
$ |
6,990 |
$ |
7,370 |
What were the total dividends paid for 2017?
In: Finance
You are trying to assess the cost of capital for a small commercial aircraft manufacturer called Jetstream Inc. Unfortunately, Jetstream is a private company so you can not estimate its equity beta using its stock returns. You have, however, collected some information on comparable firms that are publicly traded (see the table below). Assume that Jetstream targets a stable debt to enterprise value ratio (D/(D+E)) of 10% and that its cost of debt is 3.95%.
All firms face a marginal tax rate of 21%, the market risk premium (?[??]−??) is 5%, and the risk-free rate (??) is 3.5%. Additionally, assume that corporate taxes are the only market imperfection.
D/(D+E) |
rD |
βE |
rE |
rU |
|
Lightwing Aircraft Inc. |
50% |
4.85% |
1.8 |
||
Gulfstream Jets |
45% |
4.80% |
1.75 |
||
Into Thin Air Corp |
15% |
4.00% |
1.3 |
||
Turbulence Corp. |
55% |
4.87% |
1.89 |
In: Finance