Brian Henry
Brian Henry
  • 70
  • 353 191
Edgar Online Classic Version
How to get the old version of Edgar Online to pull financial data.
Переглядів: 561

Відео

Turning Excel Tables into Charts
Переглядів 30 тис.2 роки тому
How to select from a table and turn it into a bar chart.
What is a Data Set?
Переглядів 7 тис.3 роки тому
Just looking at a couple of data sets and breaking down the parts.
Basic Table in Excel (Counts Table)
Переглядів 3,1 тис.3 роки тому
How to take a statistics variable and build a table to show distribution.
Traditional Capital Budgeting in Excel Part 4
Переглядів 2994 роки тому
Last One!
Traditional Capital Budgeting in Excel Part 3
Переглядів 2704 роки тому
Continuing on.
Traditional Capital Budgeting in Excel Part 2
Переглядів 2024 роки тому
Continuing from the last one
Traditional Capital Budgeting in Excel
Переглядів 4124 роки тому
Cash outflows then inflows, calculate NPV. Normal capital budgeting with some upgraded Excel work.
Telemet IQ Quick Tutorial for CAW Fund
Переглядів 444 роки тому
Read Title
=NPER Excel Function for Time Value of Money
Переглядів 3774 роки тому
Use TVM function to solve for amount of time for money to get to a future value.
Scatterplot in Excel
Переглядів 4414 роки тому
Linked below is the data set if you want to follow along. docs.google.com/spreadsheets/d/1vI2j4SDjhtgPZUAN99vHtHBfAOmDO_6A-4nPfU6bsjY/edit#gid=999428371
Correlation Matrix in Excel
Переглядів 17 тис.4 роки тому
Link to data is below, build your own correlation matrix in Excel docs.google.com/spreadsheets/d/1aUPfUSWkfOlIOUhnekk1-U5wUsa8s4can_5BCirg_6o/edit#gid=156948344
Excel =RATE and Cash Flow Model
Переглядів 2655 років тому
How to use =Rate and the full model to show what it is doing.
Pro Forma Balance Sheet Percent of Sales (Excel 2016)
Переглядів 9 тис.5 років тому
Do this after the income statement pro forma in the FINC4650 playlist.
Pro Forma Income Statement Percent of Sales (Excel 2016)
Переглядів 15 тис.5 років тому
Using our wired income statement from before.
Cash Budget 4 (Excel 2016)
Переглядів 3,2 тис.5 років тому
Cash Budget 4 (Excel 2016)
Cash Budget 3 (Excel 2016)
Переглядів 8595 років тому
Cash Budget 3 (Excel 2016)
Cash Budget 2 (Excel 2016)
Переглядів 6915 років тому
Cash Budget 2 (Excel 2016)
Cash Budget 1 (Excel 2016)
Переглядів 1 тис.5 років тому
Cash Budget 1 (Excel 2016)
Common Sized Financial Statements (Excel 2016)
Переглядів 6585 років тому
Common Sized Financial Statements (Excel 2016)
Wiring Financial Statements (Excel 2016)
Переглядів 6655 років тому
Wiring Financial Statements (Excel 2016)
Pulling Company Financials (Excel 2016)
Переглядів 2 тис.5 років тому
Pulling Company Financials (Excel 2016)
Excel Present Value Cash Flows =PV
Переглядів 1,8 тис.5 років тому
Excel Present Value Cash Flows =PV
Record a Macro in Excel
Переглядів 696 років тому
Record a Macro in Excel
Bond Valuation in Excel (cash flow model and =PV)
Переглядів 10 тис.6 років тому
Bond Valuation in Excel (cash flow model and =PV)
Excel Data Tables
Переглядів 3186 років тому
Excel Data Tables
Excel Simple Investment Cash Flow =FV
Переглядів 3716 років тому
Excel Simple Investment Cash Flow =FV
Excel Loan Amortization =PMT formula
Переглядів 2,8 тис.6 років тому
Excel Loan Amortization =PMT formula
Standardizing Data, Look for Outliers
Переглядів 1,1 тис.6 років тому
Standardizing Data, Look for Outliers
Report 1 data pull
Переглядів 5916 років тому
Report 1 data pull

