Home
Search results “Corporate credit analysis and financial modelling”
Sensitivity Analysis for Financial Modeling Course | Corporate Finance Institute
 
34:17
Sensitivity Analysis for Financial Modeling Course | Corporate Finance Institute Enroll in the full course to earn a certificate and advance your career: http://courses.corporatefinanceinstitute.com/courses/sensitivity-analysis-financial-modeling This advanced financial modeling course will take a deep dive into sensitivity analysis with focus on practical applications for professionals working in investment banking, equity research, financial planning & analysis (FP&A), and finance functions. Course agenda includes: Introduction Why perform sensitivity analysis? Model integration - Direct and Indirect methods Analyzing results Gravity sort table Tornado charts Presenting results By the end of this course, you will have a thorough grasp of how to build a robust sensitivity analysis system into your financial model. Form and function are both critical to ensure you can handle quick changes and information requests when you're working on a live transaction.
Introduction to Corporate Finance - FREE Course | Corporate Finance Institute
 
01:07:41
Introduction to Corporate Finance - FREE Course | Corporate Finance Institute Enroll in our FREE course to earn your certificate: http://courses.corporatefinanceinstitute.com/courses/introduction-to-corporate-finance Our Intro to Corporate Finance Course will teach you who the key players in the capital markets are, what the capital raising process looks like, the main business valuation techniques, types of valuation multiples, how to structure an M&A deal, how to finance an acquisition, types of equity securities, and an overview of career paths as well as how to prepare for interviews. -- FREE COURSES & CERTIFICATES -- Enroll in our FREE online courses and earn industry-recognized certificates to advance your career: ► Introduction to Corporate Finance: https://courses.corporatefinanceinstitute.com/courses/introduction-to-corporate-finance ► Excel Crash Course: https://courses.corporatefinanceinstitute.com/courses/free-excel-crash-course-for-finance ► Accounting Fundamentals: https://courses.corporatefinanceinstitute.com/courses/learn-accounting-fundamentals-corporate-finance ► Reading Financial Statements: https://courses.corporatefinanceinstitute.com/courses/learn-to-read-financial-statements-free-course ► Fixed Income Fundamentals: https://courses.corporatefinanceinstitute.com/courses/introduction-to-fixed-income -- ABOUT CORPORATE FINANCE INSTITUTE -- CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the top universities, investment banks, accounting firms and operating companies in the world. By taking our courses you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical with step-by-step instructions to help you become a first class financial analyst. Explore CFI courses: https://courses.corporatefinanceinstitute.com/collections -- JOIN US ON SOCIAL MEDIA -- LinkedIn: https://www.linkedin.com/company/corporate-finance-institute-cfi- Facebook: https://www.facebook.com/corporatefinanceinstitute.cfi Instagram: https://www.instagram.com/corporatefinanceinstitute Google+: https://plus.google.com/+Corporatefinanceinstitute-CFI YouTube: https://www.youtube.com/c/Corporatefinanceinstitute-CFI
Credit Analysis Models
 
49:09
Training on Credit Analysis Models by Vamsidhar Ambatipudi
Views: 3518 Vamsidhar Ambatipudi
How to Build a Financial Model in Excel - Tutorial | Corporate Finance Institute
 
22:48
How to Build a Financial Model in Excel - Tutorial | Corporate Finance Institute Learn how to build a financial model in Excel with our video course (part 1). Enroll in the FULL course to earn your certificate and advance your degree: http://www.corporatefinanceinstitute.com In this course you will learn to build a financial model from scratch by working in Excel and following along with the video. Upon successfully completing the course and all quizzes you will obtain your Financial Modeling Certificate from the Corporate Finance Institute. -- FREE COURSES & CERTIFICATES -- Enroll in our FREE online courses and earn industry-recognized certificates to advance your career: ► Introduction to Corporate Finance: https://courses.corporatefinanceinstitute.com/courses/introduction-to-corporate-finance ► Excel Crash Course: https://courses.corporatefinanceinstitute.com/courses/free-excel-crash-course-for-finance ► Accounting Fundamentals: https://courses.corporatefinanceinstitute.com/courses/learn-accounting-fundamentals-corporate-finance ► Reading Financial Statements: https://courses.corporatefinanceinstitute.com/courses/learn-to-read-financial-statements-free-course ► Fixed Income Fundamentals: https://courses.corporatefinanceinstitute.com/courses/introduction-to-fixed-income -- ABOUT CORPORATE FINANCE INSTITUTE -- CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the top universities, investment banks, accounting firms and operating companies in the world. By taking our courses you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical with step-by-step instructions to help you become a first class financial analyst. Explore CFI courses: https://courses.corporatefinanceinstitute.com/collections -- JOIN US ON SOCIAL MEDIA -- LinkedIn: https://www.linkedin.com/company/corporate-finance-institute-cfi- Facebook: https://www.facebook.com/corporatefinanceinstitute.cfi Instagram: https://www.instagram.com/corporatefinanceinstitute Google+: https://plus.google.com/+Corporatefinanceinstitute-CFI YouTube: https://www.youtube.com/c/Corporatefinanceinstitute-CFI
Excel Crash Course for Finance Professionals - FREE | Corporate Finance Institute
 
