Build a fully integrated financial statement projection model with income statement projections, a self-balancing balance sheet, an automated cash flow statement, and the balancing cash flow sweep/debt schedule. While knowledge of advanced accounting concepts is not required for this course, you should possess knowledge of basic accounting ratios and a basic understanding of how the major financial statements are inter-related. Emphasis is placed on the integration of the major financial statements and becoming experts in Excel. Incorporate different methodologies to forecasting the different types of assets on the balance sheet and compare and contrast with projecting liabilities. Learn how to balance a model utilizing the debt sweep and the revolver and not using any “plugs”. Appreciate the danger of and properly control for circular references. Avoid messy nested “if” statements!! You will leave the classroom with a fully constructed model that can be customized and applied to other companies. The final model is a fully scalable model that can be added upon.
ADMIN