Financial Modeling
Budgeting in a business has benefits and consequences that go
beyond the financial dimension and have more to do with
business management in general. Consider the following
benefits of a budgeting process.
Budgeting forces managers to do better forecasting. Managers
should be constantly scanning the business environment to spot
changes that will impact the business. Vague generalizations
about what the future may hold for the business are not good
enough for assembling a budget. Managers must put their
predictions into definite and concrete forecasts.
This course provides you with the best techniques and equips
you with detailed analytical skills so that you can stand out
from crowd while at job or during application process.
- Introduction to Forecasting (Collection and examination of data)
- Smoothing Techniques
- Trend Analysis
- Regression Analysis
- Expected Values
- Evaluating Forecasting Techniques
- Perform advanced breakeven analysis for products and services
- Perform ratio analysis
- Work with dates, times, and strings of text and pluck out pieces of data from a database
- Perform What-if analysis to model and compare business scenarios
- Design a loan repayment calculator model using Excel
- Introduction and approaches to business planning
- Developing a financial plan
- Business Plans Appraisal (Net Present Value, Internal Rate of Return, Economic Order Quantity, Simple payback)
- Design and implement an investment model - NPV (Net present Value)
- Introduction to Budgets
- Making Budget Template
- Making Actual Template
- Variance Reporting Template
- Reporting Template