The Book-keepers Forum (BKF)
The Book-keepers Forum (UK) -> Introductions and Time Out -> Pre-decimilastion money - how to convert to real money?
Post Info TOPIC: Pre-decimilastion money - how to convert to real money?
Peasie


Expert

Status: Offline
Posts: 1707
Date:
Pre-decimilastion money - how to convert to real money?
Permalink  

This is going to sound barking mad.....

I'm studying ICB Manual Level III - near the end of the course and will be doing many mock exams and then a mock online exam. Here's the barking bit - for more practise I have most of the family business profit and loss accounts and balance sheets since 1959. These were in the old format. I thought it might be fun to convert them to the newer style. Maybe do a couple each night until I get bored/go insane. To use a real life example would be better than text book stuff even if the text book stuff was more complex. There are actually only two years missing and from about 1982 onwards they are in the newer format anyway after a change of accountant (the previous one was in his eighties).

I would like to start with the oldest ones - but they are in the old money format. Is there an easy way to convert them - say having a cell for (£), a cell for (s) and a cell for (d) - or would the effort of converting be too much.

It was always thought (by the generations still alive) that the family business was established in 1899 and they have that on the side of their vans. Until one day they were stopped by the owner of the garage nearby who disputed they year. He produced a calendar for 1895 and one of the adverts was for the family business. 



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/
Peasie


Expert

Status: Offline
Posts: 1707
Date:
Permalink  

I think I may start from when the business became a Limited Company - in 1975. 

I put this info into Excel in the hope of copying and pasting it here and retaining formatting but it didn't work so I took a photo of the screen, emailed the photo to myself and uploaded the picture to Tinypic.

3495onl.jpg

Now, would the current way be to have thew HP instalments under long term liabilities - or is there a completely different concept when it comes to HP? I don't think this has been covered in my course if it is different.

I should actually have taken a photo of the real Balance Sheet to show you had bad the typing is on the page with an old fashioned typewriter.



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/
Wella


Expert

Status: Offline
Posts: 2256
Date:
Permalink  

Hi Peasie

Just for fun i thought I would have a go at you first question

Example is if the three components are seperated in to cells

 

 Cell BCell CCell D Cell F
Row 2£Sd Decimal
Row 325175 25.87083

The formula entered in Cell F, Row3, is

=((B3)+(C3*12/240)+(D3/240)) 

Good job there were no ha'pennies, or farthings biggrin

Just out of interest the "d" symbol for a pennie is from the roman coin denarii, and the "£" symbol is derived from the Italian Lira (its a corruption of the letter L)

Have a fun day re-doing 36 year old accounts

Bill

 

 



__________________

 

 
BudgetB


Guru

Status: Offline
Posts: 709
Date:
Permalink  

Peasie wrote:

This is going to sound barking mad.....

 

 

 Yep! biggrin



__________________

Jenny

 

Responses are my opinion based on the information provided.  All information should be thoroughly checked before being relied on.

 
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink  

Peasie,

not to detract from the current challenge but I was just thinking. As you are preping for ICB level III have a go at these three exams as mocks.

They are the pilot papers for ACCA F3 (financial reporting). Just 50, mostly multichoice questions. Some questions test entry level knowledge of standards but you can just skip those and have a go at the numeric questions.

The answers are at the back of each paper.

http://www2.accaglobal.com/pubs/students/acca/exams/f3/past_papers/uk/f3uk_2006_dec_ppq.pdf

http://www2.accaglobal.com/pubs/students/acca/exams/f3/past_papers/uk/f3uk_2006_dec_ppq.pdf

http://www2.accaglobal.com/pubs/students/acca/exams/f3/past_papers/int/f3_d11_ppqa.pdf

__________________

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


Expert

Status: Offline
Posts: 1707
Date:
Permalink  

Shamus wrote:

Peasie,

not to detract from the current challenge but I was just thinking. As you are preping for ICB level III have a go at these three exams as mocks.

They are the pilot papers for ACCA F3 (financial reporting). Just 50, mostly multichoice questions. Some questions test entry level knowledge of standards but you can just skip those and have a go at the numeric questions.

The answers are at the back of each paper.

http://www2.accaglobal.com/pubs/students/acca/exams/f3/past_papers/uk/f3uk_2006_dec_ppq.pdf

http://www2.accaglobal.com/pubs/students/acca/exams/f3/past_papers/uk/f3uk_2006_dec_ppq.pdf

http://www2.accaglobal.com/pubs/students/acca/exams/f3/past_papers/int/f3_d11_ppqa.pdf

 Thanks Shaun - I'm beginning to wonder if I am preparing for the exam or just procrastinating. I'll have a go at the exam questions you have listed - there would seem more point to doing that. I suppose some day I might go through the old balance sheets - although I've yet to know why.

I did find an ancient spreadsheet (in Excel 4 format) for the converting thing.



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/
Peasie


Expert

Status: Offline
Posts: 1707
Date:
Permalink  

eshaa83 wrote:

start an new buisness

 Don't eat the yellow snow.

 



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink  

<<< Post deleted as the posts of Eshaa83 have now been deleted by the Admin team and my response makes no sense as a stand alone answer >>>



-- Edited by Shamus on Tuesday 31st of May 2011 02:12:10 PM

__________________

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


Guru

Status: Offline
Posts: 896
Date:
Permalink  

BudgetB wrote:
Peasie wrote:

This is going to sound barking mad.....

 

 

 Yep! biggrin

 Seconded!

 



__________________

 

Regards,
Nick

Website: www.gbmaccounts.co.uk
Twitter

Factsheet | Starting a Business

 
Peasie


Expert

Status: Offline
Posts: 1707
Date:
Permalink  

Shamus wrote:

<<< Post deleted as the posts of Eshaa83 have now been deleted by the Admin team and my response makes no sense as a stand alone answer >>>

 And the post at the top of this thread makes any sense does it? smile

 



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
The Book-keepers Forum (UK) -> Introductions and Time Out -> Pre-decimilastion money - how to convert to real money?
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