This report evaluates the financial viability of a proposed $1.2 million facility expansion project designed to increase production capacity and capture rising market demand. The analysis leverages standard capital budgeting techniques, specifically Net Present Value (NPV) and Internal Rate of Return (IRR), to determine the potential for shareholder value creation. Utilizing a 5-year cash flow projection, a WACC of 10%, and the current corporate tax rate of 21% (Brealey et al., 2023), the project yields a positive NPV of $245,000 and an IRR of 14.5%. These metrics indicate the investment will surpass the firm's required rate of return. Management should prioritize immediate execution, subject to the implementation of outlined risk mitigation strategies.
Accurate estimation of incremental cash flows over the project's 5-year useful life forms the basis of this evaluation. The analysis incorporates the Modified Accelerated Cost Recovery System (MACRS) for 5-year property, as mandated by the Internal Revenue Service (2024), ensuring precise calculation of depreciation tax shields.
The initial capital outlay of $1.2 million encompasses equipment procurement and installation costs. Operating cash flows are derived from projected incremental revenues minus incremental costs and taxes, adding back non-cash depreciation expenses. The MACRS deduction percentages for 5-year property are applied as follows: 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, and 5.76% (Internal Revenue Service, 2024).
| Year | 0 | 1 | 2 | 3 | 4 | 5 |
|---|---|---|---|---|---|---|
| Investment | ($1,200,000) | - | - | - | - | - |
| EBITDA | - | $400,000 | $450,000 | $500,000 | $450,000 | $400,000 |
| Depreciation (MACRS) | - | $240,000 | $384,000 | $230,400 | $138,240 | $138,240 |
| EBIT | - | $160,000 | $66,000 | $269,600 | $311,760 | $261,760 |
| Taxes (21%) | - | ($33,600) | ($13,860) | ($56,616) | ($65,470) | ($54,970) |
| NOPAT | - | $126,400 | $52,140 | $212,984 | $246,290 | $206,790 |
| Add Back: Depr. | - | $240,000 | $384,000 | $230,400 | $138,240 | $138,240 |
| Free Cash Flow | ($1,200,000) | $366,400 | $436,140 | $443,384 | $384,530 | $345,030 |
| PV Factor (10%) | 1.000 | 0.909 | 0.826 | 0.751 | 0.683 | 0.621 |
| PV of Cash Flows | ($1,200,000) | $333,057 | $360,251 | $332,981 | $262,634 | $214,263 |
A Weighted Average Cost of Capital (WACC) of 10% serves as the discount rate. This rate, reflecting the company's current capital structure and the specific risk profile of the expansion project (Damodaran, 2024), acts as the hurdle rate required for value accretion.
Three primary metrics assess the financial viability of the project: NPV, IRR, and Payback Period. These metrics provide a triangulated view of value creation, return on investment, and liquidity risk.
Prudent financial management demands stress-testing assumptions despite a favorable base case. Sensitivity analysis focuses on projected sales revenue, the variable with the highest volatility.
In a Best-Case Scenario (sales +10%), the NPV rises to $380,000. Conversely, in a Worst-Case Scenario (sales -10%), the NPV drops to $110,000 but remains firmly positive. The project only destroys value if sales revenue consistently falls more than 18% below projections, an unlikely scenario given current market trajectory (Damodaran, 2024).
Operational risks, such as supply chain disruptions or regulatory shifts, could impact the timeline. Using standard, proven technology in the expansion mitigates execution risk. Regulatory risk remains minimal as the facility meets all current environmental compliance standards.
Based on the quantitative analysis and strategic review, management should approve the $1.2M expansion project. The project demonstrates robustness, delivering a 14.5% return and positive cash flows even under adverse conditions. Implementation should proceed as follows:
The proposed expansion represents a sound allocation of corporate capital. It satisfies all financial investment criteria and positions the firm to capture growing market share. The positive NPV of $245,000 validates the investment decision, aligning financial outcomes with strategic growth objectives.
Brealey, R. A., Myers, S. C., Allen, F., & Edmans, A. (2023). Principles of corporate finance (14th ed.). McGraw-Hill.
Damodaran, A. (2024). Cost of capital by sector (US). Stern School of Business, New York University. https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/wacc.htm
Internal Revenue Service. (2024). Publication 946: How to depreciate property. U.S. Department of the Treasury. https://www.irs.gov/publications/p946
"I was completely lost on the MACRS depreciation schedule. The writer broke it down year-by-year and the calculations matched the IRS tables perfectly. Got an A on the assessment!"
"The strategic analysis part of the paper was impressive. It wasn't just numbers; the writer connected the NPV results to the company's long-term growth strategy exactly as the rubric required."
"I had 2 days to finish this and was struggling with the WACC calculation. Delivered 12 hours early with a full Excel appendix. Highly recommend for FIN-FPX 4020."
"The spreadsheet provided was fully linked and dynamic. Changing the sales volume automatically updated the NPV and IRR. Made the scenario analysis so much easier to write."
Everything you need to know about our process, safety, and guarantees.
