Question
Please assist with the following 5 questions: Where appropriate, show or explain the work. You may use Excel to work the problems. Problem 1. Calculating
Please assist with the following 5 questions:
Where appropriate, show or explain the work. You may use Excel to work the problems.
Problem 1.Calculating Payback Period and 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?
0 | -$12,700. | -$9,400. |
1 | $7,000. | $4,800. |
2 | $5,500. | $3,750. |
3 | $2,500. | $3,400. |
Problem 2.Calculating Payback: 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 IRR for Cash Flows: Calculate the internal rate of return for the cash flows of the two projects in the table below.
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 8 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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started