BRAVO, Alison Weber, for a fine and succinct demonstration! You might consider editing the video to make this correction: The interest rate shown in cell A2 is not an "inflation rate" as mentioned in your video. This interest rate is either a compound interest rate to calculate Future Values, or a discount interest rate to reduce Future Values to Present Values. It would also be a good idea to explain what a Present Value is, and why all revenues and costs are converted to Present Values in the money streams, so as to make equivalent data comparisons and calculations in the same (i.e.., present) time frame. You might also want to explain that the Break Even Point is calculated as a zero point, where the Total Present Value of All Benefits (or Gross Income or Gross Revenues) equals the Total Present Value of All Costs. The video would become a little longer, but worth it.
Thanks for great explanation, I have one question, why we count the intangible cost- benefit? I mean it doesn’t give any real cash flow to my business. Can I ignore it when I do the CBA?
Very nice and clear explanation. Thanks Alison!
BRAVO, Alison Weber, for a fine and succinct demonstration! You might consider editing the video to make this correction: The interest rate shown in cell A2 is not an "inflation rate" as mentioned in your video. This interest rate is either a compound interest rate to calculate Future Values, or a discount interest rate to reduce Future Values to Present Values. It would also be a good idea to explain what a Present Value is, and why all revenues and costs are converted to Present Values in the money streams, so as to make equivalent data comparisons and calculations in the same (i.e.., present) time frame. You might also want to explain that the Break Even Point is calculated as a zero point, where the Total Present Value of All Benefits (or Gross Income or Gross Revenues) equals the Total Present Value of All Costs. The video would become a little longer, but worth it.
now i understand the concept clearly..Thank you soo much
Thanks for great explanation, I have one question, why we count the intangible cost- benefit? I mean it doesn’t give any real cash flow to my business. Can I ignore it when I do the CBA?
I loved it... It was a great explanation. Thank you very much!
Good explanation. Thanks!
I really liked the way you explained and your template is also great. Could you please share the template sheet?
Thank you, I have put a link to the document in the description
@@alisonweber7073 Thank you very much Alison for your prompt response
Great explanation! May I ask you where I can find that template you are working on! Thank you in advance!
It's in the description
Hey how are you doing the autoproject?
autoproject? the template has formulas that do the calculations. The template is in the description. Is this what you mean?
What is PV TC and PV ALL ???
Present Value, FV is Future Value
You did not separate the rent and the bnb income in your calculations or am I missing something?
excellent catch! I was going to calculate them separately but I forgot to do that.
Would you please be able to provide a link to it??
Yes, I put a link to the document in the description
Thank you
Thank you, it was very useful
I'm glad it was helpful
Great
how do we do the Excel sheet?
a link to the spreadsheet template is in the description
i am a slow learner so for me it was really fast but i got the big idea that spend less and earn more.
good!!
Thank you!
AllyCat13 was here studying for Sheridan College 2021
Good luck in the class. Hope this helped
go slow so viewers can understand
The pounding on the keyboard is irritating
Yes it is. When I record this again, I will get rid of that sound.