Financial Modeling

Colleagues, this Financial Modeling program enables you to assess and manage long-term projects requiring a thorough analysis, negotiations with investors, lenders, and partners. The financial model in MS Excel is the most important tool for planning, structuring, and analysis of a project. Here you pull up and summarize all available information on your expectations and forecast. Go through the path from a blank Excel workbook, discuss the best practice for financial modeling, dig into technical and financial aspects of the methods and ratios that we use in the model.. Skill-based training modules include: 1) Introduction and general principles - forecasts, costs, investments, reports, charts and CAPEX;. During the work your attention will be focused on this data, and meantime the model will be generating thousands of cells with numbers and ratios, going through revisions and even being passed from one analyst to another, 2) Assumptions - they fulfil two roles: provide data for the calculations and reports and link the model with research and analysis supporting your forecast. Every project is unique; there is no standard template for assumptions that fits them all, 3) Reports and Financing - work with three main financial reports and understand relations between project assumptions and those reports, choose a target capital structure, model a loan and generate an acceptable schedule to repay the loan, 4) Analysis and Presentation - Discounted cash flow analysis is a vital part of financial models for any capital investment – therefore the whole model is often called DCF model; calculate such important indicators as NPV or IRR, as well as to analyze the income expected beyond the range of your model, perform a fully-fledged what-if analysis and present a broad range of possible scenarios in one model, 5) Capstone Project - choose a real or fictious project, collect necessary data and build a model from a template provided here and submit your model for peer evaluation.

Enroll today (individuals & teams welcome): https://tinyurl.com/2ryuwajm 

Much career success, Lawrence E. Wilson - Financial Certification Academy