The financial workbook provides automated 3 years historic and 5 years projected ratios.
Sustainable Growth Rate (SGR) (Advanced Edition)
Z-score ratio (Advanced Edition)
OCF and FCF (Advanced Edition)
NPV and IRR (Advanced Edition)
Enter your interest rate, or discount rate, in the space provided. This is the rate at which all future costs and savings will be discounted to present value. Some businesses use their short-term borrowing rate as a discount rate, others prefer a composite of their cost of debt and equity capital. The choice is yours. If you enter the IRR value in the Annual interest rate cell, the NPV will be 0.
Enter the industry standard ratios for your business if you wish to compare your company's ratios to the industry standard. The variations are calculated.
Screenshot not shown here!