Okay so here's another question. Hopefully I'm not limited to one question each day!
Below is an example of my financial spreadsheet with historical information. I would like to use some type of dynamic naming system that will allow me to analyze the data more effeciently and the ability to understand and verify my formulas. For example, I would like to name the line EBIT EBIT02, EBIT03, EBIT04 and so on relating to the year. Rather than having to select each and every one each time I open a new spread to perform the same analysis. At the same time, I would like to identify EBITDA as EBITDA02 which is equal to EBIT02 + DepAm02. I'm thinking that I'll need a separate sheet for this. Thoughts? Thanks.
Below is an example of my financial spreadsheet with historical information. I would like to use some type of dynamic naming system that will allow me to analyze the data more effeciently and the ability to understand and verify my formulas. For example, I would like to name the line EBIT EBIT02, EBIT03, EBIT04 and so on relating to the year. Rather than having to select each and every one each time I open a new spread to perform the same analysis. At the same time, I would like to identify EBITDA as EBITDA02 which is equal to EBIT02 + DepAm02. I'm thinking that I'll need a separate sheet for this. Thoughts? Thanks.
Financial Model V.9.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | IncomeStatementforXYZCompany | |||||||||
2 | ThousandsofDollars | |||||||||
3 | Historical | |||||||||
4 | 2002 | (05) | 2003 | (05) | 2004 | (05) | 2005 | |||
5 | Sales | $1,235 | 100.0% | $1,252 | 100.0% | $1,300 | 100.0% | $1,334 | ||
6 | CostofSales | $679 | 55.0% | $659 | 52.6% | $681 | 52.4% | $667 | ||
7 | GrossOperatingIncome | $556 | 45.0% | $593 | 47.4% | $619 | 47.6% | $667 | ||
8 | ||||||||||
9 | Selling,General&Admn.Expenses | $340 | 27.5% | $349 | 27.9% | $351 | 27.0% | $373 | ||
10 | DepreciationandAmortization | $48 | 3.8% | $52 | 4.2% | $56 | 4.3% | $75 | ||
11 | OtherNet(Income)/Expenses | ($12) | -1.0% | ($8) | -0.6% | ($7) | -0.5% | ($8) | ||
12 | EBIT | $180 | 14.6% | $200 | 16.0% | $219 | 16.8% | $227 | ||
Model |