The Book-keepers Forum (BKF)

Post Info TOPIC: cash budget problem


Member

Status: Offline
Posts: 18
Date:
cash budget problem
Permalink Closed


thanks very much for the help

the answer is £86, but it also says to round it up to the closest number (i didn't post that part)



-- Edited by mk10018 on Thursday 16th of February 2012 04:03:58 PM

__________________


Member

Status: Offline
Posts: 18
Date:
Permalink Closed

Hi,

i'm working on a cash budget past exam paper and i don't know why the answer in the "bank loan interest" column for each of the 3 months (july, aug, sep) is £86. Could anyone please tell me how £86 is calculated?

 

thanks very much.

 

A bank loan of £12,960 has been negotiated and this will be paid into the business bank account in july.

The principle capital element of the bank loan (£12,960) is to be repaid in 36 equal monthly instalments beginning in August.

The loan attracts 8% interest per annum calculated on the amount of the loan principle advanced in july. The annual interest charge is to be paid in equal monthly instalments.



__________________


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Are you sure that the answer doesn't say £86.40?

The calculation for simple interest (which in the real world is never, ever the way one calculates interest) is :

Advance + (period * interest rate * Advance)

So in this instance £12960+(3*.08*12960) = £16,070.40

Then take out the capital (16070.40 -12960 = 3110.40)

Then to calculate each month just divide 3110.40 by 36 which equals £86.40

hope that helps until someone comes up with a better answer,

Shaun.

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Expert

Status: Offline
Posts: 1536
Date:
Permalink Closed

12960*0.08/12 thats how i did it for exam purposes

Loan x 8% interest per annum / 12 months.

But see the quality and depth of a calculation at ACCA compared to AAT lol.

__________________


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Still £86.40 though... Not really the profession for calculations based on there or thereabouts no matter how you get to the result...

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Expert

Status: Offline
Posts: 1536
Date:
Permalink Closed

I take it the bank wouldn't write off the 40p every month for 36 months then?

Just a thought, it's not a Kaplan text is it because that would make more sense lol

__________________


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Spamkebab wrote:

I take it the bank wouldn't write off the 40p every month for 36 months then?


They would take your first born child and a couple of limbs at least for a fortieth of that!!!



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Expert

Status: Offline
Posts: 2085
Date:
Permalink Closed

Well If I knew I could get rid of my debts that easily.... will they take both kids?

Kris

__________________

BKN Most Innovative Accountancy Firm 2012

Director and Co-Founder of The Bookkeepers Alliance

 



Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

mk10018 wrote:

thanks very much for the help

the answer is £86, but it also says to round it up to the closest number (i didn't post that part)



-- Edited by mk10018 on Thursday 16th of February 2012 04:03:58 PM


 The AAT claim that all cash budgets are rounded, you should of known that Neil having just passed AAT 3. smile



__________________
Steve


Expert

Status: Offline
Posts: 1536
Date:
Permalink Closed

I did round it, it was Shaun pointed out that my calculation still came to £86.40, i just never mentioned it lol.

__________________


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

In the ACCA studies it really get's to me when one is expected to round to the nearest thousand, ten thousand, million, etc. As in the day job the calculations are to either 8 or 16 decimal places depending on the required precision (And the numbers that we're talking about are huge).

My first few ACCA exams I invariably had to correct my exam answers to make them less precise but still left enough of the original answer visible that the examiner knew that I had calculated to the penny even if the final answer was to the nearest 100k.

Right, I'll just stand in this corner and write out the word "Materialarity" a thousand times...


__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Expert

Status: Offline
Posts: 1536
Date:
Permalink Closed

Write it out? i can't even say it.

Makes me wonder though, why the percentages required to pass exams are as they are when as you said yourself, we deal in accuracy (or are required to be damn accurate)
I'm not complaining though.

Neil.

__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About