This assignment supports the following objectives:
Calculate IRR, NPV and Payback Period
Analyze the cash flows generated by mutually exclusive projects
Formulate a recommendation using IRR, NPV and Payback Period as the criteria
Background
Suppose that your firm is considering the following two mutually exclusive projects. Both projects have the same initial cost of $312,500 and the resulting annual cash flows for the first five years are as shown in the table below:
Year |
Alpha |
Beta |
0 |
$ (312,500) |
$ (312,500) |
1 |
375,000 |
28,935 |
2 |
46,875 |
80,376 |
3 |
15,625 |
99,229 |
4 |
15,625 |
160,788 |
5 |
3,125 |
191,414 |
It is your job to analyze the feasibility of these two projects and to make recommendations as to which project should be undertaken. You must present a written report of your findings and your recommendations to middle managers, many of whom may be unfamiliar with some of your computations. You may choose to present the results of your calculations in table form. In your report, you must address each of the following:
Analyses:
a. Calculate the IRR of each project. Which project should be selected using IRR as the criterion?
b. In its analyses of projects of this type, your firm uses a 14.0 percent discount rate. Compute the NPV for each project using the 14.0 percent discount rate. Which project should be chosen based on this result?
c. In some cases, your firm uses the payback period to assess projects, with a cut-off point of 3 years. Calculate the payback period for each project and explain which project should be chosen using this criterion.
This assignment supports the following objectives: Calculate IRR, NPV and Payback Period Analyze the cash flows...
Suppose that your firm is considering the following two mutually exclusive projects. Both projects have the same initial cost of $312,500 and the resulting annual cash flows for the first five years are as shown in the table below: Year Alpha Beta 0 $ (312,500) $ (312,500) 1 375,000 28,935 2 46,875 80,376 3 15,625 99,229 4 15,625 160,788 5 3,125 191,414 It is your job to analyze the feasibility of these two projects and to make recommendations as to...
Calculating Payback Period and NPV Novell, Inc., has the following mutually exclusive projects. Year Project A Project B 0 −$15,000 −$19,000 1 10,400 12,700 2 5,900 6,100 3 2,100 5,300 a.Suppose the company’s payback period cutoff is two years. Which of these two projects should be chosen? b.Suppose the company uses the NPV rule to rank these two projects. Which project should be chosen if the appropriate discount rate is 15 percent?
10% DISCOUNT RATE 4. You Corp, is analyzing two mutually exclusive projects. The free cash flows associated with these projects are as follows. Year Cash Flows ܘ -50,000 ܝ ܟܬ Cash Flows -50,000 15,625 15,625 15,625 15,625 15,625 ܚ ܠܛ ܗ 100,000 A) What s each project's payback period? B) What is each project's NPV? C) What is each project's IRR? D) Which project should be accepted? Why? We were unable to transcribe this image
1. A. Which of the following mutually exclusive projects should be accepted? Project NPV Payback IRR A +42,176 2 years, +$10,500 16.4% B +39,090 2 years, +9,670 15.8% C +41,894 3 years, +16,620 13.2% D +43,778 3 years, +11,625 14.9% E +38,952 2 years, +15,475 15.9% B. What is the Payback Period of a project with an initial cost of $75,000, Year 1 cash flow of $20,000 which increases by 5% each year? If the Payback cutoff is 3 years,...
4. You Corp, is analyzing two mutually exclusive projects. The free cash flows associated with these projects are as follows. Year Cash Flows Cash Flows -50,000 -50,000 15,625 15,625 15,625 15,625 15,625 100,000 The required rate of return on these projects is 10% A) What s each project's payback period? B) What is each project's NPV? C) What is each project's IRR? D) Which project should be accepted? Why?
5. Find the NPV, IRR, MIRR and Payback for the following projects; use a WACC of 10%. Year Project A Project B 0 -$130,000 -$130,000 1 $60,000 $35,000 2 $40,000 $40,000 3 $40,000 $45,000 4 $25,000 $70,000 Project A Project B NPV IRR MIRR Payback Period If projects A & B are mutually exclusive, which would you recommend be accepted? ___________________
Calculate the payback period for each of the following mutually exclusive projects, then comment on the advisability of selection based on the payback period criterion and compare the selecting suggestion with the NPV method: Project A has a cost of $15,000, returns $4,000 after-tax the first year with this amount increasing by $1,000 annually over a 5-year life; Project B costs $15,000 and returns $13,000 after-tax the first year, followed by 4 years of $2,000 per year. The firm uses...
Calculating Payback Perlod and NPV Tri Star, Inc., has the following mutually exclusive projects. YEAR PROJECT AT PROJECT B -$15,300 w No 8,700 -$10,700 5,300 4,300 4,800 7,400 3,100 a. Suppose the company's payback period cutoff is two years. Which of these two projects should be chosen? b. Suppose the company uses the NPV rule to rank these two projects. Which project should be chosen if the appropriate discount rate is 15 percent?
(Discounted payback period) Gio's Restaurants is considering a project with the following expected cash flows: Year Project Cash Flow (millions) $(210) AWNO If the project's appropriate discount rate is 11 percent, what is the project's discounted payback period? The project's discounted payback period is years. (Round to two decimal places.) (Mutually exclusive projects and NPV) You have been assigned the task of evaluating two mutually exclusive projects with the following projected cash flows: Project A Project B Year Cash Flow...
8.11 NPV versus IRR Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual return of 14 percent. Main Page Year Deepwater Fishing New Submarine Ride Incremental (Ride-Fishing) 0 $(850,000.00) $(1,650,000.00) $(800,000.00) 1 $320,000.00 $810,000.00 $490,000.00 2 $470,000.00 $750,000.00 $280,000.00 3 $410,000.00 $690,000.00 $280,000.00 Discount Rate IRR NPV As a financial analyst for BRC, you are asked the following questions: a. If your decision rule is to accept the...