Home
Search results “Investment models excel”
Financial Modeling Quick Lesson: Building a Discounted Cash Flow (DCF) Model - Part 1
 
11:07
Learn the building blocks of a simple one-page discounted cash flow (DCF) model consistent with the best practices you would find in investment banking. If you are preparing for investment banking interviews, know that the DCF is the source of a TON of investment banking interview questions. To download the backup Excel file, go to www.wallstreetprep.com/blog/financial-modeling-quick-lesson-building-a-discounted-cash-flow-dcf-model-part-1/ The DCF modeled here is a simplified version of a fully-integrated DCF model. For a deeper dive into DCF modeling in Excel, please visit www.wallstreetprep.com.
Views: 341468 Wall Street Prep
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
Value-Add Hotel Investment Model in Excel
 
22:46
To download this Hotel Investment Model, to here: http://www.adventuresincre.com/hotel-valuation-model/ For more information about the author, see: http://www.spencerburton.org
Views: 10039 Spencer Burton
Excel Shortcuts Investment Banking: Quick Tips
 
10:11
You’ll get a quick, but very powerful, tip on how to optimize your Excel setup with the Quick Access Toolbar (QAT) and custom shortcuts in this tutorial. These tips will save you a ton of time when creating valuations, organizing data, and doing any formatting exercise. http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Shortcuts Introduced: These are all BUILT-IN shortcuts: Alt, T, O: Options Menu Alt, H, FC: Font Color Alt, H, FS: Font Size Alt, H, H: Fill Color Alt, H, A, C: Center Alt, H, B: Borders Alt, H, O, I: AutoFit Column Width Alt, H, O, W: Column Width Alt, H, 0: Increase Decimal Places Alt, H, 9: Decrease Decimal Places These are the NEW shortcuts you can create via the Quick Access Toolbar: Alt, 1: Font Color Alt, 2: Font Size Alt, 3: Fill Color Alt, 4: Center Alt, 5: Borders Alt, 6: AutoFit Column Width Alt, 7: Column Width Alt, 8: Increase Decimal Places Alt, 9: Decrease Decimal Places Lesson Outline: Many Excel shortcuts that you use repeatedly when creating valuations, models and when formatting data are cumbersome to enter. Something as simple as changing the font color takes 4 keystrokes – Alt, H, F, C – if you use the built-in method for it. Other common commands such as alignment, fill colors, borders, and column widths also take 3-4 keystrokes. A more efficient alternative is to set up the Quick Access Toolbar (QAT) so that you can access the most common commands with shortcuts like Alt, 1 instead. You can either import our file (see the link below under RESOURCES) or go to the Options menu (Alt, T, O) and then the Quick Access Toolbar tab, and create the menu yourself. We recommend setting “Font Color” in position #1, followed by Font Size, Fill Color, Center, Borders, AutoFit Column Width, Column Width, and Increase and Decrease Decimal places. These are some of the most frequently used commands in Excel, and you’ll save a ton of time with the new, shorter versions. A command like AutoFit Column Width that used to take 4 keystrokes now takes only 2 (Alt, 6) with this approach. You might realize 30-40% time savings when working in Excel if you use this full set of shortcuts. They’re especially useful for formatting and analyzing data and doing the initial setup in financial models. RESOURCES: https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Excel-QAT-Export.exportedUI https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Excel-Shortcuts-Investment-Banking-Slides.pdf
Real Estate Acquisition Model for Office, Retail, or Industrial Properties
 
23:53
A basic real estate valuation model for office, retail, or industrial deals built in Microsoft Excel. The model includes a simple DCF module to calculate cash flows over the hold period, as well as an equity waterfall module for calculating partnership returns. You can download the model for free here: http://www.adventuresincre.com/real-estate-acquisition-model-for-office-retail-or-industrial-properties If you have any questions or comments, feel free to contact the author, Spencer Burton, at http://www.spencerburton.org
Views: 36496 Spencer Burton
Investment Banking 101: Operating Model
 
