Financial Modeling & Valuation with Real Indian Examples
Excel based simulations with step by step guide to financial modeling
We introduce a new way to learn finance skills - "by doing". Our online personalized finance lab, www.equitylevers.com, provides excel based real time simulations in a range of finance subjects using examples of Indian listed companies. A logical extension to textbooks and real practice with excel so that work skills could be developed alongside knowledge.
Curriculum mapping: We offer 140 simulations across 10 important finance subjects. Our complete set of skill simulations mapped as per AICTE Course Curriculum subjects can be found Here and the demo of the structure and content of the simulations can be found here. For further information, please write to us at founder@equitylevers.com
Our Simulations for Teaching/ Testing Skills in Financial Modeling and Valuation
Financial modeling is best learnt by building live financial models. Our set of simulations cover basics of financial analysis, integrated financial statements, forecasting financial statements and understanding various valuation methods.
If you are an institute or individual instructor/professor, you can assign skill tests/ certifications to the students. These skill tests/certifications will be bundle of 2-3 simulations. When you assign it as a certification, student will have additional access to supporting study material and video solution (Recording of a simulation as solved by an expert without any audio). Click here to explore our skill library.
Below is the link to introduction of our full certification (20 Simulations) on Financial Modeling & Valuation.
Topics covered in our Financial Modeling & Valuation Certification:
Understanding Financial Formulae
Rule of 72
Ratio Analysis
Financial Analysis
Ratio Comparison
Cash Flow Preparation
Integrated Financial Statements (Projecting income statement and balance sheet to prepare cash flow statement)
Computation of WACC
Computation of Beta
Discounted Cash Flow Valuation
Dividend Discount Model
Comparable Company Method
Residual Income Valuation
Economic Value Added
Earnings Power Valuation
Piotroski Score Computation
Building complete financial model leading to valuation
Understanding funding cap table for Unacademy
Valuation of Chennai Super Kings (As of FY2018)
Equity Portfolio Game
The simulations are designed in excel with examples of Indian listed companies. We have also covered two interesting case studies on unlisted companies - valuation of Chennai Super Kings and understanding startup cap table for Unacademy. The Financial Modeling & Valuation certification is suitable for intermediate and advanced users with basic knowledge of financial analysis and valuation.
The projects are engaging amongst students and feedback is very strong.
“Why solve projects and not just listen to videos”
While, we could have just created a video to explain the financial modeling and valuation process, but we have designed this as simulations so that each student can be deeply involved in the case and solve. Solving a case has better learning outcome. The simulations comes with scoring features and can be used as exams also.
A brief overview of select cases :
Comprehensive Financial Analysis - A comprehensive financial analysis of a company involves a thorough review of over 20+ financial data points and ratios . In this simulation one will review in detail 20+ financial parameters for live listed company. This simulation will require to compute and answer 50+ questions before reaching a conclusion on the company. This simulation has been built to provide a glimpse of real world comprehensive financial analysis.
Financial Statement Projection - A key skill for a finance analyst is to learn the art of making financial projections using excel. For eg. how is the revenue projected in the future, how the margins will pan out, what will be the impact on net profits - these are very important questions in everyday finance work environment. In this simulation you will be required to forecast the profit & loss statement, balance sheet and cash flow based on assumptions and live data provided.
CSK Valuation - Chennai Super Kings is one of the most successful IPL franchise. In this simulation we will understand the business of the franchise, its sources of revenue and costs. You will be required to build a financial model for CSK based on the information provided as of FY 2018.
Equity Simulation Game - Play a live portfolio game where you will be investing for the period of 1 year. Based on fundamental ratios select best performing stocks from the list of different stocks to build your own Equity Portfolio. In this game you will be given list of stocks along with its historical data as of last year. Company names will be kept hidden and the end result will show the portfolio return based on latest stock prices.
many more…
About EquityLevers: We are AICTE approved.
“Learning by doing” has been scientifically proven as the best way to learn any subject or skill whatsoever. We at EquityLevers strongly believe that mastering financial concepts is very much like learning to play cricket or learning to dance -- the more time one would spend in solving real-life problems, the deeper would be his/her understanding. EquityLevers offers 140 basic to advanced finance skill projects in Excel across 10 major finance subjects including Investor Education, Personal Finance, Accounting, Financial Analysis, Corporate Finance, Bond and Fixed Income Markets, Valuation and Modelling Mutual Funds and Wealth Management, Managerial Accounting, Finance for Marketing and Operations Managers, Derivatives and Risk Management. The projects are set in Indian context with real-time data from companies to help prepare for job roles in investing, accounting, treasury, trading, wealth management and so on. Each learner gets personalized real data set to solve in most of the skill simulations.
Thank you for reading.