Review and test Business Plan Projections Model (Spreadsheet)
- or -
Post a project like this1619
£150(approx. $188)
- Posted:
- Proposals: 11
- Remote
- #2591977
- Completed
Business Plan Expert, Financial Planner, Investors' Pitch Deck, Accounting & Bookkeeping
Karachi
Excel Expert |WordPress| Google Sheets |VBA & Google App Script | Woocommerce
Jhelum
Creative Graphics Designer & Full stack Developer| Shopify expert| Data entry |PDF Editing
Toronto
14380672558814899459352161022702274245627829773075310316471732497403283983
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
I have a spreadsheet model which is used to create projections for a business plan. Includes P&L and Balance Sheet. I will supply the spreadsheet but I need a qualified person to go over the document and validate the formulas. Not to edit or re-design the spreadsheet but identify and communicate where errors exist.
Errors include...
- incorrect formulas
- missing components of this type of model.
Particular attention must be paid to Balance Sheet items and the functions these are based on and resulting calculations.
The spreadsheet covers 3 years, broken into monthly totals from which year end figures are derived.
Currently on Google Documents I can share access or send .xls file by email. Beware potential conflicts in downloading from Google Sheets to .xls! Some functions you might expect to work in Excel may not because the original came from Google Sheets.
Deliverable by you...
(1) I require you to provide, as part of this project, two formulas specific to this spreadsheet. (i) Corporation Taxation on a monthly basis as in; corporation tax running balance due (asset/liability); FOR EXAMPLE =D4 + C3 *(SUM(D3:K3)). (ii) Share Capital calculation.
(2) There may or may not be an intentional error to test whether you have successfully reviewed the entire spreadsheet. Unlocking this puzzle is a mandatory requirement of the project and failure to recognise this flaw will result in non-compliance with requirements.
I have included a .pdf of the spreadsheet to give you an indication the rows involved. This document (tab is called 'Projections') is the output of the model and will be used in a business plan for funding. On this file the only manually altered figures are the Opening Balance of the bank account and the principal on one of the loan amounts. All other figures are driven by assumptions, formulas on other tabs.
Tabs holding assumptions:
1. Debt Finance Model - principal, interest, duration of business loans. 3 loans detailed.
2. Valuation - NPV and discount rates for calculating consideration used in Projections.
3. Actual - Forecast: 2018-2022 - Historical P&L figures used to determine projections forward. Projections forward based on random ranges taken from historical actuals. So for example 'Marketing' in Year One projection might be between 0.973 and 1.34 of the actual average over the last two years.
4. Monthly Cash as % of Total - we have the data on their cash flow from invoices raised and paid in each month. The model uses actual pay dates of invoices and splits this into a monthly % of total income. So in March the business might receive 18% of total sales and April might be 4%. This is used to break out the projections on a monthly basis. Projected forward sales are again a random figure on same basis and that illustrated with 'Marketing' in point 3.
I assume you would have to spend 50% of the time you estimate this project requires reviewing the spreadsheet in order to understand it's working fully: following formulas back to origin and understanding how assumptions feed into the model. 40% of time would then be spent testing the model to verify accurate calculations (deliverable #2) and the remaining 10% to calculating required sheet specific formula (deliverable #1).
Errors include...
- incorrect formulas
- missing components of this type of model.
Particular attention must be paid to Balance Sheet items and the functions these are based on and resulting calculations.
The spreadsheet covers 3 years, broken into monthly totals from which year end figures are derived.
Currently on Google Documents I can share access or send .xls file by email. Beware potential conflicts in downloading from Google Sheets to .xls! Some functions you might expect to work in Excel may not because the original came from Google Sheets.
Deliverable by you...
(1) I require you to provide, as part of this project, two formulas specific to this spreadsheet. (i) Corporation Taxation on a monthly basis as in; corporation tax running balance due (asset/liability); FOR EXAMPLE =D4 + C3 *(SUM(D3:K3)). (ii) Share Capital calculation.
(2) There may or may not be an intentional error to test whether you have successfully reviewed the entire spreadsheet. Unlocking this puzzle is a mandatory requirement of the project and failure to recognise this flaw will result in non-compliance with requirements.
I have included a .pdf of the spreadsheet to give you an indication the rows involved. This document (tab is called 'Projections') is the output of the model and will be used in a business plan for funding. On this file the only manually altered figures are the Opening Balance of the bank account and the principal on one of the loan amounts. All other figures are driven by assumptions, formulas on other tabs.
Tabs holding assumptions:
1. Debt Finance Model - principal, interest, duration of business loans. 3 loans detailed.
2. Valuation - NPV and discount rates for calculating consideration used in Projections.
3. Actual - Forecast: 2018-2022 - Historical P&L figures used to determine projections forward. Projections forward based on random ranges taken from historical actuals. So for example 'Marketing' in Year One projection might be between 0.973 and 1.34 of the actual average over the last two years.
4. Monthly Cash as % of Total - we have the data on their cash flow from invoices raised and paid in each month. The model uses actual pay dates of invoices and splits this into a monthly % of total income. So in March the business might receive 18% of total sales and April might be 4%. This is used to break out the projections on a monthly basis. Projected forward sales are again a random figure on same basis and that illustrated with 'Marketing' in point 3.
I assume you would have to spend 50% of the time you estimate this project requires reviewing the spreadsheet in order to understand it's working fully: following formulas back to origin and understanding how assumptions feed into the model. 40% of time would then be spent testing the model to verify accurate calculations (deliverable #2) and the remaining 10% to calculating required sheet specific formula (deliverable #1).
Alistair W.
100% (6)Projects Completed
6
Freelancers worked with
6
Projects awarded
63%
Last project
7 Oct 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies