Description
Once we are through with the Advanced Excel, we will now learn on how to apply these to evaluate the financials of a company. All the important finance related concepts like time value of money, present & future values, and annuity payments are implemented in Excel. These will help us to construct the loan structures and thus we can understand the real working of the bank loans. We will also be able to decide which project to choose when presented with multiple project opportunities, also known as Capital Budgeting. We will also familiarize with the working of a FMCG company, by modelling using Pivot tables and slicers. Finally, our Capstone project – Building Model for a real-life Company from scratch i.e. from a blank Excel worksheet to a complete valuation model.
Topics to cover-
• Descriptive data analysis
• Time value of money
• Present and Future values
• Basic annuity payment
• Loan Schedules
• Cost of capital
• Capital Budgeting (NPV, IRR, Payback period, DPP)
• Modelling of a fast-moving consumer goods company
• BUILDING MODEL FOR A REAL COMPANY FROM SCRATCH- From a blank Excel worksheet to a complete valuation model
