Edit Conditional Formulas In Excel Model
$30-250 USD
Paid on delivery
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
Project ID: #8136977
About the project
Awarded to:
I have the expertise in Excel and can do the project as per the description here. Ready to start work immediately.
27 freelancers are bidding on average $116 for this job
"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 More
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
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
Hello You will get 100% high quality professional work,we are team of professionals Looking forward to hear from you. Thank you.
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, ratin More
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.
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 h More
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
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