Closed

Complicated Excel Model

I am looking for assistance with setting up a complicated financial and planning model in MS Excel.

I envision one input sheet with a variety of questions, which can be answered either yes/no, with dates/times/hours, or with numbers. This would be laid out in a sophisticated way and essentially be so that a person with a very basic computer understanding would be able to understand without virtually any assistance.

Some data will be always one set, some data will be a range of sets from 3-8 different inputs, some data may be available some data might not be available. From the first set direct outputs will be developed. From the second range, averages, ranges (min/max) shall be given.

Subsequently all data should translate into a “review tab” – as the spreadsheet advises on ratios to be used, the human would be able to put in final decision numbers per entry.

The data from this tab would then be lodged into planning tabs. Parameter tabs and financial tabs. In total there would be 75 tabs with each tab about 100 lines and 30 columns. For some graphical representation of the outputs shall be given. In total about 50 graphs are expected. These last tabs are to be laid out as printable and sophistically laid out (printable) A4-pages with headers, footers, logo’s etc.

Input data names will be provided as flow diagrams, 20% of the formulas are currently written and will be provided to you.

Qualifications:

- Excellent analytical skills

- Good level of English

- Strong financial acumen (IRR, NPV, Cash Flows, etc.)

- Excellent Excel skills (programming/macros, highly complicated formulas, etc.)

Deadline:

- I expect the workload for this to be approximately 15 working days.

Important:

Due to confidentially concerns you will be required to sign a Non Disclosure Agreement (NDA) subject to a fine. You will also waive authorship and any further proceeds as part of our agreement.

Skills: Data Science, Excel, Financial Analysis

See more: excel illustrator diagrams, baggage handling model excel, excel 2007 creating list worksheet names, equity research valuation model excel, excel filtered calculates currently filtered, commercial real estate valuation model excel sample, real estate development model excel, excel visual basic extract worksheet names, excel 2003 view list worksheet names, options model excel, financial model excel, banking model excel, understand evaluation model excel sheets, nepra tariff model excel, bank model excel

About the Employer:
( 0 reviews ) Hong Kong

Project ID: #12291386

23 freelancers are bidding on average $5490 for this job

$5000 HKD in 10 days
(244 Reviews)
7.6
$10526 HKD in 10 days
(114 Reviews)
6.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$6000 HKD in 15 days
(154 Reviews)
6.5
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$6000 HKD in 10 days
(118 Reviews)
6.3
rakeshwadhwani

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 firm for your project, kindly check my profile, reviews, rating and More

$4444 HKD in 10 days
(41 Reviews)
5.5
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$5500 HKD in 5 days
(74 Reviews)
5.3
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y More

$4444 HKD in 10 days
(33 Reviews)
4.9
ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti More

$5000 HKD in 15 days
(33 Reviews)
4.6
suyashdhoot

Hi I am a very experienced statistician and research analyst. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have More

$10000 HKD in 15 days
(6 Reviews)
4.5
zu02

Hi there, if you'd really like to have a professional software for your project , here is my introduction: I’m an Access/VBA programmer, a mathematician and a full time developer with a strong background developing a More

$6666 HKD in 15 days
(7 Reviews)
4.6
RRconsultant

Hi there, I am a qualified accountant with ~10 years’ experience in financial research including financial modelling and projections for the equity research team of largest investment Banks globally. I am keen to More

$4444 HKD in 10 days
(16 Reviews)
5.0
kchas1

Hello, I am an Excel developer in NYC with extensive corporate and academic credentials. More importantly, I solve problems. Please share your details. Thanks. -Kevin

$6666 HKD in 5 days
(6 Reviews)
3.5
TheLKteam

Hi, I've been working in the field of finance using Excel macros for several years and would like to work on your project. I'm looking forward to hearing from you.

$4000 HKD in 15 days
(2 Reviews)
2.3
tandonshailendra

This box has limited space and no provision for attachments. As desired, I am prepared to sign NDA. I have developed various Planning and Financial Module. I am Mechanical Engineer, proficient in MS Access, Excel Ma More

$3900 HKD in 10 days
(7 Reviews)
3.1
franolubura

I am Finance manager in the small company in the UK, currently doing my MBA. I work with the excels on an everyday basis and because of my job type and experience I think I would be a perfect candidate for your projec More

$2000 HKD in 12 days
(0 Reviews)
0.0
bryanimit

Good Evening, I have an advisory firm in Hong Kong that handles just this very thing. Why don't you come into the office and you can whiteboard everything for me. I can also come up with a proper price for you. By More

$2000 HKD in 10 days
(0 Reviews)
0.0
$6666 HKD in 10 days
(0 Reviews)
0.0
teddyho

Hi there! I'm very excited to help you with your project. It sounds quite substantial and could make a big impact to your business. I'll be sure to create a top-notch model both functionally and aesthetically. More

$6688 HKD in 10 days
(0 Reviews)
0.0
andyolimov

I'm a Equity Analyst and have experience in building several Excel models. I have a finance background and work experience.

$5555 HKD in 10 days
(0 Reviews)
0.0
jfuryu

I am a Investment banker with a wealth of experience as a developer. I build and work with Complex Financial models in excel on a daily basis. I believe my understanding of Financial analysis, Financial Ratios, Sensiti More

$5000 HKD in 10 days
(0 Reviews)
0.0