Course Description

• Banking sector plays a very important role in the economic life of the country. You must be knowing how the health of the economy is closely related to the soundness of its banking system. Banks create no new wealth.
• But remember that their borrowing, lending and related activities facilitate the process of production, distribution, exchange and consumption of wealth.
• In this way they contribute to the process of economic development. Modern banks are very useful for the utilization of the resources of the country. So thus understanding the importance of the Banking sector we bring you this course on Financial Modeling and Valuation-Banking Sector of JP Morgan & Chase.

In this Course, you will learn about:

• Scenario of Banking Sector
• Calculation of Reserves, Capex, revenue, Costs, equity etc
• Financials and Valuations Analysis of Banking Sector

Target Audience for Financial Modeling and Valuation-Banking Sector

• Students
• MBA /BBA Finance students
• Equity Research Analysts keen on studying Banking Sector
• Finance Professionals
• Financial Analyst

Pre-requisites:

• Passion to learn about Financial Modeling of Financial Modeling – Banking Sector
• Computer with Internet Connection

How to access:-

Curriculum

Section 1: Banking Sector Overview

1                   Overview of Financial Institutions

Section 2: How are Banks Different

2                   Balance Sheet Difference

3                   Operation Vs Finance

4                   Overview of Building the Model

Section 3: Financial Statements Comparisons

5                   Balance sheet to Income statement

6                   Balance sheet to Income statement Continue

7                   Balance sheet to Income statement Ratios

8                   Securitization

9                   Income Statement comparison

10                Income Statement comparison Continue

11                Cash Flow statement Comparison

12                LLR Calculations

13                LLR Calculations Continue

14                LLR calculations Gross Charge offs

15                LLR calculations Change in Collateral

16                Download all Excel and PDF files

Section 4: Regulatory requirements

17                Regulatory Requirements Capital Adequacy

18                How well Capitalized are banks

19                Problems with Basel I

20                Basel II Norms

21                Basel III Norms

22                Download all Excel and PDF files

Section 5: Loan Portfolio Projections

23                Introduction to Loan Loss Reserve Projections

24                Calculating Growth rates for Loans

25                Forecasting Loan Values

Section 6: Loan Loss Reserve Projections

26                Loan Loss Reserve Effect of Loans

27                Loan Loss Reserve Understanding LLR

28                Loan Loss Reserve

29                Loan Loss Reserve Continue

30                Calculating Chargeoffs

31                Loan Loss Reserve

32                Loan Loss Reserve Continue

33                Calculating Recoveries continuation

Section 7: Balance Sheet Projections

34                Projecting Cash Deposits Securities Trading assets

35                Projecting Securities borrowed

36                Projecting Mortgage Servicing Rights

37                Projecting Balance Sheet Liabilities

Section 8: Interest bearing Assets and Liabilities

38                Introduction to Interest bearing assets liabilties

39                Calculating Interest bearing assets liabilties

40                Calculating Interest Rate Spread

Section 9: Income Statement Projections

41                Income Statement projections Introduction

42                Income Statement projections Revenue items

43                Income Statement projections

44                Income Statement projections Continue

45                Income Statement projections Expense items

Section 10: Cash Flow Statement Projections

46                Cash Flow StatementOperating activity

47                Cash Flow StatementOperating activity Continue

48                Cash Flow StatementInvesting Activity

49                Cash Flow StatementFinancing Activity

Section 11: Linking the Financial Statements

50                Linking the Financial Statements

51                Federal Funds Calculations

Section 12: Capital Adequacy

52                Capital Adequacy Intoduction

53                Capital Adequacy Tier 1 Capital

54                Capital Adequacy Tier 2 Capital

55                Capital Adequacy Average assets

Section 13: Dividends Stock Repurchase

56                Dividends Stock Repurchase Introduction

57                Dividends Payout Ratio

58                Stock Repurchase

59                Calculating number of Stock Repurchase

60                Ending basic and Shares outstanding

Section 14: Public Comparables

61                Public Comparables Introduction

62                Calculating Return on Tangible equity

63                Comparing Multiples

Section 15: Dividend Discount Model

64                Dividend Discount Model introduction

65                Ending Common Equity

66                Tangible Common Equity

67                Cost of Equit Calculations

68                Finding Common Dividends

69                Discounting the Dividends

70                Terminal value calculations

71                Sensitivity Analysis

Section 16: Solution Sheets

72                Download all Excel and PDF files

Here is a sample for the course completion certificate which you will recieve after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.

Mail us at: [email protected] with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address