Find Jobs
Hire Freelancers

Edit Conditional Formulas In Excel Model

$30-250 USD

Fullført
Lagt ut nesten 9 år siden

$30-250 USD

Betalt ved levering
Hi Thank you for reviewing my project. I'm looking to hire an Excel expert who is skilled with financial models and conditional formulas to update formulas in tables. The tables link to other tabs in an Excel model to produce values that are represented in a break even chart. I've prepared a short video that gives some background information and the changes that are required in order to satisify the required outcome. See the video below: [login to view URL] The following summarises the the problem: As described in the video, the formulas on the right in the "break even analysis" tab populate a break even chart. The current formulas in the columns highlighted at the top in yellow work fine for a company that sells products. Where the company sells services, the formulas don't work because they are based on units sold, as entered in the "sales forecast" tab and contribution per unit in the "break even analysis" tab. The project specification is as follows: 1. Edit the current formulas in the columns highlighted in yellow in the "break even analysis" tab (currently for a company that sells physical products) to incorporate the scenario where the sales data entered in the "Sales forecast" tab is that for a service company (e.g. freelancer) that doesn't sell physical products. To required outcome is for the formulas in the highlighted (yellow) columns reflect both a service company and a company that sells physical products. This is achievable by editing the current conditional formulas. 2. Edit the formulas in the "Sensitivity Analysis and Ratios" tab where the company is a service company. 3. Test the changes to the formulas by entering test data in the "Sales forecast" tab to ensure they are functioning as required. Finally, I will provide the chosen freelancer with some ideas on how to edit the formulas in the "break even analysis" tab to achieve the desired outcome. This project should take an Excel expert who has finance modelling skills no more than two hours to complete, including testing. My maximum budget is $50 because I'm looking for a quick solution and I only hire the best freelancers to work on my projects. If you are not an expert in Excel with finance experience, please don't waste our time bidding on this project. You should be free to start the project once you have been selected. Thank you again for reviewing my project. Regards David
Prosjekt-ID: 8136977

Om prosjektet

