This Capital Budgeting Analysis model template is used to provide an analysis of a proposed project. This model template includes the key metrics to calculate the value of the project using multiple methods to value the project’s cash flows.
The model starts with an assumptions section where you can enter in certain information such as projected unit sales, unit price and cost and any fixed costs that may be associated with the project. Below the assumptions, there is the proforma income statement along with a simple cash flow and discounted cash flow analysis that is all driven by formulas from the assumptions above. After that, the model contains 5 different project valuation methods to measure whether the project is a worthy investment; Net Present Value (NPV), Internal Rate of Return (IRR), Payback and Discounted Payback Period, and Profitability Index. For visualization, there is a graph to display cash flows over the valuation period.
All cells in blue font are input cells where custom information can be entered. All cells in black font are formulas set to streamline the model.
Similar Products
Other customers were also interested in...
Private Equity Acquisition Model
The Private Equity Acquisition Model provides a business valuation of a target company for investmen... Read more
Mergers & Acquisitions (M&A) Model
The Mergers & Acquisition (M&A) Model provides a projection for a company looking to potentially... Read more
Leveraged Buyout (LBO) Model Template
The Leveraged Buyout (LBO) Model provides a business valuation of a target company for investment. T... Read more
Basic Founder’s Package – Business Valuati...
To help you get a discount out of buying multiple financial model templates for business valuation, ... Read more
Basic Founder’s Package – Financial Foreca...
This is a bundle of financial model templates best suited for financial forecasting and for startups... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
Startup Company Financial Model – 5 Year Fin...
Highly-sophisticated and user-friendly financial model for Startup Companies providing a 5-Year adva... Read more
Corporate Finance Toolkit – 24 Financial Mod...
They are essential models to increase your productivity, plan your future with budgeting and forecas... Read more
Advanced Financial Model with DCF & Valuation
New Version Updates:• Model is now dynamic. Users can select the desired forecast length for up to... Read more
You must log in to submit a review.