To come up with wise investment decisions, investors must collect and analyze data systematically and scientifically.
Apparenetly, the primary concern of investors is to minimize loss risks and control related risks to mitigate potential loss. The scope of success and failure of an investment decision greatly depend on the amount of information available to investors. However, investors may treat similar sources of information differently; this depends on their analytical and forecasting capabilities.
This book is a useful guide for readers to understand and use financial formulas effectively in their analysis. The special feature of this book is that the author presents related financial formulas in association with Excel formulas so that readers can check and compare results, thus deepening their understanding of Excel formulas.
Contents:
Acknowledgement
Part 1: Considerations in using financial formulas
Date and date systems
1900 date system vs. 1904 date system
Recognizing the year value with 2 digits
Financial formulas in Excel
Overview
Formula structure
Choosing and compiling formulas
Considerations in compiling formulas
How to input function argument
How to name function argument
How to create a new financial formula using VBA tool
Changing display modes
Common function arguments in financial formulas
Common erros in financial formulas
Part 2: Financial formulas
Group A
Group C
Group D
Group E
Group F
Group I
Group M
Group N
Group O
Group P
Group R
Group S
Group T
Group V
Group X
Group Y
Part 3: Appendix
Appendix 1: Applying theories into decision making in investment
Appendix 2: Quick look up for corporate financial formulas
Appendix 3: Function DAYS360
Appendix 4: Modules for VBAProject
Appendix 5: Interpolation
Appendix 6: How to prepare financial spread sheets
Appendix 7: Financial spreadsheets
Related Articles