Brilliant. And love the Vin Diesel voice. Great tutorial. Thanks Matt.
@MattMacarty
6 жыл бұрын
Thanks. Glad it helped. 1/4 mile at a time...
@aminnazarahari2745
5 жыл бұрын
Awesome template for beginners. Easy to understand and sufficient contents
@MattMacarty
5 жыл бұрын
Thanks. Glad it helped
@dougmphilly
4 жыл бұрын
simplest model that i can adapt from. we are inherited quite a few in house prepared deal sheets that tweaking. this helps a lot.
@MattMacarty
4 жыл бұрын
Glad it helped
@shadhirjannath2495
Жыл бұрын
Thank you so much for this insightful video Matt.... you made my life easy! 😊
@MattMacarty
Жыл бұрын
Glad it helped
@MsAudron
5 жыл бұрын
thanks Matt, the tutorial is great!
@MattMacarty
4 жыл бұрын
Glad it helped
@frankmacbride9999
5 жыл бұрын
Wow, I have a final tomorrow morning and these two things were killing me...hours online with(out) my textbook...but you made it so clear. Thanks!
@MattMacarty
5 жыл бұрын
Glad it helped.
@pentamail9381
2 жыл бұрын
Brilliant explanation !!!
@MattMacarty
2 жыл бұрын
Glad it helped!
@smash666
5 ай бұрын
Thanks Matt!
@MattMacarty
5 ай бұрын
Glad it helped
@gauravbhutada15
3 жыл бұрын
Very well explained.
@MattMacarty
3 жыл бұрын
Glad it helped
@graceharley2658
4 жыл бұрын
Thanks Matt....great refresher.
@MattMacarty
4 жыл бұрын
Glad it helped.
@nguyenduc8741
5 жыл бұрын
This tutorial explained a lot of my questions. Thank you so much Sir
@MattMacarty
5 жыл бұрын
Thanks. Glad it helped
@nguyenduc8741
5 жыл бұрын
Matt Macarty Sir I found in the template provided including BEP which is so much useful but I confuse the function used could u explain ?
@MattMacarty
5 жыл бұрын
No problem. Which function do you mean?
@arbazahmad497
3 жыл бұрын
this video worth waaaay more than my 3 hours lecture.
@MattMacarty
3 жыл бұрын
Thanks. Glad it helped
@GenkiDamaSSJ
5 жыл бұрын
So ROI= NPV/cumulative cash flows? I havent been able to find any other website that says that
@MattMacarty
5 жыл бұрын
Thanks for watching. I mean there are a number of ways to assess return on investment, but yes this measurement is pretty straight forward as a ratio of outflows to net inflows. This is a pretty common calculation in software projects. ROI = (Current Value of Investment - Cost of Investment) / Cost of Investment
@dougmphilly
4 жыл бұрын
agree. i always found those models using future rather discounted cash flows flawed. i can spend in year 0 a million and over 5 years earn 2 million but it is how i earn the two million that matters. wouldn't a front loaded project have better roi than one that has a balloon at the end?
@MattMacarty
4 жыл бұрын
@@dougmphilly It will depend mostly on the time horizon mostly.
@dougmphilly
4 жыл бұрын
@@MattMacarty www.business-case-analysis.com/return-on-investment.html "PV-Based ROI Conclusions An earlier Case Alpha example stated that the "ROI result for the entire investment life is blind to the timing of inflows and outflows within the investment life." Note especially, however, that statement does not apply to PV-based ROI because the size of the discounting effect is indeed sensitive to cash flow timing. To some analysts, the examples above show how the PV based approach adds useful information to the ROI figures, while to others, the same examples show how PV-data confuse the metric's meaning. And, to many businesspeople, the discussion about front loaded and backloaded cash flow streams no doubt seems "theoretical," probably having little practical value for those making real-world investment decisions or for business planning. Therefore, In the interest of clarity and a meaning that is easily understood, many business analysts, investors, and decision-makers decide that bringing PV-based cash flow into the ROI picture "muddies the waters." Consequently, many prefer to avoid discounted data when using ROI, while leaving time-value-of-money concepts to the metrics meant explicitly to handle them: net present value NPV and internal rate of return IRR. Analysts and decision-makers are free, of course, to use or not use PV-based data for ROI, as they wish. However, those who prefer PV-based ROI's should be sure that everyone involved understands how the ROIs are derived and also how to interpret the discounting effects." Interest rates matter, inflation rates matter, risk matters, timing matters. if the decision maker is unaware of these things, then he should not be a decision maker.
@SantanuBhattacherjee
3 жыл бұрын
Found it very useful. Thank you :)
@MattMacarty
3 жыл бұрын
Glad it was helpful!
@kakhatabatadze5106
2 ай бұрын
Thanks but download link does not work.
@MattMacarty
2 ай бұрын
Seems to be working. Can you try again?
@paulwilson1726
4 жыл бұрын
Really good video, thanks.
@MattMacarty
4 жыл бұрын
Thanks. Glad it helped
@HoanZone
3 жыл бұрын
Really great video!!
@MattMacarty
3 жыл бұрын
Glad you liked it!
@juangut4531
4 жыл бұрын
Brilliant and simply explained! Just one quick question: should one include taxes and depreciation in the outflows?
@MattMacarty
4 жыл бұрын
You certainly can include if it fits your need. If you are evaluating several projects taxes will be the same for each so it really wouldn't change anything in absolute terms. I higher NPV before taxes is going to be a higher NPV after taxes too.
@juangut4531
4 жыл бұрын
@@MattMacarty thank you
@lucatintor4896
3 жыл бұрын
Excellent job Matt, also using excel skills made it very interesting to improve the knowledge of excel itself.
@MattMacarty
3 жыл бұрын
Great. Glad it helped.
@foxeverett8164
3 жыл бұрын
I dont mean to be so offtopic but does someone know of a trick to get back into an instagram account?? I stupidly forgot the account password. I would appreciate any assistance you can offer me!
@stevensamuel1968
3 жыл бұрын
@Fox Everett instablaster =)
@foxeverett8164
3 жыл бұрын
@Steven Samuel thanks for your reply. I got to the site through google and Im waiting for the hacking stuff atm. Takes a while so I will get back to you later with my results.
@foxeverett8164
3 жыл бұрын
@Steven Samuel it did the trick and I finally got access to my account again. I'm so happy! Thanks so much you saved my ass :D
@mntungwamorojele2285
3 жыл бұрын
Thank you very much for this Tutorial. You indicate that you get multiple IRRs if you have more than 1 year of negative cashflows. What happens if you have an initial investment in year 0 and then project a loss in year 1? E.g. Fish farm where your first year has no sales because you are growing the fish? How do you then compute the IRR(s)?
@MattMacarty
3 жыл бұрын
It's more of a problem when your NPV goes positive in one year and then negative in a subsquent year.
@mntungwamorojele2285
3 жыл бұрын
@@MattMacarty Thank you very much. I was thinking of a business like an agricultural operation where because you have to grow the produce before you can sell and are therefore loss-making in year 1.
@jackcapetola413
4 жыл бұрын
God bless you sir
@MattMacarty
4 жыл бұрын
Glad it helped.
@kevinmcloughlin4355
4 жыл бұрын
Hi Matt - thanks for a really great tutorial. Everything was super clear! I have a couple of questions that I hope you can help with about the IRR forumula (6th minute of video) when you said something along the lines of "If there is more than one year where the net cashflow is negative, then you will get more than one IRR - so this formula is useful only where net cash outflow is in year zero" Question 1) If I have cashflow for a project that occurs over multiple years, as well as some cashin during those years, then how can i calculate the IRR? Question 2) If I have a project with future expansion phases, e.g. Phase 1 with capex in Year 0 and Year 1, then Phase 2 with capex in Year 2 and Year 3, all contributing to the same overall cashflow, then how can I work out the IRR of the overall project? Thanks again!
@MattMacarty
4 жыл бұрын
The kind of projects you describe can be tricky to value with IRR. You can try to ballpark IRR by playing around with NPV until you get it close to 0, This effectively would be the IRR of the project.
@dav81xxx
Жыл бұрын
Hi Matt. I have a question regarding ROI. Why do you take all outflows and not only the investment amount ($425)?
@MattMacarty
Жыл бұрын
Because you need to recognize the continuing outflows needed to generate inflows
@user-ts4hj5hv4h
Жыл бұрын
How calculate the actual cash outflow if the IRR is given as 5%
@MattMacarty
Жыл бұрын
You would need some numbers in addition to the IRR. Sometimes that's all you are given though.
@elmehdinaim3476
4 жыл бұрын
Thank you so much
@MattMacarty
4 жыл бұрын
Glad it helped
@paolobonja
3 жыл бұрын
Matt, @ 3:55 min. shouldn't it be total inflow (-) total outflow for the NPV?
@MattMacarty
3 жыл бұрын
Yes, I think I started to reverse it but then corrected it in the video
@berihunyimer7412
4 жыл бұрын
this video is good but i want to calculate the project cost and benefits by net present values
@MattMacarty
4 жыл бұрын
You can download the spreadsheet I used and repurpose it to fit your needs: alphabench.com/data/excel-npv-irr-tutorial.html
@avenewconsulting1118
4 жыл бұрын
hi, for the last line, why don t you just divide 1 cumulative cashflow wioth the other one, you arrive also at 15pc
@MattMacarty
4 жыл бұрын
There are many ways to get at the same thing. My stuff tends to be very mechanical, with the idea being it's easier to see what's going on and there is less chance that you make a mistake in a complex formula.
@NoOne-cf2ji
3 жыл бұрын
If you have purchased land in the project , how would you include that in the cash flow ?
@MattMacarty
3 жыл бұрын
You can include as an initial cash outflow.
@GarrettGoodenough
5 жыл бұрын
And the cumulative can you explain what these numbers represents? Should the outflow cumulative be in negative?
@MattMacarty
5 жыл бұрын
The cumulative numbers show cumulative inflows and outflows to date on the project. Something like this is necessary if you are calculating NPV without the use of the builtin NPV function. To get NPV you subtract the total cash outflow for the life of the project from the total cash inflow. You can make the outflows negative if desired and then adjust your formulas accordingly. It is not necessary as long as you understand that an outflow is an expense and makes the project worth less.
@dildarbertty176
3 жыл бұрын
Awesome Vid, What if in year 0, you have a cash inflow rather than cash outflow. Such as borrowing money from the bank at the start, which equates to cash inflow.
@MattMacarty
3 жыл бұрын
You should consider borrowed money as a cash outflow since you will be using it to purchase an asset.
@dildarbertty176
3 жыл бұрын
@@MattMacarty Does this mean that debt repayments are also considered cash outflows
@lucatintor4896
3 жыл бұрын
@@dildarbertty176 that is a cost and has to be deducted from the inflow in order to get the net cash flow
Matt, thanks for this. Very helpful. I do have a question around ROI. I created a similar spreadsheet as urs. My year 0 investment is 3MM and net annual cashflow for years 1 thru 5 is $9MM. My ROI is only coming out to be 160% when I use your method. Isn't the ROI the return off the $3MM initial investment only? If so, even for the 1st year, shouldn't it be around 300%? (3MM returning 9MM net)
@MattMacarty
4 жыл бұрын
ROI should be the PV of cumulative inflows divided by cumulative outflows.
@Raja-up6yv
4 жыл бұрын
Sir, In an Excel Sheet, for how many 'Number of entries' in Rows one can calculate IRR ?
@MattMacarty
3 жыл бұрын
I don't think there is an upper limit
@Raja-up6yv
3 жыл бұрын
@@MattMacarty Please try to enter in 41 rows.
@carlito108306
4 жыл бұрын
Hi how did you do the break even anaylais?
@MattMacarty
4 жыл бұрын
HI. Actually I plan to publish a video that covers breakeven. I didn't explicitly cover it in this video because it was getting long. Essentially you look for the year where overall cashflow goes positive and calculate from that.
@rebeccacady21
6 жыл бұрын
Do you look over cashflows? I need some assistance with one I'm doing . It's frustrating me atm
@MattMacarty
6 жыл бұрын
Do you mean doing a statement of cash flows in Excel?
@sree1016
4 жыл бұрын
What if your initial investment is a loan? I have included loan repayments (principal+interest) in the cash outflow. However, the NPV value drastically changes from 15% to around 6%. Is this right or am I making a mistake somewhere? Thank you
@MattMacarty
4 жыл бұрын
Hi if you are analyzing a loan, the cost of capital includes the interest you are paying on the loan. So as long as your NPV is positive (or 0) you are at least earning back the interest you are paying. This is not the same as a cash flow statement or net operating income. Each serves a purpose, but they are different.
@megha3329
2 жыл бұрын
How you got D34:E34 values? I didn’t get it. Could you please explain
@MattMacarty
2 жыл бұрын
The values in row 34 are the un-discounted, net cashflows. So Cash inflow less the cash outflow, for example D13 - D23
@megha3329
2 жыл бұрын
@@MattMacarty thank you so much for your reply. 👍👍👍
@saniterrainternational2187
5 жыл бұрын
wonderful
@MattMacarty
5 жыл бұрын
Glad it helped.
@khaledsakib644
4 жыл бұрын
How did you calculate "Helper cell for functions- Cash Flow"
@MattMacarty
4 жыл бұрын
HI. Those helper cells are cash inflow less cash outflow. You can download the spreadsheet by following the link in the video or the description section.
@satishsubramanian2816
6 жыл бұрын
Hello Matt, my question is suppose lets assume , you have a cash flow of EBITDA of $2M for the next 15 years and the purchase price is $15M. I get an IRR of 13%. now how do I calculate the ROI. my EBITDA is not discounted. Can you please answer this,
@MattMacarty
6 жыл бұрын
So you can do it similiarly to the method demonstrated here except it sounds like you are starting with an annual net cash flow. You would have to discount each year by the appropriate factor. Without yearly expenses, it will look a lot more optimistic.
@hilaryjansz4687
10 ай бұрын
Use xNPV formula so that you get the same answer
@MattMacarty
10 ай бұрын
I suppose you can use XNPV, but that one is really for uneven cashflow periods. So maybe I get a cashflow in 6 mos and then another 9 mos later. So yes if you use actual dates and set the initial cash out flow as "today" then you can use XNPV.
@josephwarczynski6905
4 жыл бұрын
If it says expects a rate of return of 19% is that that same as cost of capital ?
@MattMacarty
4 жыл бұрын
Yes for this demonstration expected return is cost of capital
@60SecondSpot
7 ай бұрын
What does NPV mean?
@MattMacarty
7 ай бұрын
Net Present Value
@GgoldspiderS
4 жыл бұрын
What is cost of capital and how it is calculated ?
@MattMacarty
4 жыл бұрын
Cost of capital is usually a blend of the cost of financing a project. So if it is funded entirely with equity, then you could use return on equity. If you blend debt and equity financing, you would weight them according to each contribution to get weighted average cost of capital (WACC). Sometimes an opportunity cost is also factored in to get a hurdle rate. The bottom line is it varies company to company and a higher cost of capital represents a more risky project.
@cynthiawangui3468
3 жыл бұрын
Hey, how do i get cost of capital?
@MattMacarty
3 жыл бұрын
There are several ways to get cost of capital. A textbook example would ask you to calculate WACC which includes the required rate of return on equity and the cost of borrowing. Many times it is given or just estimated. Sometimes analysts adjust the cost of capital based on the riskiness of a project, so they might adjust it upward for projects considered more risky.
@berihunyimer7412
4 жыл бұрын
how can saved or download this video freely
@MattMacarty
4 жыл бұрын
Available at: alphabench.com/data/excel-npv-irr-tutorial.html
@sacisaci9300
3 жыл бұрын
Please Why you divide by the total cost and not only by cost of initial capital to cslculate ROI
@MattMacarty
3 жыл бұрын
Hi. ROI is total benefits divided by total costs. For a multi-year project the costs and benefits are realized over time.
@redhaeln
3 жыл бұрын
how can i get the Cost of capital?
@MattMacarty
3 жыл бұрын
It will have to be given our you can calculate it from cost of debt and required rate of return on equity.
@eveningspecial
10 ай бұрын
The calculation of ROI seems to be wrong.Kindly share the source of your calculations of ROI and secondly ROI never considers time value of money .
@MattMacarty
10 ай бұрын
Net benefits/Net investment(expenses). You can download the file here: alphabench.com/data/excel-npv-irr-tutorial.html
@muddassirlaique5868
3 жыл бұрын
For ROI, why do you use NPV as the numerator? That already includes the cost. Shouldn't the numerator only include the "return", i.e. NOPAT? Reference: corporatefinanceinstitute.com/resources/knowledge/finance/what-is-roic/
@MattMacarty
3 жыл бұрын
You can calculate ROI using different methods. At it's most basic it measures net inflows / the cost to generate those inflows which is what my model is doing. Mine is not an accounting model so I am not accounting for taxes or other common income statement items. I am really just trying to show how to get started with comparing capital budgeting projects in terms of economic benefits. Since taxes impact all projects equally, we can usually ignore them. If you have some taxes advantaged project you could just adjust your inflow upward.
@mohammadahmad1823
4 жыл бұрын
Can you give me a solution to this question dropped parcel company is considering purchasing new equipment to replace existing equipment that has book value of zero and market value of 15000 new equioment costs 90000 and is expected to provide production savings and increased profits of 20000 per year for the next 10 year new equipment has expected useful life of 10 years after which its estimated salvage value would be 10000 straight line depreciation effective tax rate 34% cost of capital 12% machinary replacement problem should droppitt replace current equipment? calculate NPV profitabiity index IRR
@MattMacarty
4 жыл бұрын
You can download the spreadsheet I used in this video and just plug in your numbers, or use it as the basis to build your own model. There is a link in the video description to download
@JonathonNeville
5 жыл бұрын
Great, but: 1. Why ignore the cash flows after 5 years? Perhaps after 20 years the present value of the net cash flow will be insignificant, and/or perhaps there are too many unpredictable variables over 20 years so we ignore the effects after some number of years. Is that right? 2. After 3 years, the cumulative cash inflow exceeds the cumulative cash outflow, so you have money you could invest somewhere, supposedly at 12% [interest] / ROI. Do the calculations in this video inherently include the return on that [extra invested money], or should there be another line showing that in year 4 the roughly $20,000 cumulative net gain earned $2400 and in year 5 that $22,400 + year 4's net gain of roughly $137,000 (total $159,400) earned roughly $19,000?
@MattMacarty
5 жыл бұрын
Thanks for your questions. When capital budgeting projects are undertaken, they are typically assigned a lifespan. If it's an IT project you can expect the lifespan will be shorter than say a power plant project. So in my example, the five-year horizon is mostly arbitrary for illustrative purposes. As far as reinvesting any excess cash flows, you can assume that the return on that investment would be the same regardless of the capital project selected. In other words, it doesn't change NPV, and in some respect, reinvestment is included since a higher NPV is better and means more money to reinvest therefore more return in the future.
@JonathonNeville
5 жыл бұрын
Thanks. If these calculations were not just for illustrative purposes, would you use the 5-year lifespan or would you extend the lifespan until the present value of future cash flow becomes insignificant? I'm guessing the answer depends on predictability, and for I.T. the future cash flow is unpredictable after 5 years, so a 5-year lifespan makes sense even though the cash flow forecast suggests year 6 will still have a net gain of almost $100,000 in PV. Yes? For a power plant, technological change could still affect the market, but future cash flows are more predictable and therefore the lifespan might be 20 years. Yes?
@MattMacarty
5 жыл бұрын
It would depend on the projected lifespan of the project. In this example, five years might make sense since it is an IT project which may be obsolete after five years. Keep in mind that you would be comparing several similar projects perhaps from different vendors and selecting the one with the highest NPV.
@kendalfoster
3 жыл бұрын
So how do you figure NPV for 5 years on a continually running business with no initial investment???
@MattMacarty
3 жыл бұрын
If there is no cash outflow just set it a t 0 in the model.
@GarrettGoodenough
5 жыл бұрын
So can I get this right...the PV of Cash Outflow say for year 1 is $276000 from the $425k investment? And same philosophy with the inflow?
@MattMacarty
4 жыл бұрын
Somehow missed this. Only 10 months late... The cash outflow in each year can be thought of as independent of the initial investment. So one I commit to taking on the project, I am also committing to any future cash outflows associated with the project. Even though I will be generating cashflow, there are continuing costs associated.
@joaopaulomg2007
4 жыл бұрын
What if you have a perpetuity after year 5, how could I calculate the IRR?
@MattMacarty
4 жыл бұрын
You determine the value of the perpetuity by dividing the cashflow you will realize indefinitely by the cost of capital. Then just include this as another inflow argument for the IRR function.
@Miguel-he7rw
4 жыл бұрын
How did you get 310k and 425k?
@MattMacarty
4 жыл бұрын
Theses are just assumptions made to set up the model. You can use any numbers you like.
@konstantinostsopanikos1595
4 жыл бұрын
npv= PVinflows - PV outflows, why u didn't do that???
@MattMacarty
4 жыл бұрын
Yes this is the way I did it. You can download the spreadsheet I used by following the link in the video
Пікірлер: 138