Question

In: Finance

Scenario Information: Assume that two gas stations are for sale with the following cash flows: CF1...

Scenario Information:

Assume that two gas stations are for sale with the following cash flows: CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the timeline and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your decision. The methods are presented and the decision each indicates is given below.

Investment Sales Price CF1 CF2
Gas Station A $50,000 $0 $100,000
Gas Station B $50,000 $50,000 $25,000

Three (3) Capital Budgeting Methods are presented:

Payback Period: Gas Station A is paid back in 2 years: CF1 in year 1, and CF2 in year 2. Gas Station B is paid back in one (1) year. According to the payback period, when given the choice between two mutually exclusive projects, the investment paid back in the shortest time is selected.

Net Present Value: Consider the gas station example above under the NPV method, and a discount rate of 10%:

NPV gas station A = $100,000/(1+.10)2 - $50,000 = $32,644

NPV gas station B = $50,000/(1+.10) + $25,000/(1+.10)2 - $50,000 = $16,115

Internal Rate of Return: Assuming 10% is the cost of funds. The IRR for Station A is 41.421%.; for Station B, 36.602.

Summary of the Three (3) Methods:

Gas Station B should be selected, as the investment is returned in 1 period rather than 2 periods required for Gas Station A.

Under the NPV criteria, however, the decision favors gas station A, as it has the higher net present value. NPV is a measure of the value of the investment.

The IRR method favors Gas Station A, as it has a higher return, exceeding the cost of funds (10%) by the highest return.

Solutions

Expert Solution

On the basis of three methods (payback period, NPV and IRR) we will select Gas Station A.

As we see in the question that NPV and IRR of Gas Station A is higher in compare to Gas Station B. Thus we should make investment in Gas Station A. Although it is also given that payback period of Gas station A is more than Gas station B that means investment of Gas station A will be recovered in more time in compare to Gas station B, but due to NPV and IRR analysis investment in Gas station A will be profitable because due to higher payback period Gas Station A will generate higher net return in long-term hence investment in Gas station A will be good option.

As we know that while we calculate NPV then we need to calculate return discounted with discounting factor hence decision made on the basis of NPV and IRR will be better option between two mutual project.

Thus as a result, we can say that investment in gas station A will be better option.


Related Solutions

There is a project with the following cash flows: CF0 = -850; CF1 = 300; CF2...
There is a project with the following cash flows: CF0 = -850; CF1 = 300; CF2 =320; CF3 = 340; CF4 = 360. If the appropriate discount rate is 10%, what is the project's MIRR? (Assume the same reinvestment rate) 14.08% 15.65% 17.21% 18.29% 19.15%
Consider the following two cash flows: CF1: 100 at t=0, 200 at t=2, and 300 at...
Consider the following two cash flows: CF1: 100 at t=0, 200 at t=2, and 300 at t=3 CF2: X at t=1, X at t=2, and 2X at t=4 The interest rate rises by 3% every year, so: between t=0 and t=1: i=0%; between t=1 and t=2: i=3%; between t=2 and t=3: i=6%, etc. What the value of X that makes the two cash flows equivalent? Question 3 options: 86-106 106-126 126-146 146-166 None of the above
An investment project has the following cash flows: CF0 = -1,000,000; CF1 – CF8 = 200,000...
An investment project has the following cash flows: CF0 = -1,000,000; CF1 – CF8 = 200,000 each. If the required rate of return is 12%: a.       What decision should be made using NPV? (5%) b.      How would the IRR decision rule be used for this project? What decision would be reached? (10%)              c.       How are the above two decisions related? (10%)
a. Find present value of the following cash flows at 3% rate: CF0 = -1000; CF1...
a. Find present value of the following cash flows at 3% rate: CF0 = -1000; CF1 = 300; CF2 = 560; CF3 = -90; CF4 = 250. b. What is the future value of these cash flows?
Calculate the IRR(s) for a 10-year project with the following cash flows: CF0 = -30, CF1...
Calculate the IRR(s) for a 10-year project with the following cash flows: CF0 = -30, CF1 = 10 = CF2 = CF3 = CF4 = CF5 = CF6 = CF7 = CF8 = CF9, and CF10 = -65. In Excel, plot the NPV against r (= discount rate), using r = 0%, 2%, 4%, 6%, 8%, 10%, 12%, 14%, 16%, 18%, 20%, 22%, 24%, 26%, 28%, and so on until you find all IRRs on the horizontal axis. Approximately, what...
A potential CB project has the following cash flows: CF0 = -$500, CF1 = $300, CF2...
A potential CB project has the following cash flows: CF0 = -$500, CF1 = $300, CF2 = $200, CF3 = $150. WACC = 6%. Compute the following: A. Payback Period B. NPV C. IRR
Assume a $52,000 investment and the following cash flows for two alternatives. Year Investment A Investment...
Assume a $52,000 investment and the following cash flows for two alternatives. Year Investment A Investment B 1 $15,000 $25,000 2 15,000 15,000 3 15,000 20,000 4 10,000 - 5 15,000 - a. Calculate the payback for investment A and B. Round your answers to 2 decimal places. Investment A years Investment B years b. Which investment would you select under the payback method? -Investment A -Investment B c. If the inflow in the fifth year for Investment A was...
Assume a $40,000 investment and the following cash flows for two alternatives. Year Investment A Investment...
Assume a $40,000 investment and the following cash flows for two alternatives. Year Investment A Investment B 1 $ 5,000 $ 25,000 2 12,000 10,000 3 15,000 20,000 4 10,000 — 5 10,000 — a. Calculate the payback for investment A and B. (Round your answers to 2 decimal places.) b. Which investment would you select under the payback method? Investment A Investment B c. If the inflow in the fifth year for Investment A was $10,000,000 instead of $10,000,...
Assume a $250,000 investment and the following cash flows for two alternatives: Year Product X   ...
Assume a $250,000 investment and the following cash flows for two alternatives: Year Product X    Product Y 1 $ 90,000   $ 50,000 2 90,000 80,000 3 60,000 60,000 4 20,000   70,000 a. Calculate the payback for products X and Y. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Payback Product X years Product Y years b. Which of the alternatives would you select under the payback method? Product X Product Y
Assume a $95,000 investment and the following cash flows for two alternatives: Year Investment A Investment...
Assume a $95,000 investment and the following cash flows for two alternatives: Year Investment A Investment B 1 $25,000 $30,000 2 15,000 30,000 3 30,000 40,000 4 30,000 — 5 20,000 — Calculate the payback period for investment A and investment B. Show calculation. (Do not round intermediate calculations. Round the final answers to 2 decimal places.) Payback period   Investment A years   Investment B years
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT