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
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
Comment