AutoSave Off be File Home Insert Page Layout Formulas Data Review View Help Century Gothic 12 AA = = = ab Wrap Text X Cut LECopy * Format Painter Paste BI U SEE Merge & Center Clipboard Font Alignment i UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. U: L22 X f H H I 1 J K A D E F 6 Input Data 7 Collections during month of sale 15% & Collections during month after sale 73% Collections during second month after sale 127 10 Lease payments $7.800 11 Target cash balance $60,000 12 General and administrative salaries $45,400 13 Depreciation charges $82.000 14 Income tax payments (March & June) $63,900 15 Miscellaneous expenses $8.550 16 Equipment Purchase (April) $337,500 17 Cash on hand January 1 $92.400 18 19 20 NO CASH DISCOUNT IS OFFERED IN THE MONTH OF SALE 21 22 NAME: SECTION: FALL 2020 23 May June $345,125 $102,900 $75,000 $112.000 24 a. Prepare a monthly cash budget for the first six months of the year. 25 26 November December Januar February March April 27 Original sales estimates $175.000 $312.000 $384.000 $384.000 $430,600 $750,700 337,600 28 Original labor and raw mat. estin $84,000 $212,000 $236.000 $598,000 $199.500 $202,400 29 30 Forecasted Sales 31 Sales (gross) 32 33 Collections 34 During month of sale 35 During 1st month after sale 36 During 2nd month after sale 37 Total collections 39 Purcbases 40 Labor and raw materials 41 Payments for labor and raw materials 42 43 Payments 4. Payments for labor and raw materials 45 General and administrative salaries 46 Lease payments 47 Miscellaneous expenses 48 Income tax payments 49 Equipment Purchase 50 Total payments 51 52 Wer Cast Flors 53 Cash on hand at start of month 54 Net cash flow (NCF): Total collections - Total payments 55 Cumulative NCF: Prior month cumulative this month's NCF 56 57 Cast Surplus for loan Requiremenij 58 Target cash balance 59 Surplus cash or loan needed: Cum NCF - Target cash 60 61 Highest Loan Needed 42 Most Available for Investment AutoSave Off be File Home Insert Page Layout Formulas Data Review View Help Century Gothic 12 AA = = = ab Wrap Text X Cut LECopy * Format Painter Paste BI U SEE Merge & Center Clipboard Font Alignment i UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. U: L22 X f H H I 1 J K A D E F 6 Input Data 7 Collections during month of sale 15% & Collections during month after sale 73% Collections during second month after sale 127 10 Lease payments $7.800 11 Target cash balance $60,000 12 General and administrative salaries $45,400 13 Depreciation charges $82.000 14 Income tax payments (March & June) $63,900 15 Miscellaneous expenses $8.550 16 Equipment Purchase (April) $337,500 17 Cash on hand January 1 $92.400 18 19 20 NO CASH DISCOUNT IS OFFERED IN THE MONTH OF SALE 21 22 NAME: SECTION: FALL 2020 23 May June $345,125 $102,900 $75,000 $112.000 24 a. Prepare a monthly cash budget for the first six months of the year. 25 26 November December Januar February March April 27 Original sales estimates $175.000 $312.000 $384.000 $384.000 $430,600 $750,700 337,600 28 Original labor and raw mat. estin $84,000 $212,000 $236.000 $598,000 $199.500 $202,400 29 30 Forecasted Sales 31 Sales (gross) 32 33 Collections 34 During month of sale 35 During 1st month after sale 36 During 2nd month after sale 37 Total collections 39 Purcbases 40 Labor and raw materials 41 Payments for labor and raw materials 42 43 Payments 4. Payments for labor and raw materials 45 General and administrative salaries 46 Lease payments 47 Miscellaneous expenses 48 Income tax payments 49 Equipment Purchase 50 Total payments 51 52 Wer Cast Flors 53 Cash on hand at start of month 54 Net cash flow (NCF): Total collections - Total payments 55 Cumulative NCF: Prior month cumulative this month's NCF 56 57 Cast Surplus for loan Requiremenij 58 Target cash balance 59 Surplus cash or loan needed: Cum NCF - Target cash 60 61 Highest Loan Needed 42 Most Available for Investment