01:18:05
In this episode of the financial modelling series Sergey, ex-Goldman Sachs investment banker, will describe how to build an operating model for a start-up company with the step-by-step financial modelling guide. 00:47 income statement assumptions total revenue cost of goods sold research & development sales & marketing general & administrative expenses other expenses 26:00 balance sheet assumptions operating assets operating liabilities capex & depreciation schedule other assumptions 37:35 income statement revenue gross profit operating expenses operating income ( EBIT) prfoit before taxes net income 49:10 balance sheet assets liabilities & shareholders equity 01:04:08 cash flow statement cash flow from operating activities Original Excel file with financial model can be found here: https://goo.gl/QScJgJ Our Investment Banking preparation course https://youtu.be/bBMmN8Cmq3g WANT TO GET INTO INVESTMENT BANKING? Join Sergey's course on Investment Banking Interview Prep https://edu.fless.pro/investment-banking-interview-prep-course SUBSCRIBE AND STAY WITH US! FLESS https://fless.pro Instagram https://www.instagram.com/flesspro Facebook https://www.facebook.com/flesspro VK https://vk.com/flesspro Telegram https://t.me/flesspro
Views: 5337 Fless
Single Family Residential Investment Model - Rental or Flip
 
24:29
This Excel spreadsheet is for performing financial analysis on single family investments, such as flipping homes or homes for rent. To download the model, visit: http://www.adventuresincre.com/single-family-residential-investment-analysis-model/ For more Excel real estate models, visit: http://www.adventuresincre.com/category/re-modeling/excel-models/ To contact Spencer Burton, visit: http://www.spencerburton.org
Views: 5085 Spencer Burton
Watch Me Build a Multifamily Real Estate Model
 
38:40
Watching others model is a great way to learn new tricks, and improve your own modeling abilities. I turned on my screen recorder and built a basic multifamily real estate model. Download the completed model here: https://www.adventuresincre.com/watch-build-multifamily-real-estate-model/ Learn more about the author: http://www.spencerburton.org
Views: 45189 Spencer Burton
Create an Investment Schedule in Excel
 
07:59
Video shows how to create an investment schedule in Excel
Views: 1707 Ronald Sweet
NPV and IRR in Excel 2010
 
09:00
Description: How to calculate net present value (NPV) and internal rate of return (IRR) in excel with a simple example. Download the excel file here: https://codible.myshopify.com/products/npv-and-irr-in-excel-2010-excel-files Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 811073 Codible
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
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
Sensitivity Analysis in Excel
 
02:18
How to do a sensitivity analysis in Excel with two input variables.
Views: 457527 financewithexcel
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.
How to Create Financial Scenarios in Excel
 
15:39
This tutorial analyzes advanced financial modeling tools provided by Excel 2010 to create multiple financial scenarios.
Views: 176169 edutechional
How to Create a Cash Flow Forecast using Microsoft Excel - Basic Cashflow Forecast
 
14:34
Create a basic cash flow forecast using excel. If you need help get in contact. www.bpfs-online.com Support this channel https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=FHGCUQ8GU9VB6 Take our Online Sage training course http://www.bpfs-online.com/p/online-sage-training-course.html Create a bookkeeping spreadsheet using Microsoft Excel http://youtu.be/LlWADbkGdac Sage Accounts Bookkeeping Tutorial/Training Learn more at www.bpfs-online.com
Views: 567530 BookkeepingMaster
481-F2 Use Excel to find Alpha and Beta of an Investment
 
09:19
How to find Beta, Sharpe Ratio, and Treynor Ratio in Excel.
Views: 21400 TimevalueVideos
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: 73519 Eric Andrews
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: 21172 TimevalueVideos
Building a Three Statement Financial Model: Part 1
 
52:25
In this video I show how to create a quick & dirty 3 statement model using Toys R Us as an example company. Sorry about the abrupt ending; please let me know if you have any questions! (Quick note:at the end that current liabilities should be added to Total Liabilities in row 26, K through N).
Views: 113084 josephlaurent
Simple LBO Model - Case Study and Tutorial
 
