| [Company Name] |
|
|
|
| Annual Operating Budget |
|
|
| Model Inputs and General Information |
|
|
| |
|
|
|
| Model key |
|
|
|
| Bold numbers in white cells are entered by user. |
|
|
| Italicized numbers in gray cells are calculations that generally should not be altered. |
|
| Black numbers in gray cells are calculations that can be overwritten. |
|
|
| |
|
|
|
| |
|
|
|
| General notes and assumptions |
|
|
|
| Document key financial planning assumptions here. |
| |
|
|
|
| Key model inputs |
|
|
|
| Use this area to capture key general assumptions that carry throughout the model. |
|
| |
|
|
|
| 1. Fringe rate for labor |
25% |
|
|
| |
|
|
|
2. Number of years for straight-line
depreciation |
5 |
|
|
| |
|
|
|
| 3. Tax rate |
30% |
|
|
| |
|
|
|
4. Annual targeted revenue
per employee |
$270,000 |
|
|
| |
|
|
|
| |
|
|
|
