Steve that's great to know that we can borrow spread sheet from session C, as I always find it difficult/time consuming to do all the calculations for a 2 mark question. This has definitely saved lot of time and a possible error by doing it manually. God bless you Sir!!!!
Thank you soo much kind sir for all ur great lectures, i passed the recent june attempt FM exam with the help of some ur lectures on past exam difficult questions of FM.
@@SteveWillisACCA i recommended your videos to many of people online who are struggling with FM, they all find ur videos very helpful specially the practice of past exam questions videos of FM. Keep up the good work
When we calculate irr manually we ve to find the required items in irr formula like npv@LR ,npv@HR But in spreadsheet we only need the pv/cashflows only ? Correct me if i am wrong I am amazed this is going save alot of time ! Thank you very much Sir
Hey Steve, we have our FM exams day after tomorrow if possible can you please upload a video covering Cost of equity and Debt question from Section A and B covering a few important calculation questions like using CAPM and DVM, I will be really grateful if you do so.
Quick question, as investor why we are not taking cash outflow '-$100' in Y0, for NPV calculation. earlier in NPV questions, Y1 to Y5 are present values and then adding cash flow of year 0 to arrive at NPV. Kindly explain. Thanks in advance
Steve kindly explain again in a different way when to use before tax or after tax.I did not understand ur explanation how to view in the eyes of the company or investor with that example
Steve that's great to know that we can borrow spread sheet from session C, as I always find it difficult/time consuming to do all the calculations for a 2 mark question. This has definitely saved lot of time and a possible error by doing it manually. God bless you Sir!!!!
My pleasure.
Steve, thanks for lectures! You are one of the best tutors!
Wow, thanks!
Thank you soo much kind sir for all ur great lectures, i passed the recent june attempt FM exam with the help of some ur lectures on past exam difficult questions of FM.
Well done!
@@SteveWillisACCA i recommended your videos to many of people online who are struggling with FM, they all find ur videos very helpful specially the practice of past exam questions videos of FM. Keep up the good work
Thanks!
You make it look soooo simple..Thank you
You’re welcome 😊
@@SteveWillisACCA How would the Qn be framed if the after tac cost of debt were to be used?
Hi Steve, what if you dont want to use the forumla of NPV, how do you get the 96?
When we calculate irr manually we ve to find the required items in irr formula like npv@LR ,npv@HR
But in spreadsheet we only need the pv/cashflows only ? Correct me if i am wrong
I am amazed this is going save alot of time ! Thank you very much Sir
Yes, correct
But make sure you practice in the spreadsheet before the exam.
Hey Steve, we have our FM exams day after tomorrow if possible can you please upload a video covering Cost of equity and Debt question from Section A and B covering a few important calculation questions like using CAPM and DVM, I will be really grateful if you do so.
Not sure if I'll have time, but will try!
sir, can you do promblem with sensitivity analysis in NPV
Will rock that soon
wish I found this channel sooner
Glad you're here now!
Quick question, as investor why we are not taking cash outflow '-$100' in Y0, for NPV calculation. earlier in NPV questions, Y1 to Y5 are present values and then adding cash flow of year 0 to arrive at NPV. Kindly explain. Thanks in advance
hi--for market value, we are trying to get the year zero amount--that is the number that would give NPV = 0.
if the market value of the bond is $85 dollars, if we put -85 in year zero of the same spreadsheet, we would have zero NPV.
Why we use 10% for discount ? Thanks in advance
Steve kindly explain again in a different way when to use before tax or after tax.I did not understand ur explanation how to view in the eyes of the company or investor with that example
I'll make a quick video on that ASAP