Capital Budgeting Spreadsheet Project

Introduction

This project is an application of capital budgeting and cash flow analysis. The Excel template is similar to what I might build in the so-called real world, and could be very useful to have on a flash drive somewhere for future reference

To make the project easier, I recommend using the template to build the example problem (based on Holliday Manufacturing, as discussed in the video) before trying the actual problem in the template. Once you have the example built and the numbers match the illustrations below, you know your spreadsheet works correctly. Then substitute the assumptions for the actual project and the spreadsheet will do the computations. Watch the depreciation assumptions on Gamma vs Holliday.