Default Value: [Company Name]
This field will update the company name across all pages in the financial model.
Default Value: USD
You can use symbols or letters to define a currency on the model. Most of the sheets, including Revenue, SG&A, Staff, COGS, and CAPEX, have a 'Currency' column that is linked to this cell. As a general good practice, you should format numbers for accounting, and not for currency.
Default Value: 1/1/2023
This settings defines the initial month for the entirety of the financial model. Our financial model supports up to 84 months (7 years) from this start date.
This value is linked to cell D6 on the FS-Month sheet, which then uses an EDATE formula to increase the month value by one in every subsequent column. The calendar month section in every other page on the financial model is referenced from here.
Bear in mind that we only support starting the model in calendar years. We use a Data Validation dropdown to limit the input values to the start of calendar years. If you need a year that's different from the list available, you can edit it from the Data Validation settings on the spreadsheet.
Default Value: 0
This settings defines the cash in the bank the company has at the start of the model. It links directly to the Cash Flow section on the FS-Month sheet (specifically cell D89).
It's meant to be used if you would like to reflect free cash balance in your bank accounts prior to the model starting.
This is a functional model you can use to create your own formulas and project your potential business growth. Instructions on how to use it are on the front page.