
Excel Financial Model update
- or -
Post a project like this1321
$100
- Posted:
- Proposals: 24
- Remote
- #3592061
- Awarded
Digital Solutions|Designer & Developer|Shopify|App Development|WordPress|Data Scraping|Lead Generation|Animation

Executive Virtual Assistant| IT Consultant | graphics| | Website design | social media management .

Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦

72839863811478301554920989661406416222557614380677122586626945772421403288524810153
Description
Experience Level: Entry
We have an existing excel based financial model, which we need modifying. We do not want to start from scratch, I repeat, we do not want to start from scratch, we simply want additional functionality building into the model.
Additional functionality includes the following;
On our original financial model, the cost hypothesis for some of our expenditure is the same for yr1, Yr2, and Yr3. This as you know is incorrect as expenditure does not stay the same 3 years in a row. We therefore need to include an algorithm that will automatically increase the expenditure each year by a variable input
I need to work out our staffing levels by working backwards from the revenue. I need you to calculate the 'revenue per employee' ratio based on our increasing turnover. This RPE needs to reflect the benchmark ratio of similar sized start-up tech companies. Once we have the benchmark we can work backwards from our revenue and work out how many staff we should have at any given time. I need to be able to easily include these new staffing levels into our cost hypothesis under the relevant job sub headings
Additional functionality includes the following;
On our original financial model, the cost hypothesis for some of our expenditure is the same for yr1, Yr2, and Yr3. This as you know is incorrect as expenditure does not stay the same 3 years in a row. We therefore need to include an algorithm that will automatically increase the expenditure each year by a variable input
I need to work out our staffing levels by working backwards from the revenue. I need you to calculate the 'revenue per employee' ratio based on our increasing turnover. This RPE needs to reflect the benchmark ratio of similar sized start-up tech companies. Once we have the benchmark we can work backwards from our revenue and work out how many staff we should have at any given time. I need to be able to easily include these new staffing levels into our cost hypothesis under the relevant job sub headings
Addressless mailing Ltd t/a DustiD
100% (4)Projects Completed
4
Freelancers worked with
4
Projects awarded
31%
Last project
3 Jun 2022
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