Expansion capital budgeting problem

Assignment Help Finance Basics
Reference no: EM13855028

Consider the following expansion capital budgeting problem.

A capital budgeting decision is being considered that would involve an expansion and simultaneous replacement of old equipment. The project is expected to have a 6 year life for the firm.

This project will replace some existing equipment which currently has a book value (BV) of $200k and an estimated market salvage value of $375k. The new project will require new equipment costing $2000k, which will be depreciated straight-line to a book value of $200k at the end of 6 years. Due to new energy efficient technology, replacing the old equipment with the new more efficient equipment will generate an immediate tax credit of 5% of the equipment's cost. The expansion will require an additional investment in NWC of $200k.

Sales are expected to increase by $1000k the first year and grow by 15% in years 2 and 3, then by 5% annually during the remaining 6 year life. Cost of goods sold is forecasted to be 45% of the increased sales, and other selling and general administrative expenses are forecasted to be 10% of the increased sales.

It is forecasted that the new equipment will have a salvage value of $300k at the end of the project's 6 year life.

The firm's weighted average cost of capital (WACC) for projects of this risk level is 8%. The firm's marginal tax rate is T = 40%.

Use the Excel template to complete the capital budgeting analysis. Your Excel analysis should clearly indicate the cash flow analysis timeline and should provide the project's NPV, IRR, PBP, PI, and also illustrate the project's NPV Profile.

Reference no: EM13855028

Questions Cloud

Provide a description and component of information system : Provide a description and the major components of the information system. This should be facilitated by using models of the information system.
A microscope objective lens has a focal length : A microscope objective lens has a focal length of 10mm. How close should the object be to the objective lens so that the image is formed in the microscope tube 160mm from the objective lens. FYI the answer is 10.67 mm
How was gender idendtification explicitly stated : Submit 2-4 page paper in which you refect on your childhood and indentify a time when you behaved in a way that was inconsistent with society's views or expections of gender. How was gender idendtification explicitly, or implicity, stated
A beam of green light wavelength : A beam of green light wavelength of 4000 A passed through a grating of 3000 lines / cm. Determine the maximum diffraction what level that can still be seen clearly?
Expansion capital budgeting problem : Consider the following expansion capital budgeting problem. A capital budgeting decision is being considered that would involve an expansion and simultaneous replacement of old equipment. The project is expected to have a 6 year life for the firm..
Analysis for the financial situation : Make a strengths and weaknesses portion S-W-O-T analysis for the financial situation of this organization. 2 sources must be used cited properly in APA format with references page.
Determine the tension experienced by the spring : An elastic spring which has a cross-sectional area of 100m2. If the spring is pulled with a force of 150 Newton. Determine the tension experienced by the spring!
Describe ethnocentric challenges that may arise : At least three topics that you would like to better understand before beginning the project. Describe ethnocentric challenges that may arise when planning the project. Discuss the types of questions the researcher should ask
Compound interest pays interest for each time period : What is the residual income for a firm with $1 million in total capital, $300,000 in net income, and a 20% cost of capital - What is the residual income for a firm with $1 million in total capital, $300,000 in net income, and a 20% cost of capital?

Reviews

Write a Review

Finance Basics Questions & Answers

  Calculate the net present value payback profitability

Using a 4.5% discount rate, calculate the Net Present Value, Payback, Profitability Index, and IRR for each of the investment projects below (note, the inflows are for each year). Based on your calculations rank the projects and support you answer

  The underlying goal of commercial bank management is to

the underlying goal of commercial bank management is to maximize the wealth of the banks shareholders which implies

  Numerous definitions of insurance

There are numerous definitions of insurance. Based on the definition of insurance stated in the text, indicate whether each of the following guarantees is considered insurance.

  Define what is the default risk premium on corporate bond

The yield on a certain 20 year corporate bond is 14%. the yield on 90 day treasury bills is 8% while 20 year treasury securities are yielding 12%. what is the default risk premium on the corporate bond? you must show all your work used to solve pr..

  I horicon uses the equity method to account for its

assume that horicon corp. acquired 25 of the common stock of sheboygan corp. on january 1 2012 for 300000. during 2012

  How would you go about it to find out if market value is dir

How would you go about it to find out if market value is directly related to the dividends that are paid out via the firm?

  The current price of a stock is 32 and the annual

the current price of a stock is 32 and the annual risk-free rate is 3. a call option with a strike price of 30 and 1

  Use the technical forecasting technique

As a financial analyst, you are asked to advise a MNC about its one-year investment plan next year in Germany. Because the investment is denominated in euros, you are asked to forecast how the euro's value may change against the U.S. dollar ove..

  Find the required return on equity

Other information: risk free rate = 4.0%, the market risk premium = 6.5%, tax rate = 40.0%. Using the average of the CAPM and DCF estimates, find the required return on equity.

  Amortization schedules- straight line and effective interest

Spencer Company sells 10 percent bonds having a maturity value of $300,000,000 for $2,783,724. The bonds are dated January 1, 2012, and mature January 1, 2017.

  Days sales in receivables a company has net income of

days sales in receivables a company has net income of 195000 a profit margin of 9.40 percent and an accounts receivable

  Additional profits after tax will amount to 18000 per year

you are a small business owner and you have the opportunity to expand your facility which will increase your

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd