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.
Credit Analysis Models
 
49:09
Training on Credit Analysis Models by Vamsidhar Ambatipudi
Views: 2213 Vamsidhar Ambatipudi
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.
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
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
Credit Analysis Overview and Sun Edison
 
26:46
Find courses at http://financeenergyinstitute.com Find files at http://edbodmer.com
Views: 153 Edward Bodmer
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: 85475 Bart Baesens
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: 616 Edward Bodmer
Miniperm Structuring and Credit Analysis Overview
 
14:36
Find courses at htpp://financeenergyinstitute.com Find files at htpp://edbodmer.com
Views: 73 Edward Bodmer
Overview of Financial Model
 
01:26
Find courses at http://financeenergyinstitute.com Find files at http://edbodmer.com
Views: 1196 Edward Bodmer
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: 345052 GatewayCFO
Debt Structuring Refinancing and Cash Sweep
 
20:55
Find courses at htpp://financeenergyinstitute.com Find files at htpp://edbodmer.com
Views: 1135 Edward Bodmer
Credit Research Modeling
 
05:04
https://www.educba.com/course/credit-research-modeling/ 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.
Views: 890 eduCBA
Monthly Corporate Model and Revolver
 
30:41
Find courses at http://financeenergyinstitute.com Find files at http://edbodmer.com
Views: 821 Edward Bodmer
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: 142852 eduCBA
Financial Modeling using Excel at sCoolTV
 
02:12
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. Financial Modeling 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. By changing the values of the input parameters, you can do "what-if" studies to see what happens when the inputs change. A Financial Model can help you in decision making whether to make investment in a company. It could also be used to represent the performance of a business, a project, or any other investment. Useful tools that allow business options and risks to be evaluated in a cost-effective manner against a range of assumptions. Helps in identifying optimal solutions and evaluating financial returns. This awesome course will deal with the followings: Learn professional analyst's accounting to evaluate historical and current trends of a company in excel. Effectively forecast trends and performance of the firm using analyst's tool like horizontal analysis, vertical analysis and ratio analysis. Learn complex financial modeling by identifying and utilizing key business drivers and integrating them into a three statement forecasting model for a generic company. Learn to efficiently build the financial model from scratch. https://www.scooltv.com/course/2901/
Views: 248 sCoolTV
Top 5 Excel Features for Financial Modellers
 
07:50
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: 46758 Executive Finance
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 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 If you are writing CT3/Exam P/Actuarial Statistics then you might be interested in this: Teachable - Statistics by MJ https://statistics-by-mj.teachable.com/p/stats-bundle 50% off for first 150 students: EARLYACCESS150 Instagram @statisticsbymj Discord Invite https://discord.gg/rgnAdDM
Views: 22523 MJ the Fellow Actuary
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: 362306 Wall Street Prep
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: 26552 DataCamp
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
Financial Analysis Fundamentals - Course | Corporate Finance Institute
 
02:08
Financial Analysis Fundamentals - Course | Corporate Finance Institute Enroll in the FULL course to earn your certificate and advance your career: http://www.corporatefinanceinstitute.com This four module course demonstrates how you can perform a financial analysis on any organization using a wide variety ratios derived from its financial statements. -- 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
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
Financial Analyst & Business Analyst Training Program
 
10:12
Advanced Excel ***** VBA (Macros) **** Access + SQL *** SAP FI/CO **** + * Interview Prep
Views: 226437 puresvideo
My book on Financial Modeling
 
03:07
#financialmodeling Mastering the art of financial modeling is imperative for those who want to enter the ultra-competitive world of corporate finance, in investment banking, private equity, or equity research. Only those who excel (pun intended) in modeling early on are often the most successful long-term. Having spent a decade in this field, am often asked to give pointers on how does one get initiated into the art and science of financial modelling So, here a primer on Financial Modeling for the uninitiated. # Introduction # Approach to Financial Modeling # Deep Dive into the Construction Phase # Guidelines for Creating an Effective Financial Model # Scenario Analysis and Sensitivity # Financial Modeling—Real Life Illustrations # Case Studies # Cash-Flow-at-Risk (CFaR) Model Kindle version https://www.amazon.in/dp/B07H6CDBH6 (In case you don’t have a Kindle, you can use Kindle for PC, Android and iPhone) Hard copy https://pothi.com/pothi/node/195705
Views: 913 Anurag Singal
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: 599 Spencer Burton
Banking Financial Modelling using Modeler.
 
01:05
Build an App with no coding using only MS Excel and Powerpoint!
Views: 489 Model Citizn
Financial Modeling   Paint Sector at sCoolTV
 
03:45
CFA Institute has approved this program[/b], offered by Corporate Bridge, for 3 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. This course is specific to Paint Sector Modeling. Financial Modeling 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. By changing the values of the input parameters, you can do "what-if" studies to see what happens when the inputs change. A Financial Model can help you in decision making whether to make investment in a company. It could also be used to represent the performance of a business, a project, or any other investment. Useful tools that allow business options and risks to be evaluated in a cost-effective manner against a range of assumptions. Helps in identifying optimal solutions and evaluating financial returns. This awesome course will deal with the followings: Learn professional analyst's accounting to evaluate historical and current trends of a company in excel. Effectively forecast trends and performance of the firm using analyst's tool like horizontal analysis, vertical analysis and ratio analysis. Learn complex financial modeling by identifying and utilizing key business drivers and integrating them into a three statement forecasting model for a generic company. Learn to efficiently build the financial model from scratch. https://www.scooltv.com/course/2881/
Views: 48 sCoolTV
Investment Banking Interview Preparation
 
57:13
This is an overview of what to expect in a first round investment banking interview.
Views: 161025 Paul Pignataro
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: 47910 Bionic Turtle
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: 98706 Avadhut Nigudkar
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.
Financial Modeling Jobs
 
