The Slidebean Financial Model
Knowledge Base

The Assumptions Sheet

The Assumptions Sheet lets users input key variables impacting business forecasts. It includes sections like Capital Expenditures and Loans, guiding the automatic estimation of costs like computer purchases and setting depreciation periods for various assets.

Article by 
Caya
 | 
Book Consulting Call
Last updated 
January 10, 2024

The Assumptions Sheet in the Slidebean Financial Model is a critical component for laying the groundwork of your financial projections. It allows users to input key variables that directly influence the business forecast.

On a our blank/free financial model template, the Assumptions sheet is mostly empty, and it is to be used as a dashboard to keep all programatic financial model assumptions in one place. On our pre-built financial model templates, the Assumptions sheet is pre-populated with the inputs from the financial model map.

Here's a breakdown of its main sections included on the free template.

For specific details on the our pre-built financial model templates, please visit the corresponding page:
- SaaS
- Marketplace
- eCommerce
- Mobile App

Capital Expenditures

Automatically estimate new computer purchases for new employees

Default Value: YES

This option, when enabled, automates the estimation of new computer purchases based on the number of new employees. Device purchases are automatically added to the CAPEX sheet, and Depreciated accordingly. See Depreciation.

Price per computer
Default Value:  2,000

Sets the cost assumed for each computer purchase. This figure is used in conjunction with the automated estimation for new computer purchases.

Time for Assets to Depreciate

This section allows you to set the depreciation period for various assets. Once an asset is depreciated, the model automatically triggers a re-purchase/replacement of the asset, based on the original price, plus the accumulated inflation.

Notice how all values except for computers are blue, which means the designation can be edited according to the company's needs.

Computers

Default Value: 3.0 years

Office Fixings

Default Value: 10.0 years

Office Furniture

Default Value: 3.0 years

Telecom Equipment:

Default Value: 5.0 years

Servers & Other Tech Infrastructure:

Default Value: 5.0 years

Other:

Default Value: 5.0 years

Inflation

Default Value: 3%

The assumed annual inflation rate. This percentage only impacts the estimated replacement/re-purchase value of depreciating assets.

Loans

This section allows you to estimate the default loan terms for any loan financing the company takes. Loans amounts can be added directly on the FS-Month sheet, and are amortized on the WK-CAPEX Sheet. For more detail now on how loans work, see our article about Loans.

Base Interest Rate

Default Value: 7%

The default interest rate for loans. This can be adjusted based on actual loan terms.

Base Term

Default Value: 24 months

Description: The default term length for loans, expressed in months.

Relevant articles

The Staff Sheet

Related to: 

Organized into sections for various company roles, the Staff Sheet allows for detailed input and monitoring of staff-related costs, tailor roles and expenses, track salary increments, and plan for new hires.

The Settings Sheet

The Settings Sheet allows you to set company-specific parameters like start dates, currency, and tax rates, ensuring all other sheets align with your unique business context.

Financial Modelling examples

Learn to model  🚀

A LIVE 1-week workshop to create investor-proof projections, estimate your fundraising needs, and track the core KPIs for any kind of startup
Learn more
Slidebean logo
© Copyright 2024 Slidebean Incorporated. All rights reserved.
Made with 💙️ in New York City and San Jose