27 forslag
Eksternt prosjekt
Aktiv 9 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
I have the expertise in Excel and can do the project as per the description here. Ready to start work immediately.
$50 USD om 1 dag
4,6 (65 omtaler)
5,4
5,4
27 frilansere byr i gjennomsnitt $116 USD for denne jobben
Brukeravatar
"Thanks David for looking for my proposal!!I have a look on video do you need graphs also. **Check my reviews to confirm our work quality(100%completion rate) ***From last 4.5 yers of I done more than 1200 projects in O-Desk,Freelancer, Guru and E Lancer***I am expert in Excel, Macros,VB.net, Web scraping, Data enty, Copy typing, Transcription works***Ihave my own scraping tool to scrap the data and have tools developed in VB.net to make Data entry works easy***I strongly committed to my work.*** I can work 8 to 10 hrs per day and 24 X 7 available for comunication support***I will deliver your project within the shortest possible time within your budget*** Check my O-desk profile - SBLancer and E Lancer profile - datakartsolutions With Regards, Bhaskar "
$50 USD om 3 dager
4,9 (449 omtaler)
7,7
7,7
Brukeravatar
Hi, not sure why the formula bar was hidden in the video as it would have helped to see the formulas in the selected cells, especially since no Excel file was provided
$150 USD om 1 dag
4,9 (251 omtaler)
7,7
7,7
Brukeravatar
After carefully reviewing your requirement, I confirm I am able to do this task for you. I am an expert in MS Excel to the point I previously held training programmes on VBA and Macro writing. I can provide you with a full and correct outcome on this task, Quickly. As you have requested. Please review my completion rate for work, this is 100% - I don't let clients down, ever. Kind regards, ES.
$132 USD om 3 dager
4,9 (237 omtaler)
7,0
7,0
Brukeravatar
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$45 USD om 1 dag
5,0 (255 omtaler)
6,6
6,6
Brukeravatar
A proposal has not yet been provided
$222 USD om 2 dager
4,8 (94 omtaler)
6,4
6,4
Brukeravatar
Having more than 14 years of experience in banking /finance /accounting, business analysis, Data analysis, process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, etc. Expert in MS office, which includes powerpoint presentation, mail merge, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers.
$50 USD om 0 dag
4,9 (83 omtaler)
6,1
6,1
Brukeravatar
I have more than 15 years’ experience in business planning and project management. I have written more than 500 projects in different scopes. My work is individual, without using common templates and software. I hold a Bachelor of Applied Mathematics and a Master of Business and Finance in Institute of Chartered Accountants in England and Wales. Thank you in advance.
$54 USD om 1 dag
4,8 (37 omtaler)
6,2
6,2
Brukeravatar
Dear David, thank you for the very detailed project description. I have over 12 years of experience in financial analysis and modelling while working in finance, audit and accounting industries (including 4 years at consulting department of a Big4 audit firm). I am well prepared to work on this project and will provide high quality result with quick turnaround. Thank you!
$50 USD om 0 dag
5,0 (65 omtaler)
5,6
5,6
Brukeravatar
Hello You will get 100% high quality professional work,we are team of professionals Looking forward to hear from you. Thank you.
$147 USD om 3 dager
5,0 (8 omtaler)
5,1
5,1
Brukeravatar
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right candidate for your project, kindly check my profile, reviews, rating and portfolio. With over 8 years of cross-functional experience, and helping clients world wide, I provide genuine and innovative solutions as per your circumstances and requirements. I hold MBA-Finance, M.A-Economics and Chartered Accountancy. If you feel to discuss more before you award me the project, you can send me the message. Kind regards, Naveen
$155 USD om 3 dager
4,7 (23 omtaler)
4,4
4,4
Brukeravatar
Hello David My name is Dan. I have watched the video and understood the requirement. As the spreadsheet is not completely visible in the video, it will be nice if you could share the file. I would need to know as to how the service company and manufacturing company are identified in this spreadsheet ? Is there an indicator to know the difference ? Please message me and we can discuss and proceed further. Thanks ! Regards Dan
$50 USD om 1 dag
4,9 (10 omtaler)
4,3
4,3
Brukeravatar
I have a Master's in Finance from Johns Hopkins and am very experienced in utilizing Excel for financial analysis. I see two general directions to take this project: update the formulas so that the user can just input how much they billed for a certain type of labor or just reconceptualize units sold as hours worked. You probably won't need me if you wanted to go with the latter option but I thought I'd suggest it.
$66 USD om 3 dager
5,0 (2 omtaler)
3,6
3,6
Brukeravatar
A proposal has not yet been provided
$50 USD om 1 dag
5,0 (1 omtale)
2,5
2,5
Brukeravatar
I am the bookkeeper in the UK accountancy firm's back office and have good skills in excel so it'll be great to working on urgent assignments.
$50 USD om 0 dag
5,0 (5 omtaler)
0,8
0,8
Brukeravatar
I am expert in MS Excel with over 9 years of professional experience in using Excel in data analysis, calculations, and reporting. I can do the corrections in formulas for you quickly, accurately, and in budget. I have used complex formulas and calculations in many projects and all the required knowledge like absolute/relative referencing, ranges, cross-sheet referencing, conditional formulas that will help do the task
$45 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
A proposal has not yet been provided
$222 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
A proposal has not yet been provided
$55 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hi, it's easy job and I can help you with table and all links. I can add some new columns, if needed. We can show the currency as well , etc
$45 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hi i am sandeep rawat. I am currently working as a business analyst and my job roles is to create complex financial models and edit them from time to tim
$50 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hi Thank you posting a video to explain your requirement. I have understood what you want to achieve through this project. I come from a market research background, where 90% of my daily working time goes into data analysis in Excel. I have been working on conditional formulas in Excel since 4 years. Previously being a software developer, I have worked on all kinds of logical data solutions. Based on the video that you have shared, and the solution that you are seeking through this project, I can comfortably complete the work within a day. Hoping to work on this project. Awaiting positive response. Thank You. Best Regards, Nihar
$40 USD om 0 dag
0,0 (0 omtaler)
0,0
0,0

Om klienten

UNITED KINGDOMs flagg
London, United Kingdom
4,9
291
Betalingsmetode bekreftet
Medlem siden apr. 2, 2011

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.