Great video, thanks! I was wondering, does the Excel version on the CFE have the NPV, IRR, RATE, and other formulas built in? If so, does it still tell you the order of the arguments or do you have to memorize that? Thanks again
I know it allows you to use the formulas, not sure if it tells you the arguments or not... perhaps it is something you can ask in the WhatsApp or Facebook groups?
Hi Alex, thanks for the video. How can we know that we are being asked to calculate the IRR for the 2nd option? Is there a trigger, and if so, what is it?
The trigger to know you needed to do the IRR is that you would notice that the interest rate is not given for options that require borrowed money to purchase the assets (options 1 and 2). Option 1's interest rate is the 12% stated, but we don't know about option 2s.
The real question is if we should buy or lease a home in Canada 2022? 😅 #crazycanadianhousingmarket
Thanks! This is so helpful
I did understand the calculations that you did but Im quite weak on those when im solving cases. Please make a video on that!
I'm so glad you like it, stay tune for the rest of the series! :)
Sure, perhaps I can make a video of all the tools you can use (NPV, IRR, PV, and payback period), is that what you are talking about?
@@ShumzCPA Yes Please!!!
Great video, thanks! I was wondering, does the Excel version on the CFE have the NPV, IRR, RATE, and other formulas built in? If so, does it still tell you the order of the arguments or do you have to memorize that? Thanks again
I know it allows you to use the formulas, not sure if it tells you the arguments or not... perhaps it is something you can ask in the WhatsApp or Facebook groups?
It allows using the formulas (don't need to memorize them). The problem is how to enter the data in the spreadsheet quickly. :(:(
Hi Alex, thanks for the video. How can we know that we are being asked to calculate the IRR for the 2nd option? Is there a trigger, and if so, what is it?
The trigger to know you needed to do the IRR is that you would notice that the interest rate is not given for options that require borrowed money to purchase the assets (options 1 and 2). Option 1's interest rate is the 12% stated, but we don't know about option 2s.
Please explain how to calculate irrelevant in separate video