Questions
8. Analysis of a replacement project Dismiss All Please Wait . . . Please Wait... At...

8. Analysis of a replacement project

Dismiss All

Please Wait . . .

Please Wait...

At times firms will need to decide if they want to continue to use their current equipment or replace the equipment with newer equipment.

The company will need to do replacement analysis to determine which option is the best financial decision for the company.

Price Co. is considering replacing an existing piece of equipment. The project involves the following:

The new equipment will have a cost of $1,200,000, and it will be depreciated on a straight-line basis over a period of six years (years 1–6).
The old machine is also being depreciated on a straight-line basis. It has a book value of $200,000 (at year 0) and four more years of depreciation left ($50,000 per year).
The new equipment will have a salvage value of $0 at the end of the project's life (year 6). The old machine has a current salvage value (at year 0) of $300,000.
Replacing the old machine will require an investment in net working capital (NWC) of $20,000 that will be recovered at the end of the project's life (year 6).
The new machine is more efficient, so the firm’s incremental earnings before interest and taxes (EBIT) will increase by a total of $700,000 in each of the next six years (years 1–6). Hint: This value represents the difference between the revenues and operating costs (including depreciation expense) generated using the new equipment and that earned using the old equipment.
The project's cost of capital is 13%.
The company's annual tax rate is 35%.

Complete the following table and compute the incremental cash flows associated with the replacement of the old equipment with the new equipment.

Year 0

Year 1

Year 2

Year 3

Year 4

Year 5

Year 6

Initial investment selector 1   
  • $1,200,000
  • $52,500
  • $525,000
  • $507,500
EBIT selector 2   
  • $700,000
  • $245,000
  • $52,500
  • $100,000
selector 3   
  • $1,200,000
  • $245,000
  • $700,000
  • $52,500
selector 4   
  • $700,000
  • $400,000
  • $245,000
  • $52,500
selector 5   
  • $700,000
  • $500,000
  • $245,000
  • $52,500
selector 6   
  • $700,000
  • $52,500
  • $150,000
  • $245,000
selector 7   
  • $52,500
  • $245,000
  • $700,000
  • $150,000
– Taxes selector 8   
  • $245,000
  • –$20,000
  • $35,000
  • $700,000
selector 9   
  • –$20,000
  • $700,000
  • $35,000
  • $245,000
selector 10   
  • $35,000
  • –$20,000
  • $1,200,000
  • $245,000
selector 11   
  • $245,000
  • $700,000
  • –$20,000
  • $35,000
selector 12   
  • $245,000
  • $1,200,000
  • $35,000
  • –$20,000
selector 13   
  • $35,000
  • $245,000
  • –$20,000
  • $1,200,000
+ Δ Depreciation × T selector 14   
  • $52,500
  • 35,000
  • 245,000
  • –20000
  • -$955,000
selector 15   
  • 525,000
  • 35,000
  • 245,000
  • –20000
  • $52,500
selector 16   
  • –20000
  • 245,000
  • 35,000
  • 507,500
  • $52,500
selector 17   
  • 52,500
  • 35,000
  • 525,000
  • 245,000
  • –20000
selector 18   
  • 245,000
  • 70,000
  • –20000
  • 545,000
  • 35,000
selector 19   
  • –20000
  • -$955,000
  • 245,000
  • 35,000
  • 70,000
+ Salvage value selector 20   
  • $1,200,000
  • $700,000
  • $245,000
  • $300,000
– Tax on salvage selector 21   
  • $300,000
  • $245,000
  • $52,500
  • $35,000
– NWC selector 22   
  • $20,000
  • $-$955,000
  • $525,000
  • $300,000
+ Recapture of NWC selector 23   
  • $20,000
  • $35,000
  • -$955,000
  • $525,000
Total free cash flow selector 24   
  • -$955,000
  • $245,000
  • $700,000
  • $52,500
selector 25   
  • $507,500
  • -$700,000
  • $245,000
  • $52,500
selector 26   
  • $52,500
  • $507,500
  • -$700,000
  • $245,000
selector 27   
  • $507,500
  • $245,000
  • $52,500
  • $700,000
selector 28   
  • $245,000
  • -$700,000
  • $507,500
  • $52,500
selector 29   
  • $245,000
  • -$700,000
  • $525,000
  • $52,500
