The Finance Storyteller
The Finance Storyteller
  • 271
  • 18 405 901
Payback period in Excel
How to calculate the payback period in Excel? There are two ways to do that, and your choice of method depends on the characteristics of the project you are evaluating.
Project A has stable and recurring benefits. Using the payback method for this project is very easy.
Project B has fluctuating benefits. Calculating the payback period in Excel for this project requires a bit more advanced calculations.
⏱️TIMESTAMPS⏱️
00:00 Payback period explained
01:13 Simple payback period calculation
01:41 Payback period vs length of project
02:38 Advanced payback period calculation
05:29 Full years and partial years
The payback method asks a very simple central question: How many years does it take to recover the initial investment? Cash outflows are shown as numbers between brackets, in year 0, in other words today. Cash inflows, or benefits, are shown as positive numbers, for four years. Both projects have cumulative benefits over these four years of $1600, but as the size and timing of the benefits is different, the payback period will be different. By the way, you can adapt this Excel template as needed to calculate the payback period, if your project runs for more than four years.
Project A. Stable and recurring benefits. $1000 of investment, four years of $400 each of benefits. Let’s show the absolute value of the investment in row 5, and the annual benefits in row 6. The #payback period is simply the investment divided by the stable and recurring annual benefits, in this case two and a half years.
There is one caveat though: you want to make sure that the #paybackperiod calculated in this way does not exceed the length of the project. A simple check takes care of that risk. Cumulative benefits are the sum of the benefits in column C through F. If the cumulative benefits are greater than or equal to the investment, then we’re OK. However, if that isn’t the case, then we’re not OK.
If we drop the annual benefits to $200 per year, then the payback method formula tells you that the payback period would be 5 years of continuing benefits, however the cumulative benefits check tells you the project is NOT OK as those benefits end after 4 years. With $400 of annual benefits, we are good to go!
Onward to project type B: fluctuating benefits.
Once we’ve established that the cumulative benefits for the project as a whole are OK, we can insert a row with cumulative benefits on a history-to-date basis. Visually, this gives us a clue about the payback period very quickly:
After one year, the cumulative benefits are still negative.
After two years, the cumulative benefits are positive.
This means that the payback period must be somewhere between one and two years, and probably closer to two years than to one year. The approach here is to have Excel calculate the full number of years first, and then add the partial years, to get to the total payback period.
We are going to use the COUNTIF function for the full years part, in the dialog box. The range is C15 through F15. Criteria: smaller than or equal to zero. Excel now counts for us how many years have negative or zero cumulative history-to-date benefits. With the benefits listed above for project B, this is one full year.
To figure out the fraction of the year, we need to take how much cash flow was still needed to get to a cumulative amount of zero, in our case $400, and divide it by the benefits of the next year, in our case $500. Minus C15 divided by D14. The outcome is 0.8, and let’s copy over the formula through column E so we can experiment later on with different annual benefits, while still getting the formulas to work.
Now we don’t care about each and every fraction we calculated here, we only want the one number that is bigger than or equal to zero, and at the same time smaller than one. We are going to use an IF function here, with an AND operator inserted. The logical test is twofold: C16 bigger than or equal to zero, and C16 smaller than one, if true display the value in cell C16, if false put zero. Copy this over through column E as well.
Now the partial years in the calculation of the payback period is simply equal to the sum of the values in cell C18 through E18. And the total payback period is the sum of the full years and the partial years. 1 plus 0.8 is 1.8.
Philip de Vroe (The Finance Storyteller) aims to make accounting, finance and investing enjoyable and easier to understand. Learn the business and accounting vocabulary to join the conversation with your CEO at your company. Understand how financial statements work in order to make better investing decisions. Philip delivers #financetraining in various formats: UA-cam videos, livestreams, classroom sessions, and webinars. Connect with me through Linked In!
Want to get access to bonus content, and/or express your gratitude by buying me a cup of tea? Join my channel as a member through ua-cam.com/channels/QQJnyU8fALcOqqpyyIN4sg.htmljoin
Переглядів: 3 436

Відео

