I am completely lost. Any and all help would be appreciated

A. Using the information provided, construct a monthly cash budget for October through December 2017. 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 2018 (Oct. through Dec. 2017) and a pro forma balance sheet as of December 31, 2017. What is your estimated external funding required for December 31?

c. Does the December 31, 2017 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 2017.

Clipboard Font G10 X December A H 1 J K L 1 6 7 8 9 B D G NOBLE EQUIPMENT CORP. Facts and assumptions Sales (20 percent for cash, the rest on 30-day credit terms): 2017 Actual 2017 Projected July August SeptembeOctober November December 76,000 88,000 266,000 ##### 51,000 53,000 10 11 12 13 14 Purchases (all on 60-day terms): 2017 Actual 2017 Projected July August SeptembeOctober Novemb December er ##### ##### 257,000 62,000 27,000 26,000 15 16 17 18 19 20 21 22 Salaries payable monthly Principal payment on debt due in D Interest due in December Dividend payable in December Taxes payable in November Addition to acoumulated depreciat Cash balance on October 1, 2017 Minimum desired cash balance 20,000 25,700 9,000 15,000 19,000 4,000 34,000 15,000 24 25 26 27 28 29 30 31 32 NOBLE EQUIPMENT CORP. OME STATEMENT ($thousa Fiscal year ended September 30, 201 Net sales 1,581.6 Cost of goods sold' 1,098.0 Gross profits 483.6 Selling and administrative 240.0 Interest expense 18.0 Depreciation' 16.0 Net profit before tax 209.6 Tax at 33% 69.2 Net profit after tax 34 35 36 37 38 140.4 39 40 41 42 43 44 45 46 47 ALANCE SHEET($thousand September 30, 2017 Assets Cash 34.0 Accounts receivable 212.8 Inventory 425.0 Total current assets 671.8 Gross fixed assets 135.0 Accumulated depreciatio 52.0 Net fixed assets 83.0 Total assets 754.8 48 49 50 51 52 53 54 55 56 57 58 59 Liabilities Bank loan 0.0 Accounts payable 379.0 Accrued expenses 55.0 Current portion long-term 25.7 Taxes payable 56.0 Total current liabilities 515.7 Long-term debt 120.0 Shareholders' equity 119.1 Total liabilities and equity 754.8 61 62 63 65 66 67 'Cost of goods sold oonsists entirely of Selling and administrative expenses consist Depreciation is straight-line at the rate of "Accrued expenses are not expected to $25.7 due December 2017. No payments Sheet1 5 Sheet2 Sheet3 + Ready Type here to search Clipboard Font G10 X December A H 1 J K L 1 6 7 8 9 B D G NOBLE EQUIPMENT CORP. Facts and assumptions Sales (20 percent for cash, the rest on 30-day credit terms): 2017 Actual 2017 Projected July August SeptembeOctober November December 76,000 88,000 266,000 ##### 51,000 53,000 10 11 12 13 14 Purchases (all on 60-day terms): 2017 Actual 2017 Projected July August SeptembeOctober Novemb December er ##### ##### 257,000 62,000 27,000 26,000 15 16 17 18 19 20 21 22 Salaries payable monthly Principal payment on debt due in D Interest due in December Dividend payable in December Taxes payable in November Addition to acoumulated depreciat Cash balance on October 1, 2017 Minimum desired cash balance 20,000 25,700 9,000 15,000 19,000 4,000 34,000 15,000 24 25 26 27 28 29 30 31 32 NOBLE EQUIPMENT CORP. OME STATEMENT ($thousa Fiscal year ended September 30, 201 Net sales 1,581.6 Cost of goods sold' 1,098.0 Gross profits 483.6 Selling and administrative 240.0 Interest expense 18.0 Depreciation' 16.0 Net profit before tax 209.6 Tax at 33% 69.2 Net profit after tax 34 35 36 37 38 140.4 39 40 41 42 43 44 45 46 47 ALANCE SHEET($thousand September 30, 2017 Assets Cash 34.0 Accounts receivable 212.8 Inventory 425.0 Total current assets 671.8 Gross fixed assets 135.0 Accumulated depreciatio 52.0 Net fixed assets 83.0 Total assets 754.8 48 49 50 51 52 53 54 55 56 57 58 59 Liabilities Bank loan 0.0 Accounts payable 379.0 Accrued expenses 55.0 Current portion long-term 25.7 Taxes payable 56.0 Total current liabilities 515.7 Long-term debt 120.0 Shareholders' equity 119.1 Total liabilities and equity 754.8 61 62 63 65 66 67 'Cost of goods sold oonsists entirely of Selling and administrative expenses consist Depreciation is straight-line at the rate of "Accrued expenses are not expected to $25.7 due December 2017. No payments Sheet1 5 Sheet2 Sheet3 + Ready Type here to search