01:15:58
Excel Crash Course for Finance Professionals - FREE | Corporate Finance Institute Enroll in the FREE full course to earn your certification and advance your career: http://courses.corporatefinanceinstitute.com/courses/excel-crash-course-for-finance The ultimate Excel crash course for finance professionals. Learn all the Excel tips, tricks, shortcuts, formulas and functions you need for financial modeling in this free online course. Key concepts include: formatting, ribbon shortcuts, if statements, eomonth, year, paste special, fill right, fill down, auto sum, sumproduct, iferror, today(), concatenate, special numbers, vlookup, index, match, xirr, xnpv, yearfrac, and much more. -- FREE COURSES & CERTIFICATES -- Enroll in our FREE online courses and earn industry-recognized certificates to advance your career: ► Introduction to Corporate Finance: https://courses.corporatefinanceinstitute.com/courses/introduction-to-corporate-finance ► Excel Crash Course: https://courses.corporatefinanceinstitute.com/courses/free-excel-crash-course-for-finance ► Accounting Fundamentals: https://courses.corporatefinanceinstitute.com/courses/learn-accounting-fundamentals-corporate-finance ► Reading Financial Statements: https://courses.corporatefinanceinstitute.com/courses/learn-to-read-financial-statements-free-course ► Fixed Income Fundamentals: https://courses.corporatefinanceinstitute.com/courses/introduction-to-fixed-income -- ABOUT CORPORATE FINANCE INSTITUTE -- CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the top universities, investment banks, accounting firms and operating companies in the world. By taking our courses you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical with step-by-step instructions to help you become a first class financial analyst. Explore CFI courses: https://courses.corporatefinanceinstitute.com/collections -- JOIN US ON SOCIAL MEDIA -- LinkedIn: https://www.linkedin.com/company/corporate-finance-institute-cfi- Facebook: https://www.facebook.com/corporatefinanceinstitute.cfi Instagram: https://www.instagram.com/corporatefinanceinstitute Google+: https://plus.google.com/+Corporatefinanceinstitute-CFI YouTube: https://www.youtube.com/c/Corporatefinanceinstitute-CFI
Advanced Financial Analysis Setup - Excel Crash Course Part 5 of 7 | Corporate Finance Institute
 
25:34
Excel Crash Course for Finance Professionals - FREE | Corporate Finance Institute View full playlist: https://www.youtube.com/playlist?list=PLl3-0Xe_motSqc7469g3hPoyRymclkgIL Copyright © 2015 – 2019, CFI Education Inc. All Rights Reserved. Enroll in the FREE full course to earn your certification and advance your career: http://courses.corporatefinanceinstitute.com/courses/excel-crash-course-for-finance The ultimate Excel crash course for finance professionals. Learn all the Excel tips, tricks, shortcuts, formulas and functions you need for financial modeling in this free online course. Key concepts include: formatting, ribbon shortcuts, if statements, eomonth, year, paste special, fill right, fill down, auto sum, sumproduct, iferror, today(), concatenate, special numbers, vlookup, index, match, xirr, xnpv, yearfrac, and much more. -- FREE COURSES & CERTIFICATES -- Enroll in our FREE online courses and earn industry-recognized certificates to advance your career: ► Introduction to Corporate Finance: https://courses.corporatefinanceinstitute.com/courses/introduction-to-corporate-finance ► Excel Crash Course: https://courses.corporatefinanceinstitute.com/courses/free-excel-crash-course-for-finance ► Accounting Fundamentals: https://courses.corporatefinanceinstitute.com/courses/learn-accounting-fundamentals-corporate-finance ► Reading Financial Statements: https://courses.corporatefinanceinstitute.com/courses/learn-to-read-financial-statements-free-course ► Fixed Income Fundamentals: https://courses.corporatefinanceinstitute.com/courses/introduction-to-fixed-income -- About Corporate Finance Institute® -- CFI is a world-leading provider of online financial analyst certification and training programs and the FMVA™ designation. CFI’s financial modeling courses, programs, and certifications have been delivered to tens of thousands of individuals around the world to help them become world-class financial analysts. The financial analyst certification program begins where business school ends to teach you job-based skills for corporate finance, investment banking, corporate development, treasury, financial planning and analysis (FP&A), and accounting. CFI courses have been designed to make the complex simple by distilling large amounts of information into an easy-to-follow format. Our training will give you the practical skills, templates, and tools necessary to advance your career and stand out from the competition. Learn about the FMVA™ Certification Program: https://corporatefinanceinstitute.com/certifications/financial-modeling-valuation-analyst-fmva-program/ Explore CFI courses: https://courses.corporatefinanceinstitute.com/collections -- JOIN US ON SOCIAL MEDIA -- LinkedIn: https://www.linkedin.com/company/corporate-finance-institute-cfi- Facebook: https://www.facebook.com/corporatefinanceinstitute.cfi Instagram: https://www.instagram.com/corporatefinanceinstitute Google+: https://plus.google.com/+Corporatefinanceinstitute-CFI YouTube: https://www.youtube.com/c/Corporatefinanceinstitute-CFI
Link the 3 Financial Statements in Excel - Tutorial | Corporate Finance Institute
 
41:43
Link the 3 Financial Statements in Excel - Tutorial | Corporate Finance Institute Download Excel template: https://corporatefinanceinstitute.com/resources/knowledge/modeling/link-the-3-financial-statements-cfi-webinar/ The 3 financial statements are all linked and dependent on each other. In financial modeling, your first job is to link all three statements together in Excel, so it’s critical to understand how they’re connected. This is also a common question for investment banking interviews, FP&A interviews, and equity research interviews. -- FREE COURSES & CERTIFICATES -- Enroll in our FREE online courses and earn industry-recognized certificates to advance your career: ► Introduction to Corporate Finance: https://courses.corporatefinanceinstitute.com/courses/introduction-to-corporate-finance ► Excel Crash Course: https://courses.corporatefinanceinstitute.com/courses/free-excel-crash-course-for-finance ► Accounting Fundamentals: https://courses.corporatefinanceinstitute.com/courses/learn-accounting-fundamentals-corporate-finance ► Reading Financial Statements: https://courses.corporatefinanceinstitute.com/courses/learn-to-read-financial-statements-free-course ► Fixed Income Fundamentals: https://courses.corporatefinanceinstitute.com/courses/introduction-to-fixed-income -- ABOUT CORPORATE FINANCE INSTITUTE -- CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the top universities, investment banks, accounting firms and operating companies in the world. By taking our courses you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical with step-by-step instructions to help you become a first class financial analyst. Explore CFI courses: https://courses.corporatefinanceinstitute.com/collections -- JOIN US ON SOCIAL MEDIA -- LinkedIn: https://www.linkedin.com/company/corporate-finance-institute-cfi- Facebook: https://www.facebook.com/corporatefinanceinstitute.cfi Instagram: https://www.instagram.com/corporatefinanceinstitute Google+: https://plus.google.com/+Corporatefinanceinstitute-CFI YouTube: https://www.youtube.com/c/Corporatefinanceinstitute-CFI
Financial modeling in Excel - Working capital
 
