|General Excel Financial Models|
|DCF Model, Discount Rate, Excel, Sensitivity Analysis, Terminal Value, Valuation|
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.