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.
- Excellent analytical skills
- Good level of English
- Strong financial acumen (IRR, NPV, Cash Flows, etc.)
- Excellent Excel skills (programming/macros, highly complicated formulas, etc.)
- I expect the workload for this to be approximately 15 working days.
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.
23 freelancers are bidding on average $5490 for this job
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
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.