Rohit Goyal
If you want to know the value of your business, then this tool could be helpful. This tool contains different valuation methods like DCF model, Enterprise valuation, Perpetuity value and Payback period.
DCF model is a specific type of financial modeling tool used to value a business. DCF is a valuation method used to estimate the value of an investment based on its expected future cash flows. It calculated the value of an investment today, based on projections of how much money it will generate in the future.
Payback period: It is used to calculate the number of years it would take to get back the initial investment made in a project/business. Two techniques are used here:
i) Payback simple i.e. without discounting of future cash flows
ii) Payback period discounted i.e. Cash flows are discounted at a rate and then payback period is calculated
Enterprise value or firm value is an economic measure reflecting the market value of a business. EV includes in its calculation the market capitalization of a company but also short-term and long-term debt as well as any cash on the company's balance sheet. Enterprise value is a popular metric used to value a company for a potential takeover.
Perpetuity is a constant stream of identical cash flows with no end.
PS: I have read many online study materials and have tried to compile it in one excel file. Please let me know if you have any suggestions, I will be happy to modify this.
CAclubindia
