construct pro forma financial statements for Starbucks and to develop basic financial projections. This week’s assignment is to prepare two pro forma financial statements and respond to related questions based on your projections. The required statements are a pro forma Income Statement and a pro forma Balance Sheet.
download the template to get started . You may also download and refer to the Home Depot template.
Use the Search FilingsLinks to an external site. page to download the last 10-Q from Starbucks into Excel.
In the Financial Forecasting ,
Complete the Income Statement and Balance Sheet on the appropriate tabs in the template, using the downloaded data. Calculate the expenses to determine what will change and what will remain the same. Summarize your rationale, within each line-item expense. Assume that sales will increase for the next quarter by the same percentage increase from the previous quarter to the last reported quarter. For example, if sales increased 8% from the last quarter to the current reported quarter, you would use 8% as the sales increase for your pro formas.