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.
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.
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)
@@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.
didnt know I can calculate the NPV this way, definitely saves my time ! thx for the tips Sir.
Happy to help!
Wow Steve how did I miss you, calculation of NPV was awesome and looks pretty & simple.
Glad it was helpful!
Hi sir, my question is, why didn't you do a balancing adjustment for the 4th year, and apply the tax rate to the balancing allowance figure?
Learnings
Make template in lease and buy
Calculate post tax cost of borrowing.
Great vid, thanks!
Glad you liked it!
Good to see, thanks for make it very simple, specially pv calculation.
Glad it was helpful!
Thanks..pls do more video related Acca f9..
Adding some more right now.
@@SteveWillisACCA yes sir plz🙏
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?
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.
Thnku Steve ❤
u r welcome! Good luck
Sir please make a video on expected values in investment appraisal.. 3 days to go for the exam and really struggling with that topic
Will do!
Hello, what about loan interest??
That's covered by the discount rate.
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 ?
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.
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)
@@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.