13:39
Here we show how to model in Excel the Working Capital. This is part of our on-line course Financial Modeling for Business Analysts and Consultants. For more use the link to get 65% discout:http://bit.ly/FinancialModelStepByStep You can find more details on financial modeling in Excel in this post: https://badassconsultants.com/2018/09/26/how-to-create-a-finacial-model/ Check my all courses on Udemy: http://bit.ly/ManagementConsultingCourses And my profile on quora: https://www.quora.com/profile/Asen-Gyczew as well as on slideshare: https://www.slideshare.net/AsenGyczew Check my step by step guide how to model the whole financial model: https://badassconsultants.com/2018/09/26/how-to-create-a-finacial-model/ Check also my other business models in Excel 1. Restaurant model: https://www.youtube.com/watch?v=P3rrLgaaOLI 2. E-commerce model :https://www.youtube.com/watch?v=NjQrW--dfm0 3. Consulting Business model: https://www.youtube.com/watch?v=ijtVIZDb880 4. Financial modeling – capex and depreciation: https://youtu.be/g647Bz4nVe0 5. Retail model in Excel: https://www.youtube.com/watch?v=e_3HymWbj8w
Views: 6631 Startup Akademia
Corporate and Project Finance Credit Analysis and Short-cut Key Review
 
19:31
Find courses at http://financeenergyinstitute.com Find files at http://edbodmer.com
Views: 806 Edward Bodmer
CFA Level 2 Seminar: Structural Model and Reduced form Model of Credit Risk
 
43:27
Note: Credit Analysis Models has changed in Level II from 2018 to 2019. The 2018 reading had a very heavy focus on the structural model and the reduced form model. This is now gone in 2019, except for a small section. This seminar was done for the 2018 reading but is more than what is required for 2019.
Views: 5257 Mark Meldrum
How to Automate Fundamental Analysis with Excel VBA
 
09:31
This video covers automating financial statement analysis by using VBA Macros to automatically pull in financial statements from any company you want. This is the first version. The sequel will cover how to upgrade this macro to be even more user friendly. To book me to work on your financial projects or analysis, go here: www.arbogastadvisers.com/contact-us/ To follow my company on facebook go here: www.facebook.com/arbogastadvisers To subscribe for more videos like this, go here: https://www.youtube.com/user/TimevalueVideos
Views: 27675 TimevalueVideos
Revolutionalize Financial Model With Professional Financial Modeler (PFM)
 
01:11
Understand how PFM Certification can enhance your knowledge in financial modeling and analysis for valuation, project feasibility, credit and risk analysis. . . . . . . . Preference : pfm, finance, financial, certification, course, finance certification, financial certification, finance institute, finance modeling institute, finance institution, finance course, finance organization, finance model, financial model, finance professional, finance modeler, finance job, finance strategy, financial modeler, rjcons, rajawali konsulindo, pt rajawali konsulindo, ifmi, financial modeling institute, professional financial modeler
Credit Risk Modeling
 
51:29
Credit Risk Analytics is undoubtedly one of the most crucial activities in the field of financial risk management at the moment. With the recent financial downturn and the regulatory changes introduced by the Basel accords, credit risk analytics has been attracting greater attention from the banking and finance industries worldwide. Throughout the course of this webinar Bart Baesens will outline a multilevel architecture for credit risk analytics as follows: • Level 0: Data • Level 1: Model • Level 2: Ratings and Calibration Furthermore, Bart will discuss challenges across each of these levels such as data quality, model performance measurement and risk measure calibration.
Views: 98047 Bart Baesens
Overview of Financial Model
 
01:26
Find courses at http://financeenergyinstitute.com Find files at http://edbodmer.com
Views: 1236 Edward Bodmer
Credit Analysis and Lending Management (4th Edition) by M Sathye & J Bartle
 
02:08
Credit Analysis and Lending Management (Fourth Edition) by Milind Sathye & James Bartle Lending is one of the most important functions of any financial institution. If not managed properly, it can lead to credit quality problems, threatening the existence of the financial institution. To manage the lending function properly and mitigate credit quality problems, bank loan officers should be adequately trained in risk assessment techniques. No single textbook has previously covered credit risk analysis and lending management in a comprehensive and complete manner. 'Credit Analysis and Lending Management, Fourth Edition' is a comprehensive and complete textbook on credit risk management. It is divided into seven parts, containing 16 chapters and 5 case studies. Parts I & II present a framework for assessing and managing credit risk. Parts III & IV include chapters that deal with special types of lending: consumer lending, corporate lending, small business lending and international lending. Part V details credit risk management and measurement techniques, and problem loan management. Part VI then looks at other forms of finance, while Part VII contains the case studies. Throughout this text, learning objectives are clearly indicated at the beginning of each chapter, and the chapter content then directly addresses these objectives. Additionally, new concepts are developed in a brick-by-brick manner, and are then supplemented by clear and useful examples. This Fourth edition has been fully revised to address issues from the global financial crisis (GFC). It also contains new chapters on micro-finance, agricultural, and quantitative finance.
Views: 76 Mirabel Publishing
Top 5 Excel Features for Financial Modellers
 
07:49
In this video, we look at 5 Excel features that most financial analysts aren't even aware of. Find out what they are how to use them. (Video 8 of 8 for the course on Financial Modeling using Excel) To get CPD or CPE for this course, visit the Proformative Academy at www.proformative.com and use the COOK10 discount code to get a discount on your subscription. Learn more and become student at EF University for FREE - http://executivefinance.teachable.com/ Like us Facebook- https://www.facebook.com/exfinance/ Linkedin- https://www.linkedin.com/company/executive-finance Twitter- https://twitter.com/exfinance
Views: 59889 Executive Finance
Financial Modeling Quick Lesson: Cash Flow Statement (Part 1)
 