13:25
In this LBO Model tutorial, you'll learn how to build a very simple LBO model "on paper" that you can use to answer quick questions in PE (and other) interviews. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" This matters because in many cases, they'll ask you to calculate numbers such as IRR and multiple of invested capital very quickly and will not actually ask you to build a more complex model until later in the process. You should always START this exercise by looking at the actual question or set of questions they are asking you: "Calculate the purchase price required for ABC Capital to obtain a 3.0x multiple of invested capital (MOIC) if it plans to sell OpCo after five years at an EV / EBITDA multiple of 6.0x." So they're giving you the exit multiple and the return on investment that the PE firm is targeting, and you have to figure out the initial purchase price by "working backwards." Here's how we interpret each line in this case study and use it in the model: "OpCo currently has EBITDA of $250mm, and ABC believes that the new management team could keep EBITDA flat for the next 5 years." This tells you to make the initial EBITDA $250mm and keep it at that level for 5 years - skip revenue, COGS, OpEx, and everything else because none of that matters if this is all they give you. "ABC Capital has obtained debt financing of $750mm at 10% interest, and OpCo expects working capital to be a source of funds at $6mm per year." The initial debt balance is $750mm and there's a 10% interest rate, so the interest expense will be $75mm per year. In the "Cash Flow Statement Adjustments", since Working Capital is a SOURCE of funds it will add $6mm to cash flow each year. "OpCo requires capital expenditures of $35mm per year, and it has a tax rate of 40%. Assume no transaction fees, zero minimum cash required, and that PP&E on the balance sheet remains constant for the next 5 years." Also in the CFS section, CapEx = $35mm per year, and Depreciation also equals $35mm per year since the PP&E balance does not change at all. So you can also fill in the Depreciation figure on the Income Statement. No transaction fees and no minimum cash requirement simplify the purchase price and debt repayment - although we don't even have debt repayment here. "Assume that excess cash is NOT used to repay debt, and instead simply accumulates on the Balance Sheet." This makes the final numbers easier to calculate, since interest expense will never change and you can simply add up cash generated to get to the final cash number at the end. PROCESS: 1. Start with the Income Statement - EBITDA is $250mm per year. Subtract Depreciation of $35mm per year, and interest of $75mm per year. So EBIT = $140mm. Taxes = $140mm * 40%, so Net Income = $140mm - $56mm = $84mm. 2. On the simplified CFS, Net Income = $84mm, Depreciation = $35mm, Change in Working Capital = $6mm, CapEx = ($35mm), so Cash Generated per year = $90mm. 3. EBITDA Exit Multiple = 6.0x, and final year EBITDA = $250mm, so Exit EV = $1.5B. Subtract the outstanding debt of $750mm and add the cash generated in this period of $450mm, so Equity Proceeds = $1.2B. 4. Targeted MOIC = 3.0x so the PE firm would have to invest $400mm in the beginning. $400mm equity + $750mm debt = $1.150B, so the purchase multiple is $1,150 / $250 = 4.6x. Further Resources http://youtube-breakingintowallstreet-com.s3.amazonaws.com/109-04-Simple-LBO-Model.pdf http://youtube-breakingintowallstreet-com.s3.amazonaws.com/109-04-Simple-LBO-Model.xlsx
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
Forecasting Models with Excel
 
01:07
EXFINSIS Website: http://www.exfinsis.com/ Disclaimer: Course has an educational purpose and doesn’t constitute any type of investment or trading recommendation. All conclusions reflect solely its author’s opinions based on historical data and calculations. Past performance doesn’t guarantee future returns. Investment risk can possibly lead to its total loss for unleveraged products and even larger for leveraged ones. Therefore, its author isn’t responsible for any damages caused by using data, information, opinions or conclusions for investment or trading decisions; exclusively transferring all this responsibility to the viewer.
Ch04-01 Investment Problem Excel Model
 
