Complete the following homework scenario:
Compare the results of the three (3) methods by quality of information for decision making. Using what you have learned about the three (3) methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three (3) methods. Review the video titled â€œNPV, IRR, MIRR for Mac and PC Excelâ€ (located at https://www.youtube.com/watch?v=C7CryVgFbBc and previously listed in Week 4) to help you understand the foundational concepts:
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 time line 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.
InvestmentSales PriceCF1CF2Gas Station A$50,000$0$100,000Gas 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%:
NPVgas station A = $100,000/(1+.10)2 – $50,000 = $32,644
NPVgas 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.
We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.Read more
The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.Read more
The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.Read more
By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.Read more