'Lease or Buy' Made Easy in CBE | ACCA CBE paper FM | Question Dink Sept/Dec 2019

Learn how to quickly and efficiently solve a 'Lease-or-Buy' question from paper FM / F9, using the ACCA spreadsheet tool. This is a difficult topic that requires NPV: you'll learn the exam technique that you need to get a pass. In this video I take you through question Dink part A, from the Sept/Dec 2019 exams, showing you how to pass ACCA FM. Make sure you learn to use the NPV function when you do do question Dink, which will save you a lot of time--I demonstrate this at 12:05.
Get Here's help, tips and exam technique for ACCA CBE FM exams in this video.
******************
Steve Willis ACCA
stevewillistraining.com
How to Pass ACCA CBE Exams
Lease or buy Help
******************
If you want more information on ACCA FM Lease or Buy, check out Open Tuition: • Discounted Cash Flow F...

[@kennniiikc3162]

didnt know I can calculate the NPV this way, definitely saves my time ! thx for the tips Sir.

[@SteveWillisACCA]

Happy to help!

[@karts2010]

Wow Steve how did I miss you, calculation of NPV was awesome and looks pretty & simple.

[@SteveWillisACCA]

Glad it was helpful!

[@mainifester1668]

Learnings Make template in lease and buy Calculate post tax cost of borrowing.

[@sadikhassan3117]

Good to see, thanks for make it very simple, specially pv calculation.

[@SteveWillisACCA]

Glad it was helpful!

[@TheJirator]

Great vid, thanks!

[@SteveWillisACCA]

Glad you liked it!

[@DirterXaap]

Thnku Steve ❤

[@SteveWillisACCA]

u r welcome! Good luck

[@ishikatrivedi2526]

Sir please make a video on expected values in investment appraisal.. 3 days to go for the exam and really struggling with that topic

[@SteveWillisACCA]

Will do!

[@amritavijayan8984]

Thanks..pls do more video related Acca f9..

[@SteveWillisACCA]

Adding some more right now.

[@prernaarora3505]

@@SteveWillisACCA yes sir plz🙏

[@shakyasitubandara392]

It’s not having the $ and ‘000 affecting us when getting marks? Also, is it necessary to link within the sum and working done to gain marks?

[@SteveWillisACCA]

Hi Shakya, please check cell E2 in the video, I showed I was working in dollars and 1000's: this is what the '$000' means. But that is just a touch of professionalism, even if it had been omitted you'd get full marks. Check the marking guide: there are no marks for 'spreadsheet labeling.' You don't need a '$' at the top of every row, and you can easily make the decision working in thousands. Can you tell me what spot in the video you have question about the SUM function at? The sum function automatically links when you copy a relative cell address. There had been a bug in the practice platform about copy/pasting formulas, but it is now fixed.

[@englishfire7670]

Hello, what about loan interest??

[@SteveWillisACCA]

That's covered by the discount rate.

[@nayangupta3890]

Sir hope you are doing well. Why you have put the value of E18 not in D18, F18 not in E18, G18 not in F18 and H18 not in G18 ?

[@SteveWillisACCA]

Hi Nayan, thanks a lot for checking out my video :) I'm doing fine thanks, hope the same by you. I used column A for the section headings, and then indented to column B for my row items. Only to make it easier to read for the marker. There are no marks for formatting, so you can set it up anyway you want. But best so copy paste works well and it's easy to follow for the marker. That's what I'm trying to achieve.

[@nayangupta3890]

I was mis interpret the calculation i was considering 0 as a one year and 1 as another year and 2 again as another year that is why i asked tax saving of 0 should be in 1.. similarly for other years. Now I understand 0 is one where there is no maintenance cost, rather maintenance exp took place in 1st year so saving of tax be in 2nd year similarly for other years. I appreciate your efforts sir for making useful videos for us. Thanks 😊 Nayan (from India)

[@SteveWillisACCA]

@@nayangupta3890 Thanks for the feedback! In the videos I'm showing exactly how I would do it in the exam. We can clean up the presentation a bit, but you won't get any marks for that.