Net Revenue forecasting Net Revenue forecasting
Posts 1 to 7 of 7
  1. #1

    Nervous Newbie


    Join Date
    Jan 2013
    Posts
    12

    Default Net Revenue forecasting

    Hi All,

    I'm wondering if someone can help me out with a question I have. I'm trying to put together a basic and very 'crude' formula to enable me to do some revenue calculation comparisons.

    Basically I want a spreadsheet with a different daily rate in each column, number of days worked in a month and VAT applied etc. I then want a formula to calculate my annual revenue (with some assumption on number of days worked over the year etc) and I want to apply a very basic formula to calculate the income net of tax (all tax - capital gains, income, VAT). But I'm not looking for a comprehensive set of calculations (I'll let my accountant do that for me). I'm looking for a very crude formula (like somewhere between 20 - 35% maybe?) to enable me to do some revenue forecasting and also some 'what if' analysis based on different business development options and different possible rates of pay being earned.

    I hope my question is clear enough for people to answer but please advise if further clarification is required.

    Thanks in advance for my replies

    jonniu

  2. #2

    Still gathering requirements...


    Join Date
    Jul 2014
    Posts
    22

    Default

    Lol. If you can't work that out then how can you have any sort of grip on your company finances?

  3. #3

    Nervous Newbie


    Join Date
    Jan 2013
    Posts
    12

    Default

    Thanks for your helpful post

  4. #4

    Contractor Among Contractors

    PerfectStorm's Avatar
    Join Date
    May 2014
    Location
    Yes, I have asked my accountant.
    Posts
    1,395

    Default

    Could you use the Nixon Williams takehome calculator and plug different rates into it? If you select the option to see more info it will show you some of the working too.

  5. #5

    Nervous Newbie


    Join Date
    Jan 2013
    Posts
    12

    Default

    Quote Originally Posted by PerfectStorm View Post
    Could you use the Nixon Williams takehome calculator and plug different rates into it? If you select the option to see more info it will show you some of the working too.
    Oh I've never heard of that. I'll give it a whirl. Thank you for your help

  6. #6

    More time posting than coding


    Join Date
    Jan 2013
    Location
    Watford & London
    Posts
    200

    Default

    Quote Originally Posted by PerfectStorm View Post
    Could you use the Nixon Williams takehome calculator and plug different rates into it? If you select the option to see more info it will show you some of the working too.
    This will be fine for what you need. From memory it doesn't account for profits that you don't draw that would send you into higher rate tax - but that's an extra complication for your accountant

  7. #7

    Double Godlike!

    malvolio's Avatar
    Join Date
    Jul 2005
    Location
    Walking in the garden, dreaming of Olivia...
    Posts
    12,162

    Default

    IT's not rocket science. For a rough estimate:

    (((day rate) x (expected no of days worked per year)) - (likely expenses)) * 80%) will get you in the ball park. Or even simpler, assume net 70% of your gross and any more would be a bonus.
    Blog? What blog...?

Posting Permissions

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