the following year-end results: For next year, Strellman is making the following planning assumptions: Revenue growth: 7.5% IBT Margin: 1 percentage point higher than current year (e.g. if Current Year IBT Margin is 25%, the planning year IBT Margin would be 26%) Tax Rate: Unchanged Dividends: Same dollar amount as current year Current Assets: Increase 2 percentage points faster than the sales growth rate (e.g., if Sales Growth rate is 10%, the Current Assets would rise by 12%) Net Fixed Assets: $2.4 million net increase Long-Term Debt: Repay $0.7 million Repurchase $1.8 million in common shares (a reduction in Common Stock Questions: a. What amount of Short-term Debt will be needed in Box 1 to make this plan possible? (You will need to make a pro forma forecast of the table above to answer this question.) b. You realize that your Short-Term Borrowing facility is limited to $8.5 million. To comply with this cap. you decide to defer the purchase of a fourth machining center and thus cut the capital spending plan by $860,000 to a $1,540,000 net increase (instead of the planned $2,400,000 increase): and you also decide to reduce the sales forecast. All the other parameters set out in Part (A) continue to apply. What is the new growth rate in sales in Box 2 (percentage to one decimal point, like x.x%) in that you can support with the credit constraint? This homework Mini Case requires that you complete and then upload the Excel file template Jinked in these instructions. Rename the file as follows: "Your Last Name] Assignment#2.xlsx and Submit here by clicking on the Submit Assignment button above and upload your document. The Strellman Corporation, a metal forming company, had the following year-end results: For next year, Strellman is making the following planning assumptions: Revenue growth: 7.5% IBT Margin: 1 percentage point higher than current year (e.g., if Current Year IBT Margin is 25%, the planning year IBT Margin would be 26%) Tax Rate: Unchanged Dividends: Same dollar amount as current year Current Assets: Increase 2 percentage points faster than the sales growth rate (e.g., if Sales Growth rate is 10%, the Current Assets would rise by 12%) Net Fixed Assets: $2.4 million net increase Long-Term Debt: Repay $0.7 million Repurchase $1.8 million in common shares (a reduction in Common Stock the following year-end results: For next year, Strellman is making the following planning assumptions: Revenue growth: 7.5% IBT Margin: 1 percentage point higher than current year (e.g. if Current Year IBT Margin is 25%, the planning year IBT Margin would be 26%) Tax Rate: Unchanged Dividends: Same dollar amount as current year Current Assets: Increase 2 percentage points faster than the sales growth rate (e.g., if Sales Growth rate is 10%, the Current Assets would rise by 12%) Net Fixed Assets: $2.4 million net increase Long-Term Debt: Repay $0.7 million Repurchase $1.8 million in common shares (a reduction in Common Stock Questions: a. What amount of Short-term Debt will be needed in Box 1 to make this plan possible? (You will need to make a pro forma forecast of the table above to answer this question.) b. You realize that your Short-Term Borrowing facility is limited to $8.5 million. To comply with this cap. you decide to defer the purchase of a fourth machining center and thus cut the capital spending plan by $860,000 to a $1,540,000 net increase (instead of the planned $2,400,000 increase): and you also decide to reduce the sales forecast. All the other parameters set out in Part (A) continue to apply. What is the new growth rate in sales in Box 2 (percentage to one decimal point, like x.x%) in that you can support with the credit constraint? This homework Mini Case requires that you complete and then upload the Excel file template Jinked in these instructions. Rename the file as follows: "Your Last Name] Assignment#2.xlsx and Submit here by clicking on the Submit Assignment button above and upload your document. The Strellman Corporation, a metal forming company, had the following year-end results: For next year, Strellman is making the following planning assumptions: Revenue growth: 7.5% IBT Margin: 1 percentage point higher than current year (e.g., if Current Year IBT Margin is 25%, the planning year IBT Margin would be 26%) Tax Rate: Unchanged Dividends: Same dollar amount as current year Current Assets: Increase 2 percentage points faster than the sales growth rate (e.g., if Sales Growth rate is 10%, the Current Assets would rise by 12%) Net Fixed Assets: $2.4 million net increase Long-Term Debt: Repay $0.7 million Repurchase $1.8 million in common shares (a reduction in Common Stock