Financial Modeling in Excel

Learn about Excel financial modeling, including cash flow, scenario analysis, time value, and capital budgeting.

This course is designed to transform you into a proficient financial analyst using Excel. Starting with the fundamentals of cash flow analysis, you will learn to construct financial models, calculate net income, and deconstruct income statements, laying a strong foundation in financial modeling. The course then progresses to advanced scenario analysis techniques, teaching participants to forecast different outcomes and conduct sensitivity analyses using Excel's diverse functionalities. A key component of the course is mastering the time value of money, a crucial concept in financial decision-making, where students will learn to calculate present and future values with precision. The final segment focuses on capital budgeting skills, equipping you with the ability to make data-driven decisions using key metrics like net present value and internal rate of return, and to provide actionable recommendations in various financial scenarios. By the end of the course, you will not only grasp complex financial concepts but also possess the practical skills to apply them effectively, becoming adept at financial modeling in Excel.

• Financial modeling
• Use financial data from an income statement to create a financial model to forecast income, expenses, and net income and evaluate the purchase and sale price of the property using dynamic modeling features.
• What-if Analysis in Financial Models
• Use Excel’s What-If toolkit to enhance the power of financial modeling. Analyze and compare different hypothetical scenarios with the Scenario Manager, Goal Seek, and Data Table tools.
• Time Value of Money
• Time is money! Use the time value of money to analyze cash flows through the lens of an investor with return on investment, future value, and present value.
• Capital Budgeting
• Prioritize projects and make actionable investment recommendations using capital budgeting techniques. Calculate the net present value and the internal rate of return for the acquisition of West Ridge North.