Chapter 3 Problem 16 a. Using the information provided, construct a monthly cash budget for October through December 2021. Based on your analysis, will Noble enjoy a surplus of cash, or require external financing? b. Construct a pro forma income statement for the first fiscal quarter of 2022 (Oct. through Dec. 2021) and a pro forma balance sheet as of December 31, 2021. What is your estimated external funding required for December 31 ? c. Does the December 31, 2021 estimated external financing equal your cash surplus (deficit) for this date from your cash budget? d. Based on your answers above, construct a cash flow forecast for Noble for the period October through December 2021. NOBLE EQUIPMENT CORP. INCOME STATEMENT (\$ thousands) 1 Cost of goods sold consists entirely of items purchased during the quarter. 2 Selling and administrative expenses consist entirely of salaries. 3 Depreciation is straight-line at the rate of $4,000 per quarter. 4 Accrued expenses are not expected to change in the last quarter. 5$25.7 due December 2021. No payments for remainder of year