Calculate the internal rate of return-net present value

Assignment Help Financial Management

Reference no: EM131989789

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): Kingston Corp. is considering a new machine that requires an initial investment of $520,000 installed, and has a useful life of 8 years. The expected annual after-tax cash flows for the machine are $76,000 during the first 3 years, $87,000 during years 4 through 6 and $92,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) 3% (b) 4% (c) 8% (d)9%

(iv) Using IRR and NPV criterion, comment if the project should be accepted or rejected at the following required rates of return: (a) 3% (b) 4% (c) 8% (d) 9% (v) Plot the Net Present Value profile (NPV on Y axis and rates of return on X-axis).

Reference no: EM131989789

Questions Cloud

What rate of return would she have earned for past year : If Janet sold the bond today for $1,086.29, what rate of return would she have earned for the past year?

Decide to open an individual retirement account : You decide to open an individual retirement account (IRA) at your local bank that pays 8 %/year compounded annually.

The time value of the call and put options : Calculate the intrinsic value and the time value of the call and put options (in US cents).

What is the value of this stock at the beginning of year : What is the value of this stock at the beginning of 2013 when the required return is 14.6 percent?

Calculate the internal rate of return-net present value : Calculate the Internal Rate of Return (IRR). Calculate the Net Present Value (NPV) at the following required rates of return: (a) 3% (b) 4% (c) 8% (d)9%

What is yield to maturity on this bond : What is the yield to maturity on this bond? If the yield to maturity on this bond increased to 5.20 % , what would the new price be?

Discuss the key features of arbitration and meditation : "Arbitration". Discuss the key features of arbitration and meditation, explain how they differ and provide an example of cases for which each is suited.

What is the cost of haroldson inc. new common stock : Flotation costs on new stock sales are 5% of the selling price. What is the cost of Haroldson Inc.'s new common stock?

What is the cost of new common stock : The stock sells for $48, and flotation expenses of 5% of the selling price will be incurred on new shares. What is the cost of new commonstock?

User Account

All Pages