Edit Conditional Formulas In Excel Model

Completed Posted Jul 25, 2015 Paid on delivery
Completed 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

Business Plans Excel Financial Planning

Project ID: #8136977

About the project

27 proposals Remote project Active Jul 29, 2015

Awarded to:

surekash7096

I have the expertise in Excel and can do the project as per the description here. Ready to start work immediately.

$50 USD in 1 day
(65 Reviews)
5.4

27 freelancers are bidding on average $116 for this job

SBITServices

"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

$50 USD in 3 days
(449 Reviews)
7.7
zExcel

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 in 1 day
(251 Reviews)
7.7
cleverpen

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 More

$132 USD in 3 days
(237 Reviews)
7.0
watersev

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 in 1 day
(255 Reviews)
6.6
swift555

A proposal has not yet been provided

$222 USD in 2 days
(94 Reviews)
6.4
kevivu

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 inclu More

$50 USD in 0 days
(83 Reviews)
6.1
BPlans

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 More

$54 USD in 1 day
(37 Reviews)
6.2
dviruki

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 co More

$50 USD in 0 days
(65 Reviews)
5.6
DominiqueFranc

Hello You will get 100% high quality professional work,we are team of professionals Looking forward to hear from you. Thank you.

$147 USD in 3 days
(8 Reviews)
5.1
naveenthourani

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

$155 USD in 3 days
(23 Reviews)
4.4
dank111

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 t More

$50 USD in 1 day
(10 Reviews)
4.3
seanlave

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 More

$66 USD in 3 days
(2 Reviews)
3.6
SVK1985

A proposal has not yet been provided

$50 USD in 1 day
(1 Review)
2.5
ahsaniqbal16

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 in 0 days
(5 Reviews)
0.8
zecrossmedia

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

$45 USD in 1 day
(0 Reviews)
0.0
fernandostcampos

A proposal has not yet been provided

$222 USD in 3 days
(0 Reviews)
0.0
abinashsu

A proposal has not yet been provided

$55 USD in 3 days
(0 Reviews)
0.0
vw8094800vw

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 in 1 day
(0 Reviews)
0.0
sandyrawat1983

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 in 3 days
(0 Reviews)
0.0
nihar2287

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 da More

$40 USD in 0 days
(0 Reviews)
0.0