Some of the things that give this template some unique characteristics include a visual that allows users to see how the valuation of cash flows change given 4 different discount rates.
Additionally, instead of just having pure cash flow, the user can enter a given year’s revenue, COGS, expenses, and resulting net operating income in order to drive the analysis.
This model goes out 400+ years to get to a near 0 discount value given any amount of starting cash flow.
|Industry||General Excel Financial Models|
|Summary||Allows user to enter various inputs about their business cash flows and get a straight forward valuation based on the Gordon Growth Model logic.|
|Screenshots / Pictures|
|Use Cases||DCF Model, Discount Rate, Excel, Sensitivity Analysis, Terminal Value, Valuation|