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.
This article summarizes good practices and recommendations for your financial model.
Currency on the Slidebean financial model is controlled via the Settings Page, to allow you to use a centralized symbol, rather than having to assign formatting to each cell.
Most of the sheets, including Revenue, SG&A, Staff, COGS, and CAPEX, have a 'Currency' column that is linked to this cell. You should format numbers as 'Automatic' or 'Numbers' using your spreadsheet editor's formatting tools, rather than adding a currency symbol to each cell.
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.
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.
The basics of driver based modeling