14:43
This video is part of a lecture series available at https://www.youtube.com/channel/UCMvO2umWRQtlUeoibC8fp8Q
Views: 6795 Decision Making 101
Jensen's alpha definition for investment modeling
 
04:31
The definition, visualization and demonstration of a calculation of the Jensen's alpha in Excel. We discuss the two types of performance analysis: returns-based and holdings-based. For investment and financial modeling of stocks and portfolios. We discuss the use of the =AVERAGE function for returns and =STDEV.P for standard deviation, plus =INTERCEPT for the alpha measure. https://factorpad.com/fin/glossary/jensens-alpha.html Please note, here we use the method to source Jensen's Alpha from the regression. Many times the regression outputs are a given in the problem. If inputs are given, you can isolate the alpha term from the CAPM formula: Jensen's Alpha = (Portfolio Return - Risk Free) - Portfolio Beta * (Market Return - Risk Free) Topics covered in our investment glossary: Excel tutorial, Python examples, portfolio theory, portfolio return, portfolio risk, correlation, regression, linear algebra, alpha signal, risk models, performance attribution. Glossary: https://factorpad.com/fin/glossary/index.html Innovators: https://factorpad.com/fin/innovators/index.html https://factorpad.com
Views: 2415 FactorPad
Build an IRR Matrix for Real Estate in Excel
 
15:23
How to build a simple tool in Excel - the IRR Matrix - to analyze the internal rate of return of a real estate investment in each year of the projected hold period. The IRR Matrix is one tool for helping to assess the ideal hold period for an investment. To download the Excel Workbook used in this video, visit: https://www.adventuresincre.com/using-an-irr-matrix-to-analyze-hold-period To learn more about the author, visit: http://www.spencerburton.org
Views: 20688 Spencer Burton
Basic Monte Carlo Simulation of a Stock Portfolio in Excel
 
11:30
https://alphabench.com/data/monte-carlo-simulation-tutorial.html Demonstration of a simple Monte Carlo simulation technique or Monte Carlo method that utilizes the Excel Data Table feature to replicate iterations. This tutorial models annual investments in an S&P 500-like environment. No add-ins are used; 100% pure Excel. Monte Carlo simulation in Excel typically makes use of add-in software for Excel like Palisades Decision Suite or Oracle's Crystal Ball, but we can do a reasonable job modeling Monte Carlo Simulation with Excel, using just Excel. Monte Carlo Simulation is one of the most highly used and important numerical techniques used in finance. A dynamic histogram can be added to further characterize a return profile. See my video on the topic if interested: https://youtu.be/WsQH3AtJqxY For a Monte Carlo simulation to approximate individual stock price movement see: https://youtu.be/1ot7HOI3wQE
Views: 199225 Matt Macarty
Introduction to Investing and Finance - Lesson 1 by Martin Shkreli
 
02:26:50
MODELS AND HELPFUL FILES LINK HERE: https://drive.google.com/folderview?id=0B7KHNVOBFX8qMEs1LWlKamZsRE0&usp=sharing
Views: 464839 Martin Shkreli
Watch Me Model a Real Estate Private Equity Technical Interview Exercise in Excel
 
01:15:55
Warning: This video is long and boring! But, if you're preparing for a real estate technical interview, you'll likely find value in it. Watch me complete what is an actual real estate private equity modeling test. Download the Excel file and follow along (see notes below for edits). To download the Excel file that goes along with this video (both the finished version as well as a blank tab to follow along), visit: https://www.adventuresincre.com/watch-me-model-real-estate-technical-interview/ To learn more about the author: http://www.SpencerBurton.org A Couple of Notes/Corrections: At 21:20, the formula for the Loan Cash Flow should be Total Project Costs (row 22) minus Equity (row 26), not row 20 minus row 26. This error was fixed around the 26:00 mark, but was not made clear. The formula in C21 that sums all Construction Interest for the entire development period [=SUM(G21:CR21)] got zeroed out somehow. I didn't realize this had happened until the 1:00:00 minute mark, when I saw my Levered Cash Flow line had equity contributions beyond when I'd expect. Adding the formula in C21 back, corrected the issue.
Views: 19770 Spencer Burton
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
Estimate CAPM Beta in Excel
 