04:13
For full text article go to : https://www.educba.com/financial-modeling-jobs/ This talks about "What are the Financial Modeling jobs? and how to get job in Investment banks/Large analytic companies/credit rating companies/project finance companies?
Views: 3480 eduCBA
Sensitivity Analysis - An Effective Financial Analysis Tool for Project Appraisal
 
09:44
The video explains the concept of Sensitivity Analysis.
Views: 2601 Ns Toor
5. How to create the credits analysis sheet
 
14:59
http://www.magicmoneytips.com YOU HAVE FULL RIGHTS TO SHARE THIS VIDEO ON TWITTER, ON YOUR BLOG ETC. This video continues with the creation of the credit analysis part of the overall bank account/cash account analysis spreadsheet. If you like this training you have my express permission to Tweet the link or embed the video in your blog/website.
Views: 7436 Gareth Thomas
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: 182 sCoolTV
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.
Credit Indices
 
13:05
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 frontline 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
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: 2577 eduCBA
Sensitivity Analysis in Term Loan Appraisal
 
07:28
Install our android app CARAJACLASSES to view lectures direct in your mobile - https://bit.ly/2S1oPM6 Join my Whatsapp Broadcast / Group to receive daily lectures on similar topics through this Whatsapp direct link https://wa.me/917736022001 by simply messaging YOUTUBE LECTURES Did you liked this video lecture? Then please check out the complete course related to this lecture, Banking Credit Analysis Process with 240+ Lectures, 17+ hours content available at discounted price (10% off)with life time validity and certificate of completion. Enrollment Link For Students Outside India: https://bit.ly/2wcpBMk Enrollment Link For Students From India: https://www.instamojo.com/caraja/banking-credit-analysis-process/?discount=inybcap68 Our website link : https://www.carajaclasses.com ---------------------------------------------------------------------------------------------------------------- BEST FOR CREDIT ANALYSIS THIS IS BEST LECTURE EXPLAINED IN SIMPLE METHOD WITH EXAMPLES FOR CREDIT PROFESSIONAL.Also it would def help on the job purpose as well.Would def recommend ------------------------------------------------------------------------------------------------------------------ Credit Analysis is the core process adopted by any Bank to understand, evaluate and appreciate about the Customers Identity, Integrity, Financial Position, - Repayment Capacity, Etc. Every Banker should be through with Credit Analysis Process because day in day out they have to deal with new customers and before sanctioning any new loans to them, Banker should have made detailed study of their customers. No Banker can raise to top unless he becomes conversant with Credit Analysis Process. Bank would generally throw employees on to the job before they get opportunity to be trained. This is with more specific reference to Credit Analysis where Bankers should under detailed learning process, else their mistakes in the process will be Very Costly beyond their manageable Position. Hence, this course will provide platform to Bankers to have fall back reference on the Critical Aspects of Credit Analysis Process, Banking/ Management Consultants can also use this course for the equipping themselves to the expectations of the Bankers while handling Credit Proposals. This Course has been Structured in self paced Learning Style. Learners can Learn Credit Analysis process at their own time, Convenience and place. Materials used in this Course will enable the participants to understand credit Analysis Process with almost Clarity. • Category: Business What's in the Course? 1. Over 171 lectures and 11 hours of content! 2. By taking this Course you will Understand, What is Credit Analysis 3. By taking this Course you will Understand, What is Working Capital Cycle 4. By taking this Course you will Understand, What is Project Financing 5. By taking this Course you will Understand, Detailed Process of Credit Analysis Course Requirements: 1. No prior knowledge is required for taking this course. 2. Students need PC / Laptop / Tab / Mobile (supporting Android / iOS) to view this course Who Should Attend? 1. Bankers 2. Consultants(Management/Banking/Finance) 3. Finance Managers 4. Entrepreneurs looking for Raising Funds 5. Department Heads 6. Chartered Accountants
Views: 597 CARAJACLASSES
Credit Analysis and Debt Default in Mini-perm
 
16:18
Find courses at http://financeenergyinstitute.com Find files at http://edbodmer.com
Views: 42 Edward Bodmer
Cash Flow Model Tutorial - Scenarios, DCF, Capital Structure, Debt Model, Balance Sheet, P&L
 
13:05
Hello! This is a quick overview of an extended financial model I put together. You can download the free Excel template from http://www.challengejp.com/excel-tutorials.php#financial-extended. If you have any questions or suggestions feel free to email me at [email protected] or leave a comment below. Enjoy the video and let me know if you find it useful:)
Views: 448 Jacek Polewski
Chris Barrow - Financial Modelling
 
03:20
http://www.jspmediagroup.com Learn Chris Barrow's 8 outcomes - the 2nd is: Financial Modelling: Understand your accounts, cash flows, KPIs and profitability models. * Review and understanding of your existing profit & loss statement * Understanding key performance indicators * Which numbers to monitor * How you compare against industry averages * Measuring the average productivity of all fee-earners * Negotiating rates of pay for associates, therapists and hygienists * Establishing production targets and monitoring systems * Calculating your prices * Zoning the appointment book to maximise productivity * Creating budget versus actual cash flow forecasts * Help with the creation of business plan and finance proposals * Measuring the return on investment of your marketing spend
Views: 2466 JSPMediaGroup
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: 954 The Audiopedia
Project Finance Working Analysis
 
52:41
Find courses at htpp://financeenergyinstitute.com Find files at htpp://edbodmer.com This case illustrates how to use MATCH. INDEX and LOOKUP to develop project finance model Capital expenditues, revenues and expenses.
Views: 6208 Edward Bodmer
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: 3985 Startup Akademia