Kapalı

Business Projection Spreadsheet

Hi,

I have made a spreadsheet with a lot of formulas interlinking. I use it to project my business and have to keep updating it for different scenarios as we are a scale-up company and have different things coming at us all the time. Thus, I over a period have got quite a integrated spreadsheet that allows me to make Best & Worst Case scenario projections. This take a lot of my time and remembering version is difficult.

I want to now convert the spreadsheet into a semi-automated-Parameter Driven one, where I can enter key parameters which will then drive the projection. These are as follows:

1. Change the year as time moves on (meaning assuming that I did the projection for 2016 - 2020 ; and now it is 2017, so need to roll forward numbers so taht it is 2017 to 2021)

2. Changes sales volumes, applicable sales price and assumptions

3. Change selling price, cost price and packages (combination of items that make up the total sales price)

4. Add additional selling methods (currently, the spreadsheet is based on an outright purchase and installment)

5. Capex Parameters - estimate capex, determine which years they will be incurred over; change the spread when in (1) above, the year changes;

6. Summary of P&L, Balance Sheet, Cash Flow, Funding Calculations, Share Valuations,

7. Able to change for currency to be used (USD, MYR, THB)

8. Sales can come from single country or multiple country

9. Head count based on sales per country, head count per country, overall HQ headcount and similarly allowances

10. Some internal notes that help me remember what was the Basis of the Business Case in the spreadsheet

Pls send me you interest and capabilities, including if you have done work in this area. Upon shortlist I will send you my spreadsheet for you to better understand. I dont mind using an existing template if you already have one with similar functionalities. Or you can you mine and modify. Or you can write a fresh one.

Regards

Prabodh K Sheth (PK)

Beceriler: Excel, Uygulamalar için Visual Basic

Daha fazlasını görün: business directories spreadsheet, business card spreadsheet excel, enter business cards spreadsheet, salary projection spreadsheet excel, business cards spreadsheet, business card spreadsheet, excel business plan spreadsheet, business planning spreadsheet calculation, year business plan spreadsheet, business plan spreadsheet

İşveren Hakkında:
( 0 değerlendirme ) Puchong, Malaysia

Proje NO: #14831660

32 freelancer bu iş için ortalamada 1754RM teklif veriyor

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. Best regards Habilidades y experiencia re Daha fazlası

in 3 gün içinde2250RM MYR
(170 Değerlendirme)
6.7
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement. Relevant Skills and Experience I have the 5 years of e Daha fazlası

in 7 gün içinde2500RM MYR
(177 Değerlendirme)
6.9
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. Stay tuned, I'm still working on this proposal.

in 10 gün içinde2250RM MYR
(179 Değerlendirme)
6.7
in 10 gün içinde2222RM MYR
(187 Değerlendirme)
6.1
dgled

I have experience in accounting, Financial Report Tools, and in Excel/VBA. I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in accounting, consolidating, for Daha fazlası

in 10 gün içinde2750RM MYR
(30 Değerlendirme)
5.6
rohitagarberg

HI Sir I have rich experience in excel and semi- automate the process as per your requirements.Thanks Relevant Skills and Experience Excel,VBA Proposed Milestones RM1999 MYR - On Completion

in 10 gün içinde1999RM MYR
(187 Değerlendirme)
5.7
zu02

Hi, Prabodh After learning your project specifications I think a better way to build it from scratch. I can make it directly Ms Excel or via Ms Access GUI/ with Excel automation( if it need). Zura Relevant Skills a Daha fazlası

in 10 gün içinde2468RM MYR
(10 Değerlendirme)
4.7
in 10 gün içinde916RM MYR
(29 Değerlendirme)
4.6
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation and accounting. Propose Daha fazlası

in 10 gün içinde2000RM MYR
(44 Değerlendirme)
4.9
tiaratechies

Hello, I read your requirement and let me introduce our team first. we have a team of Chartered accountants and excel experts with more than 15 years of experience in this field. Relevant Skills and Experience Excel, Daha fazlası

in 10 gün içinde2780RM MYR
(28 Değerlendirme)
4.7
teeares

I have written many macros in Excel. I do understand, but have not written macros of the type you are looking. Please send me your spreadsheet then I can confirm Relevant Skills and Experience Excel VBA Proposed Mile Daha fazlası

in 10 gün içinde1833RM MYR
(49 Değerlendirme)
4.9
asadkhan3533

Please review my profile as i have relevant skills and experience for this project Relevant Skills and Experience Excel, Visual Basic for Apps Proposed Milestones RM1833 MYR - Excel, Visual Basic for Apps Send me a Daha fazlası

in 10 gün içinde1833RM MYR
(18 Değerlendirme)
4.4
awaisjahangir25

A proposal has not yet been provided

in 5 gün içinde825RM MYR
(11 Değerlendirme)
4.1
in 10 gün içinde2222RM MYR
(5 Değerlendirme)
3.6
in 10 gün içinde1000RM MYR
(16 Değerlendirme)
3.9
htiwary

Please accept my proposal and give a chance to prove my ability. Relevant Skills and Experience Almost 6+ years in VBA and more then 10 years in VB, VB.net, Asp.net which gives me an extra edge over others Proposed M Daha fazlası

in 5 gün içinde916RM MYR
(2 Değerlendirme)
1.7
JaishriLodha

Certified accountant with 8 years of diverse industry experience. Have expert command on excel. Provide quality work in agreed timelines.

in 3 gün içinde825RM MYR
(2 Değerlendirme)
2.0
NORAZEAN

15yrs experience on purchasing and human resource.... Relevant Skills and Experience Mic excel Proposed Milestones RM1833 MYR - By email Additional Services Offered RM2000 MYR - Mic Excel and Word Your site easy to Daha fazlası

in 10 gün içinde1833RM MYR
(0 Değerlendirme)
0.0
nagyahmed

A proposal has not yet been provided

in 5 gün içinde880RM MYR
(0 Değerlendirme)
0.0
figueroanny

Hola soy nuevo integrante en freelancer, comprendí lo que necesita, por favor contactarme para la actividad. Stay tuned, I'm still working on this proposal.

in 10 gün içinde2222RM MYR
(0 Değerlendirme)
0.0