DCF Excel model
Переглядів 2 тис.2 місяці тому
How to build a discounted cash flow model in Excel? Let me walk you through the DCF Excel model that I built for a #valuation of US telecom company Verizon. I hope it provides you with insights into the practical side of doing a DCF valuation. ⏱️TIMESTAMPS⏱️ 00:00 DCF model structure 02:23 Purpose of DCF model 02:59 DCF model: P&L forecasting 09:15 Horizontal and vertical analysis 12:59 DCF mod...
Discounted Cash Flow method (DCF)
Переглядів 9 тис.3 місяці тому
What is discounted cash flow, and how to get started on building a DCF model. A big part of what the discounted cash flow method is all about, is right there in the name: it involves estimating future cash flows, and discounting or translating them to today’s equivalent. A lot of people use the DCF method in order to decide whether to buy, sell or hold a share of a publicly listed company. Your...
Double declining balance depreciation
Переглядів 4,3 тис.6 місяців тому
How does the double declining balance method work for calculating depreciation? Let’s go through some examples, step by step, to make the double declining balance method come alive. Let’s work with: A capitalized value, or purchase cost, of $100,000. A residual value, also known as salvage value, scrap value, or trade-in value, of $7,776. That sounds like a strange amount to use, I will explain...
Present value of an annuity
Переглядів 7 тис.7 місяців тому
What is an annuity? A fixed sum of money paid to someone each year. Why is the present value of an annuity so important? You need to figure out how big this bag of money needs to be at t equals zero, today, in order to fund the equally sized recurring payments in future years. There are multiple ways to calculate the present value of an annuity. There is the slow but easier to understand way, t...
Straight line depreciation
Переглядів 10 тис.9 місяців тому
Straight line depreciation is a tried and tested method, which is used by some of the largest companies in the world, as well as your neighborhood grocery store. A short definition of depreciation is: the decrease in value of a tangible asset over time. The main idea of depreciation: buy a tangible asset (like a machine) now, then use and expense it over time. When you buy the machine, you put ...
How to calculate profit margin and markup in Excel
Переглядів 10 тис.10 місяців тому
Let’s walk through how to calculate profit margin and markup in Excel, and then apply this to setting the selling price based on cost and either margin or markup, and target costing based on selling price and margin or markup. ⏱️TIMESTAMPS⏱️ 00:00 How to calculate margin and markup 01:07 Margin and markup scenarios 02:36 How to calculate the selling price from cost and margin % 04:28 Cost-plus ...
How to calculate the effective annual interest rate (EAR) in Excel
Переглядів 6 тис.10 місяців тому
Let’s play around with the effective annual interest rate in Excel, to understand the EAR concept and see the impact of the effective rate versus the nominal rate. ⏱️TIMESTAMPS⏱️ 00:00 Effective vs nominal interest rate in Excel 00:38 Effective annual interest rate calculation Excel formula 01:34 Delta effective rate vs nominal rate 02:53 Effect of number of compounding periods on EAR 04:32 Eff...
Effective annual interest rate (EAR) vs nominal rate
Переглядів 29 тис.10 місяців тому
Effective annual interest rate versus nominal interest rate. It’s one of the things to look at when choosing where to open a savings account. Bank A offers you a 6% nominal annual interest rate, and so does Bank B. At Bank A, the interest is credited to your account annually, at Bank B monthly. Does that make any difference? 12 times 0.5% interest equals 6% per year, right? The difference is th...
Dollar cost averaging in investing
Переглядів 2,7 тис.10 місяців тому
Dollar cost averaging, or DCA. Why do you need it? What is dollar cost averaging, and How to use dollar cost averaging in investing. Investing in the stock market comes with very strong emotions for a lot of people. If you suffer from FOJI, the Fear Of Joining In, your main concern is that if you buy stocks and they go down in value, you’ll be unhappy you bought them. This might lead you to pos...
Accounting principles
Переглядів 41 тис.11 місяців тому
Accounting principles
VAT inclusive vs VAT exclusive
Переглядів 10 тис.Рік тому
VAT inclusive vs VAT exclusive
Horizontal analysis of financial statements
Переглядів 14 тис.Рік тому
Horizontal analysis of financial statements
Vertical analysis of financial statements
Переглядів 19 тис.Рік тому
Vertical analysis of financial statements
Price to sales ratio
Переглядів 3,1 тис.Рік тому
Price to sales ratio
How to calculate sales growth in Excel
Переглядів 11 тис.Рік тому
How to calculate sales growth in Excel
What is Net Income?
Переглядів 14 тис.Рік тому
What is Net Income?
How to round numbers in Excel
Переглядів 1 тис.Рік тому
How to round numbers in Excel
Balance sheet example
Переглядів 7 тис.Рік тому
Balance sheet example
Balance sheet analysis
Переглядів 19 тис.Рік тому
Balance sheet analysis
Profit and Loss
Переглядів 13 тис.Рік тому
Profit and Loss
Discounted payback period
Переглядів 21 тис.Рік тому
Discounted payback period
Future Value in Excel
Переглядів 4,9 тис.Рік тому
Future Value in Excel
Dividend investing explained
Переглядів 7 тис.2 роки тому
Dividend investing explained
Difference between stocks and bonds
Переглядів 12 тис.2 роки тому
Difference between stocks and bonds
OFFSET function in Excel
Переглядів 7 тис.2 роки тому
OFFSET function in Excel
RANK function in Excel
Переглядів 4,4 тис.2 роки тому
RANK function in Excel
Checkboxes in Excel
Переглядів 3,6 тис.2 роки тому
Checkboxes in Excel
Excel sales tracker
Переглядів 23 тис.2 роки тому
Excel sales tracker
Inventory in Excel vs inventory software
Переглядів 5 тис.2 роки тому
Inventory in Excel vs inventory software

