How to EASILY prepare a Consolidated Statement of Financial Position | ACCA FR | Question Runner
HTML-код
- Опубликовано: 22 июл 2024
- Tips and exam technique guidance to help you pass the ACCA CBE FR exam. ACCA FR / F7 students: Here's the spreadsheet exam technique you need to solve a full ACCA FR / F7 Consolidated Statement of Financial Position (Balance Sheet) question using the CBE spreadsheet tool. Consolidations made easy: I'll show you how to do question Runner, Part A, from the Sept/Dec 2019 FR exam: you can apply the same approach to any past FR exam question. This video is full of FR CBE spreadsheet tips and tricks, and shows you how to pass ACCA FR and tackle consolidation questions.
Here's the full spreadsheet to check out the workings for a Consolidated SoFP (statement of financial position) in more detail: tinyurl.com/yyedsath
**************
Steve Willis ACCA
How to Pass ACCA CBE Exams
If you want more help with ACCA FR consolidations, SOFP and Runner check out Open Tuition:
• Group SFP - Basic cons...
Find many other helpful videos on James Wright ACCA / jameswrightacca
your videos helped me pass PM exam, thank you for your help
Excellent to hear--well done :)
A better presentation, thank you so much helped alot!
Glad it was helpful!
Thanks Steve. This video will definitely help in better presentation.
Glad it was helpful!
This video was amazing and definitely worth watching 😃 thanks a lot..
Glad you liked it!
its not in this question, but how to adjust for intra group loans in SFP
Hi Steve, Always love watching your lessons. I passed my F9 because of last week revision from your videos. And it got very easy because of the templete workings shown by you. Now I am watching for my FR exam next week ❤ love for you from India.
That's great! thanks so much. Good luck on FR. Check my video on consolidations for easy exam technique there.
Sir, Thank you so much for this video. Could you also make videos on the subject audit and assurance?
Hi Steve a very informative video, thanks! Could I ask if our assets don't not balance with the E+L should will leave them slightly off? or change one figure (ie total assets) so they balance together?
Hi there! The assets should equal the E & L. If they don't, either you've missed something, or, as you say, the current liabilities are netted off the assets, so then "Total assets - current liabilities" = "Capital employed"
If you are in section C, do your best to figure it out but keep moving. They will mark you step by step, so if you are a little off in one part, but finished the question, you should get a comfortable pass.
Hello Sir. Request you to please help with a question for consolidation of statement of profit or loss and other comprehensive income. (Your proforma methods are really helpful). if you could make a video, i would be grateful.
Thanks, glad the videos are helpful. Yes, I'll add that to the list.
Does consolidations question testing in real exam is only upto the one you showing?
Or is it more compicated
This one is an exam-standard question--they similar to this, but each exam question will have some variations. The basic structure, and step by step approach, however, will remain the same.
It's incredibly useful, Sir. Also, I tried surfing for an appropriate method to tackle Consolidated SOPL and Published Single Entity Section C questions. Could you please refer a video that may come handy? Thanks a lot in advance, Sir.
I'm not sure--try open tuition, they have a lot of good videos.
@@SteveWillisACCA Thank you, Sir. I'll check it out.
please provide the explanation for consolidated SOPL
Hi Manvi, my goal in this video is to demonstrate the CBE spreadsheet exam technique that many students have trouble with. If you'd like a full explanation of group accounting, I suggest you check Open Tuition--they will have a full lesson on it.
are you allowed to show a 4 column method in the exam? because in all the kaplan answers for CSOFP it just had the group SOFP, which makes it harder for me as i can make more errors.
Can i use your same approach for SPL
Yes you can show multiple columns
I was using the past exam and the practice platform from the link you provided then it was suddenly removed.
I see that too. Strange--maybe ACCA is updating their site and their links.
Do I have to copy answer from spreadsheet to word processor (on answer sheet).
No--they will give you a spreadsheet or word processor response option, and you use what they give you.
@@SteveWillisACCA thanks so much for your kind reply.
you are welcome :)
Everytime i type Consolidated SOFP it straight away cuts everything that doesn't fit in the cell and SOFP is not visible until click on the cell. So how can i merge cells in the platform?
Unfortunately the platform doesn't have that feature like excel. You can double click on the column separator and it will auto enlarge to the width of your text. Good luck 🤞
@@SteveWillisACCA oh got it, Thanks!
Excellent :)
Sir, do we have to link our cells?
Hi there, in what sense? Use the spreadsheet as a practical tool to do your work. Yes, link the cell to another cell if you need to use that number again. But you won't lose any marks if you just re-type it.
Thank you sir
you're welcome :)
nice video it was not that hard i was assuming it to be more challenging
After you master this one, try another Consolidation question using the same approach.