Spreadsheets for Business Analysis and Decision Making
Spreadsheets are computer driven power tools for business analysis and decision making. Having facility with spreadsheets gives you the ability to create and plan projects and present them to bosses or investors with supporting analysis.
This seminar is a companion to the Finance series and is a must for entrepreneurs and corporate managers and those aspiring to be either.
This is a hands-on workshop and we will use Excel to create financial templates and do the calculations. You will leave this seminar with real skills you can apply ASAP!
Finance can be split into two categories
- Financial Statement Analysis
- Time Value of Money
This seminar will get you familiar with the concepts of
- Payback period,
- Break even analysis,
- Net Present Value and
- Internal Rate of Return.
You will understand how to how to determine whether a project is worth undertaking and investing in.
This is a hands-on workshop and we will create spreadsheet templates and use Excel and its formulas to prepare financial forecasts and calculate NPV and IRR.
Valuation and Capital Budgeting Tools for analysis, presentation, and decision-making
Corporate Finance encapsulates the twin disciplines of how to cost effectively raise money for an enterprise and how to analyze projects and equipment investments in order to allocate those funds to the best projects.
Spreadsheets are the tools and format for actually making these decisions.
Learn how to structure and calculate the analytic concepts of finance
The key to raising funds is properly valuing the enterprise. This involves understanding and being able to employ the tools of estimating a stream of future cash flows and translating them into today’s dollars.
Capital Budgeting is the technique of deciding whether the future benefits of investing in a project, or expansion, or piece of equipment is more than its cost.
Learn how you can use Net Present Value to translate an investment’s value into today’s dollars
- Time Value of Money
- Interest Rates
- Risk vs. Return
- Free Cash Flow
Economics is the study Decision Making and Allocating Scarce Resources to their best use.
Finance is the tools for making these decisions in an analytical fashion.
The scarce resources that are analyzed are
And the relationship between time and money is known as the Time Value of Money
This relationship is quantified as Interest Rates
The two types of decisions we make, and measure the performance of, in Finance relate to:
We use spreadsheets to calculate and quantify these decisions. Check out the seminar on the basics of corporate finance for the theoretical underpinning of spreadsheet analysis.