Spreadsheet Model for Valuation of a Company

You can delete formula in cell Q44 which refers to XIRR function. You can use rest of the spreadsheet.

Equity Valuation.xls (172 KB)

I have removed the formula and the macro so you should be able to use the attached one wihtout any macros. This will not give you the expected returns over the high growth period, but you can still calculate the intrinsic value.

2 Likes