Calculate the internal rate of return

Assignment Help Corporate Finance
Reference no: EM132425332

You are required to use a financial calculator or spreadsheet (Excel) to solve the following capital budgeting problem (sample questions and solutions are provided for guidance): Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed, and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years.

(i) Develop the timeline (linear representation of the timing of cash flows)

(ii) Calculate the Internal Rate of Return (IRR)

(iii) Calculate the Net Present Value (NPV) at the following required rates of return:

  • (a) 9%
  •  (b) 10%
  •  (c) 11%
  • (d) 12%

(iv) Using IRR and NPV criterion, comment if the project should be accepted or rejected at the following required rates of return:

  • (a) 9%
  • (b) 10%
  • (c) 11%
  • (d) 12%

(v) Plot the Net Present Value profile (NPV on Y axis and rates of return on X-axis).

Reference no: EM132425332

Questions Cloud

Perspectives on adjudication and sentencing of young people : Discuss the various perspectives on adjudication and sentencing of young people who are involved in serious offenses.
Discuss about agile method : Explain why we need a 3-way handshake in TCP? Why not just 2-way and Discuss two advantages and two disadvantages of agile methods
Dialogue between you and an imaginary socrates : For this paper, you will write a dialogue between you and an imaginary Socrates. You will debate the question of free will versus determinism.
Identify the primary purpose of the plan : Identify the primary purpose of this plan. How did you decide? Based on principles of good planning, suggest three ways to edit the plan to improve it.
Calculate the internal rate of return : Calculate the Internal Rate of Return.) Calculate the Net Present Value (NPV). Plot the Net Present Value profile (NPV on Y axis and rates of return on X-axis)
Elements of asian religious culture : Select three aspects or elements of Asian religious culture that appealed to American religious innovators or American culture at large.
Prepare a strategic map of firms : Case Study - LEICA CAMERA: A "Boutique" Firm Faces A World Of Change. Prepare strategic map of these firms according to two or three dimensions of your choosig
What must a needs analysis do : Q1: What must a needs analysis do? Q2: What three areas should be the focus of a needs analysis?
Explain why you selected the topic : Choose thematic topic for a group of 3-year-old children. In a two-page response, explain why you selected the topic, and discuss how it is age-appropriate.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Describe why limited leverage is good for business

Explain why limited leverage is good for business. Show the profitability of the project so that Stephanie can convince her father to purchase the truck by borrowing money.

  Make a rough sketch of a spreadsheet model

The Pine Furniture Corporation makes fine country furniture. The firm's current product lines consist of coffee tables, end tables, & dining room tables.

  Calculate the total value of all shares

Calculate the total value of all shares outstanding currently and what fraction of the total value outstanding does each stock make up?

  Discuss the role of investing in personal financial planning

Discuss the overall role of investing in personal financial planning. Discuss three attributes of three different stocks that would be a good choice for Sam's financial profile based on your Internet research.

  If a company does not do better than its competitors

If a company does not do better than its competitors but the stock market goes up, executives do very well from their stock options. This makes no sense.'' Discuss this viewpoint.

  Stephenson real estate recapitalization stephenson real

stephenson real estate recapitalization stephenson real estate company was founded 25 years ago by the current ceo

  Determine the price of the option if it is american

Determine the price of the option if it is European. - Determine the price of the option if it is American. (use Binomial: American with 100 tree steps).

  What is the net advantage or disadvantage to the company

The Tingey Company has 500 obsolete microcomputers that are carried in inventory at a total cost of $720,000. If these microcomputers are upgraded at a total cost of $100,000, they can be sold for a total of $160,000.

  Calculate the weighted average cost of capital

Calculate the Weighted Average Cost of Capital (WACC). Calculate the NPV (Net Present Value) of the project, using the WACC calculated in (b) above as the discount rate.

  What will her principal outstanding balance be at that time

How much will Emily need to pay per month if she borrows the $300,000 needed to buy the house assuming a 20 year mortgage at the floating rate and How much will her monthly instalments be if she opted for the fixed term rate instead?

  What total price will webster ask for the entire order

The company uses cost-based pricing and adds 20% markup to total costs. What total price will Webster ask for the entire order?

  Analysis on whether to go for investment in fixed assets or

analysis on whether to go for investment in fixed assets or borrow funds.1. if a company in making money from

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