Income Stmt Pre-Deal Excel Sheet  make an income statement, together with a % of Sales analysis based on the information given. The 'Income Stmt with Projections' tab is provided to help get you started. Cells that require your attention are highlighted in blue. All blue cells should be filled in Hint: If pre-tax operating income is negative, it is possible for income tax expense to be negative, i.e. a credit. We can make that assumption in this case if/when applicable Cells highlighted in orange are forecasted growth rates applicable to each of the future years.

Answer rating: 100% (QA)

Introduction Creating an income statement and performing a percentage of sales analysis based on the provided information involves organizing financia... View the full answer