09:04
This is a supplement to the investment courses I teach.
Mining Investment -  Project Analysis
 
09:08
Walkthrough of the gold mine investment model. The Excel model puts a financial plan and IRR investment analysis together to evaluate an investment in a mining operation such as a gold mine Link to the model https://goo.gl/QTa6RT
Views: 83 eFinancial Models
Subscription Revenue Model (Netflix)
 
17:38
You’ll learn how to project subscription revenue for a Software as a Service (SaaS) or other subscription-based company in this tutorial, which is based on a case study of Netflix. http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Table of Contents: 1:16 Part 1: Key Drivers of a Subscription Revenue Business 5:09 Part 2: Where to Find the Required Information 10:08 Part 3: How to Put It Together in Excel + Add Scenarios 15:32 Recap and Summary Part 1: Key Drivers of a Subscription Revenue Business The key revenue drivers for subscription-based businesses include: 1) Existing Subscribers and the Renewal Rate – MOST revenue depends on the existing subscriber base unless the business is growing like a beast. 2) New Subscribers and Their Renewal Rates – As a % of existing subscribers, how many new ones is the company adding each year? 3) Monthly Fees and Pricing Increases – How much will these increase by over time? How much *can* the company can increase fees before driving away members? The renewal rates often differ for existing vs. new subscribers because new customers tend to cancel more quickly; once someone has been around for a few years, he/she is more likely to stay subscribed. You should also look at different scenarios – What happens with higher growth, renewal rates, and fee growth and with lower growth, renewal rates, and fee growth? Part 2: Where to Find the Required Information Some companies disclose these figures in their filings, but Netflix does not – they only give us the Net Additions, Revenue, and Average Monthly Fees in each business segment. However, if you run the numbers yourself, you’ll see that the Churn Rate, or Cancellation Rate, can’t possibly be that high because Net Additions have been 17-25% of Subscribers historically. So with a 30% cancellation rate, the company would have to replenish its subscriber base by 50% with new subscribers each year – not likely! Also, industry sources like Parks Associates point to a fairly low cancellation rate of ~9% for the company. So we choose to use a 94% renewal rate for existing subscribers and an 88% renewal rate for new subscribers (the 91% rate in the middle corresponds to the 9% cancellation rate). We go 2% higher in the Upside Case, 2% lower in the Downside Case, and 2% lower than that in the “Extreme Downside” Case. Subscriber Additions as a % of Base Subscribers will be higher than the historical numbers but decline over time. Monthly Fee increases will range between the average historical increases. Part 3: How to Put It Together in Excel + Add Scenarios Step 1: Set up the Renewal Rate Schedule for New vs. Existing Step 2: Multiply the Existing Subscribers by the Renewal Rate each year Step 3: Factor in New Additions each year as a % of Base Subscribers Step 4: Apply the New or Existing Renewal Rate each year Step 5: Sum the Total Subscribers and take the yearly average Step 6: Grow the Monthly Fees and multiply to get Total Revenue What’s Next? After setting up the basic schedule, you could check and refine your numbers to make sure the scenarios and capitalized annual growth rates (CAGR) all make sense. You could also consult other sources, like equity research, and see how your views compare with the consensus estimates for the company. And then you could build the rest of the model by projecting expenses, Working Capital, CapEx, and other line items required for the full financial statement projections. RESOURCES: https://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-18-Subscription-Revenue-Model.pdf https://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-18-Subscription-Revenue-Model-Excel.xlsx https://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-18-NFLX-Annual-Report-Extracts.pdf https://youtube-breakingintowallstreet-com.s3.amazonaws.com/105-18-Industry-Churn-Rates.pdf
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
A 60 Minute Recipe for creating a Simple Project Finance Model - Part 1
 