12:39
Learn the building blocks of a financial model. In this video, we'll build a cash flow statement given an income statement and balance sheet in Excel. To download the Excel template that goes with this video, go to http://www.wallstreetprep.com/blog/financial-modeling-quick-lesson-cash-flow-statement-part-1/ The accounting here is a simplified presentation of how the three major financial statements are inter-related and lays the foundation of financial statement models in investment banking. Many accounting questions that we see time and again in finance interviews are designed to test the understanding explained in this exercise.
Views: 394943 Wall Street Prep
Credit Risk Introduction
 
20:05
hese videos go through the syllabus objectives for the Financial Exams of ST5/F105/SA5/F205. They are raw, unedited and contain a large amount of opinion. I've taken a skeptical approach to the subject and my views may not be correct. Feel free to correct me in the comment section below. I'll be releasing a new video every day ----------------------------- Let's Keep in Contact ----------------------------- Hit the subscribe button if you would like to see more on Youtube. Join our Actuarial Science Community on Facebook - https://bit.ly/2AyCN1p MJ’s Udemy courses - https://bit.ly/2AyCUtR MJ's awesome website - https://www.mjactuary.com -----------------------------
Views: 34193 MJ the Fellow Actuary
Business Model
 
15:43
This video talk about a small integrate financial model on a start-up company. It has a case explaining how a start-up company can be eligible to raise fund if it meets the eligibility criteria set by the venture capitalist. Likewise you can get the video on equity valuation using discounted cash flow (DFC) analysis and comparable analysis, operational risk modeling, project finance modeling, fixed income modeling, and courses on analytics. You can find these videos uploaded. Visit here:-http://www.edupristine.com/ca/courses/financial-modeling/
Views: 1377 EduPristine
Commercial Bank Revenue Model: Loan Projections
 
21:30
In this tutorial Commercial Bank Revenue Model: Loan Projections, you’ll learn about the key revenue drivers for a commercial bank, with a focus on how to project its loan portfolio based on GDP growth, market share, and addressable loan market sizes. http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Table of Contents: 1:46: Overview of Revenue for a Bank 6:47: The Step-by-Step Process to Project Loan Growth 15:06: Calculating and Checking the Loan Size in Each Segment 19:39: Recap and Summary For pure-play commercial banks, the vast majority of their revenue will come from “Net Interest Income”: Interest Income on Loans, less Interest Expense paid on Deposits, Debt, and Other Funding Sources. KEY QUESTION #1: What will the bank’s Loans and Deposits be? KEY QUESTION #2: What will the bank’s Interest Rates Earned and Paid Be? Interest rates are a whole separate topic, and Deposits and Funding Sources are usually linked to Loans, so we’re going to focus on the key drivers behind Loans and Loan Growth here. More so than with “normal companies,” commercial banks’ fortunes are heavily linked to the overall economy. Higher GDP growth results in more transactions – more buying and selling – and to more borrowing by both consumers and businesses. A healthy bank will tend to grow its loans more quickly than the GDP growth rate – credit expansion leads economic expansion. So the first key driver of Loan Growth is GDP growth. Some banks might sell more effectively, might offer more favorable terms for lenders, or might have different lending standards, so market share also plays a role (this is key driver #2). The Step-by-Step Process to Project a Bank’s Loan Portfolio Step #1: Determine the sizes of a bank’s markets (e.g., Mortgages, Auto Loans, and Credit Cards) to calculate its market share(s). Step #2: Make each market a percentage of the country’s GDP. Step #3: Project how the country’s GDP changes in the future. Step #4: Project the bank’s market share in each segment and forecast each loan market as a percentage of the country’s GDP. Step #5: Calculate the Loan Size in each segment with GDP * Loan Market Size as a % of GDP * Bank’s Market Share. Steps 1 & 2: Sizing the Loan Markets Possible Sources: Bank’s IPO Prospectus, Industry Reports (UK – De Montfort Group), Bank’s Interim/Annual Reports or Earnings Calls, Equity Research… If you can’t find data on loan market sizes, make it less granular and look at Total Loans in the country instead and calculate the bank’s market share there. The goal is to get a rough sense of whether the bank’s market share is rising or declining over time. Step 3: Projecting GDP Growth You can find any country’s nominal GDP via sources like Wikipedia, Statista, the IMF/World Bank, etc. For the projections, you can consult with similar sources, but you should also consider different cases and think about what happens if growth continues as expected, what happens if it goes above expectations, and what happens if there’s a recession followed by a recovery. Step 4: Projecting Future Market Share and Addressable Loan Market Sizes Approach #1: Follow and extend historical trends (If the bank is losing/gaining market share, continue that; otherwise, keep it steady). Approach #2: Speak with people in the market, such as real estate brokers and new homeowners, and see if you can discern trends from them (“channel checks”). Approach #3: Look for outside sources such as equity research and buy-side research and see what they’re saying. Step 5: Calculating the Loan Size in Each Segment Loan Size = Nominal GDP * Loan Market Size as % of GDP * Bank’s Market Share The harder part is checking your numbers afterward – Do the estimates seem reasonable? Do they accurately reflect different outcomes? You often want the Base or Upside Case to be close to equity research/consensus/management estimates. And the Downside Case should be real (e.g., 2009-style recession) – negative GDP growth, not just 1% growth rather than 2%. RESOURCES: https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Bank-Loan-Projections-Before.xlsx https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Bank-Loan-Projections-After.xlsx https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Bank-Loan-Projections.pdf
7. Value At Risk (VAR) Models
 
