Want FREE Templates on Digital Transformation? Download our FREE compilation of 50+ slides. This is an exclusive promotion being run on LinkedIn.

Capital Budgeting Model Excel Template   Excel template (XLSX)
$89.00

Capital Budgeting Model Excel Template (Excel template (XLSX)) Preview Image Capital Budgeting Model Excel Template (Excel template (XLSX)) Preview Image Capital Budgeting Model Excel Template (Excel template (XLSX)) Preview Image Capital Budgeting Model Excel Template (Excel template (XLSX)) Preview Image Capital Budgeting Model Excel Template (Excel template (XLSX)) Preview Image Capital Budgeting Model Excel Template (Excel template (XLSX)) Preview Image Capital Budgeting Model Excel Template (Excel template (XLSX)) Preview Image Capital Budgeting Model Excel Template (Excel template (XLSX)) Preview Image Capital Budgeting Model Excel Template (Excel template (XLSX)) Preview Image Log in to unlock full preview.
Arrow   Unlock all 17 preview images:   Login Register

Capital Budgeting Model Excel Template (Excel XLSX)

File Type: Excel template (XLSX)

#1 in Business Case Example $89.00
Created by a Financial Modeling, Planning & Performance Consultant with 15+ years of experience at Ernst & Young, Toyota, Viohalco, and Upstream. Certified by both the Corporate Finance Institute and the Financial Modeling Institute.
Add to Cart
  


BUY WITH CONFIDENCE

Immediate digital download upon purchase.
Lifetime document updates included with purchase.
Fully editable & customizable XLSX document.
Trusted by over 10,000+ organizations.

BENEFITS OF DOCUMENT

  1. Calculate capital budgeting for expansion projects
  2. Calculate capital budgeting for replacement projects
  3. Calculate mutually exclusive projects with unequal lives.

DESCRIPTION

This product (Capital Budgeting Model Excel Template) is an Excel template (XLSX), which you can download immediately upon purchase.

Capital Budgeting consists of a process that companies use for decision making on investment projects that usually have a long-term horizon (over a year). This Excel model contains three types of methods: capital budgeting for expansion projects, capital budgeting for replacement projects, and finally mutually exclusive projects with unequal lives.

So, a quick overview of the model, in the contents tab you can see the structure of the model and by clicking on any of the headlines to be redirected to the relevant worksheet.

On the manual tab, you can feed the general information for the model such as: model name, responsible, timeline of the model, and the date and currency conventions.

Additionally, there is a description of the color-coding of the model in the same tab. Inputs are always depicted with a yellow fill and blue letters, call up (that is direct links from other cells) are filled in light blue with blue letters while calculations are depicted with white fill and black characters.

There is also color coding for the various tabs of the model. Yellow tabs are mostly assumptions tabs, grey tabs are calculations tabs, blue tabs are outputs tabs (that is effectively results or graphs) and finally, light blue tabs are admin tabs (for example: the cover page, contents, and checks).

The next 2 tabs are related to an expansion project, which is an independent project that does not affect the cash flows for the rest of the company. The assumptions for an expansion project consist of general assumptions such as marginal tax rate, tax credit, discount rate, and investment duration. The investment duration is limited to 10 years.

Sunk costs are costs that have already been incurred and are not considered in the capital budgeting process. Afterward, the user needs to set the price of the new investment, how much of the investment will be depreciable, its useful life, and market salvage value (which is the amount that the investment can be sold at the end of its life), as well as the net working capital.

The user will also need to input the first-year sales and their yearly growth, as well as the operating expenses and their growth. Finally, the user will also need to set the sensitivities steps.

Everything is calculated on the next tab, the initial investment, operating cash flows and terminal cash flows are computed resulting in various capital budgeting metrics such as the Net Present Value, the Internal Rate of Return, the Payback Period, the Average Accounting, as well as the profitability index. Sensitivity Analysis follows, for the Net Present Value and Internal Rate of Return. As well as various graphs related to the sensitivity analysis.

The next 2 tabs concern a replacement project, which is a project that affects the company's cash flows. In this case, we must consider the incremental cash flows of the project. Or in other words, the cash flows if the project is made less the cash flows if the project is not made. In this tab, we present the case of the replacement of an old investment with a new investment.

This tab follows the same logic as previously, except that the user needs to fill the assumptions for both the new investment and the old investment. This includes the investment (both new and old), the incremental working capital, the operating cash flows (both new and old).

Everything is calculated on the next tab, the initial investment, operating cash flows and terminal cash flows are computed resulting in various capital budgeting metrics such as the Net Present Value, the Internal Rate of Return, the Payback Period, the Average Accounting, as well as the profitability index. Sensitivity Analysis follows, for the Net Present Value and Internal Rate of Return. As well as various graphs related to the sensitivity analysis.

The third case considers the comparison between two projects which have unequal lives, and that can be repeated or replicated at the end of their life. In this case, the Net Present Value criteria cannot be used, and we need to use the Equivalent Annual Annuity concept to compare these 2 projects.

Finally, we present a set of capital budgeting pitfalls, which have to be taken into account in any capital budgeting process.

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in Business Case Example, Business Case Development Excel: Capital Budgeting Model Excel Template Excel (XLSX) Spreadsheet, Big4WallStreet


$89.00
Created by a Financial Modeling, Planning & Performance Consultant with 15+ years of experience at Ernst & Young, Toyota, Viohalco, and Upstream. Certified by both the Corporate Finance Institute and the Financial Modeling Institute.
Add to Cart
  

OVERVIEW

File Type: Excel xlsx (XLSX)
File Size: 1.1 MB

ABOUT THE AUTHOR

Additional documents from author: 75

We help small and midsize businesses' leaders with their strategic problems by creating or improving financial models, implementing tools to drive efficiency, performance, and better decision making. [read more]

Ask the Author a Question

Must be logged in

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided best practices to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab




Read Customer Testimonials




Customers Also Bought These Documents


Customers Also Like These Documents

Related Management Topics


Business Case Example Business Case Development Integrated Financial Model Financial Modeling Costing Break Even Analysis Employee Training Change Management

Download our FREE Strategy & Transformation Framework Templates

Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more.