14:27
http://www.videofinancialmodelling.com/ Part 1 of a tutorial developing a simple acquisition financial model for a toll road. If you want more free tutorials and spreadsheets (including access to this tutorials accompanying e-book) go to http://www.videofinancialmodelling.com/subscribe-to-newsletter/ and subscribe. Subscription is free.
Watch Me Build a Basic Real Estate Equity Waterfall Model with IRR Hurdles
 
31:02
In this video, I build a basic, 3-tier real estate equity waterfall model with IRR hurdles. Download blank worksheet together with the completed version, and follow along to learn one way I model real estate partnership cash flows in Excel. To download the models that go along with this video, visit: https://www.adventuresincre.com/watch-build-equity-waterfall/ To learn more about or to contact the author, visit: http://www.SpencerBurton.org
Views: 13683 Spencer Burton
Finance Lesson 4 - IBM Model Valuation
 
01:59:50
MODELS AND HELPFUL FILES LINK HERE: https://drive.google.com/folderview?id=0B7KHNVOBFX8qMEs1LWlKamZsRE0&usp=sharing
Views: 82637 Martin Shkreli
NAV Model (Oil & Gas): Production Decline Curve
 
24:28
When you're valuing an E&P (Exploration & Production) company, the Net Asset Value (NAV) Model is the key methodology. By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" UNLIKE in a DCF, where cash flow growth is assumed into infinity, in a NAV model you assume the company's cash flows go to $0 eventually as it completely produces all of its reserves and has nothing left. A granular NAV model is complex, but it comes down to a 2-step process: Step 1: Model the company's existing production from wells it already has... and assume a decline rate for the annual production each year, also assuming commodity prices to determine revenue, and linking operating expenses to production and calculating cash flow like that. Step 2: Assume the company drills new wells in its PUD (Proved Undeveloped), PROB (Probable), and POSS (Possible) reserves. The second step involves dozens of sub-steps and assumptions, but here we're just going to focus on ONE small part of this process: estimating the decline rate of a new well the company drills. It starts off at a very high production rate, but then declines quickly within even the first year of its useful life - and we need to estimate the decline rates each year to build the rest of the model. You COULD do lots of complicated math, try fitting hyperbolic or exponential functions, run a regression analysis, etc., but we suggest a much simpler approach here: if the company doesn't disclose data on its decline rates for individual wells, find data from another company operating in the same region and fit it to your company's "average" wells. How to Do That: Step 1: Find the company's key data, such as the EUR per well and IP rate per well in the region you're looking at. Step 2: Now, see if the company discloses data on its own decline rates... if so, you're set! If not, or if it's not enough, find another company operating in the region that discloses more data (EQT here), and go to that company's investor presentations to get the numbers. Step 3: In the first year, assume that production is some % of 365 * IP Rate per Well... because there is a huge drop-off in daily production from Month 1 to Month 12 in that first year. EQT's data shows 45%; we assume 60% here since UPL has a slightly flatter decline curve. Step 4: Copy and paste the other company's decline rates into each year of your decline curve. Step 5: Enter the correct formula for calculating annual production each year AFTER the initial year... here: =MIN(AU129*(1+AT130),$AT$126-SUM(AU$129:AU129)) Want to take either Last Year Production * (1 + Decline Rate) (the first part), or the total remaining reserves in this well (the second part). Step 6: Set up Subtotal / Remainder / Total math and ensure that everything is produced. Step 7: "Fit the data" using Goal Seek and the Factor - multiply each decline rate by a certain factor and use Goal Seek (Alt + A + W + G) to solve for the factor that makes the Subtotal equal to the EUR. Step 8: Build in support for a different EUR by scaling the production up or down in the "Total" column. Step 9: Allocate the production to oil vs. gas. vs. NGLs. Step 10: Complete the Subtotal / Remainder / Total math at the bottom. What Next? Next, we'd complete this process for all the wells the company drills in every region, estimate revenue, expenses, and cash flow for each one, and then aggregate the discounted cash flow values in every region across all reserve types... Which brings us closer to the implied NAV per share, which is what the NAV model is really all about. Stay tuned for more!
Discounted Cash Flow (DCF) Model – CH 3 Investment Banking Valuation Rosenbaum
 
