
- 160 pages
- English
- PDF
- Available on iOS & Android
Financial Planning Models in Excel
About this book
This book presents the construction of a basic but complete financial planning model that may be used as a tool when addressing the strategic and financial challenges of a firm.Financial Planning Models in Excel introduces a model that, in addition to having budgeted statements of income and financial position as output, presents a budgeted cash flow statement. The advantage is that the cash flow conse-quences of different scenarios are presented in more detail and structured by operating, investing and financing cash flows. Most importantly, this approach provides a check of the model relationships, thus ensuring the reliability of the model.The book presents solutions to the most common problems in relation to model-building and there are specific chap-ters on developing support modules for revenues, expenses, investments, research and development, liabilities, equity and tax. Focusing on the interpretation of the models, there are also chapters on support modules for calculating fi-nancial ratios and company valuation.Although Excel is not the primary focus of the book, there are guidelines on how to construct the model in order to maximise the computer support and instructions for specific issues such as the use of logical tests.Financial Planning Models in Excel is intended for university students in accounting and finance. These types of models constitute useful tools for strategy development and evaluation, as well as for learning accounting.
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- _GoBack
- _GoBack
- _GoBack
- _GoBack
- _GoBack
- Preface
- Financial planning models in Excel
- FINANCIAL STATEMENTS-BASED MODELS
- Problem-oriented models
- The model logic
- Estimates
- Converting the model to the spreadsheet program
- FURTHER DEVELOPMENT
- A sales module
- An expense module
- An investment module
- A research and development module
- A loan module
- An equity module
- A tax module
- A financial ratios module
- A valuation module
- USING THE MODEL
- Using models
- Index