team@referralroom.in; thereferralroom@gmail.com

Financial Modelling

Financial Modelling

2500

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.

Category:

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