Quick and Powerful Spreadsheet Solutions for Finance
Customized Spreadsheets at Template Prices
Investment Project Financial Analysis
A Great Investment Analysis Template
This template contains everything you need to analyze a wide range of investment projects. It models investment, cash flow with equity, debt and lease financing. It models operating results – revenue sales units, operating expense, financial and tax expenses and earnings –in some detail. You can model separate financial analyses for sub-projects – for example, multiple vehicles, building, or pieces of equipment.
More Information About the Model
Show infoThis model analyzes the return on investment of an investment project. It analyzes sub-projects that have their own fixed investment, working capital, revenues and expenses within a larger project. You can optionally specify a list of products and services, each with its own price, sale units, and variable expense per sales unit.
The main outputs of the model are:
- A summary of investment, on worksheet 'Investment'
- Statement of operations, on worksheet 'Operations'
- Financial summary of all-equity financing, on worksheet 'Equity Fin'
- Financial summary of blended equity, debt and lease financing, on worksheet 'Blend Fin'
- Optional: For each sub-project,
- A worksheet with a financial summary of all-equity financing
- A worksheet with a financial summary of blended equity, debt and lease financing
- Net present value (NPV), return on capital (ROC), and internal rate of return (IRR), on worksheet 'Valuation'
The primary data inputs to the model are:
- working capital requirements, initial value, and salvage value
- revenues, operating expenses, income taxes and tax credits
Optional: a number of subprojects, each with its own initial value, start date, depreciation method and life, and salvage value, whose financial performance is reported separately and in aggregate
You can specify the number of financing scenarios included in the model. Each financing scenario can have a different blend of equity, debt and lease financing.
The original version of this model was based on an investment project analysis workbook named capbudg.xls made available for public use on the website of Professor Aswath Damodaran of NYU Stern School of Business at http://pages.stern.nyu.edu/~adamodar/ . ModelSheet Software is solely responsible for any errors in this derivative work.
Graphs | 
Investment | 
Operations | 
Equity Financing | 
Equity Financing - Subproject | 
Blended Financing |
Why Use Customizable Spreadsheet Solutions?
Customizable spreadsheet solutions fit your needs better than any conventional spreadsheet template. Simply specify information unique to your needs using our simple online form, select features from a broad selection, and download your spreadsheet solution in minutes.
Get Your Customized Spreadsheet in Minutes
The Spreadsheet is Easy to Use
Each Microsoft® Excel® spreadsheet solution contains · carefully organized layout · Excel comments on every variable table ·
Excel collapsible groups to hide detail until you want it ·
a worksheet with easy-to-read symbolic formulas that tell you what the model does.
Your customized spreadsheet solution makes it easy for you to change the following items in Excel:
- All the input data
- Starting date
- Text of all labels (e.g., products, departments, locations, etc.)
View a 2 minute introductory video about customized spreadsheet solutions!
New! International Formatting
During customization you can select from a set of international currency symbols and date entry and display formats. Once you create a free account, you can also set these options in your profile.
Looking for more customizations?
If you want more customizations, we can build them for you. Our experience in business and engineering analysis, combined
with revolutionary ModelSheet technology, enable us to build complex custom templates and deliver great value. Read what
our users say about our consulting services.
|