'Lease or Buy' Made Easy in CBE | ACCA CBE paper FM

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

Рет қаралды 9,192

3 жыл бұрын

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...

Пікірлер: 24

@kennniiikc3162 8 ай бұрын

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

@SteveWillisACCA 8 ай бұрын

Happy to help!

@DirterXaap 4 ай бұрын

Thnku Steve ❤

@SteveWillisACCA 3 ай бұрын

u r welcome! Good luck

@mainifester1668 4 ай бұрын

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

@karts2010 3 жыл бұрын

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

@SteveWillisACCA 3 жыл бұрын

Glad it was helpful!

@sadikhassan3117 3 жыл бұрын

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

@SteveWillisACCA 3 жыл бұрын

Glad it was helpful!

@TheJirator 10 ай бұрын

Great vid, thanks!

@SteveWillisACCA 10 ай бұрын

Glad you liked it!

@amritavijayan8984 3 жыл бұрын

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

@SteveWillisACCA 3 жыл бұрын

Adding some more right now.

@prernaarora3505 3 жыл бұрын

@@SteveWillisACCA yes sir plz🙏

@shakyasitubandara392 3 жыл бұрын

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 3 жыл бұрын

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.

@ishikatrivedi2526 3 жыл бұрын

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 3 жыл бұрын

Will do!

@englishfire7670 10 ай бұрын

Hello, what about loan interest??

@SteveWillisACCA 10 ай бұрын

That's covered by the discount rate.

@nayangupta3890 3 жыл бұрын

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 3 жыл бұрын

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 3 жыл бұрын

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 3 жыл бұрын

@@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.