calculating payback and profitability 1
-
Overview
Complete a series of five problems in which you discount the cash flows of alternative capital investments, compare the expected values of alternative investments, and choose the investment that will provide maximum value for shareholders.Note: The assessments in this course build upon each other, so you are strongly encouraged to complete them in sequence.SHOW MORE
- Toggle Drawer
Questions to Consider
To deepen your understanding, you are encouraged to consider the questions below and discuss them with a fellow learner, a work associate, an interested friend, or a member of the business community.SHOW LESS
- How would you define the following capital budgeting methods: net present value (NPV), internal rate of return (IRR), and payback period? How do they differ from one another? What are some other capital budgeting methods? Which, if any, of the methods might be superior to the others?
- What are some concepts associated with making capital investment decisions such as cash flows, sunk costs, or opportunity costs? Why should an investor factor these concepts into the decision-making process?
- Toggle Drawer
Resources
Suggested Resources
The resources provided here are optional. You may use other resources of your choice to prepare for this assessment; however, you will need to ensure that they are appropriate, credible, and valid. They provide helpful information about the topics in this unit. The MBA-FP6016 – Finance and Value Creation Library Guide can help direct your research. The Supplemental Resources and Research Resources, both linked from the left navigation menu in your courseroom, provide additional resources to help support you.The following resources will provide assistance to complete the assessment.
The following texts are designed to assist learners to master core concepts, solve financial problems, and analyze results.
- Boundless. (n.d.). Boundless finance. Retrieved from https://www.boundless.com/finance/textbooks/boundl…
- Chapter 5, “Time Value Money”.
- Chapter 6, “Bond Valuation”
- Chapter 7, “Stock Valuation”.
- Chapter 15, “Dividends”.
- Boundless. (n.d.). Boundless finance. Retrieved from https://www.boundless.com/finance/textbooks/boundl…
-
Assessment Instructions
Demonstrate your understanding of financial concepts by completing the following problems. Where appropriate, show or explain your work. You may use Excel to work on the problems.Problem 1. Calculating net present value (NPV): Porter Incorporated has two exclusive projects, listed in the table below. Use the NPV rule to rank these two projects. If the appropriate discount rate is 13 percent, which project should be chosen?
Problem 1. Calculating NPV
Year Project A Project B 0 −$12,700 −$9,400 1 $7,000 $4,800 2 $5,500 $3,750 3 $2,500 $3,400 Problem 2. Calculating payback period: An investment project provides cash inflows of $920 per year for eight years. Calculate the project’s payback period if the initial cost is each of the following:
- $4,500.
- $5,500.
- $7,000.
Problem 3. Calculating internal rate of return (IRR) for cash flows: Calculate the internal rate of return for the cash flows of the two projects in the table below.
Problem 3. Calculating IRR for Cash Flows
Year Project A Project B 0 −$4,600 −$3,500 1 $1,400 $1,250 2 $2,200 $1,800 3 $2,700 $1,600 Problem 4. Calculating profitability index of a project: Jeff plans to open a small health club. The equipment will cost $225,000. Jeff expects that there will be after-tax cash inflows of $62,000 annually for seven years. The equipment will then be scrapped and the health club will close. At year-end of the first year, the first cash inflow occurs. The required return is 13 percent. What is the project’s profitability index? Should it be accepted?Problem 5. Calculating project NPV: Jenny’s Creamery is considering the purchase of a $27,000 ice cream maker. The ice cream maker has an economic life of eight years. Using the straight-line method, it will be fully depreciated. The machine will produce 250,000 servings per year, with each costing $1.25 to make, and priced at $1.99. The discount rate is 12 percent. The tax rate is 35 percent. Should the company make the purchase? Provide a rationale using the calculations.
Calculating Payback and Profitability Scoring Guide
VIEW SCORING GUIDEUse the scoring guide to enhance your learning
- SCORING GUIDE/RUBIC-****PLEASE READ
-
Calculating Payback and Profitability Scoring Guide
CRITERIA NON-PERFORMANCE BASIC PROFICIENT DISTINGUISHED Calculate the payback period and net present value (NPV) of a project. Does not calculate the payback period and net present value (NPV) of a project. Calculates the payback period and net present value (NPV) of a project; however, there are errors in the calculations and/or a recommendation of whether or not to purchase was overlooked. Calculates the payback period and net present value (NPV) of a project. Calculates the payback period and net present value (NPV) of a project; arrives at accurate calculations to recommend whether to purchase or not. Calculate the internal rate of return (IRR) for the cash flows. Does not calculate the internal rate of return (IRR) for the cash flows. Calculates the internal rate of return (IRR) for the cash flows; however, there are errors in the calculations. Calculates the internal rate of return (IRR) for the cash flows. Calculates the internal rate of return (IRR) for the cash flows; uses appropriate methods to arrive at accurate calculations. Calculate the profitability index of a project. Does not calculate the profitability index of a project. Calculates the profitability index of a project; however, there are errors in the calculation. Calculates the profitability index of a project. Calculates the profitability index of a project; uses appropriate methods to calculate the profitability index.