01:21:15
MIT 18.S096 Topics in Mathematics with Applications in Finance, Fall 2013 View the complete course: http://ocw.mit.edu/18-S096F13 Instructor: Kenneth Abbott This is an applications lecture on Value At Risk (VAR) models, and how financial institutions manage market risk. License: Creative Commons BY-NC-SA More information at http://ocw.mit.edu/terms More courses at http://ocw.mit.edu
Views: 200709 MIT OpenCourseWare
Financial Modelling Training www.bgconsulting.com
 
01:41
BG Consulting provides the highest quality talent development solutions to the financial services sector. Based in London, we provide training all around the world. The key to our success is the extensive front line banking experience of our trainers combined with a proven track record in highly effective teaching. Our training courses cover a wide variety of disciplines across capital markets, cash and derivative products; corporate finance; accounting and financial analysis; and credit. Look to BG Consulting for financial modelling training, global banking training, investment banking training, and banking courses. Some types of training we do include financial markets training, derivatives training, derivatives courses, credit training and credit courses. For more information, visit www.bgconsulting.com.
How to Build a Forecasting Model in Excel - Tutorial | Corporate Finance Institute
 
19:24
How to Build a Forecasting Model in Excel - Tutorial | Corporate Finance Institute Enroll in the Full course to earn your certificate and advance your career: http://courses.corporatefinanceinstitute.com/courses/fpa-rolling-12-month-cash-flow-forecast-course Master the art of building a rolling 12-month cash flow forecast model in our Financial Planning & Analysis (FP&A) course. In this course you will learn to build a cash flow model from scratch complete with assumptions, financials, supporting schedules and charts. -- FREE COURSES & CERTIFICATES -- Enroll in our FREE online courses and earn industry-recognized certificates to advance your career: ► Introduction to Corporate Finance: https://courses.corporatefinanceinstitute.com/courses/introduction-to-corporate-finance ► Excel Crash Course: https://courses.corporatefinanceinstitute.com/courses/free-excel-crash-course-for-finance ► Accounting Fundamentals: https://courses.corporatefinanceinstitute.com/courses/learn-accounting-fundamentals-corporate-finance ► Reading Financial Statements: https://courses.corporatefinanceinstitute.com/courses/learn-to-read-financial-statements-free-course ► Fixed Income Fundamentals: https://courses.corporatefinanceinstitute.com/courses/introduction-to-fixed-income -- ABOUT CORPORATE FINANCE INSTITUTE -- CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the top universities, investment banks, accounting firms and operating companies in the world. By taking our courses you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical with step-by-step instructions to help you become a first class financial analyst. Explore CFI courses: https://courses.corporatefinanceinstitute.com/collections -- JOIN US ON SOCIAL MEDIA -- LinkedIn: https://www.linkedin.com/company/corporate-finance-institute-cfi- Facebook: https://www.facebook.com/corporatefinanceinstitute.cfi Instagram: https://www.instagram.com/corporatefinanceinstitute Google+: https://plus.google.com/+Corporatefinanceinstitute-CFI YouTube: https://www.youtube.com/c/Corporatefinanceinstitute-CFI
How to Build a Basic Financial Projection - Business Finance
 
10:31
http://GatewayCFO.com - Building a projection or budget for your business doesn't have to be a daunting task. Understanding your goals and tracking your progress against them can be a straightforward exercise, and doesn't have to require a ton of your time. In this video, Josh Turner with Gateway CFO Solutions shows you how to build a basic projection for your company's P&L or Income Statement. Business finance doesn't have to be complicated, and this screencast will quickly get you on the road to building your own financial projections. Be sure to visit GatewayCFO.com for more finance resources and tutorials that can help you achieve your profit potential, and to download a sample Excel template of this financial projection.
Views: 393840 GatewayCFO
Ratio Analysis, Financial Ratio Analysis in Excel
 
46:56
For details, visit: http://www.financewalk.com Ratio Analysis, Financial Ratio Analysis in Excel Financial Ratio Analysis Meaning- " The process of calculating the relationships between various pairs of financial statement values for the purpose of assessing a company's financial condition or performance is called ratio analysis." Users of Financial Analysis Financial Analysis can be undertaken by management of the firm, or by parties outside the firm like owners, creditors, investors and others. The nature of analysis will differ depending on the purpose of the analyst. • Trade creditors- are interested in firm's ability to meet their claims over a very short period of time. Their analysis will, therefore, confine to the evaluation of the firm's liquidity position. • Suppliers of long term debt- on the other hand, are concerned with the firm's long-term solvency and survival. They analyse the firm's profitability over time, its ability to generate cash to be able to pay interest and repay principal and the relationship between various sources of funds i.e. capital structure relationships. Long-term creditors do analyse the historical financial statements, but they place more emphasis on the firm's projected, or pro forma, financial statements to make analysis about its future solvency and profitability. • Investors -- who have invested their money in the firm's shares, are most concerned about the firm's earnings. They restore more confidence in those firms that show steady growth in earnings. As such, they concentrate on the analysis of the firm's present and future profitability. They are also interested in the firm's financial structure to the extent it influences the firm's earnings ability and risk. • Management - of the firm would be interested in every aspect of the financial analysis. It is their overall responsibility to see that the resources of the firm are used most effectively and efficiently, and that the firm's financial condition is sound.
Views: 114088 FinanceWalk
Using the Commercial Mortgage Loan Analysis Excel Model
 
13:29
See download link below. This model helps you size a mortgage loan, based on DSCR, LTV, and debt yield. It also includes a robust refinance analysis and sensitivity tool. Download the model here: https://www.adventuresincre.com/commercial-mortgage-loan-analysis-model/ View all of our real estate financial models: https://www.adventuresincre.com/library-real-estate-excel-models/
Views: 2184 Spencer Burton
Financial Analyst Interview Questions and Answers - For Freshers and Experienced Candidates
 
13:38
Learn most important Financial Analyst Interview Questions and Answers, asked at every interview. These Interview questions will be useful to all entry level candidates, beginners, interns and experienced candidates interviewing for the role of Financial Analysts across various domains like banking, financial, investment, statistical etc. The examples and sample answers with each question will make it easier for candidates to understand these conceptual, situational and behavioral interview questions.
Views: 40766 CareerRide
R tutorial: Intro to Credit Risk Modeling
 
