ABC paid a dividend of $3.00 this past year. The dividends are expected to grow at a rate of 20% for the next three years, and at a constant 3% rate thereafter. The required rate of return for investors in this stock is 10%. Calculate the value of this stock today.
In: Finance
Evaluate the following pure-yield pickup swap: You currently hold a 15-year, AA-rated, 8.5% coupon bond priced to yield 11.0%. As a swap candidate, you are considering a 15-year, AA-rated, 10.5% coupon bond priced to yield 12.0%. (Assume reinvestment at 11.0%, $1,000 par value, semiannual coupons.) Do not round intermediate calculations. Round your monetary answers to the nearest cent and percentage answers and value of swap to two decimal places. You may use Appendix C to answer the questions.
Current Bond | Candidate Bond | |
Dollar investment | $ | $ |
Annual coupon | $ | $ |
i on one coupon | $ | $ |
Principal value at year end | $ | $ |
Total accrued | $ | $ |
Realized compound yield | % | % |
Value of swap: basis points in one year
In: Finance
PROJECT CASH FLOW
Colsen Communications is trying to estimate the first-year cash flow (at Year 1) for a proposed project. The financial staff has collected the following information on the project:
Sales revenues | $15 million |
Operating costs (excluding depreciation) | 10.5 million |
Depreciation | 3 million |
Interest expense | 3 million |
The company has a 40% tax rate, and its WACC is 12%.
Write out your answers completely. For example, 13 million should be entered as 13,000,000.
In: Finance
1.
(Pmt, FV=? ) what is the future value of an annuity of $9 invested every week for the next 2 years starting one week from now at 8.9% compounded every week?
2.
(PMT, N = ?) You need to borrow &117,119 today and can repay the money in installments of $11,760 every year stating next year. If the rate of return is 7.5%, how long do you expect to repay the loan
In: Finance
Company A plans to replace with one of their current equipment with one of the three options shown in the table.
Option |
A |
B |
C |
Initial Cost |
200 |
350 |
475 |
Annual Operation Cost |
450 |
275 |
300 |
Salvage Value |
75 |
60 |
80 |
Estimated Life in Year |
20 |
20 |
20 |
Perform AW analysis to figure out which option should company A choose. The rate of return is 8% per year compounded Monthly. Please see correct answer below how do you get this?
Time Window - Year | |||
A | B | C | |
PMT | ($469.24) | ($310.18) | ($347.77) |
Winner |
In: Finance
Company B must choose one of two methods for its validation activity. Based on the information below, perform an AW analysis and make recommendation. MARR is 10% per year compounded quarterly. Please use the AW analysis.
Method |
X |
Y |
Initial Cost |
100,000 |
250000 |
Annual Operation Cost |
30,000 in year one increasing by 5000 each year |
200,00 |
Salvage Value |
0 |
0 |
Estimated Life in Year |
3 |
6 |
Please see below correct answer. How do you get this? Use Excel.
X | Y | |
FV | ||
PMT | ($75,152.98) | ($78,044.72) |
Winner |
In: Finance
In: Finance
Blossom Corp. management is investigating two computer systems. The Alpha 8300 costs $2,991,425 and will generate cost savings of $1,560,125 in each of the next five years. The Beta 2100 system costs $3,323,500 and will produce cost savings of $1,340,750 in the first three years and then $2 million for the next two years. The company’s discount rate for similar projects is 14 percent. What is the NPV of each system? (Enter negative amounts using negative sign, e.g. -45.25. Do not round discount factors. Round other intermediate calculations and final answer to 0 decimal places, e.g. 1,525.)
NPV of Alpha system $enter a dollar amount rounded to 0 decimal places
NPV of Beta system $enter a dollar amount rounded to 0 decimal places
Which one should be chosen based on the NPV?
In: Finance
Problem 7-18 Abandonment
We are examining a new project. We expect to sell 6,700 units per year at $61 net cash flow apiece for the next 10 years. In other words, the annual operating cash flow is projected to be $61 × 6,700 = $408,700. The relevant discount rate is 15 percent, and the initial investment required is $1,780,000. After the first year, the project can be dismantled and sold for $1,650,000. Suppose you think it is likely that expected sales will be revised upward to 9,700 units if the first year is a success and revised downward to 5,300 units if the first year is not a success.
a. If success and failure are equally likely, what is the NPV of the project? Consider the possibility of abandonment in answering. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
b. What is the value of the option to abandon? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
In: Finance
The Gilbert Instrument Corporation is considering replacing the wood steamer it currently uses to shape guitar sides. The steamer has 6 years of remaining life. If kept, the steamer will have depreciation expenses of $650 for 5 years and $325 for the sixth year. Its current book value is $3,575, and it can be sold on an Internet auction site for $4,150 at this time. If the old steamer is not replaced, it can be sold for $800 at the end of its useful life.
Gilbert is considering purchasing the Side Steamer 3000, a higher-end steamer, which costs $12,000, and has an estimated useful life of 6 years with an estimated salvage value of $1,200. This steamer falls into the MACRS 5-years class, so the applicable depreciation rates are 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, and 5.76%. The new steamer is faster and would allow for an output expansion, so sales would rise by $2,000 per year; even so, the new machine's much greater efficiency would reduce operating expenses by $1,500 per year. To support the greater sales, the new machine would require that inventories increase by $2,900, but accounts payable would simultaneously increase by $700. Gilbert's marginal federal-plus-state tax rate is 40%, and its WACC is 14%.
Should it replace the old steamer?
The old steamer _________shouldshould not be replaced.
What is the NPV of the project? Do not round intermediate calculations. Round your answer to the nearest dollar.
$
Should it replace the old steamer?
The old steamer be replaced.
What is the NPV of the project? Do not round intermediate calculations. Round your answer to the nearest dollar.
$
First determine the net cash flow at t = 0:
Purchase price | ($12,000) |
Sale of old machine | 4,150 |
Tax on sale of old machine | (230)a |
Change in net working capital | (2,200)b |
Total investment | ($10,280) |
aThe market value is $4,150 – $3,575 = $575 above the
book value. Thus, there is a $575 recapture of depreciation, and
Gilbert would have to pay 0.40($575) = $230 in taxes.
b The change in net working capital is a $2,900 increase
in current assets minus a $700 increase in current liabilities,
which totals to $2,200.
Now, examine the annual cash inflows:
Sales increase | $2,000 |
Cost decrease | 1,500 |
Increase in pre-tax revenues | $3,500 |
After-tax revenue increase:
$3,500(1 – T) = $3,500(0.60) = $2,100.
Depreciation:
Year | 1 | 2 | 3 | 4 | 5 | 6 |
New a | $2,400 | $3,840 | $2,304 | $1,382 | $1,382 | $691 |
Old | 650 | 650 | 650 | 650 | 650 | 325 |
Change | $1,750 | $3,190 | $1,654 | $732 | $732 | $366 |
Depreciation tax savings b | $700 | $1,276 | $662 | $293 | $293 | $146 |
a Depreciable basis = $12,000. Depreciation expense in
each year equals depreciable basis times the MACRS percentage
allowances of 0.2000, 0.3200, 0.1920, 0.1152, 0.1152, and 0.0576 in
Years 1-6, respectively.
b Depreciation tax savings = T(ΔDepreciation) =
0.4(ΔDepreciation).
Now recognize that at the end of Year 6 Gilbert would recover its
net working capital investment of $2,200, and it would also receive
$1,200 from the sale of the replacement machine. However, since the
machine would be fully depreciated, the firm must pay 0.40($1,200)
= $480 in taxes on the sale. Also, by undertaking the replacement
now, the firm forgoes the right to sell the old machine for $800 in
Year 6; thus, this $800 in Year 6 must be considered an opportunity
cost in that year. Taxes of $800(0.4) = $320 would be due because
the old machine would be fully depreciated in Year 6, so the
opportunity cost of the old machine would be $800 – $320 =
$480.
Finally, place all the cash flows on a time line:
0 | 1 | 2 | 3 | 4 | 5 | 6 |
14% | |||||||
Net investment | (10,280) | ||||||
After-tax revenue increase | 2,100 | 2,100 | 2,100 | 2,100 | 2,100 | 2,100 | |
Depreciation tax savings | 700 | 1,276 | 662 | 293 | 293 | 146 | |
Working capital recovery | 2,200 | ||||||
Salvage value of new machine | 1,200 | ||||||
Tax on salvage value of new machine | (480) | ||||||
Opportunity cost of old machine | (480) | ||||||
Project cash flows | (10,280) | 2,800 | 3,376 | 2,762 | 2,393 | 2,393 | 4,686 |
Note: While the calculations above show values rounded to the
nearest whole number, unrounded values should be used in all
calculations above.
The net present value of this incremental cash flow stream, when
discounted at 14%, is $1,433. Thus, the replacement should be
made.
Feedback
Check My Work
Reset Problem
Submit for Grading
Once you click "Submit Activity for Grading", you will not be able to attempt this activity again.
Current Score:
0/10 pts (0%)
Submit Activity for Grading
Show Hint
References
m
Back
Next
Scientific NotationPeriodic TableTables
In: Finance
You must evaluate a proposal to buy a new milling machine. The base price is $185,000, and shipping and installation costs would add another $7,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $83,250. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The machine would require a $4,000 increase in net operating working capital (increased inventory less increased accounts payable). There would be no effect on revenues, but pretax labor costs would decline by $51,000 per year. The marginal tax rate is 35%, and the WACC is 12%. Also, the firm spent $5,000 last year investigating the feasibility of using the machine.
a)How should the $5,000 spent last year be handled? (Choose from options 1-5)
1Last year's expenditure is considered as a sunk cost and does not represent an incremental cash flow. Hence, it should not be included in the analysis.
2The cost of research is an incremental cash flow and should be included in the analysis.
3Only the tax effect of the research expenses should be included in the analysis.
4Last year's expenditure should be treated as a terminal cash flow and dealt with at the end of the project's life. Hence, it should not be included in the initial investment outlay.
5Last year's expenditure is considered as an opportunity cost and does not represent an incremental cash flow. Hence, it should not be included in the analysis.
b)What is the initial investment outlay for the machine for capital budgeting purposes, that is, what is the Year 0 project cash flow? Round your answer to the nearest cent.
c)What are the project's annual cash flows during Years 1, 2, and 3? Round your answer to the nearest cent. Do not round your intermediate calculations.
Year 1 $
Year 2 $
Year 3 $
d)Should the machine be purchased?
In: Finance
The spot price of corn is $17.2 per bushel. Storage costs are $0.32 per bushel per year. Payment of storage costs occurs in advance for the next three months. Assuming that interest rates are 7% per annum, calculate the forward price of corn for delivery in 12 months.
Appreciate if you show me the calculation steps. Thank you!!
In: Finance
1. Seth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority, the company's geologist, has just finished his analysis of the mine site. He has estimated that the mine would be productive for eight years, after which the gold would be completely mined. Dan has taken an estimate of the gold deposits to Alma Garrett, the company's financial officer. Alma has been asked by Seth to perform an analysis of the new mine and present her recommendation on whether the company should open the new mine.
Alma has used the estimates provided by Dan to determine the revenues that could be expected from the mine. She has also projected the expense of opening the mine and the annual operating expenses. If the company opens the mine, it will cost $635 million today, and it will have a cash outflow of $45 million nine years from today in costs associated with closing the mine and reclaiming the area surrounding it. The expected cash flows each year from the mine are shown in the table. Bullock Mining has a 12 percent required return on all of its gold mines.
Year | Cashflow |
0 | -635,000,000 |
1 | 89,000,000 |
2 | 105,000,000 |
3 | 130,000,000 |
4 | 173,000,000 |
5 | 205,000,000 |
6 | 155,000,000 |
7 | 145,000,000 |
8 | 122,000,000 |
9 | -45,000,000 |
Questions:
1. Construct a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return, and the net present value of the proposed mine.
2. Based on your analysis, should the company open the mine?
3. Bonus question: Most spreadsheets does not have a built-in formula to calculate the payback period. Write a VBA script that calculates the payback period for a project.
Change the cash-flows as follows
Investment: 600,000,000
Year | Cashflow |
1 | 79,000,000 |
2 | 95,000,000 |
3 | 120,000,000 |
4 | 163,000,000 |
5 | 195,000,000 |
6 | 145,000,000 |
7 | 135,000,000 |
8 | 112,000,000 |
9 | -55,000,000 |
B. Answer the same question from problem 1
In: Finance
In: Finance
The Butler-Perkins Company (BPC) must decide between two mutually exclusive projects. Each costs $6,500 and has an expected life of 3 years. Annual project cash flows begin 1 year after the initial investment and are subject to the following probability distributions:
Project A | Project B | |||
Probability | Cash Flows | Probability | Cash Flows | |
0.2 | $6,250 | 0.2 | $0 | |
0.6 | $6,500 | 0.6 | $6,500 | |
0.2 | $6,750 | 0.2 | $18,000 |
BPC has decided to evaluate the riskier project at 11% and the less-risky project at 10%.
What is each project's expected annual cash flow? Round your answers to two decimal places.
Project A: $
Project B: $
Project B's standard deviation (σB) is $5,822.37 and its coefficient of variation (CVB) is 0.78. What are the values of (σA) and (CVA)? Round your answers to two decimal places.
σA = $
CVA =
Based on the risk-adjusted NPVs, which project should BPC choose?
_________Project AProject B
If you knew that Project B's cash flows were negatively correlated with the firm's other cash flow, but Project A's cash flows were positively correlated, how might this affect the decision?
_________This would make Project B more appealing.This would make Project B less appealing.
If Project B's cash flows were negatively correlated with gross domestic product (GDP), while A's cash flows were positively correlated, would that influence your risk assessment?
_________This would make Project B more appealing.This would make Project B less appealing.
What is each project's expected annual cash flow? Round your answers to two decimal places.
Project A. $
Project B. $
Project B's standard deviation (σB) is $5,822.37 and its coefficient of variation (CVB) is 0.78. What are the values of (σA) and (CVA)? Round your answers to two decimal places.
σA = $
CVA =
Based on the risk-adjusted NPVs, which project should BPC choose?
If you knew that Project B's cash flows were negatively correlated with the firm's other cash flow, but Project A's cash flows were positively correlated, how might this affect the decision?
If Project B's cash flows were negatively correlated with gross domestic product (GDP), while A's cash flows were positively correlated, would that influence your risk assessment?
In: Finance