🔑 Join this channel to get access to perks & support my work: th-cam.com/channels/Akyj2N9kd0HtKhCrejsYWQ.htmljoin 💾 Download Free Excel File: ► Grab the file from this video here: ryanoconnellfinance.com/product/payback-period-and-discounted-payback-period-calculation-excel-file/
You helped me understand this better than my doctorate professor did in an entire semester. Bc of this video I likely just passed my last final to graduate. Thank you so much
I appreciate you breaking the formulas down, very succinct. Others take 10 minutes to explain what you can do in 4. Thanks and keep keeping them short.
Hi Ryan, If I am looking to invest in a start-up x amount of $$, to find my payback period would I need the projected Net cashflows of the start-up to find my payback period? also, how do you add the interest on the money lent and isn't the catalyst in this scenario how much and when the startup can begin to pay me back on the borrowed amount?
Hello! Yes, to determine the payback period for your investment in a startup, you will need the projected net cash flows to calculate the time it will take to recover your initial investment. When considering the discounted payback period, you would discount these cash flows using a chosen rate of return to account for the time value of money. The catalyst for repayment indeed depends on the startup's ability to generate enough cash to begin making payments to you according to the agreed-upon schedule.
What if the fifth year is the last negative cash flow in the communicative discounted cash flow, and there are no more years, should I divide it by the discounted cash flow of the same year (year 5) or do I divide it by 0?
@@RyanOConnellCFA Projects with an initial cash outlay of $400,000 are projected to record annual cash inflows of $50,000 each; $50,000; $100,000; $150,000; $200,000. What is the payback period for the project (12% discount rate). Can you answer this for me?
@@kelompok2pengantarakuntans371 You should be able to follow the logic in this video exactly to answer this question. If you follow the steps, what do you get for the answer?
🔑 Join this channel to get access to perks & support my work: th-cam.com/channels/Akyj2N9kd0HtKhCrejsYWQ.htmljoin
💾 Download Free Excel File:
► Grab the file from this video here: ryanoconnellfinance.com/product/payback-period-and-discounted-payback-period-calculation-excel-file/
This is what we call a perfect explanation.
Thank you so much!
You helped me understand this better than my doctorate professor did in an entire semester. Bc of this video I likely just passed my last final to graduate. Thank you so much
I really appreciate that feedback, thank you!
I appreciate you breaking the formulas down, very succinct. Others take 10 minutes to explain what you can do in 4. Thanks and keep keeping them short.
Glad you enjoyed it and I really appreciate the feedback!
These video series you provide illustrating how to use excel are hidden gems.
I really appreciate the feedback Tyler!
Ryan explains the concept and practical calculation so well. Thank you !
You're very welcome! Thank you for leaving this feedback for me
Massively helpful, and super clear. Thank you Ryan.
My pleasure and thank you for commenting!
Thank you for the quick and to-the-point explanation.
You're welcome!
Awsome,understood the concept..well explained Sir!
Thanks! from india
My pleasure!
very Well explained..KEEP IT UP
Thank you, I will!
Great explanation.
Thank you!
Hi Ryan, If I am looking to invest in a start-up x amount of $$, to find my payback period would I need the projected Net cashflows of the start-up to find my payback period? also, how do you add the interest on the money lent and isn't the catalyst in this scenario how much and when the startup can begin to pay me back on the borrowed amount?
Hello! Yes, to determine the payback period for your investment in a startup, you will need the projected net cash flows to calculate the time it will take to recover your initial investment. When considering the discounted payback period, you would discount these cash flows using a chosen rate of return to account for the time value of money. The catalyst for repayment indeed depends on the startup's ability to generate enough cash to begin making payments to you according to the agreed-upon schedule.
Thanks!
You're welcome!
What if the fifth year is the last negative cash flow in the communicative discounted cash flow, and there are no more years, should I divide it by the discounted cash flow of the same year (year 5) or do I divide it by 0?
You should handle every cash flow the same way whether it is positive or negative, by dividing the cash flow by (1 + discount rate)^years
@@RyanOConnellCFATHANK YOU SO MUCH. But, can you give me an example?
@@RyanOConnellCFA Projects with an initial cash outlay of $400,000 are projected to record annual cash inflows of $50,000 each; $50,000; $100,000; $150,000; $200,000. What is the payback period for the project (12% discount rate).
Can you answer this for me?
@@kelompok2pengantarakuntans371 You should be able to follow the logic in this video exactly to answer this question. If you follow the steps, what do you get for the answer?
@@RyanOConnellCFA 5 years or 5,3 years? and this project will be rejected
Thanks
My pleasure
Thankyou
You're welcome!
good looks slime
Appreciate it! First time I've been called "slime" lol
Thanks Luka Doncic
That is one of the best complements I have received 😎
payback period might be 3.14 instead of 4.86
Can you show us our math that led you to believe that?