Home For AAT student members AQ 2016 Professional Diploma in Accounting Cash and Treasury Management
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


Practice assessment 2, Task 7 F and G, extract of trial balance and Gearing Ratio

chloewain_chloewain_ Registered, AAT Student Posts: 42
I was wondering if someone could help me please, I am really struggling with this one.

So you are given the above trial balance and information. And are asked to fill in 6 blanks.

I understand that the 'Current portion of Long-term Loan' is 10% of 1,260,000 as the loan is over 10 years and is equally portioned

I also understand that 'Long-term Loan' 2016 is £126,000 lower than 2015 figure (as you are paying off £126,000 of the loan per year.
But i cannot for the life of me work out where -£1,071,000 comes from for 2015 'Long-term Loan'

I also understand that 'Long-term loan interest' is 57 and 33 as they are just stated above.

But this 1071 figure i just can't reach. I presume i start off with 1260 as this is the figure of the original loan, but then i cant find the 189k difference. I have tried taking off 126, and then 33 interest (which is what i thought the question was asking) but that would mean i am still 30k out.

Also, question G is work out the gearing ratio for both years, so i understand i would use the formula Total Debt / Total Debt + Equity but i have no idea where i would get these figures from in the above trial balance. The answers are 2016 = 17% and 2015 = 25%

Thank you very much in advance and sorry for rambling on







Comments

  • hal978hal978 LondonMAAT, AAT Licensed Accountant Posts: 187
    945,000 + 126,000 = 1,071,000
    Or alternatively:
    1,260,000 - 63,000 (6 months of repayments, as loan taken out in June) = 1,197,000 (total loan outstanding, 31 Dec 20X5)
    1,197,000 - current portion (126,000) = 1,071,000

    Equity = Share capital + retained profit
    Non-current liabilities = Long-term loan
Sign In or Register to comment.