![The Finance Storyteller](/img/default-banner.jpg)
- 271
- 18 405 901
The Finance Storyteller
Netherlands
Приєднався 30 бер 2016
Learn finance the EASY way! My channel is all about explaining you finance, accounting and investing in an understandable way: getting straight to the point, and having the numbers do the talking. Lots of case studies and real life examples, and clear descriptions of how things work in the real world (rather than the textbook).
Whether you are new to finance, or already experienced, you will find content that gives you a fresh look at finance, make sure to subscribe to my channel right now.
I will explain you finance terminology, guide you through accounting steps, show you how to read an annual report, walk you through the financial statements, and explain you how to invest.
Learn the business vocabulary to join the conversation with the CEO at your company. Understand how financial statements work in order to make better stock market investment decisions.
If that sounds like something that could help grow your career or your business, then make sure to join me by subscribing!
Whether you are new to finance, or already experienced, you will find content that gives you a fresh look at finance, make sure to subscribe to my channel right now.
I will explain you finance terminology, guide you through accounting steps, show you how to read an annual report, walk you through the financial statements, and explain you how to invest.
Learn the business vocabulary to join the conversation with the CEO at your company. Understand how financial statements work in order to make better stock market investment decisions.
If that sounds like something that could help grow your career or your business, then make sure to join me by subscribing!
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
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...
Horizontal analysis of financial statements
Переглядів 14 тис.Рік тому
Horizontal analysis of financial statements
Vertical analysis of financial statements
Переглядів 19 тис.Рік тому
Vertical analysis of financial statements
How to calculate sales growth in Excel
Переглядів 11 тис.Рік тому
How to calculate sales growth in Excel
Inventory in Excel vs inventory software
Переглядів 5 тис.2 роки тому
Inventory in Excel vs inventory software
Thank you for recommending me this playlist!
Again Great Video Sir....Could you make a video on MIRR and why MIRR is Better than IRR
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.
Thank you for this
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!
Helped me alot thankss:)
Happy to hear that! More cash flow related videos in this playlist: ua-cam.com/video/mZBjsIYrLvM/v-deo.html&pp=gAQBiAQB
What’s the 8K accumulated oci made outnof
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.
Thankkk youuu
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
How do I put this in practice? Really interested. Where can I study more about it?
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
Great!!Could you explain Permanent working capital
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.
Learning in 2024
Just started my journey into Accounting. grateful you exist!!! 🥲
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
short and sweet. thanks
Glad you liked it! Thanks for watching and commenting!
do stock splits and bonuses be taken into account while calculating the returns of a stock?
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?
@@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?
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.
@@TheFinanceStoryteller Thanks for the reply. It helped me clear my doubt on how to calculate the returns from a stock.
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
Thank you for your help! Very useful video!
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.
If the company wasn't taxed during the period, How does it affect the diacount rate?
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
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?
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).
@@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.
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
@@TheFinanceStoryteller Thanks! Agreed - my big takeaway from his work was to look for ways to mitigate risk everywhere.
Thankyou that was very clear, I kept using pmt, rather that pv and just ended up using a formula in frustration.
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.
@@TheFinanceStoryteller I still have a sheet tucked away for depreciation, each method contrasted manual vs function.
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?
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.
Thanks
Happy to help! More DCF related content in this playlist: ua-cam.com/video/Wez6_1-9WiU/v-deo.html&pp=gAQBiAQB
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🤗🤗🤗🤗
Glad it was helpful! Some more examples and discussion in this playlist: ua-cam.com/video/W5CrcMSBARU/v-deo.html&pp=gAQBiAQB
Could you make a video on P/B Ratio Please?
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
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* ???
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.
@@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" ??
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.
@@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?
Your channel is underrated, thanks for the content.
Thanks for the kind words! Please recommend it to friends and colleagues.
Heyy Please dont stop Uploading I Truly want to learn Finance Things as I am Finance student
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!
Does WACC can be different in each year?
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
May I know how the NPV was calculated as 35?
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.
As the new CEO of a superhero company this is great!
Thank you! More explanations and examples in this EBITDA playlist: ua-cam.com/video/eH4ex5q_j1w/v-deo.html&pp=gAQBiAQB
It's better to do both the certifications, isn't it?
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.
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?
Inflation is (implicitly) included. The higher the inflation, and the higher the risk level, the bigger the rate of return will need to be.
@@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?
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).
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.
Thank you for the compliments. Please share with friends and colleagues.
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?
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.
get marry CapEx Mantain Wife is OpEx😂
the Share price of Verizon today is 40.94%
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.
Volgende keer gewoon in het Nederlands? 😅
Kleiner taalgebied (dus minder kijkers), en het klinkt ook een stuk saaier....
THANK YOU THANK YOU THANK YOU 🎉
Happy to help, Mitchell!
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?
I would argue conservatism / prudence. What do you think?
@@TheFinanceStoryteller I'm confused between conservatism/prudence and materiality. Is it possible for both to occur simultaneously?
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.
Great teaching syllabuses 🎉
Thank you! 😃
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"
Like yourself, I am a big fan of incremental improvements as well. Both technical as well as perceived quality should go up, not down!
can any one please explain hoe NVP is 35$
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.
@@TheFinanceStoryteller thank you so much iam a CFA level 1 asperent and the day i found ur channel it had given me confidence
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?
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
@@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?
Thanks brother
Happy to help!
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.
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.
Simple
... yet effective. :-)
@@TheFinanceStoryteller Really awesome how you kept it simple for us all to understand. Subscribed!!!
Please share the video and/or link to the channel with friends and colleagues! 😊
My biggest mistake is i didn't do any research during my study
The best time to plant a tree was twenty years ago, the second best time is today! ;-)
When you say the higher the interest rate, do you mean the higher the nominal rate or higher EAR? I am a bit confused...
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".
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
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?
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.
You Just Gain A Sub . Thanks❤
Awesome, thank you!
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 😢🙏
Hello! No, that's not something that I have expertise on.
@@TheFinanceStoryteller Oh its alright Sir!! Then uhm can you please make a video on teaching how to make suspense accounts??
Yes, my suspense account video can be found here: ua-cam.com/video/7_CBmXcJE2Y/v-deo.html
@@TheFinanceStoryteller Thankyou sir 😊
Wow quickest easiest explanation to the concept . Great job
Thank you so much! 😊
Could be lives down the road