Part A,B,C,D please. Some numbers are already given.

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 Dee. 2017) and a pro forma balance sheet as of December 31,2017 . What is your estimated external funding reouired for December 31 ? c. Does the December 31, 2017 estimated external financing equal your cash surplus (deficit) for this date from your cash budeet? d. Based on your answers above, construct a cash flow forecast for Noble for the period October through December 2017. NOBLE EQUIPMENT CORP. Facts and assumptions Sales ( 20 percent for cash, the rest on 30-day credit terms): NOBLE EQUIPMENT CORP. INCOME STATEMENT (S thousands) Fiscal year ended September 30,2017 Net sales 1.581 .6 Cost of goods sold 1 1.098 .0 Gross profits 483.6 Selling and administrative expenses 2 Interest expense 18.0 Depreciation Net profit before tax Tax at 33% Net profit after tax 16.0209.669.2140.4 er. Depreciation is straight-line at the rate of $4,000 per quarter. 4 Accrued expenses are not expeped w change in the last quarter. \$ \$25.7 due December 2017. No payments for remainder of year. A. NOBLE DQUIPMENT CORP. Cash budget, 2017 Noble will need $151,300 in external financing by the end of December. NOBLE EQUTPAENT CORP. BALLMCE SHLET (S theusands) December 31,2017 Arseds Cash Aecounts receivable linentiory Total cument assetx Check ligure (82.40 Cross lined assets Accumalated depreciation Wurt finced axseta Tolal usetar Eheck figure 5A 1 du] Limbillities Bank loum Cheek ligure 151 i4 Aecaunta payable Miscellamegus exerada Cumtent partion loag term debt Taxer payaile Tatal qurremil liabilitied Cheek figune 3ar 84 lang lerminded Sinarebalders equily Toial hegudetige a equily Cherk figane laveniory ie -atinezifa es lollawa: Begianing invandary (x. 1. Iat quarrar fost of qoanda said Fadiag invengopy Deferalaef 31 enentrin ligane Toxes pay ible are earmated as kollowa: Taxea pay derle 5ape 30,2011 paymen mas Taxes payable Decomaer 31 Cinesin higure so sid C