selector 30   
  • $245,000
  • $700,000
  • $545,000
  • $52,500

Points:

The net present value (NPV) of this replacement project is:

$1,321,520

$1,266,457

$1,101,267

$936,077

In: Finance

The Casper Ice Cream Company is an ice cream manufacturer in Richmond, Utah famous for making...

The Casper Ice Cream Company is an ice cream manufacturer in Richmond, Utah famous for making Fat Boy Ice Cream Sandwiches. The owner, Mr. Casper, the grandson of the founder, is considering replacing an existing ice cream maker and batch freezer with a new maker which has a greater output capacity and operates with less labor. His only alternative is to overhaul his ice cream maker and batch freezer which have a current net book value of $6,000 and three years of remaining depreciable life (straight line). The equipment would cost $10,000 to overhaul but this would increase its useful life for 10 years which is also the life of the new machinery. Mr. Casper’s accountant tells him the new net book value of the overhauled equipment could be depreciated straight line over four years. The old machinery has zero salvage value currently.

The new maker and freezer would cost $50,000 including installation. It would be fully depreciated over 10 years and would have $3,000 salvage at the end of that period. Because of automatic features, the new equipment would allow labor saving of $9,000 per year.

Even though the new equipment has increase capacity, Mr. Casper does not feel any extra product could be sold until year five. At that time, he estimates that additional sales would result in additional net cash revenues before tax of $5,000 per year for the remaining life of the machine. By the end of year four, however, working capital would have to be increased by $3,000 to support the higher sales. This increase in working capital will be recovered at the end of the project, which will last for 10 years.   

Casper Company is currently in the 30% tax bracket. Mr. Casper demands a rate of return of 16%.   

Complete a NPV and IRR analysis on the project.

In: Finance

Stock quotes Smith Enterprises recently was profiled on a financial information website and touted as a...

Stock quotes

Smith Enterprises recently was profiled on a financial information website and touted as a "hot" growth stock. You acquired the stock quote shown here from that website.

Smith Enterprises (NYSE: SME)

Last Trade: 51.63 Day’s Range: 47.22 – 51.96
Trade Time: 4:00 PM ET 52wk Range: 25.48 – 60.71
One-Day Stock Return: 11.58% Volume: 1,419,317
Prev. Close: 46.27 Avg. Vol. (3m): 1,921,518
Open: 47.25 Market Cap: 1.63B
Bid: N/A P/E (ttm): 25.43
Ask: N/A EPS (ttm):
1y Target Est: 55.40 Div. & Yield: 0.20 (0.40%)

The last trade time is shown to be at 4:00 PM Eastern Time. The abbreviation “ttm” stands for “trailing twelve months,” and the number shown reflects data from the previous 12 months. The abbreviation “3m” reflects data from the previous 3 months.

What exchange does Smith Enterprises trade on?

NYSE

FTSE

NASDAQ

AMEX

SME

What is Smith’s earnings per share (EPS) for the trailing 12 months?

$1.97

$2.24

$1.75

$2.03

$1.67

How much did the price increase today over yesterday’s closing price?

$5.22

$5.29

$5.08

$5.15

$5.36

How heavy was the trading of Smith’s stock today relative to the normal level of trading?

Relatively light trading

Average trading

Relatively heavy trading

In: Finance

Calculate the annualized cost of the trade credit terms of 3​/15 net 75 when payment is...

Calculate the annualized cost of the trade credit terms of 3​/15 net 75 when payment is made on the net due date​ (assume a​ 365-day year).

The annualized cost of the trade credit terms is ___% (round to 2 decimal places)

In: Finance

This case continues following the new project of the WePPROMOTE Company, that you and your partner...

This case continues following the new project of the WePPROMOTE Company, that you and your partner own. WePROMOTE is in the promotional materials business. The project being considered is to manufacture a unique case for smartphones. The case is very durable, attractive and fits virtually all models of smartphone. It will also have the logo of your client, a prominent, local company and is planned to be given away at public relations events by your client.

As we know from prior cases involving this company, more and more details of the project become apparent and with more precision and certainty.

The following are the final values to the data that you have been estimating up to this point:

- You can borrow funds from your bank at 3%.

- The cost to install the needed equipment will be $105,000 and this cost is incurred prior to any cash is received by the project.

- The gross revenues from the project will be $25,000 for year 1, then $27,000 for years 2 and 3. Year 4 will be $28,000 and year 5 (the last year of the project) will be $23,000.

