Personal finance spreadsheet Personal finance spreadsheet
Posts 1 to 8 of 8
  1. #1

    Fingers like lightning

    VillageContractor is a permanent contractor

    VillageContractor's Avatar
    Join Date
    Aug 2014
    Posts
    597

    Default Personal finance spreadsheet

    Hi,

    Just going over the finances and wondered if anyone had a personal finance planner in a spreadsheet (or other tool) that factors into account salary, share holdings, dividends and also capped out at the basic rate?

    My spreadsheet only goes salary and dividends and tbh not really looking to create it if one already exists.

    Thanks

    VC

  2. #2

    Super poster

    Lance - scorchio!

    Lance's Avatar
    Join Date
    Sep 2013
    Location
    home
    Posts
    4,012

    Default

    SJD provides one every year exactly as you describe. I’ve left them so don’t have one with the 2017/18 calculations.
    It’s probably easier to just punch the numbers into contractor calculator.com I would reckon.
    See You Next Tuesday

  3. #3

    Fingers like lightning

    VillageContractor is a permanent contractor

    VillageContractor's Avatar
    Join Date
    Aug 2014
    Posts
    597

    Default

    They were my accountants a few yrs ago but I didn’t get anything for personal finance just the company finance spreadsheet

  4. #4

    My post count is Majestic

    MarillionFan is a fount of knowledge

    MarillionFan's Avatar
    Join Date
    Jul 2005
    Location
    .
    Posts
    35,765

    Default

    I’ve been running one since 1997 and can trace it all the way back to when I had student debts.

    It’s nice to see how I moved from being skint to millionaire over those last 20 years. Though according to my forecast I should have at least another million on top!
    What happens in General, stays in General.
    You know what they say about assumptions!

  5. #5

    Super poster

    TheCyclingProgrammer is NOT a disguised employee


    Join Date
    Jan 2009
    Location
    Near London, UK
    Posts
    4,091

    Default

    I use YNAB to manage my budget. I wouldn’t be without it. Well worth the annual subscription.

  6. #6

    Godlike

    jamesbrown is a fount of knowledge

    jamesbrown's Avatar
    Join Date
    Dec 2011
    Posts
    7,225

    Default

    Quote Originally Posted by MarillionFan View Post
    I’ve been running one since 1997 and can trace it all the way back to when I had student debts.

    It’s nice to see how I moved from being skint to millionaire over those last 20 years. Though according to my forecast I should have at least another million on top!
    Here's a graphical representation.


  7. #7

    Fingers like lightning

    VillageContractor is a permanent contractor

    VillageContractor's Avatar
    Join Date
    Aug 2014
    Posts
    597

    Default

    Put some time into this over the holidays and got something workable, now the only thing is to make sure I update it regularly to see whether I'm saving or spending accordingly.

    I've looked at YNAB before but it doesn't look at dividends, income and tax. My spreadsheet helped me understand the optimal amount of dividends to take this yr - now that I think about it I probably should have got my accountant to do this.

  8. #8

    My post count is Majestic

    northernladuk is always on top

    northernladuk's Avatar
    Join Date
    Mar 2009
    Posts
    40,506

    Default

    Quote Originally Posted by jamesbrown View Post
    Here's a graphical representation.

    I'm sure that could be used in the Crypto thread many times over.
    'CUK forum personality of 2011 - Winner - Yes really!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •