IF POSSIBLE SHOW EQUATIONS USED IN EXCEL.

Chapter 3 Problem 16 a. Using the information provided, construct a monthly cash budget for October through December 2017 BBased on your analysis, will Noble enjoy a surplus of cash, or require external financing? b IConstruct 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 rrequired for December 31 ? c. IDoes the December 31,2017 estimated external financing equal your cash surplus (deficit) for this date from your cash budget? d. IBased on your answers above, construct a cash flow forecast for Noble for the period October through December 2017. NOBLE EQUIPMENT CORP. Facts and assumptions iSales ( 20 percent for cash, the rest on 30 -day credit terms): Purchases (all on 60-day terms): \begin{tabular}{l|r} \hline Salaries payable monthly & 20,000 \\ \hline Principal payment on debt due in December & 25,700 \\ \hline Interest due in December & 9,000 \\ \hline Dividend payable in December & 15,000 \\ \hline Taxes payable in November & 19,000 \\ \hline Addition to accumulated depreciation in December & 4,000 \\ \hline Cash balance on October 1,2017 & 34,000 \\ \hline Minimum desired cash balance & 15,000 \end{tabular} 5$25.7 due Deoember 2017 . No payments for remainder of year. Chapter 3 Problem 16 a. Using the information provided, construct a monthly cash budget for October through December 2017 BBased on your analysis, will Noble enjoy a surplus of cash, or require external financing? b IConstruct 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 rrequired for December 31 ? c. IDoes the December 31,2017 estimated external financing equal your cash surplus (deficit) for this date from your cash budget? d. IBased on your answers above, construct a cash flow forecast for Noble for the period October through December 2017. NOBLE EQUIPMENT CORP. Facts and assumptions iSales ( 20 percent for cash, the rest on 30 -day credit terms): Purchases (all on 60-day terms): \begin{tabular}{l|r} \hline Salaries payable monthly & 20,000 \\ \hline Principal payment on debt due in December & 25,700 \\ \hline Interest due in December & 9,000 \\ \hline Dividend payable in December & 15,000 \\ \hline Taxes payable in November & 19,000 \\ \hline Addition to accumulated depreciation in December & 4,000 \\ \hline Cash balance on October 1,2017 & 34,000 \\ \hline Minimum desired cash balance & 15,000 \end{tabular} 5$25.7 due Deoember 2017 . No payments for remainder of year