Salary Structure Calculator (Google Sheet).

PTO Balance for Salaried (Google Sheet).PTO Manager for Salaried (Google Sheet).Learning & Development Dashboard (Google Sheet).Learning & Development Dashboard (Excel).Compliance Training Dashboard (Google Sheet).Free Recruitment Tracker (Google Sheet).Recruitment Tracker Dashboard (Google Sheet).Part Two: Financial Modeling Using Excel.Ĭhapter 12 Building Good Excel Models and Debugging Them.Ĭhapter 13 Financial Statements Forecasting.Ĭhapter 15 Financial Planning and Investments.Ĭhapter 19 Options and Option Portfolios.Ĭhapter 27 Financial Planning and Investments.Ĭhapter 30 Options and Option Portfolios.Īppendix C Excel and VBA Built-In Functions. Part One: Excel for Financial Analysis and Modeling.Ĭhapter 2 Excel 2007 and Previous Excel Versions.Ĭhapter 5 Making Decisions and Looking Up Values.Ĭhapter 10 Using Excel's Financial Functions. This comprehensive guide is an essential read for anyone who has to perform financial analysis or understand and implement financial models.Ĭhapter 1 Introduction to Financial Analysis and Modeling. * Designed for self-study, classroom use, and reference * Other titles by Sengupta: Financial Modeling Using C++ and The Only Proven Road to Investment Success * Contains detailed coverage of the powerful features of Excel 2007 essential for financial analysis and modeling, such as the Ribbon interface, PivotTables, data analysis, and statistical analysis * Teaches financial analysis and modeling and illustrates advanced features of Excel and VBA, using a learn-by-doing approach A companion CD-ROM includes several useful modeling tools and fully working versions of all the models discussed in the book. This expanded and fully updated guide reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial problems and models that you can learn from, use for practice, and easily adapt for work and classroom use. An updated look at the theory and practice of financial analysis and modelingįinancial Analysis and Modeling Using Excel and VBA, Second Edition presents a comprehensive approach to analyzing financial problems and developing simple to sophisticated financial models in all major areas of finance using Excel 2007 and VBA (as well as earlier versions of both).

Technical Analysis With Excel Vba