Spreadsheet: 713761d1610918192-formula-for-recognising-dates-between-and-outside-a-range-of-start-and-end-times-staff-cost-forecasting-jan-2021
Sheet: Staff Costs (2)

STAFF COSTS & PRODUCTIVITY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To say if Start Date is AFTER beginning of year and END DATE is Before beginning of next year
 | Firm Start Date |  | 2021-04-01 00:00:00
STAFF COST ASSUMPTIONS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
 | NAME |  | TITLE | PT/FT | START DATE | END DATE | FIXED [NAME] (Annual) or PT Pro Rata | HEALTH INSURANCE | LIFE INSURANCE | EMPLOYER INCOME TAX % | DISCRET. BONUS US$ | HEAD HUNTER FEE (% Salary) | ANNUAL SALARY INFLATION | PROFIT SHARE % | ANNUAL INFLATION ON BENEFITS |  |  | <---- Annual Salary Forecast----> |  |  |  |  |  | <---- Annual Employer Income Tax----> |  |  |  |  |  | <---- Annual Employee Benefits----> |  |  |  |  |  | <---- Annual Employee Benefits----> |  |  |  |  |  | <---- Discretionary Bonus ----> |  |  |  |  |  | <---- Profit Share  ----> |  |  |  |  |  | <---- Headhunter Fees  ----> |  |  |  |  |  | <---- Headcount  ---->
PARTNER COSTS (USD) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-01 00:00:00 | 2023-04-30 00:00:00 | 2024-04-30 00:00:00 | 2025-04-30 00:00:00 | 2026-04-30 00:00:00
1 | A.N Other Partner 0 |  | Equity Partner | FT | 2021-04-01 00:00:00 |  | 1000000 | 10000 | 10000 | 0 |  | 0 | 0 | 0.9 | 0.03
2 | A.N Other Partner 1 |  | Non Equity Partner | FT | 2021-09-01 00:00:00 |  | 600000 | 10000 | 10000 | 0 | 500000 | 0.3 | 0.2 | 0.1
3 | A.N Other Partner 2 |  | Non Equity Partner | FT |  |  |  | 10000 | 10000 | 0 |  | 0 | 0 | 0 | 0.03
4 | A.N Other Partner 3 |  | Non Equity Partner | FT |  |  |  | 10000 | 10000 | 0 |  | 0 | 0 | 0 | 0.03
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Partners
SENIOR ASSOCIATE COSTS (USD)
1 | A.N Other Snr Assoc |  | Senior Associate | FT |  |  | 280000 | 5000 | 5000 | 0 | 65000 | 0 | 0.1 | 0
2 | A.N Other Snr Assoc |  | Senior Associate | FT |  |  | 280000 | 5000 | 5000 | 0 | 65000 | 0 | 0.05 | 0
3 | A.N Other Snr Assoc |  | Senior Associate | FT | 2021-09-01 00:00:00 |  | 280000 | 5000 | 5000 | 0 |  | 0 | 0 | 0
4 | A.N Other Snr Assoc |  | Senior Associate | FT |  |  | 280000 | 5000 | 5000 | 0 |  | 0 | 0 | 0
5 | A.N Other Snr Assoc |  | Senior Associate | FT |  |  | 280000 | 5000 | 5000 | 0 |  | 0 | 0 | 0
6 | A.N Other Snr Assoc |  | Senior Associate | FT |  |  | 280000 | 5000 | 5000 | 0 |  | 0 | 0 | 0
7 | A.N Other Snr Assoc |  | Senior Associate | FT |  |  | 280000 | 5000 | 5000 | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Snr Associates
JUNIOR ASSOCIATE COSTS (USD)
1 | A.N Other |  | Junior Associate | FT |  |  | 180000 | 5000 | 5000 | 0 | 25000 | 0 | 0.05
2 | A.N Other |  | Junior Associate | FT | 2021-09-01 00:00:00 |  | 180000 | 5000 | 5000 | 0 |  | 0 | 0.05
3 | A.N Other |  | Junior Associate | FT |  |  | 180000 | 5000 | 5000 | 0 |  | 0 | 0.05
4 | A.N Other |  | Junior Associate | FT |  |  | 180000 | 5000 | 5000 | 0 |  | 0 | 0.05
5 | A.N Other |  | Junior Associate | FT |  |  | 180001 | 5000 | 5000 | 0 |  | 0 | 0.05
6 | A.N Other |  | Junior Associate | FT |  |  | 180002 | 5000 | 5000 | 0 |  | 0 | 0.05
7 | A.N Other |  | Junior Associate | FT |  |  | 180003 | 5000 | 5000 | 0 |  | 0 | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Junior Associates
PARA LEGAL STAFF (USD)
1 |  |  | [NAME] | FT |  |  | 88888 | 2500 | 2500 | 0 | 0 | 0 | 0.05
2 | A.N Other |  | [NAME] | FT | 2024-01-01 00:00:00 |  | 88888 | 2500 | 2500 | 0 | 0 | 0 | 0.05
3 | A.N Other |  | [NAME] | FT
4 | A.N Other |  | [NAME] | FT
5 | A.N Other |  | [NAME] | FT
6 | A.N Other |  | [NAME] | FT
SUPPORT STAFF (USD)
1 | A.N Other |  | Head of Operations | PT |  |  | 60000 | 2500 | 2500 | 0 | 0 | 0 | 0.05
2 |  |  | Personal Assistant | FT |  |  | 85000 | 2500 | 2500 | 1 | 0 | 0 | 0.05
3 | A.N Other |  | Personal Assistant | FT | 2022-01-01 00:00:00 |  | 85000 | 2500 | 2500 | 2 | 0 | 0 | 0.05
4 | A.N Other |  | Personal Assistant | FT
5 | A.N Other |  | Personal Assistant | FT
6 | A.N Other |  | Personal Assistant | FT
7 | A.N Other |  | Personal Assistant | FT