Excel sheet with formulas to work out a day rate to charge
- or -
Post a project like this3100
£20(approx. $25)
- Posted:
- Proposals: 3
- Remote
- #926673
- PRE-FUNDED
- Completed
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
General information for the business: Variable day rate depending on number of days worked
Description of excel work: What I would like to receive at the end of this job is an Excel sheet with fields which I can populate with these variable details;
- Required income for the month
- Tax to be paid
- Number of days worked per week
- Exchange rate for currency
So it can display the amount which needs to be charged.
For example, if I need to bring home 3500 per month, and I'm paying 21% tax, and I have 5 days of work, the worksheet will tell me that I need to charge 200 per day.
If I'm only working 3 days per week, the worksheet will tell me I'll need to charge 325 per day, 2 days per week I'll need to charge 550 per day, etc. (numbers for illustrative purposes)
I will also need to be able to convert between Pounds Sterling, Euros and US Dollars - ideally by allowing me to put in my own conversion so the primary sheet will be in Pounds Sterling but there will be a box where I can put in a rate of (for example) 1.4 for Euros and 1.5 for Dollars (it will be different to the actual exchange rate to allow for fluctuations).
And all of the above is required before 10pm GMT on Sunday 11th October - please do not bid if you cannot meet this timescale.
Happy to answer any queries and clarify details before applying for the work.
A
Extra notes:
Description of excel work: What I would like to receive at the end of this job is an Excel sheet with fields which I can populate with these variable details;
- Required income for the month
- Tax to be paid
- Number of days worked per week
- Exchange rate for currency
So it can display the amount which needs to be charged.
For example, if I need to bring home 3500 per month, and I'm paying 21% tax, and I have 5 days of work, the worksheet will tell me that I need to charge 200 per day.
If I'm only working 3 days per week, the worksheet will tell me I'll need to charge 325 per day, 2 days per week I'll need to charge 550 per day, etc. (numbers for illustrative purposes)
I will also need to be able to convert between Pounds Sterling, Euros and US Dollars - ideally by allowing me to put in my own conversion so the primary sheet will be in Pounds Sterling but there will be a box where I can put in a rate of (for example) 1.4 for Euros and 1.5 for Dollars (it will be different to the actual exchange rate to allow for fluctuations).
And all of the above is required before 10pm GMT on Sunday 11th October - please do not bid if you cannot meet this timescale.
Happy to answer any queries and clarify details before applying for the work.
A
Extra notes:
Double A.
100% (7)Projects Completed
15
Freelancers worked with
12
Projects awarded
31%
Last project
21 Nov 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies