Part A: Create Pro Forma Financial Statements This spreadsheet is set up so that yellow cells contain numbers and white cells contain formulas. Follow the steps below to prepare pro formas for 20X4, assuming that New England Corporation will make up any funding shortfall with long-term debt and will use any funding surplus to pay down long-term debt (let long-term debt be the plug figure). As a starting point, assume that sales growth in 20X4 will be equal to 12.5%. Enter this figure in the Key Assumptions section in cell C4, and then, in cell C11, enter the formula for projected sales in 20X4, which is = B11*(1 C$4). This will give you sales 12.5% highe