01:23:02
The discount cash flow analysis (DCF) is a fundamental valuation methodology broadly used by investment bankers, corporate officers, and other finance professionals. It is based on the principal that the value of a company can be derived from the PV of its projected free cash flow (FCF). While many videos cover the actual framework and how to build the excel model, the assumptions and thinking behind the model are often left to more “real world” examples. This is that example! Chapter 3 covered topics like; - How do you project revenues for a DCF model? - How many years do you project cashflows for? - What is the exit multiple method? - What is the perpetuity growth method? - How do you project EBITDA for a DCF model? - How do you project EBIT for a DCF model? - How do you project the NWC for a DCF model? - What is the mid-year convention? - How do you calculate unlevered free cash flow? For those who are interested in buying the Investment Banking: Valuation, Leveraged Buyouts, and Mergers and Acquisitions by Joshua Rosenbaum and Joshua Pearl, follow the Amazon link below; https://www.amazon.ca/Investment-Banking-Valuation-Leveraged-Acquisitions/dp/1118656210 If you have any other questions, please comment below. If you enjoyed the video and found it helpful, please like and subscribe to FinanceKid for more videos soon! For those who may be interested in finance and investing, I suggest you check out my Seeking Alpha profile where I write about the market and different investment opportunities. I conduct a full analysis on companies and countries while also commenting on relevant news stories. http://seekingalpha.com/author/robert-bezede/articles#regular_articles Videos referenced; Estimating Cost of Debt For WACC: https://www.youtube.com/watch?v=CSkPlxEe-dY Estimating Cost Of Equity For WACC: https://www.youtube.com/watch?v=ZigyWoDAMrE Projecting NWC; https://www.youtube.com/watch?v=2E1Hca2dVbI Why Is Your DCF Model Incorrect? https://www.youtube.com/watch?v=ByyK0AMuLxc
Views: 5873 FinanceKid
Linear Programming Investment Problem
 
07:21
Using Solver to determine the maximum return on multiple investment
Views: 12192 Roberta Aronoff
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.
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
Investment Property Spreadsheet Real Estate Excel ROI Income NOI Template
 
08:25
Get the spreadsheet at https://mspreadsheets.myshopify.com/
Views: 55488 notmfb
Capital Budgeting in Excel Example
 
16:54
Description
Views: 35038 financecanbefun
Waterfall Returns Distribution in an LBO Model
 
