Financial models
Welcome to the THC Financial Models Library.
This library is designed to promote the usage and better understanding of financial models.
All financial models are in Excel spreadsheet format, and can be downloaded, used free of charge, and distributed freely. These free excel spreadsheets are related to business finance, including valuations, cash flow models, forecasting, and fundamental analysis.
We hope that you can also contribute to the library of financial models by submitting your Excel model spreadsheet in the format consistent with our models. We maintain the right to reject your submission or suggest revisions of the models.We reserve the copyright of the Excel spreadsheet model. Interested in uploading your own models? Please send it to support@thomasho.com
Note: The site is not responsible for any errors in the models and copyright violation of any models submitted.
Guide to Financial Models
• Models are arranged from the basic to the complicated. Click on the model that you would like to use.
• Each model provides its own instructions. In general, the input date should be pasted in the marked area and the output data is provided in the marked area.
• Open a workbook from our local system. Save the Excel model spreadsheet(s) from the site to your local drive. Do not use the models on the site to do calculations, because the results cannot be saved in your local system for future use.
Basic Excel functions are used and some tips are given below
• Dragging is useful to increase the model size. For practical use, you may want to increase the number of periods of the model, and you should be able to drag the model to fit your needs.
• Solver can be found in the tool. Solver is used to solve for minimum or maximum output of a function or solving a set of equations. Enter the changing variable and specify the target cell to determine the solution. Make sure that you have loaded the solver in your tool section.
• Workbook can save several Excel model spreadsheets, so that you can do a portfolio analysis of different securities or derivatives. You can also develop macros on the workbook to automate your portfolio analysis.
• To assist the authors in developing the models and us in providing a better library, please provide us comments and suggestions to the site or each model