Questions
ABC paid a dividend of $3.00 this past year. The dividends are expected to grow at...

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...

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)...

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.

  1. What is the project's cash flow for the first year (t = 1)? Round your answer to the nearest dollar.
    $_____?

  2. If this project would cannibalize other projects by $1.5 million of cash flow before taxes per year, how would this change your answer to part a? Round your answer to the nearest dollar.
    The firm's project's cash flow would now be $______? .

  3. Ignore part b. If the tax rate dropped to 30%, how would that change your answer to part a? Round your answer to the nearest dollar.
    The firm's project's cash flow would -INCREASE OR DECREASE??  by $______? .

In: Finance

1. (Pmt, FV=? ) what is the future value of an annuity of $9 invested every...

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...

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...

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

Broussard Skateboard's sales are expected to increase by 20% from $8.6 million in 2016 to $10.32...

Broussard Skateboard's sales are expected to increase by 20% from $8.6 million in 2016 to $10.32 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 $450000 of accounts payable $500000 of notes payable and $450000 of accruals. The after tax profit margin is forecasted to be 7% and the forecasted payout is 70%. Use the AFN equation to forecast Broussard's additional funds needed for the coming year.

In: Finance

Blossom Corp. management is investigating two computer systems. The Alpha 8300 costs $2,991,425 and will generate...

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...

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...

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,...

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...

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...

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

Tim Smith is shopping for a used luxury car. He has found one priced at $30,000....

Tim Smith is shopping for a used luxury car. He has found one priced at $30,000. The dealer has told Tim that if he can come up with a down payment of 5,000​, the dealer will finance the balance of the price at a 6% annual rate over
3years (36 months). 
a.  Assuming that Tim accepts the​ dealer's offer, what will his monthly​ (end-of-month) payment amount​ be?
b.  Use a financial calculator or spreadsheet to help you figure out what​ Tim's monthly
payment would be if the dealer were willing to finance the balance of the car price at an annual rate of 4.0​%?
a. ​ Tim's monthly​ (end-of-month) payment amount is_______
​(Round to the nearest​ cent.)
b. ​ Tim's monthly payment, if the dealer were willing to finance the balance of the car price at an annual rate of 4.0%​, would be ________(Round to the nearest​ cent)

In: Finance

The Butler-Perkins Company (BPC) must decide between two mutually exclusive projects. Each costs $6,500 and has...

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%.

  1. 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 =

  2. Based on the risk-adjusted NPVs, which project should BPC choose?

    _________Project AProject B

  3. 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.

  1. 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 =

  2. Based on the risk-adjusted NPVs, which project should BPC choose?

  3. 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