This financial modeling course focuses on practical applications of corporate finance concepts using Microsoft Excel. It is designed to help learners understand how to evaluate investment decisions and build financial models step by step. The course begins with key investment appraisal techniques such as Net Present Value (NPV) and Internal Rate of Return (IRR), explaining how these tools are used to determine whether a project should be accepted or rejected. It also covers the payback period and discounted payback period, helping learners understand how quickly investments can recover their initial costs. Another important topic is the profitability index, which is used to compare the value created by different investment projects. The course also explains the Weighted Average Cost of Capital (WACC), which is essential for determining the discount rate used in valuation. In addition, learners are introduced to building a complete income statement in Excel, helping them understand financial reporting in a practical way. The course also includes loan amortization schedules and explains how debt repayments are structured over time. Finally, it introduces financial planning and analysis (FP&A) concepts, giving learners a strong foundation in financial decision-making and business analysis. By the end of this course, learners will be able to build and interpret financial models using Excel for real-world investment and corporate finance decisions.
