I have a 5-year financial projection MS Excel spreadsheet which needs to have the dates changed by 4 months.
Ideally the task needs to be completed in the next 24 hours (maximum 48 hours).
Presently the projections commence April 2018 and we need this to be changed to January 2018 (with the resulting 'missing' 4 months of 2023 simply a repeat of the August 2023 figures). The existing file is fully linked, which is the reason I am having trouble with a manual cut-and-paste ... however the amended file does not ti be fully linked and internally consistent as long as the correct figures are in place.
The file consists of 9 worksheets:
- Monthly OpEx for 5 years
- Monthly P&L for 5 years
- Monthly Balance Sheet for 5 years
- Monthly Cash Flow for 5 years
- Summary consolidated yearly P&L
- Summary consolidated yearly Balance Sheet
- Summary consolidated yearly Cash Flow
- Summary consolidated yearly sales
- Summary consolidated chart of projected yearly sales and EBITDA
The spreadsheet is exactly the way we want it and fully complete as well as internally consistent ... it simply needs to be adjusted to commence 1 January 2018 rather than 1 May 2018 - with the resulting changes to the yearly totals, which are then reflected in the yearly summaries.
I need to engage a resource who is both adept at this task (MS Excel/financial projections) as well as fluent in English. Please provide credentials and experience (along with hourly rate) and if selected I will send you a copy of the original spreadsheet. Happy to pay hourly rate based on your estimate of the total number of hours.
For someone who knows what they are doing this is a straightforward task so if you are not 100% competent and experienced please do not apply. The hourly rate is a lot less important than the total amount of time for the job, and our level of confidence in your proven ability to complete this in the time available.