An investment project requires a net investment of $200 million. The project is expected to generate annual net cash flows of $25 million for the next 15 years with a one-time end of project cash flow of $3 million. The firm's cost of capital is 14 percent and marginal tax rate is 40 percent.
a) Evaluate the project using the NPV method and state whether or not the project should be accepted.
b) Evaluate the project using the IRR method and state whether or not the project should be accepted.
c) Evaluate the project using the PI method and state whether or not the project should be accepted.
Answers: NPV = -$46 million < 0 so Reject; IRR = 9.20 < 14% so Reject; PI = 0.77 < 1 so Reject
Please show the step by step formula included process for each part of the question! Thank you.
In: Finance
Excel Online Structured Activity: WACC and optimal capital budget
Adamson Corporation is considering four average-risk projects with the following costs and rates of return:
| Project | Cost | Expected Rate of Return |
| 1 | $2,000 | 16.00% |
| 2 | 3,000 | 15.00 |
| 3 | 5,000 | 13.75 |
| 4 | 2,000 | 12.50 |
The company estimates that it can issue debt at a rate of rd = 11%, and its tax rate is 35%. It can issue preferred stock that pays a constant dividend of $6 per year at $47 per share. Also, its common stock currently sells for $37 per share; the next expected dividend, D1, is $3.75; and the dividend is expected to grow at a constant rate of 6% per year. The target capital structure consists of 75% common stock, 15% debt, and 10% preferred stock. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Open spreadsheet
What is the cost of each of the capital components? Round your answers to two decimal places. Do not round your intermediate calculations.
Cost of debt %
Cost of preferred stock %
Cost of retained earnings %
What is Adamson's WACC? Round your answer to two decimal places. Do not round your intermediate calculations.
%
Only projects with expected returns that exceed WACC will be accepted. Which projects should Adamson accept?
| Project 1 | _______acceptreject |
| Project 2 | _______acceptreject |
| Project 3 | _______acceptreject |
| Project 4 | _______acceptreject |
In: Finance
Excel Online Structured Activity: Foreign capital budgeting
Sandrine Machinery is a Swiss multinational manufacturing company. Currently, Sandrine's financial planners are considering undertaking a 1-year project in the United States. The project's expected dollar-denominated cash flows consist of an initial investment of $2000 and a cash inflow the following year of $2400. Sandrine estimates that its risk-adjusted cost of capital is 12%. Currently, 1 U.S. dollar will buy 0.82 Swiss franc. In addition, 1-year risk-free securities in the United States are yielding 6.75%, while similar securities in Switzerland are yielding 3.5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations.
Open spreadsheet
If this project was instead undertaken by a similar U.S.-based company with the same risk-adjusted cost of capital, what would be the net present value and rate of return generated by this project? Round your answers to two decimal places.
NPV = $
Rate of return = %
What is the expected forward exchange rate 1 year from now? Round your answer to two decimal places.
SF per U.S. $
If Sandrine undertakes the project, what is the net present value and rate of return of the project for Sandrine? Do not round intermediate calculations. Round your answers to two decimal places.
NPV = Swiss Francs
Rate of return = %
In: Finance
Stock X has a 10.0% expected return, a beta coefficient of 0.9, and a 40% standard deviation of expected returns. Stock Y has a 12.5% expected return, a beta coefficient of 1.2, and a 20.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Open spreadsheet
Calculate each stock's coefficient of variation. Round your answers to two decimal places. Do not round intermediate calculations.
CVx =
CVy =
Which stock is riskier for a diversified investor?
Calculate each stock's required rate of return. Round your answers to two decimal places.
rx = %
ry = %
On the basis of the two stocks' expected and required returns, which stock would be more attractive to a diversified investor?
_________Stock XStock Y
Calculate the required return of a portfolio that has $7,000 invested in Stock X and $4,000 invested in Stock Y. Do not round intermediate calculations. Round your answer to two decimal places.
rp = %
If the market risk premium increased to 6%, which of the two stocks would have the larger increase in its required return?
_________Stock XStock Y
In: Finance
1. Over the last couple of decades the Euro has been as low as $0.85 and as high as $1.51. It is currently at $1.10. How do currency movements affect Porsche's profitability? Give a detailed example using a single, new Porsche 911. You are welcome to come up with your own estimates of selling price. Use realistic currency fluctuations and time periods for manufacturing and selling a car.
2 . Hedging vs Speculating
a. What is a speculator in the context of futures markets?
b. Are speculators bad for the futures markets or our economy?
c. At what point does Porsche move from being a hedger and become a speculator?
d. As a stockholder, how would you react to Porsche speculation?
In: Finance
The Warren Watch Company sells watches for $23, fixed costs are $140,000, and variable costs are $10 per watch.
In: Finance
Firms HL and LL are identical except for their financial leverage ratios and the interest rates they pay on debt. Each has $16 million in invested capital, has $3.2 million of EBIT, and is in the 40% federal-plus-state tax bracket. Firm HL, however, has a debt-to-capital ratio of 55% and pays 12% interest on its debt, whereas LL has a 20% debt-to-capital ratio and pays only 8% interest on its debt. Neither firm uses preferred stock in its capital structure.
In: Finance
Baker Industries’ net income is $21,000, its interest expense is $6,000, and its tax rate is 25%. Its notes payable equals $23,000, long-term debt equals $80,000, and common equity equals $240,000. The firm finances with only debt and common equity, so it has no preferred stock.
What are the firm’s ROE and ROIC? Do not round intermediate calculations. Round your answers to two decimal places.
In: Finance
Q3Company JC Electronics had a net income of $1,200,000 this year. The company has a target capital structure of 43% in debt and the rest in equity. The company is considering the following independent projects to invest for next year:
Project A: capital budget 500,000; cost of capital 15%; IRR 13%.
Project B: capital budget 600,000; cost of capital 14%; IRR 15%.
Project C: capital budget 1,000,000; cost of capital 15%; IRR 18%.
Assuming that the above projects are the only items to be budgeted for next year. What will be this year's dividend payout ratio?
In: Finance
Sadik Industries must install $1 million of new machinery in its Texas plant. It can obtain a bank loan for 100% of the required amount. Alternatively, a Texas investment banking firm that represents a group of investors believes that it can arrange for a lease financing plan. Assume that these facts apply:
| Year | 3-year MACRS | |
| 1 | 33.33 | % |
| 2 | 44.45 | % |
| 3 | 14.81 | % |
| 4 | 7.41 | % |
In: Finance
The annual sales for Salco, Inc. were $ 4.46 million last year. The firm's end-of-year balance sheet was as follows: Salco's income statement for the year was as follows:
a. Calculate Salco's total asset turnover, operating profit margin, and operating return on assets. b. Salco plans to renovate one of its plants and the renovation will require an added investment in plant and equipment of $ 1.09 million. The firm will maintain its present debt ratio of 50 percent when financing the new investment and expects sales to remain constant. The operating profit margin will rise to 13.9 percent. What will be the new operating return on assets ratio (i.e., net operating income divided by total assets) for Salco after the plant's renovation?
c. Given that the plant renovation in part (b) occurs and Salco's interest expense rises by $ 53,000 per year, what will be the return earned on the common stockholders' investment? Compare this rate of return with that earned before the renovation. Based on this comparison, did the renovation have a favorable effect on the profitability of the firm?
Balance sheet
| Current assets | $500,000 | Liabilities | $994,000 | |
| Net fixed assets | 1488000 | Owners' equity | 994000 | |
| Total Assets | $1,988,000 | Total | $1,988,000 | |
Income statement
| Sales | $4,460,000 |
| Less: Cost of goods sold | (3,490,000) |
| Gross profit | $970,000 |
| Less: Operating expenses | (505,000) |
| Net operating income | $465,000 |
| Less: Interest expense | (102,000) |
| Earnings before taxes | $363,000 |
| Less: Taxes (35%) | (127,050) |
| Net income | $235,950 |
In: Finance
Consider the following two projects:
Year Cash Flow (ABC) Cash Flow (XYZ)
0 −$23,000 −$23,000
1 10,490 12,000
2 10,900 9,360
3 10,500 10,400
Instructions:
I. Using company cost of capital 15%, calculate the following investment criteria for both projects:
1. Payback period
2. Internal Rate of Return (IRR)
3. Profitability Index (PI)
4. Net Present Value (NPV)
II. If projects A and B are independent, which one(s) will you choose? Why?
III. If projects A and B are mutually exclusive, which one will you choose? Why?
In: Finance
a no-load fund charges a 112b-1 fee of 1% and maintains an expense ratio of 0.75%. Assumes the securities in which the fund invests an increase in value by 6% per year. How much will an investment of $1000 grow to after 5 years? a. $1,231.35 b. $1,263.72 c. $1,195.33 d.$1,300.53
In: Finance
For this week choose a news article from a well-known news source about why it interests you and why it is related to financial accounting
In: Finance
Salty Pawz was established using Wanda’s personal funds, since originally she sold her products only to friends and family and was able to pay for everything as she went along. Now that the business is growing, she knows she cannot finance the expansion out of her own pocket, so she is considering taking out a loan. She has no experience with financial institutions other than the basics such as managing her personal bank accounts, a credit card, a mortgage, and a car loan, all of which are with the local Credit Union.
Explain to Wanda how the monetary system works. In particular, describe the various financial institutions she could approach to seek funding.
Explain the financial institutions and markets appropriate for Salty Pawz needs.
Describe available loan options and processes required for Salty Pawz to obtain funds to expand.
Identify your recommendation for the best loan option based on Salty Pawz needs and goals.
In: Finance