Financial statements and additional information for Noble Equipment Corp. are available for download from McGraw-Hill’s Connect or your course instructor (see the Preface for more information). The company’s fiscal year end is September 30. Noble’s management wants to estimate the company’s cash balances for the last three months of calendar year 2021, which are the first three months of fiscal year 2022. The questions accompanying the spreadsheet ask you to prepare a monthly cash budget, pro forma financial statements, and a cash flow forecast for the period.

 LO.1