03:59
Learn more about credit risk modeling with R: https://www.datacamp.com/courses/introduction-to-credit-risk-modeling-in-r Hi, and welcome to the first video of the credit risk modeling course. My name is Lore, I'm a data scientist at DataCamp and I will help you master some basics of the credit risk modeling field. The area of credit risk modeling is all about the event of loan default. Now what is loan default? When a bank grants a loan to a borrower, which could be an individual or a company, the bank will usually transfer the entire amount of the loan to the borrower. The borrower will then reimburse this amount in smaller chunks, including some interest payments, over time. Usually these payments happen monthly, quarterly or yearly. Of course, there is a certain risk that a borrower will not be able to fully reimburse this loan. This results in a loss for the bank. The expected loss a bank will incur is composed of three elements. The first element is the probability of default, which is the probability that the borrower will fail to make a full repayment of the loan. The second element is the exposure at default, or EAD, which is the expected value of the loan at the time of default. You can also look at this as the amount of the loan that still needs to be repaid at the time of default. The third element is loss given default, which is the amount of the loss if there is a default, expressed as a percentage of the EAD. Multiplying these three elements leads to the formula of expected loss. In this course, we will focus on the probability of default. Banks keep information on the default behavior of past customers, which can be used to predict default for new customers. Broadly, this information can be classified in two types. The first type of information is application information. Examples of application information are income, marital status, et cetera. The second type of information, behavioral information, tracks the past behavior of customers, for example the current account balance and payment arrear history. Let's have a look at the first ten lines of our data set. This data set contains information on past loans. Each line represents one customer and his or her information, along with a loan status indicator, which equals 1 if the customer defaulted, and 0 if the customer did not default. Loan status will be used as a response variable and the explanatory variables are the amount of the loan, the interest rate, grade, employment length, home ownership status, the annual income and the age. The grade is the bureau score of the customer, where A indicates the highest class of creditworthiness and G the lowest. This bureau score reflects the credit history of the individual and is the only behavioral variable in the data set. For an overview of the data structure for categorical variables, you can use the CrossTable() function in the gmodels package. Applying this function to the home ownership variable, you get a table with each of the categories in this variable, with the number of cases and proportions. Using loan status as a second argument, you can look at the relationship between this factor variable and the response. By setting prop.r equal to TRUE and the other proportions listed here equal to FALSE, you get the row-wise proportions. Now what does this result tell you? It seems that the default rate in the home ownership group OTHER is quite a bit higher than the default rate in, for example, the home ownership group MORTGAGE, with 17.5 versus 9.8 percent of defaults in these groups, respectively. Now, let's explore other aspects of the data using R.
Views: 36054 DataCamp
CFA Level II- Analysis of Financial Institutions  - Part I
 
21:39
To know more about CFA/FRM training at FinTree, visit: http://www.fintreeindia.com For more videos visit: https://www.youtube.com/c/FintreeIndia?sub_confirmation=1 CFA | FRM | CFP | Financial Modeling Live Classes | Videos Available Globally Follow us on: Facebook: https://www.facebook.com/FinTree/ Instagram: https://www.instagram.com/fintree_education/ Twitter: https://twitter.com/Fin_Tree Linkedin: https://www.linkedin.com/company/fintree-education/ We love what we do, and we make awesome video lectures for CFA and FRM exams. Our Video Lectures are comprehensive, easy to understand and most importantly, fun to study with! This Video lecture was recorded by our Lead Trainer for CFA, Mr. Utkarsh Jain, during one of his live Session in Pune (India). To know more about CFA/FRM training at FinTree, visit: http://www.fintreeindia.com
2015-FRM : Stress Testing Part 1(of 2)
 
09:55
FinTree website link: http://www.fintreeindia.com This series of video's discusses following key points : 1) Purposes of stress testing and the process of implementing a stress testing scenario 2) Event-driven scenarios and portfolio-driven scenarios 3) Common one-variable sensitivity tests 4) Drawbacks to scenario analysis 5) Unidimensional and multidimensional scenarios 6) Various approaches to multidimensional scenario analysis 7) Sensitivity analysis and stress testing model parameters 8) Results of a stress test can be used to improve risk analysis and risk management systems We love what we do, and we make awesome video lectures for CFA and FRM exams. Our Video Lectures are comprehensive, easy to understand and most importantly, fun to study with! This Video lecture was recorded by our popular trainer for CFA, Mr. Utkarsh Jain, during one of his live FRM Part I Classes in Pune (India). FB Page link :http://www.facebook.com/Fin... #FRM #FinTree #Stresstesting
FRM: Altman's Z score for credit risk
 
08:06
Altman's Z is the most famous type of linear discriminant model: borrowers are classified into high or low default risk categories. It does not directly give a probability of default (PD), although we can map to the score to a credit rating and map the rating to a PD (so there is an indirect path from the score to the PD). Four drawbacks: 1. Not granular: only gives default/zone of ignorance/no default; 2. Constant factor weights (i.e., factor weights may be time varying); 3. Only considers five fundamental variables, ignores other variables; 4. No centralized database on defaulted business loans (not really an Altman's critique at all). For more financial risk videos, visit our website! http://www.bionicturtle.com
Views: 52139 Bionic Turtle
Top 5 Financial Certification in India | Career in Finance | Salary in Crores
 