КОМЕНТАРІ

  • @trip362
    @trip362 10 днів тому

    thank you GOD bless you

  • @xayrullayevzafar
    @xayrullayevzafar 5 місяців тому

    Hi, thank you so much bro

  • @jagopenelitian
    @jagopenelitian 7 місяців тому

    How tu use $ prof, I always fail in may computer?

  • @_J4CK4L_
    @_J4CK4L_ 9 місяців тому

    Great video thank you!

  • @Rafaeladedayo
    @Rafaeladedayo 9 місяців тому

    Thank you 👍

  • @joegramlich
    @joegramlich 9 місяців тому

    Professor Henry is the 🐐

  • @DataSet
    @DataSet 10 місяців тому

    What am I

  • @habibi_sport312
    @habibi_sport312 10 місяців тому

    Thank you for your help!

  • @Pancake3399
    @Pancake3399 11 місяців тому

    hello sir, really helpful for my learning. although i am final level student on CMA. your video will help me for learn financial management

  • @dianenahabwe9148
    @dianenahabwe9148 Рік тому

    Thank you

  • @nootnot1398
    @nootnot1398 Рік тому

    thank you for the help!

  • @davidmickelson5731
    @davidmickelson5731 Рік тому

    How did you jump to the top of the excel sheet so quickly when you were at the bottom of the table?

  • @alex-sd
    @alex-sd Рік тому

    This showed me how to visualize the correlation matrix with mixed data types. Thanks so much!

  • @leocastet3156
    @leocastet3156 2 роки тому

    super video, tu viens de me sauver le grand orale

  • @BK.577
    @BK.577 2 роки тому

    Thank you very much sir

  • @daraormon3229
    @daraormon3229 2 роки тому

    Where would you get the operating revenue figure on a future year? For example, 2022? This looks like you calculated based on a prior year.

    • @brianhenry4754
      @brianhenry4754 2 роки тому

      If you were building Proformas for a company you would be using internal revenue projections typically.

  • @danahendriamoyano9424
    @danahendriamoyano9424 2 роки тому

    what type of formula or computation is this? Does it have a particular type?

  • @klodiademaj2135
    @klodiademaj2135 2 роки тому

    is this example with 2 stages of growth rate ?

  • @klodiademaj2135
    @klodiademaj2135 2 роки тому

    what if you calculate the average growth rate , how you did estimate the 15% growth rate ?

  • @youssefmakki6730
    @youssefmakki6730 2 роки тому

    horrible

  • @imlkr_
    @imlkr_ 2 роки тому

    Thank you! Helped me build a sensitivity analysis table for my dcf model!

  • @karaking3223
    @karaking3223 2 роки тому

    how do you solve for treasury stock as the plug?

  • @chetaningole7802
    @chetaningole7802 2 роки тому

    Can do a graphs on this basis

  • @dianemaecontillo264
    @dianemaecontillo264 3 роки тому

    Is correlation possible for different n? (E.g first data has n=12, second data has n=15)

  • @kamalassi2606
    @kamalassi2606 3 роки тому

    can you send the exel file ?

  • @siobhanallen5356
    @siobhanallen5356 3 роки тому

    Oh this is brilliant!

  • @fatimazahra6047
    @fatimazahra6047 3 роки тому

    Hello Professor. can we use correlation table in time series data ?

  • @MasudRana-zm7fr
    @MasudRana-zm7fr 3 роки тому

    Can you show us, how to make find correlation coefficient from correlation matrix?

    • @brianhenry4754
      @brianhenry4754 3 роки тому

      They are all correlation coefficients in the matrix, so it depends on what you are trying to find. A specific one, ones above certain thresholds, if you tell me what you are looking for specifically with the find I can.

  • @RoyLachica
    @RoyLachica 3 роки тому

    And if you don't have time to setup the the correct Excel formulas etc. you could use the free online correlation matrix builder at roy.lachica.no/correlationmatrix/

  • @danielandrade9945
    @danielandrade9945 3 роки тому

    awesome job brother, thank you

  • @stereohearts970
    @stereohearts970 3 роки тому

    Thank you, sir!

  • @carolinaescobar8481
    @carolinaescobar8481 3 роки тому

    THANK YOU SO MUCH!

  • @Jevuify
    @Jevuify 3 роки тому

    What if we are to use a quarterly model are we to divide the growth rate by 4 and also the required return by 4 too?

    • @brianhenry4754
      @brianhenry4754 3 роки тому

      Yes, you would need to divide by 4 and quadruple the number of periods.

  • @jeremylee3827
    @jeremylee3827 3 роки тому

    Hi thanks for the video. Would you mind showing an example if we use actual dates instead of N={1,2,3..}? If not, can you shed some light on: (Assuming there are a few more months until we receive our first coupon) 1. How to take into account clean/dirty price? 2. Does YearFrac function for the first cash flow solve the problem above?

    • @brianhenry4754
      @brianhenry4754 3 роки тому

      You cannot discount using dates that way without doing a lot of work, since that is your exponent in the denominator. You could run a second row above that showed the dates 1/31/21, 7/31,21, 1/31/22, etc. if you wanted.

  • @liubovpiano9573
    @liubovpiano9573 3 роки тому

    didn't we have to add discounted price to discounted dividends to get value of stock price?

    • @brianhenry4754
      @brianhenry4754 3 роки тому

      If you mean price 24 calculated in AF5, yes. You discount that back to take the place of all dividends 25 and on so you don't have to build the model out forever.

  • @tennisedit
    @tennisedit 3 роки тому

    thx i applied this on google sheets and it worked great

  • @johng5295
    @johng5295 3 роки тому

    Thanks in a million. Awesome. Great strick. Where have you been all these years.A+

    • @brianhenry4754
      @brianhenry4754 3 роки тому

      No problem. Let me know if there is anything else you need to know how to do and I'll make a video of it if I can.

  • @Matt-ob8gj
    @Matt-ob8gj 4 роки тому

    First

  • @Thecreativedogechannel
    @Thecreativedogechannel 4 роки тому

    I'm getting an error "function tiny parameter 2 value is -1.it should be greater then or equal to 1.

    • @brianhenry4754
      @brianhenry4754 4 роки тому

      Without seeing where my guess is that you are not putting in the 90%, 95%, and 99% as percentages or decimals. If you put them in as whole numbers, when you take 1- them they go negative, which won't work.

  • @ExcelAutomationByMudit
    @ExcelAutomationByMudit 4 роки тому

    Hi Brain, I am working in Aditya Birla Group in Dubai for past 4 years in Field of Excel Automation. And i must appreciate you for the way you are explaining to the learners. I usually do not see the basic videos but your thumbnail was too attractive to refuse. Kudos to Excel. Also in case you or any of your excel enthusiastic friend want to join for some role ill be happy to help. From Mudit Lalwani

    • @brianhenry4754
      @brianhenry4754 4 роки тому

      Thanks, I appreciate it. This was an extra credit assignment for some of my undergraduate students.

    • @shiroloco
      @shiroloco 3 роки тому

      Cool animation. Check out mine ua-cam.com/video/uG-NGXbHqEE/v-deo.html

  • @chiomaotuonye7896
    @chiomaotuonye7896 4 роки тому

    Thank so much this helped a lot!

  • @16deej
    @16deej 4 роки тому

    How do you lock in excel?

    • @brianhenry4754
      @brianhenry4754 4 роки тому

      F4 on a PC. Or Command+T on a Mac. You can also just type the dollar signs in.

  • @maryalexiusagathe129
    @maryalexiusagathe129 4 роки тому

    Hi, I have a problem with the long if formula

  • @AI-zt9pb
    @AI-zt9pb 4 роки тому

    this is assuming we have previous financial data. what if we don't have that? how do we build the balance sheet?

    • @giordanberwyntanoto4046
      @giordanberwyntanoto4046 3 роки тому

      You need prior years financial data to be able identify the trends, and therefore make assumptions about the incoming year

  • @AceHardy
    @AceHardy 4 роки тому

    💻📱

  • @ajithviswanathsreenivasan9648
    @ajithviswanathsreenivasan9648 4 роки тому

    Thanks for the help. One more easy way is to use the 'data analysis' tool kit in excel, select the range of values and the tool automatically generates the results! ua-cam.com/video/DywVjSgkAR4/v-deo.html

  • @Matt-ob8gj
    @Matt-ob8gj 4 роки тому

    yeet

  • @zainabkhan2475
    @zainabkhan2475 4 роки тому

    Thanks very much

  • @aliazzam2817
    @aliazzam2817 4 роки тому

    How can i make several iteration for this matrix please !!! ?

  • @buckyafitch
    @buckyafitch 5 років тому

    What is wrong with you Brain? You are not balancing the balance sheet?