КОМЕНТАРІ

  • @nomnombr
    @nomnombr 3 години тому

    Thank you for recommending me this playlist!

  • @nealshah9575
    @nealshah9575 10 годин тому

    Again Great Video Sir....Could you make a video on MIRR and why MIRR is Better than IRR

  • @rando4168
    @rando4168 13 годин тому

    I understand what you're saying about risk-free but the truth is that different risk profiles can't be considered in a vacuum so it seems reasonable to consider the lowest risk security in existence as risk-free.

  • @Catalinbut
    @Catalinbut 22 години тому

    Thank you for this

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 20 годин тому

      My pleasure, Catalin! Related concepts like IRR and WACC are discussed in this playlist: ua-cam.com/video/aS8XHZ6NM3U/v-deo.html&pp=gAQBiAQB Feel free to connect on Linked In!

  • @MessixPrashant
    @MessixPrashant День тому

    Helped me alot thankss:)

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 20 годин тому

      Happy to hear that! More cash flow related videos in this playlist: ua-cam.com/video/mZBjsIYrLvM/v-deo.html&pp=gAQBiAQB

  • @razieluchiha7580
    @razieluchiha7580 День тому

    What’s the 8K accumulated oci made outnof

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 20 годин тому

      I assume you are referring to the 3M balance sheet example near the end of the video? Accumulated other comprehensive income or loss in the equity section of the balance sheet relates to the cumulative OCI that went through the income statement through the years.

  • @neodyinrich
    @neodyinrich День тому

    Thankkk youuu

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 20 годин тому

      You're welcome 😊 Here's how to apply these concepts in a Net Present Value calculation: ua-cam.com/video/N-lN5xORIwc/v-deo.html&pp=gAQBiAQB

  • @nomnombr
    @nomnombr День тому

    How do I put this in practice? Really interested. Where can I study more about it?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 19 годин тому

      If you want to learn more about DuPont Analysis (return on assets, return on equity), then the videos in this playlist will help: ua-cam.com/video/bhbDDSohJ84/v-deo.html&pp=gAQBiAQB If you are interested in the risk of taking on too much debt and "blowing up" when overleveraged, then understanding liquidity and solvency are key: ua-cam.com/video/XtjS7CfUSsA/v-deo.html&pp=gAQBiAQB

  • @nealshah9575
    @nealshah9575 День тому

    Great!!Could you explain Permanent working capital

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 19 годин тому

      Hello Neal! I had not heard of the term "permanent working capital" before you mentioned it, and have not seen it used in real world financial reporting in companies.

  • @mememajor2346
    @mememajor2346 День тому

    Learning in 2024

  • @itslordscrbble480
    @itslordscrbble480 2 дні тому

    Just started my journey into Accounting. grateful you exist!!! 🥲

    • @TheFinanceStoryteller
      @TheFinanceStoryteller День тому

      Welcome aboard! Happy to help wherever I can. I categorized my accounting related videos in a logical sequence in the Accounting 101 playlist. Have a browse through it, and see which videos could be helpful: ua-cam.com/video/b93KBmcXanI/v-deo.html&pp=gAQBiAQB

  • @fliich
    @fliich 2 дні тому

    short and sweet. thanks

  • @abcdabcd8605
    @abcdabcd8605 2 дні тому

    do stock splits and bonuses be taken into account while calculating the returns of a stock?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller День тому

      Hi! Yes, for stock splits the historical share prices are also adjusted to be able to calculate returns on an apples-to-apples basis. Regarding the second part of your question (bonuses), I am not sure what type of bonuses you are referring to? Bonuses paid to the management of the company? Bonuses paid to shareholders as in one-time "superdividends" in a very successful year?

    • @abcdabcd8605
      @abcdabcd8605 День тому

      @@TheFinanceStoryteller In National Stock Exchange(NSE India), bonus shares would be given. Bonus shares are similar to stock split which can be given as 1:1 or any ratio and we would get additional shares for no extra cost. But in bonus, the face value of the stock remains the same after the bonus is issued. BTW, in NYSE there is no bonus shares?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 19 годин тому

      Thank you for clarifying! In Europe, we tend to call this "stock dividends", where shareholders get additional shares in a company rather than cash in hand. I have seen in the reporting of my stock portfolio that this is sometimes handled by lowering the average value per share retrospectively. Example: you originally bought 10 shares of a company at $100 per share, so invested $1000 in total. When you get 1 bonus share, you have 11 shares, and the original investment remains at $1000. The historical cost is then adjusted to $90.91. Assuming the share price in the market stayed at $100 per share, then your current holding is worth $1100, and you made a 10% return (($1100/$1000) - 1, or ($100/$90.91) - 1). Regarding the second part of your question: my experience is that US bases companies tend to pay cash dividends only.

    • @abcdabcd8605
      @abcdabcd8605 18 годин тому

      @@TheFinanceStoryteller Thanks for the reply. It helped me clear my doubt on how to calculate the returns from a stock.

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 17 годин тому

      Happy to help! I have a few more useful videos about the stock market in a playlist, covering topics such as dividend yield, book value versus market value, IPOs, short selling, penny stocks, ETFs, etcetera: ua-cam.com/video/K4mWd2zBYVk/v-deo.html&pp=gAQBiAQB

  • @MsGrazy13
    @MsGrazy13 3 дні тому

    Thank you for your help! Very useful video!

    • @TheFinanceStoryteller
      @TheFinanceStoryteller День тому

      Great to hear that! Here's my playlist with financial statement case studies, nothing like going through the numbers of a real world company to learn new terminology and review unusual situations: ua-cam.com/video/Hq-44PHgAiU/v-deo.html&pp=gAQBiAQB It's got the Microsoft income statement, Tesla balance sheet and cash flow statement, etc.

  • @LoveU_Allthetime
    @LoveU_Allthetime 4 дні тому

    If the company wasn't taxed during the period, How does it affect the diacount rate?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller День тому

      I have the feeling this is a homework question that you are trying to get answered, so I am not directly answering it, but rather pointing you to the section of the video (~15 seconds long) where you will easily find the answer: ua-cam.com/video/1O-DbtVueMw/v-deo.htmlsi=obv5zlwf_8wfM9Wg&t=477

  • @Evanrholloway
    @Evanrholloway 8 днів тому

    This channel was invaluable during my MBA. You’re a fantastic educator. Thanks for your work. Considering that WACC and DCF analysis involves assumptions that can be quite unreliable, do you think it’s still a useful model despite its flaws? Do you think behavioral economics or alternative models more accurately predict returns?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 7 днів тому

      Thanks for the kind words, Evan! Please share the link to the channel with new generations of MBA students. DCF analysis is nice as a thought experiment, and for entertainment purposes. There can be quite a bit of confirmation bias in the assumptions, and obviously you cannot forecast or predict the "unknown unknowns". Yet, those unknown unknowns are the ones that can have a huge impact on future share prices. The problem I see with behavioral economics is that it is not easy to generalize their findings to a bigger environment, and that it focuses on trivial matters not the "life or death" category of problems. In general, I have turned away over time from prediction, and am far more interested in Nassim Taleb's work operationalizing concepts like convex vs concave, and building robustness (instead of fragility) or even better antifragility (benefiting from disruption).

    • @Evanrholloway
      @Evanrholloway 7 днів тому

      @@TheFinanceStoryteller I’m also a fan of Taleb’s work. Do you have any content about implementing his principles in an individual portfolio? Lately I’ve been looking into barbell portfolios and tail hedges, but it seems like many of Taleb’s strategies would require the resources of a large fund to take advantage of.

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 5 днів тому

      To me, his approach is about lifestyle in general.... I have fully paid down the mortgage on my house, no other debt, know the ins and outs of my country's tax laws to avoid any unpleasant surprises, live below my means, etc. In my investment portfolio, a few of the stocks (Adobe, Synopsys, Airbus) explain most of my returns. I expected these to have convex properties when I bought them, and turned out to be right and/or lucky. I also picked a few stocks that turned out to be losers (hindsight bias), but only lost a bit of money on them (never blow up!). Other than that, I go for 50/50 ETFs and individual stocks. See also: ua-cam.com/video/GBLNKbOgQ4w/v-deo.html I have a few videos about Taleb's work, but not specifically on how to apply his principles to portfolios: ua-cam.com/video/tQEH9caNMi8/v-deo.html&pp=gAQBiAQB

    • @Evanrholloway
      @Evanrholloway 5 днів тому

      @@TheFinanceStoryteller Thanks! Agreed - my big takeaway from his work was to look for ways to mitigate risk everywhere.

  • @williamarthur4801
    @williamarthur4801 9 днів тому

    Thankyou that was very clear, I kept using pmt, rather that pv and just ended up using a formula in frustration.

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 8 днів тому

      Happy to help! My experience with Excel is that certain functions might work slightly differently than you originally expect, that's why I build my own calculation first and then check how to input data into the Excel function to get the same result. One such example is the NPV function in Excel, which really is a PV function rather than NPV, as you still have to deduct the initial investment.

    • @williamarthur4801
      @williamarthur4801 8 днів тому

      @@TheFinanceStoryteller I still have a sheet tucked away for depreciation, each method contrasted manual vs function.

  • @ceylanpolat
    @ceylanpolat 9 днів тому

    Many thanks for the video, it explains very clearly. what would be the formula/approach if our initial investment spent in three years-not in year?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 8 днів тому

      You could do separate calculations for the present value of the investment cash outflows, and separately calculate the present value of the future benefits (cash inflows). That way, you still get one number to put into the denominator of the calculation.

  • @Financedude-6003
    @Financedude-6003 9 днів тому

    Thanks

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 8 днів тому

      Happy to help! More DCF related content in this playlist: ua-cam.com/video/Wez6_1-9WiU/v-deo.html&pp=gAQBiAQB

  • @134princesa
    @134princesa 10 днів тому

    Oh my God. I had to take Advance Accounting last semester, and I swear these concepts were so hard for me. I am so glad I found your videos because there are concepts that I did not understand well, but you explained them really well. Thanks🤗🤗🤗🤗

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 8 днів тому

      Glad it was helpful! Some more examples and discussion in this playlist: ua-cam.com/video/W5CrcMSBARU/v-deo.html&pp=gAQBiAQB

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

    Could you make a video on P/B Ratio Please?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 8 днів тому

      I have one video on the channel that is very close to that: "Book Value vs Market Value of Shares" ua-cam.com/video/uCs9AyGIb3c/v-deo.html

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

    Wait if this is the case and debit indicates the assets in increasing then suppose we happen to say that we have some money in our bank but someone doesn't want to reveal amount and just wants to say as "Debit or Credit balance" then which would be the correct one? *I have debit balance in my bank account or I have credit balance in my bank account* ???

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 8 днів тому

      Hello Niraj. Bank statements are written from the bank's perspective. If you have money in your bank account, then that is an asset for you, and on the bank's side a liability from the bank to you. Hence the bank statement will say you have a credit balance.

    • @nirajthakor9748
      @nirajthakor9748 8 днів тому

      @@TheFinanceStoryteller Okay thank you! I understood But i want to know that if i want to tell someone that i have money in my account that should i say? "I have credit balance in my bank account or I have debit balance in my bank account" ??

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 8 днів тому

      Keep it simple: you either have money in your account, or you owe money to the bank. Per your bank statement, you have a credit balance.

    • @nirajthakor9748
      @nirajthakor9748 7 днів тому

      @@TheFinanceStoryteller Okay but can't i say that i have credit balance to light up my saying that i have money in my bank account?

  • @oliverkhoo
    @oliverkhoo 11 днів тому

    Your channel is underrated, thanks for the content.

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

      Thanks for the kind words! Please recommend it to friends and colleagues.

  • @nealshah9575
    @nealshah9575 12 днів тому

    Heyy Please dont stop Uploading I Truly want to learn Finance Things as I am Finance student

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

      No worries! Been delivering a lot of "Finance Essentials" and "Advanced Finance" programs to clients in the corporate world. Now back to making videos starting this week! Stay tuned!

  • @LoveU_Allthetime
    @LoveU_Allthetime 13 днів тому

    Does WACC can be different in each year?

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

      Hello! There are two ways I can read your question: 1) If I do a DCF analysis on a certain company now (in June 2024), can the WACC be different from the one that I used in a previous DCF analysis for the same company a year ago or two years ago? Yes, especially as interest rates have changed significantly over time. 2) Can I apply a different WACC to cash flows occurring in different years in the same DCF model? No, that makes it unnecessarily complicated. When calculating the present values, you already apply the time value of money ("lighter" on earlier years, "heavier" on later years) by doing WACC^1 for year 1, WACC^2 for year 2, etcetera. See also my video on DCF: ua-cam.com/video/Wez6_1-9WiU/v-deo.html&pp=gAQBiAQB

  • @anoushkamani9895
    @anoushkamani9895 14 днів тому

    May I know how the NPV was calculated as 35?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 14 днів тому

      Hi! Add up the discounted benefits $333 + $278 + $231 + $193 and then deduct the upfront investment of $1000, that gets you to NPV of $35. My apologies if that was not clear in the video.

  • @ohiotoledo3787
    @ohiotoledo3787 16 днів тому

    As the new CEO of a superhero company this is great!

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 15 днів тому

      Thank you! More explanations and examples in this EBITDA playlist: ua-cam.com/video/eH4ex5q_j1w/v-deo.html&pp=gAQBiAQB

  • @ruchadave1026
    @ruchadave1026 16 днів тому

    It's better to do both the certifications, isn't it?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 15 днів тому

      I would suggest to go very deep in one of the two, and build strong expertise, while being aware of the differences with the other standard. Many accounting firms have published guides on the main differences, with various level of "technical" discussion.

  • @kikhwan4648
    @kikhwan4648 17 днів тому

    But the issue is there is no inflation rate included. Supposed it is an investment (there is no other way we can get free money), we get the AMOUNT of it but what is the value? How we want to make sure the amount we get represents the value we have now when the interest rate (what we get) can differ depending on banks or the type of investment?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 15 днів тому

      Inflation is (implicitly) included. The higher the inflation, and the higher the risk level, the bigger the rate of return will need to be.

    • @kikhwan4648
      @kikhwan4648 15 днів тому

      @@TheFinanceStoryteller I know it will be difficult to determine the true value because it depends on who we trade with. So it can be said that in TVOM we assume the interest rate already includes the inflation rate. Am I right?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 15 днів тому

      Agree! Sadly enough, in today's economic circumstances in Europe, banks offer an interest rate that is lower than the inflation rate, which has prompted me to put my money elsewhere (higher yielding and obviously also higher risk bonds of small to medium enterprises).

  • @terrenceolivido741
    @terrenceolivido741 17 днів тому

    right away he speaks clearly, with the correct pace and he shows diagrams in sync with the narrative. wow ..., the minute i open a video and hear the horrible - often indian - accents, i turn it off. others try to be flashy and speak rapidly. i refuse all those videos.

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 15 днів тому

      Thank you for the compliments. Please share with friends and colleagues.

  • @Aaron38269
    @Aaron38269 17 днів тому

    What if both of these figures (net profit and shareholders equity) are negative and the company has an enormous ROE ratio, what does this tell us?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 15 днів тому

      Then the outcome of the calculation is NMF: Not MeaningFul. It tells you absolutely nothing. Other than the company potentially being in significant financial trouble.

  • @HabibKhan-ll6qs
    @HabibKhan-ll6qs 17 днів тому

    get marry CapEx Mantain Wife is OpEx😂

  • @kennethyujin841
    @kennethyujin841 18 днів тому

    the Share price of Verizon today is 40.94%

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 15 днів тому

      Yep, it has pretty much been moving "sideways" for the past couple of months. I am still holding on to my shares, as I am optimistic of Verizon's future.

  • @droneshotsantoine1805
    @droneshotsantoine1805 18 днів тому

    Volgende keer gewoon in het Nederlands? 😅

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 15 днів тому

      Kleiner taalgebied (dus minder kijkers), en het klinkt ook een stuk saaier....

  • @mitchellmullen472
    @mitchellmullen472 18 днів тому

    THANK YOU THANK YOU THANK YOU 🎉

  • @tramy8564
    @tramy8564 18 днів тому

    Thanks to your video. I have a question that: If the company's revenue in financial statement is higher than actual amount, what account principle that the company has violated?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 15 днів тому

      I would argue conservatism / prudence. What do you think?

    • @tramy8564
      @tramy8564 15 днів тому

      @@TheFinanceStoryteller I'm confused between conservatism/prudence and materiality. Is it possible for both to occur simultaneously?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 15 днів тому

      Overstating revenue is taken very seriously by authorities and auditors. In fact, it is a very common factor in a lot of accounting fraud cases. I have seen many CFOs getting fired for not having revenue recognition under control (and booking too much revenue is obviously a far bigger problem than understating revenue). Have a look at my revenue recognition video for more information: ua-cam.com/video/816Q6pOaGv4/v-deo.html Overstatement of revenue of any amount is seen as an issue, regardless of the size, so I don't think materiality is the main concern here.

  • @abilkassymaman681
    @abilkassymaman681 19 днів тому

    Great teaching syllabuses 🎉

  • @ajamesmcdermott
    @ajamesmcdermott 20 днів тому

    The new way of doing things in ideas number 4, is cost cut and degrade the product. Till the buyers no longer believe in it's quality. Then they move onto another product and cost cut and degrade the quality and move on. Total BS Millenial University BS again, just loves destroying and never building. "that's the way it is"

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 20 днів тому

      Like yourself, I am a big fan of incremental improvements as well. Both technical as well as perceived quality should go up, not down!

  • @AinkyaJadhav17
    @AinkyaJadhav17 20 днів тому

    can any one please explain hoe NVP is 35$

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 20 днів тому

      Hi! Add up the discounted benefits $333 + $278 + $231 + $193 and then deduct the upfront investment of $1000, that gets you to NPV of $35. My apologies if that was not clear in the video.

    • @AinkyaJadhav17
      @AinkyaJadhav17 18 днів тому

      @@TheFinanceStoryteller thank you so much iam a CFA level 1 asperent and the day i found ur channel it had given me confidence

  • @Dylan-cr5ub
    @Dylan-cr5ub 21 день тому

    Thank you ❤, but does this mean if you go higher then the 22% discount rate or now our IRR it's actually bad because our NPV becomes negative. So our limit in this case of IRR/Discount rate is 22% because otherwise we would lose profitability and become unprofitable because our NPV becomes negative if it is higher than 22%, is this correct?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 20 днів тому

      Hi Dylan! You are largely correct, but I would phrase it slightly differently. At 22% discount rate, you are indifferent between doing or not doing the project, as the NPV is zero. At higher discount rates (over 22%), you would get a negative NPV, meaning that the project destroys value if it is pursued. At lower discount rates (below 22%), you get a positive NPV, meaning the project creates value when pursued. I have a separate video explaining the difference between IRR and discount rate (aka WACC), this might be useful to watch: ua-cam.com/video/ZuH_q5crAWg/v-deo.html

    • @Dylan-cr5ub
      @Dylan-cr5ub 20 днів тому

      ​@@TheFinanceStoryteller Oh ok ofcourse, now I understand it better thank you. Basically, we need to find the discount rate that makes the NPV zero, which in this case is 22%. This rate is the IRR, which tells us if the project is profitable or not and the NPV indicates this together with the discount rate/IRR. If a higher discount rate (WACC/RRR+components) results in a negative NPV, it means the project or investment is not profitable, and vice versa with a positive NPV. The other thing I need to be careful about is between gross IRR and net IRR. Net cash flow or FCF will most of the time be a net IRR if used in an IRR calculation if I'm not wrong?

  • @josephl-h6247
    @josephl-h6247 21 день тому

    Thanks brother

  • @TheDontbeEvil
    @TheDontbeEvil 21 день тому

    I'm confused by the numbers. if you own a house worth 500k, and pays 200k off debt. Why does the "worth" increase? That like buying a car, you make monthly payments but your car doesn't increase value. If i buy a 50k car and pays off 50k loan, it does not mean the car suddenly worth 100k.

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 20 днів тому

      Hi! The terms assets, liabilities and equity come from the financial statement called the balance sheet, which is a picture at a point in time of what a company (of a person) owns on one side, and owes on the other side. In your example of the house that's worth 500K, which is fully financed by a loan of 500K, then the equity (what a home is worth minus how much you owe to the bank) is zero. If the house is worth 500k, and the debt on it is 300K, then the owner of the house has 200K equity in the house.

  • @ismaelhall3990
    @ismaelhall3990 22 дні тому

    Simple

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 21 день тому

      ... yet effective. :-)

    • @ismaelhall3990
      @ismaelhall3990 21 день тому

      @@TheFinanceStoryteller Really awesome how you kept it simple for us all to understand. Subscribed!!!

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 20 днів тому

      Please share the video and/or link to the channel with friends and colleagues! 😊

  • @leoyamiyo8597
    @leoyamiyo8597 22 дні тому

    My biggest mistake is i didn't do any research during my study

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 21 день тому

      The best time to plant a tree was twenty years ago, the second best time is today! ;-)

  • @isabellaschultze1586
    @isabellaschultze1586 23 дні тому

    When you say the higher the interest rate, do you mean the higher the nominal rate or higher EAR? I am a bit confused...

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 22 дні тому

      Good catch! I should have phrased that as: "The higher the NOMINAL interest rate, and the more frequent the compounding periods, the bigger the difference between nominal and effective rate".

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 22 дні тому

      Play around with it a bit in Excel, and you will see how nominal rate and EAR relate: ua-cam.com/video/8PkMM1_DseU/v-deo.html

  • @Random_sandwich
    @Random_sandwich 24 дні тому

    is it possible po na gamitin ang break even analysis, if lets say in a restaurant, the labor cost or rather salary of a cook that produces dishes is fixed, like 150 a month, not hour based, so will eventually use that as a part of the variable, is it feasible?

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 22 дні тому

      Break even analysis is a simplified view on the much more complex real world. You classify costs as either variable or fixed, even though they might not be 100% fitting that definition. For labor cost, I would indeed make the assumption that you include them in variable cost. Take the monthly salary and divide by the number of hours worked.

  • @nealshah9575
    @nealshah9575 26 днів тому

    You Just Gain A Sub . Thanks❤

  • @Dessertsoulss
    @Dessertsoulss 27 днів тому

    Hello sir!! Sir can you please teach me how to do cash books and petty cash books? I'm a high school accounting student and I need help in it 😢🙏

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 26 днів тому

      Hello! No, that's not something that I have expertise on.

    • @Dessertsoulss
      @Dessertsoulss 23 дні тому

      @@TheFinanceStoryteller Oh its alright Sir!! Then uhm can you please make a video on teaching how to make suspense accounts??

    • @TheFinanceStoryteller
      @TheFinanceStoryteller 22 дні тому

      Yes, my suspense account video can be found here: ua-cam.com/video/7_CBmXcJE2Y/v-deo.html

    • @Dessertsoulss
      @Dessertsoulss 22 дні тому

      @@TheFinanceStoryteller Thankyou sir 😊

  • @kbelamin
    @kbelamin Місяць тому

    Wow quickest easiest explanation to the concept . Great job

  • @theguy12322
    @theguy12322 Місяць тому

    Could be lives down the road