- The expected annual cash outflows (current project costs) are estimated at being $13,000 for the first year, then $12,000 for years 2, 3, and 4. The final year costs will be $10,000.

- Your tax rate is 30% and you plan to depreciate the equipment on a straight-line basis for the life of the equipment.

- After 5 years the equipment will stop working and will have a residual (salvage) value of $5,000).

- The discount rate you are assuming is now 7%.

The Tasks:

1. Perform the final NPV calculations and provide a narrative of how you calculated the computations and why.

2. Then provide a summary conclusion on whether you should continue to pursue this business opportunity.

In: Finance

At $73 , a firm can sell 4,525 stereo earphones (3.5 mm for android). At this...

At $73 , a firm can sell 4,525 stereo earphones (3.5 mm for android). At this price, elasticity is estimated at 2.4. What is the change in total revenue (+ or -) if the firm drops price by 10%? Round your answer to the nearest dollar.

In: Finance

A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be...

A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: (PLEASE ANSWER FULL QUESTIONS)

0 1 2 3 4 5 6 7
Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180
Project B -$400 $131 $131 $131 $131 $131 $131 $0
  1. What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations.

    Project A: $  

    Project B: $  

  2. What is each project's IRR? Round your answer to two decimal places.

    Project A: %

    Project B: %

  3. What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Round your answer to two decimal places. Do not round your intermediate calculations.

    Project A: %

    Project B: %

  4. From your answers to parts a-c, which project would be selected?

    _________Project AProject B

    If the WACC was 18%, which project would be selected?

    _________Project AProject B


  5. Construct NPV profiles for Projects A and B. Round your answers to the nearest cent. Do not round your intermediate calculations. Negative value should be indicated by a minus sign.

    Discount Rate NPV Project A NPV Project B
    0% $   $  
    5 $   $  
    10 $   $  
    12 $   $  
    15 $   $  
    18.1 $   $  
    23.54 $   $  
  6. Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places. Do not round your intermediate calculations.

    %

  7. What is each project's MIRR at a WACC of 18%? Round your answer to two decimal places. Do not round your intermediate calculations.

    Project A: %

    Project B: %

    In: Finance

    Suppose Capital One is advertising a 6060​-month, 5.25 %5.25% APR motorcycle loan. If you need to...

    Suppose Capital One is advertising a

    6060​-month,

    5.25 %5.25%

    APR motorcycle loan. If you need to borrow

    $ 8 comma 700$8,700

    to purchase your dream​ Harley-Davidson, what will be your monthly​ payment?​ (Note: Be careful not to round any intermediate steps less than six decimal​ places.)

    In: Finance

    NPV AND IRR A store has 5 years remaining on its lease in a mall. Rent...

    NPV AND IRR

    A store has 5 years remaining on its lease in a mall. Rent is $2,100 per month, 60 payments remain, and the next payment is due in 1 month. The mall's owner plans to sell the property in a year and wants rent at that time to be high so that the property will appear more valuable. Therefore, the store has been offered a "great deal" (owner's words) on a new 5-year lease. The new lease calls for no rent for 9 months, then payments of $2,500 per month for the next 51 months. The lease cannot be broken, and the store's WACC is 12% (or 1% per month).

    1. Should the new lease be accepted? (Hint: Be sure to use 1% per month.)

      -Select-Yes or No
    2. If the store owner decided to bargain with the mall's owner over the new lease payment, what new lease payment would make the store owner indifferent between the new and old leases? (Hint: Find FV of the old lease's original cost at t = 9; then treat this as the PV of a 51-period annuity whose payments represent the rent during months 10 to 60.) Round your answer to the nearest cent. Do not round your intermediate calculations. $
    3. The store owner is not sure of the 12% WACC—it could be higher or lower. At what nominal WACC would the store owner be indifferent between the two leases? (Hint: Calculate the differences between the two payment streams; then find its IRR.) Round your answer to two decimal places. Do not round your intermediate calculations.

      %

    In: Finance

    Describe the concept of variance analysis. Explain the importance of variance analysis. Provide specific examples of...

    Describe the concept of variance analysis. Explain the importance of variance analysis. Provide specific examples of how variance analysis is beneficial to the organization.

    In: Finance

    Paymaster Enterprises has arranged to finance its seasonal​ working-capital needs with a​ short-term bank loan. The...

    Paymaster Enterprises has arranged to finance its seasonal​ working-capital needs with a​ short-term bank loan. The loan will carry a rate of

    14 percent per annum with interest paid in advance​ (discounted). In​ addition, Paymaster must maintain a minimum demand deposit with the bank of 11 percent of the loan balance throughout the term of the loan. If Paymaster plans to borrow $120,000 for a period of 6 ​months, what is the annualized cost of the bank​ loan?

    The annualized cost of the bank loan is ______%.

    ​(Round to two decimal​ places.)

    In: Finance

    Consider the following financial information pertaining to a firm in a particular year: Rev 1,000 COGS...

    Consider the following financial information pertaining to a firm in a particular year:

    Rev

    1,000

    COGS

    400

    R&D

    50

    SGA (excl. Depr)

    100

    Depreciation

    60

    Interest Exp

    20

    Taxes

    110

    Dividends

    130

    Change in Inventory

    -25

    Change in Acct. Pay.

    15

    Change in Acct. Rec.

    30

    Change in Cash/Secu.

    0

    Plant & Equip (new)

    225

    Shares Issued

    N/A

    Change in Debt

    N/A

    1. Using this information, please calculate and report the following items:

    Gross Profit

    EBIT

    NI

    Operating CF

    Investing CF

    Free CF

    1. Also, using only one sentence, remark on additional financing requirements (if any).

    Answer

    In: Finance

    Explain how the KMV model predicts bankruptcy probability?

    Explain how the KMV model predicts bankruptcy probability?

    In: Finance

    Chiptech, Inc., is an established computer chip firm with several profitable existing products as well as...

    Chiptech, Inc., is an established computer chip firm with several profitable existing products as well as some promising new products in development. The company earned $1 per share last year and just paid out a dividend of $.50 per share. Investors believe the company plans to maintain its dividend payout ratio at 50%. ROE equals 20%. Everyone in the market expects this situation to persist indefinitely.


    a.

    What is the market price of Chiptech stock? The required return for the computer chip industry is 15%, and the company has just gone ex-dividend (i.e., the next dividend will be paid a year from now, at t = 1). (Round your answer to 2 decimal places.)


      Market price $


    b.

    Suppose you discover that Chiptech’s competitor has developed a new chip that will eliminate Chiptech’s current technological advantage in this market. This new product, which will be ready to come to the market in two years, will force Chiptech to reduce the prices of its chips to remain competitive. This will decrease ROE to 15%, and, because of falling demand for its product, Chiptech will decrease the plowback ratio to .40. The plowback ratio will be decreased at the end of the second year, at t = 2: The annual year-end dividend for the second year (paid at t = 2) will be 60% of that year’s earnings. What is your estimate of Chiptech’s intrinsic value per share? (Hint: Carefully prepare a table of Chiptech’s earnings and dividends for each of the next three years. Pay close attention to the change in the payout ratio in t = 2.) (Round your answer to 2 decimal places.)


      Book value per share $


    No one else in the market perceives the threat to Chiptech’s market. In fact, you are confident that no one else will become aware of the change in Chiptech’s competitive status until the competitor firm publicly announces its discovery near the end of year 2. (Hint: Pay attention to when the market catches on to the new situation. A table of dividends and market prices over time might help.)


    c-1.

    What will be the rate of return on Chiptech stock in the coming year (i.e., between t = 0 and t = 1)? (Do not round intermediate calculations. Round your answer to 2 decimal places.)


      Rate of return %  


    c-2.

    What will be the rate of return on Chiptech stock in the second year (i.e., between t = 1 and t = 2)? (Negative value should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to 2 decimal places.)


      Rate of return %  


    c-3.

    What will be the rate of return on Chiptech stock in the third year (i.e., between t = 2 and t = 3)? (Do not round intermediate calculations. Round your answer to 2 decimal places.)


      Rate of return %  

    In: Finance

    With alternative choice decisions, managers seek to choose the alternative most likely to accomplish the objectives...

    With alternative choice decisions, managers seek to choose the alternative most likely to accomplish the objectives of the organization. In addition to ROI, discuss other business objectives that may be important in the choice of the best alternative.

    should be at 200-300 words, formatted and cited in current APA style with support from at least 2 academic sources.

    In: Finance