Tech in Finance - 2
(40 hours)
- To help students learn the tech skills, which will enable them to extract more insights from financial data, develop financial models, create visuals, improve reporting, make data-driven decisions, and thrive in a data-driven finance world.
- To link academia with industry requirements and make the students job ready from day one.
Course outcomes
-
At the end of the course, students should be ready to use MS Excel, Tableau, Power BI, and AI to create dashboards and visual presentations, analyse financial statements, and build models for valuation, M & A, LBO, Real Estate, Start Up and Project Finance.
COURSE SYLLABUS:
Objective:
- To use Tableau in construction and analysis of financial statements
Coverage:
Preparation of financial statements (Income Statement, Balance Sheet, Cash Flow Statement) from transactions and analyzing the same using Horizontal, Vertical & Ratio analysis.
Objective:
- To use Power BI in construction and analysis of financial statements
Coverage:
Preparation of financial statements (Income Statement, Balance Sheet, Cash Flow Statement) from transactions and analyzing the same using Horizontal, Vertical & Ratio analysis.
Objective:
- To evaluate the financial feasibility and returns of a real estate investment by forecasting cash flows, analyzing investment returns, and assessing risk over a holding period
Coverage:
Real Estate Modelling - Assumptions, Sources & Uses of funds, Projections, Proforma, Returns, Investment decision
Objective:
- To analyze the financial viability and returns of acquiring a company using a significant amount of debt financing.
Coverage:
LBO Modelling - Basic concepts, Assumptions, Projections, Structuring the cash flow, Debt schedule & Exit Valuation & IRR comparisons.
Objective:
- To forecast the financial performance and viability of a new business venture over time, based on assumptions about growth, costs, capital requirements, and funding.
Coverage:
Introduction, Understanding Business models, Logical flow of financial models, KPIs, Modelling for E commerce, B2C - Restaurants, SaaS Business, Media Business, etc.