Typically, the main balance sheet section of a model will either have its own dedicated worksheet or it will be part of a larger worksheet containing other financial statements and schedules. Now it’s time to turn to the balance sheet. Based on analyst research and management guidance, we have completed the company’s income statement projections, including revenues, operating expenses, interest expense and taxes – all the way down to the company’s net income. Imagine that we are tasked with building a 3-statement statement model for Apple. Forecasting cash and short term debt (revolving credit line).
