Calculate the internal rate of return

Assignment Help Financial Management

Reference no: EM132031027

Instructions: 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: EM132031027

Questions Cloud

Characters and the setting from descriptions : What information can you glean about the characters and the setting from these descriptions?

What are budgeted purchases in units for december : Budgeted sales for December are 3,909 units. The November 30 inventory was 1,919 units. What are Budgeted purchases in units for December

Would the study involve measurement over time : Would you recommend a pre-experimental, experimental, or quasi-experimental design? Would the study involve measurement over time?

Search committee attitude : What implications might your answer have on the search committee's attitude toward you? (consider both the positive and negative answer

Calculate the internal rate of return : Develop the timeline. Calculate the Internal Rate of Return (IRR)

What were the most important rules in your family : When you were growing up, what were the three or four most important rules in your family? Do you think these rules were rational and fair? Why or why not?

Calculate GSs payoff from its raw materials : Calculate GS’s payoff from its raw materials, its long position in Nikkei put warrants

What new problems might be created in given case : Which people and what institutions might be most seriously harmed by a technological solution? What new problems might be created because we have solved.

What is the property worth to you today : Your required rate of return is 14%. What is the property worth to you today?

User Account

All Pages