Math Problem Statement
Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year Alternative A Alternative B 0 $(85 comma 000) $(65 comma 000) 1 (16 comma 000) (7 comma 000) 2 (16 comma 000) (7 comma 000) 3 (16 comma 000) (7 comma 000) 4 (16 comma 000) 5 (16 comma 000) 6 (16 comma 000) 7 (16 comma 000) Question content area top Part 1 (Related to Checkpoint 11.2) (Calculating EAC) Barry Borromeo is a financial analyst for Dossman Metal Works, Inc., and he is analyzing two alternative configurations for the firm's new plasma cutter shop. The two alternatives, denoted A and B below, will perform the same task, but alternative A will cost $85 comma 000 to purchase, while alternative B will cost only $ 65 comma 000. Moreover, the two alternatives will have very different cash flows and useful lives. The after-tax costs for the two projects are as follows: LOADING.... a. Calculate each project's EAC, given a discount rate of 11 percent. b. Which of the alternatives do you think Barry should select? Why? Question content area bottom Part 1 a. Alternative A's EAC at a discount rate of 11% is $
enter your response here. (Round to the nearest cent.)
Solution
To calculate the Equivalent Annual Cost (EAC) for each alternative, we will first compute the Net Present Value (NPV) of the cash flows for each alternative, then convert that into an equivalent annual amount using the formula:
where the Annuity Factor (AF) is calculated as:
where:
- is the discount rate (11% or 0.11),
- is the number of years (7 years).
Step 1: Calculate the NPV for each alternative.
We will calculate the NPV for both alternatives based on the following cash flows:
-
Alternative A:
- Initial cost (Year 0): $(85,000)
- Yearly costs (Years 1-7): $(16,000)
-
Alternative B:
- Initial cost (Year 0): $(65,000)
- Yearly costs (Years 1-7): $(7,000)
We'll first compute the NPV for each project using the formula for NPV:
where represents the cash flow at time .
Let me calculate the NPVs and the EAC for both alternatives. numpy as np
Given data
discount_rate = 0.11 years = 7
Cash flows for both alternatives
cash_flows_A = [-85000] + [-16000] * years # Alternative A cash_flows_B = [-65000] + [-7000] * years # Alternative B
Function to calculate NPV
def calculate_npv(cash_flows, r): return sum(cash_flows[t] / (1 + r) ** t for t in range(len(cash_flows)))
Calculate NPVs for both alternatives
npv_A = calculate_npv(cash_flows_A, discount_rate) npv_B = calculate_npv(cash_flows_B, discount_rate)
Calculate Annuity Factor
annuity_factor = (1 - (1 + discount_rate) ** -years) / discount_rate
Calculate EAC for both alternatives
eac_A = npv_A / annuity_factor eac_B = npv_B / annuity_factor
npv_A, npv_B, eac_A, eac_BHere are the results:
-
Alternative A:
- NPV:
- EAC:
-
Alternative B:
- NPV:
- EAC:
b. Which alternative should Barry select?
Barry should select Alternative B, as it has a lower Equivalent Annual Cost (EAC) of , which means it is the less costly option over the project's useful life compared to Alternative A, which has an EAC of .
Would you like more details on how the calculation was done? Let me know if you have further questions.
Related questions:
- How does the discount rate affect the EAC of each alternative?
- What would happen if the useful life of the alternatives were longer or shorter?
- How do cash flow variations influence the choice between two alternatives?
- What is the difference between NPV and EAC in capital budgeting?
- How would the choice change if the discount rate were lower than 11%?
Tip: When calculating EAC, always ensure that the discount rate used is consistent with the time value of money and reflects the firm's required return.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Financial analysis
Present value
Equivalent Annual Cost (EAC)
Formulas
EAC = NPV / Annuity Factor
NPV = Σ (C_t / (1 + r)^t)
Annuity Factor = (1 - (1 + r)^-n) / r
Theorems
Time value of money
Suitable Grade Level
Undergraduate level or professionals in financial analysis
Related Recommendation
Calculate the Equivalent Annual Cost (EAC) of Dimple-Max Golf Practice Equipment
Calculate Equivalent Annual Cost (EAC) for Car vs. Train Travel
Calculate the Equivalent Annual Cost (EAC) of Golf Practice Equipment Using Straight-Line Depreciation
Calculate EUAC for Vehicle Upgrade vs Lease | TVM Analysis
Calculate Annual Cost of Dump Truck Using EUAC at 8% Interest