Math Problem Statement
The Michner Corporation is trying to choose between the following two mutually exclusive design projects:
Year Cash Flow (I) Cash Flow (II) 0 −$ 83,000 −$ 41,000 1 32,900 12,900 2 43,000 30,500 3 49,000 24,500 a-1. If the required return is 16 percent, what is the profitability index for each project?
Note: Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.
a-2. If the company applies the profitability index decision rule, which project should it take?
b-1. If the required return is 16 percent, what is the NPV for each project?
Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.
b-2. If the company applies the net present value decision rule, which project should it take?
Solution
Define the cash flows for both projects cash_flows_I = [-83000, 32900, 43000, 49000] cash_flows_II = [-41000, 12900, 30500, 24500] required_return = 0.16
Function to calculate Present Value (PV) of cash flows
def calculate_pv(cash_flows, rate): return sum(cf / (1 + rate) ** t for t, cf in enumerate(cash_flows))
Function to calculate Profitability Index (PI)
def calculate_pi(cash_flows, rate): pv_cash_inflows = calculate_pv(cash_flows[1:], rate) return pv_cash_inflows / abs(cash_flows[0])
Function to calculate Net Present Value (NPV)
def calculate_npv(cash_flows, rate): return calculate_pv(cash_flows, rate)
Calculate PI and NPV for both projects
pi_I = calculate_pi(cash_flows_I, required_return) pi_II = calculate_pi(cash_flows_II, required_return)
npv_I = calculate_npv(cash_flows_I, required_return) npv_II = calculate_npv(cash_flows_II, required_return)
(pi_I, pi_II, npv_I, npv_II)### Results: Profitability Index (PI):
- Project I: 1.282
- Project II: 1.400
Net Present Value (NPV):
- Project I: $8,710.30
- Project II: $8,483.27
Decisions:
- Profitability Index Decision Rule: Since Project II has a higher PI (1.400 vs. 1.282), the company should select Project II.
- Net Present Value Decision Rule: Since Project I has a slightly higher NPV ($8,710.30 vs. $8,483.27), the company should select Project I.
Would you like a step-by-step breakdown of the calculations or have further questions?
5 Related Questions:
- How is the profitability index (PI) calculated, and why is it useful in decision-making?
- What factors might lead to discrepancies between PI and NPV decisions?
- How does the required return impact the NPV and PI results?
- Can mutually exclusive projects lead to conflicting decision outcomes under different rules?
- What are some limitations of using NPV and PI for project evaluation?
Tip:
Always double-check cash flow inputs and discount rates when performing investment appraisals to ensure precision in financial decision-making.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Profitability Index
Net Present Value
Discounted Cash Flows
Investment Appraisal
Formulas
Profitability Index (PI) = Present Value of Cash Inflows / Initial Investment
Net Present Value (NPV) = Σ (Cash Flow at Time t / (1 + Discount Rate)^t)
Theorems
Time Value of Money
Suitable Grade Level
Undergraduate Finance or Business Courses
Related Recommendation
Profitability Index and NPV Analysis for Michner Corporation Projects
Project Selection: Net Present Value and Profitability Index Comparison
NPV and Profitability Index for Coore Manufacturing Projects
Project Profitability Analysis Using NPV and PI with a 10% Discount Rate
Profitability Index and NPV Analysis for Michner Corporation Projects