04:29
Top 5 Financial Certification in India | Career in Finance | Salary in Crores Finance Related Videos [हिंदी में ] ► Highest Paying Jobs in India 2018✔ https://www.youtube.com/watch?v=zAa0w1eufLs ►CFP Certification Details - https://www.youtube.com/watch?v=NllUwgavLsw ✔ ►CFA Certification Details - https://www.youtube.com/watch?v=nYbYVjqSvUk ✔ ►CIMA Certification Details - https://www.youtube.com/watch?v=duw0G0MTdNk ✔ ►CA Complete Details - https://www.youtube.com/watch?v=dDGKtqYMc5Q ✔ ►CS Complete Details - https://www.youtube.com/watch?v=0HpnWt2URJg&t=3s ✔ ►Investment Banking Details - https://www.youtube.com/watch?v=tMYVaPFG4Kw ✔ ►Actuarial Science (Actuaries) - https://www.youtube.com/watch?v=y5Sodo-SHng ✔ ►MBA Complete Details Watch Full series - https://www.youtube.com/playlist?list=PLZDpJlybwPQ4wUplEdL6bL3pC1J_1Sk_s ✔ Follow us on : Facebook - https://www.facebook.com/PraveenDilliwala Twitter - https://twitter.com/praveendiliwala Instagram - https://www.instagram.com/praveendilliwala Subscribe Here- https://www.youtube.com/PraveenDilliwala
Views: 146086 Praveen Dilliwala
Financial Modelling - Sensitivity and Scenario Analysis
 
12:47
http://www.videofinancialmodelling.com/financial-modelling-sensitivity-and-scenario-analysis/ Shows how to setup a sensitivity, scenario or what-if analysis manager in a financial model.
What is FINANCIAL RISK MODELING? What does FINANCIAL RISK MODELING mean?
 
02:40
What is FINANCIAL RISK MODELING? What does FINANCIAL RISK MODELING mean? FINANCIAL RISK MODELING meaning - FINANCIAL RISK MODELING definition - FINANCIAL RISK MODELING explanation. Source: Wikipedia.org article, adapted under https://creativecommons.org/licenses/by-sa/3.0/ license. Financial risk modeling refers to the use of formal econometric techniques to determine the aggregate risk in a financial portfolio. Risk modeling is one of many subtasks within the broader area of financial modeling. Risk modeling uses a variety of techniques including market risk, value at risk (VaR), historical simulation (HS), or extreme value theory (EVT) in order to analyze a portfolio and make forecasts of the likely losses that would be incurred for a variety of risks. Such risks are typically grouped into credit risk, liquidity risk, market risk, and operational risk categories. Many large financial intermediary firms use risk modeling to help portfolio managers assess the amount of capital reserves to maintain, and to help guide their purchases and sales of various classes of financial assets. Formal risk modeling is required under the Basel II proposal for all the major international banking institutions by the various national depository institution regulators. In the past, risk analysis was done qualitatively but now with the advent of powerful computing software, quantitative risk analysis can be done quickly and effortlessly. Modeling the changes by distributions with finite variance is now known to be inappropriate. Benoît Mandelbrot found in the 1960s that changes in prices in financial markets do not follow a Gaussian distribution, but are rather modeled better by Lévy stable distributions. The scale of change, or volatility, depends on the length of the time interval to a power a bit more than 1/2. Large changes up or down, also called fat tails, are more likely than what one would calculate using a Gaussian distribution with an estimated standard deviation. Quantitative risk analysis and its modeling have been under question in the light of corporate scandals in the past few years (most notably, Enron), Basel II, the revised FAS 123R and the Sarbanes-Oxley Act, and for their failure to predict the financial crash of 2008.
Views: 1279 The Audiopedia
ESG in credit risk and ratings
 
01:37:42
Moderated by: Carmen Nuzzo, Senior Consultant, Credit Ratings Initiative, PRI Olivia Albrecht, Senior Vice President, ESG Portfolio Strategist, PIMCO Laurel Peacock, Senior Manager, Sustainability, NRG Orhan Sarayli, Managing Director, Barings Anne Selting, Senior Director, Global Infrastructure Ratings, S&P Global Ratings John Thieroff, Vice President, Senior Analyst, Corporate Finance Group, Moody’s Investors Service 01:07 PRI: Overview 09:43 S&P Global: Overview 28:56 Moody’s Investors Service: Overview 44:43 How are you integrating ESG in credit? 50:21 As a result of increased ESG integration, how have your organisations changed? 57:11 How, as a corporate and an issuer, are you coping with the increased demand for data? 01:00:50 How can we reconcile the need to do backtesting and modelling looking at the past to predict something that will happen in the future, if it happens? 01:04:48 How have we, as an industry, got a responsibility in soliciting the data? 01:09:39 What about using scenario analysis to provide long-term risk guidance? 01:16:08 When are ESG factors relevant to credit? 01:21:45 Q&A 01:34:02 What would you like to see changed in the next five years, which could make your job easier?
Views: 503 PRI
How to value a company using discounted cash flow (DCF) - MoneyWeek Investment Tutorials
 
10:50
Every investor should have a basic grasp of the discounted cash flow (DCF) technique. Here, Tim Bennett introduces the concept, and explains how it can be applied to valuing a company.
Views: 521448 MoneyWeek
Interview Questions and Answers - Finance
 
22:07
In this video I go through the questions from the practice finance interview and give you guidance, and hints and tips on how best to answer them.
Views: 78453 NanoTechTips
The Bankers Perspective: Modelling for Capital Raising
 
47:14
Do you know what kind of metrics and ratios a bank or investor looks for in a financial model? Hands-on working capital lending specialist Matthew Costello gave a short presentation on what lenders, investors and acquirers look for in a company’s financial models in terms of the financial ratios, sales pipelines and model stress testing from both a historical reporting and forecasting perspective. Matt Costello is Managing Director for Asia/Pacific for Greensill Capital, a specialist supply chain finance bank. With over a decade of experience in M&A, corporate advisory and now traditional corporate finance, Matt has assisted many businesses over the year raise debt or equity and ultimately sell.
Views: 188 plumsolutions
Reading Financial Statements into Python Pandas - Episode 4
 
18:24
How to Read Financial Statements (income statement) into Python Pandas from SimFin data for Value Investing Stock Analysis Series, Episode 4 Source Code: https://github.com/taewookim/YouTube/tree/master/Ep%20004%20-%20Reading%20Financial%20Statements%20into%20Pandas
Views: 2700 Taewoo Kim
Financial Modeling in Excel - Visualizing the Final Output
 
