8:45 PM Tue Jun 4 . . . ( 81% coursehero.com a & d. Monthly cash budget(Oct.-Dec 2017) Oct. Nov. Dec. Quarter Beginning balance 34000 129500 15000 34000 Sales collections Cash sales(2096*Mthly sales budgeted] 25000 10200 10500 45800 A/es. Rec. (Sep.sales) 212800 212800 Other 80%% collections of: Oct. 14 100000 Nov. 14 40800 40500 1.Total cash available 271800 24000066400 433400 Cash disbursements: For purchases: Aug 14 122000 122000 Sep. 14 257000 257000 Oct. 14 62000 62000 Selaries 20000 20000 20000 60000 Principal payment 25700 25700 Interest 3000 9000 Dividend 15000 15000 Taxes 00061 19000 2 Total disbursements 142000296000 131700 569700 Surplus/[Deficit)[1-2) 129500-56000-65300-136300 Ext. Fin Needed 71000 80300 151300 Ending balance 12900015060 15000 15000 b. Proforma Income statement for the Qtr. Oct.Dec. 2017 Net sales(125000+51000+53000) 229000 COGS(62000+27000+26000) 115000 Gross profit 114000 Sell.&. Admn. Exp. (20000 3] GOOOD Interest expense 9000 Depn 4000 Net profit before tax 41000 Tex at 339% 13530 Net profit after tax 27470 Proforma Balance Sheet As at Dec. 2014 Cash 15000 Accounts Receivables( Dec14-53000*8076) 42400 Inventory(425000+115000-115000 425000 Total current essets 482400 Gross Fixed assets 135000 Less: Ace. Depn.(52000+4000) 56000 Net fixed assets 79000 Total assets 561400 Liebilities Bank Loan-External Financing Needed Bal Fig.)151300 Accounts payable(27000+26000) 53000 Accrued expenses 55000 Taxes payable(56000+13530-19000) 50530 Total current liabilities 309830 Long-term debt 120000 Shareholders' Equity(119100+27470-15000) 131570 Total Liabilities 561400 Estimated EFN for the quarter encled Dec. 2017 (from b. above) =151300 C YES Send a question O Do not enter any personal information