Benninga 4th edition - Chap 6 pro forma model of CAT without formula errors

This is an Excel model based on the pro forma model of Caterpillar in Benninga Financial Modeling 4th edition Chapter 6; this Excel model does not have formula errors or missing data. One can obtain the original Excel valuation model that was developed and used in Benninga (2014) by going to http://mitpress.mit.edu/books/financial-modeling-fourth-edition. The results obtained using the original Benninga model are very similar to the results obtained using the model we provide. To use Bennina’s original model one will need to fill in missing information by referring to the assumptions provided on page 176 for “Interest rate on debt” in Chapter 6 of his textbook. (2018-12-08)