02:38
Academy of Financial Training's Video Tutorials on Financial Modeling in Excel. This video gives you the overview & explanation on the how the final output of the Program, i.e. a completed financial model will look like. It helps you note (a) the different worksheets of the completed model, (b) colour coding of worksheets to highlight / differentiate the varied sections of the final model... i.e. (i) Summary & Inputs to the model, (ii) Special Calculations for the model (iii) Output of the model in the form of Financial Statements, and (c) brief explanation on the contents and purpose of each of the sections. SUBSCRIBE for Updates on our Upcoming Training Videos Visit us: http://www.ftacademy.in/ About Us: Academy of Financial Training is training services company that specializes in providing a complete range of finance training services and solutions Since its incorporation AFT has trained more than 5,000 attendees in various finance domains, and is serving marquee Fortune 500 clients, making it one of the largest corporate training companies in India AFT's training modules include programs right from basic financial statements analysis to advanced financial modelling, corporate finance, risk management and capital markets, etc related trainings.
What is Financial Modeling ?
 
08:26
For online financial modeling course go to : https://www.educba.com/what-is-financial-modeling/ This video gives you a basic understanding of what financial modelling is and what goes inside it. CFA Institute has approved this program, offered by Corporate Bridge, for 20 CE credit hours. If you are a CFA Institute member, CE credit for your participation in this program will be automatically recorded in your CE tracking tool.
Views: 149840 eduCBA
Monte Carlo Simulation - NPV example
 
07:03
To Download , send me an email to [email protected] Recommended Books at Amazon: Building Winning Algorithmic Trading Systems, + Website: A Trader's Journey From Data Mining to Monte Carlo Simulation to Live Trading (Wiley Trading) https://amzn.to/2DAxOyZ Explorations in Monte Carlo Methods (Undergraduate Texts in Mathematics) https://amzn.to/2TfBCe2 Follow me at LINKED IN: https://www.linkedin.com/in/luisolano/ FACEBOOK: https://www.facebook.com/luisolanoms/ Monte Carlo Simulation in NET PRESENT VALUE (NPV) Let me know your comments, Thanks......
Views: 153276 Luis Olano
How to Build a Basic Financial Model in Excel
 
10:10
Here is a quick lesson on how to build a basic financial model in Excel 2016. In this video we focus on the P&L, or income statement. Course discount: https://www.udemy.com/excel-power-user/?couponCode=YOU-TUBE ________ We learn how to build a basic financial model, specifically an income statement. We'll review how to apply industry formats to assumptions and formulas to model clearly. All financial models in Excel begin with the income statement - or P&L. First we will build a set of assumptions, and then we will build a financial model based on our initial assumptions. If you'd like to learn more, I built a business-focused Excel course on Udemy that is stripped down to the core functions for being an analyst. The objective is to get people to the power-user level quickly. Check it out in the link above! The course is about 2 hours and includes things like: -completely abandoning the mouse to increase speed 3X -data manipulation & visualization -conditional statements & pivot tables For additional tutorials about Excel, check out my Quora profile: https://www.quora.com/profile/Eric-Andrews-5 For additional information about the course, check out my website: http://excelpoweruser.weebly.com/
Views: 151228 Eric Andrews
Credit Scoring and Retail Credit Risk Management
 
54:36
Training on Credit Scoring and Retail Credit Risk Management by Vamsidhar Ambatipudi
Views: 2076 Vamsidhar Ambatipudi
Financial Modeling and Valuation - Banking Sector
 
08:09
https://www.educba.com/ This Financial Modeling Course is based on the Financial Modeling Example of Banking Sector Modeling. This Financial Modeling Course includes professionally forecasting future financial statements like Income Statements, Balance Sheets & Cash Flows. A financial model consists of one or more input parameters along with data and formulas that are used to perform calculations or make predictions.
Views: 2997 eduCBA
Introduction to Financial Analysis
 
10:24
Quick Summary from Introduction to Financial Analysis course. You can take this course online at: http://www.exinfm.com/training/M1C2/
Views: 79927 Matt Evans
Credit Research at sCoolTV
 
03:01
CFA Institute has approved this program[/b], offered by Corporate Bridge, for 20 CE credit hours. If you are a CFA Institute member, CE credit for your participation in this program will be automatically recorded in your CE tracking tool. Credit research is a study responsible for analyzing the quality of debt issuers for all our in-house portfolios and bond funds. Credit research process evaluates an applicant's loan request or a corporation's debt issue in order to determine the likelihood that the borrower will live up to his/her obligations. Credit research analysts examine the financial history of an applicant in order to determine creditworthiness. This course will deal with the nuts and bolts of Credit Research. You will learn the followings: Analyze corporate credit risk and access appropriate returns. Understanding the Corporate Structure - Debt - Parent subsidiary relationship Subordinate loans/ secured - unsecured loans - Covenant Analysis Understand the Recovery Analysis using Multiple based coverage analysis & Asset based coverage analysis Learn the Debt Scenarios under Realistic, Distressed Scenarios and Debt Repayment Schedule Learn Deleveraging Analysis Return Calculations using IRR (for investment in Bonds)Learn to efficiently build revenue drivers of a few Sectors. Learn complex financial modeling by identifying and utilizing key business drivers and integrating them into a three statement forecasting model for a generic company https://www.scooltv.com/course/2981/
Views: 184 sCoolTV
Developing & Deploying Credit Risk Models with Anaconda | Hussain Sultan | AnacondaCON 2017
 
21:08
The talk will go over how we use Anaconda stack for credit analysis and model management integrating a disparate user group from data scientists to business analysts. Presented at AnacondaCON 2017 by Hussain Sultan, Capital One Download Hussain's slides here: https://www.slideshare.net/continuumio/developing-deploying-credit-risk-models-with-anaconda-anacondacon-2017
Views: 2902 Anaconda, Inc.