I’ve uploaded a new model to the Models page of foquant.com. This model is a standard 5 period DCF.

Keep in mind that this model would be the aggregate tab in a workbook. A relatively more granular model would have probably between 5 to 15 more worksheets that feed into the DCF tab.

I return bearing gifts. After a short and well-used break from the site, I am glad to post a working version of a capital budgeting model. This model is straightforward, and focuses on corporate finance in terms of project analysis.

It incorporates all of the standard features, such as IRR and NPV calculations, but it adds a bit more. These special features include:

Scenario Analysis The user can compare multiple scenarios (3) side by side.
Sensitivity Analysis The user can manipulate inputs with slide bars to immediately see the impact on profitability.
SML Hurdle Rate The user can follow the SML methodology to develop a project specific hurdle rate.
Equivalent Annual Annuity The user can use the EAA method to compare projects with varying lives.
Multiple Depreciation Method The user can select straight line, or use a custom (commonly accelerated or MACRS) depreciation schedule.
Graphics The model automatically creates presentable 3D graphics to showcase the results based upon the selected inputs. These can quickly be copied and pasted into other MS software, such as PowerPoint.

As usual, the model has been uploaded to the Models page of the foquant.com site. The “Terms” tab has not been completed, but once uploaded that will share additional insight into the inputs and outputs of the model. Also, as usual, the user assumes any and all risk - I partake in model creation for recreation; if any reliance is placed upon these models it is at the assumption of risk of the user.

Using multiple discriminate analysis, Edward Altman created a model that provides guidance regarding a company’s credit health. The model is named The Z-Score Model. Upon providing measures from a company’s financial statements, the model would yield a single variable that is designed to be compared to a pre-specified scale. The placement of the Z-score on the scale would indicate whether a company was likely to head toward bankruptcy.

I implemented the model in Excel, and it can now be accessed through the Models page of the foquant.com website.

This model was also covered in the Fixed Income curriculum for the CFA Level 2 exam.