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.
Prabodh K Sheth (PK)
30 freelancers are bidding on average RM1783 for this job
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.
HI Sir I have rich experience in excel and semi- automate the process as per your [url removed, login to view] Relevant Skills and Experience Excel,VBA Proposed Milestones RM1999 MYR - On Completion