19:19
What is a "Waterfall Returns" Schedule? CONCEPT: In a leveraged buyout or any deal where an investment firm acquires another company, they'll often own close to 100% of it... By http://breakingintowallstreet.com/ "Financial Modeling Training And Career Resources For Aspiring Investment Bankers" Table of Contents: 1:04: Example of Management Promotes / Waterfall Returns 3:29: Rationale for Management Promotes and Giving Away Ownership 4:25: Step-by-Step Modeling Process for Waterfall Returns 6:35: Excel Setup 7:12: Level 1 IRR Calculations 10:05: Level 2 IRR Calculations 12:38: Level 3 IRR Calculations 13:55: Level 4 IRR Calculations 14:23: How the Waterfall Distribution Affects IRRs to Everyone 17:35: Recap and Summary What is a "Waterfall Returns" Schedule? CONCEPT: In a leveraged buyout or any deal where an investment firm acquires another company, they'll often own close to 100% of it... But sometimes management will retain a small portion, or another investor group might retain a certain portion. Sometimes it ends there - but sometimes, that smaller group gets ADDITIONAL ownership and a higher stake upon exit if the investment performs well. This is called a "management promote" (if it's the management team that receives this as an incentive). EXAMPLE: A new leveraged buyout takes place, and the PE firm structures the deal to heavily incentivize the management team: For an IRR up to 10%, PE firm gets 95% and management team gets 5% of the proceeds. Then, for the portion of the IRR between 10% and 15%, the PE firm gets 90% and the management team gets 10%. For the portion of IRR between 15% and 20%, the PE firm gets 85% and the management team gets 15%. Then for the IRR above 20%, the PE firm gets 80% and the management team gets 20%. A PE firm might do this to create a "win win" scenario - yes, it loses some of its IRR by giving up a % to the management team... but if all goes well, the team should outperform and help the PE firm achieve a higher overall IRR. How Do You Model This Scenario? 1) Make assumptions for the initial investment and proceeds upon exit, plus the ownership percentages. 2) Make assumptions for how the proceeds split changes at different IRR levels. 3) For each "tier" of IRR, take the initial investment and calculate the amount of net proceeds upon exit that would correspond to that IRR. Example: $1,000 initial investment, and 10% IRR tier - multiply by (1 + 10%), then multiply that number by (1 + 10%), and so on until the exit year. 4) Determine the split of proceeds within that tier. If the actual proceeds are $1,500, for example, and $1,611 would correspond to a 10% IRR, you're done - just split the $1,500 between the PE firm and management team in a 95% / 5% split. But if it goes beyond that $1,611, you just split up the $1,611 according to those numbers and then save the rest for the next tier. 5) Determine the proceeds to distribute in the next tiers. For $3,000, for example, you'd distribute $1,611 and save ($3,000 - $1,611) for the next tiers. If you're at the 10% level and you get something below $1,611, you'd set the "proceeds for the next tiers" number to $0 (use a MAX function for this). 6) Keep doing this for each tier of IRRs until the end. The formulas get trickier as you move up because you need to use MIN and MAX to ensure that you don't get negative or nonsensical values. In Level 2, for example, the "Amount to Distribute and Split" is: =MIN(Net Proceeds That Correspond to 15% IRR in Year 5 minus Net Proceeds That Correspond to 10% IRR in Year 5, MAX(Total Net Proceeds minus Net Proceeds That Correspond to 10% IRR in Year 5, 0)) So you're taking the lesser of the proceeds between 10% and 15% IRRs, or the total remaining amount that can be distributed AFTER the Level 1 distributions. And that same type of logic continues as you move down, until the last tier. RESOURCES: http://youtube-breakingintowallstreet-com.s3.amazonaws.com/109-03-Simplified-Waterfall-Distribution-Before.xlsx http://youtube-breakingintowallstreet-com.s3.amazonaws.com/109-03-Simplified-Waterfall-Distribution-After.xlsx
351-8 How to Build a Portfolio in Excel
 
19:29
Walkthrough for Assignment 8 for FINA 351. We'll be building and comparing 11 portfolios in Excel. The portfolios will have weights ranging from 100% Stock A to 100% stock B and combinations in between. Comment or message me with any questions.
Views: 55017 TimevalueVideos
Investment portfolio analysis
 
04:21
Using XBRLAnalyst for Excel, we show how to monitor investment portfolio performance and drill down into financial data reported by individual companies. In this video, we explain how to use XBRLAnalyst with provided Excel template to monitor portfolio risk and return automatically. The user may change portfolio stocks by simply replacing tickers on the Summary page.
Views: 11776 FinDynamics, Inc.
Investment Optimization
 
10:24
Using EXCEL Solver to determine the amount to invest in a group of bonds
Views: 13871 Jim Grayson
The LBO Model: Learn to Value Any Business Like a Private Equity Pro
 
13:01
Jon Taylor of Stanton Park Advisors (www.stantonparkllc.com) explains how to use a leverage buyout (LBO) model to value a business. The LBO model template can be downloaded at www.stantonparkllc.com in the blog section.
Views: 33508 Jon Taylor
Using Excel to Calculate Return on Marketing Investment
 
08:19
A step by step guide for calculating ROMI using Excel.
Views: 133 MktgStudyGuide

Cover letter sample for nurses
Job cover letter salutation line
Reviews essay writing service
Santa clara address admissions essay
Civil code of the philippines annotated by paras