Merge & Center Alignment $ - %) 382 Clipboard Conditional Format Call Formatting Table Styles Font Format Number G36 Gate A 110,000 S Mare 99.000 5 106,000 48,000 $ 5.000 $ 36,000 5 4.2005 41.000 4800 25 75% 7 Budgeted Sales and Cash Pmt for Merchandise for at uarter 2021 for Arte. Co is provided below January Budgeted Sales $ 10 Budgeted Pimits for merchandise 11 Merchandise Inventory 12 Shipping 13 14 Nel total sales that cash sales 15 of total sales that AR 15 A/R collection in the month of the sale te collection in the month following the sale 19 20 Balances for relevant accounts on Dec 31, 2020 Cash 5 22 Accounts Receivable $ 24 Loan Payable to bank s 25 16 Montly operating expenses paid in the month incurred Sales commission of sales Office Salaries Rents 40 60% 15,000 24.000 5.000 amounts can only be borrowed from the bank in increments of 50.000 15% 25.000 9,000 Minimum required ending cash balance 5 Montly interest rate an beginning of month loan balance 15.000 2.3% 15 Required Prepare a cash receipts budget for lanuary February, and March for Artz Co. Gray cell number or formula entry Given cel formula & sheet reference blue celle Formula Tangerine celle sheet reference/Cell reference Prepare a Cashbudget for each month January February, and March for Art Co. Green celis formule & sheet reference Blue Form Tangerine cell sheet reference/Cel reference you should combine handhe payments into one group in cash budet Instructions Cash Receipts Budget Cash Budget File Home Home Cashbudget Project - Excel Page Layout Formulas Data Review Draw View Help Calibri ' ' General Paste . . BTU. 3 Wrap Text Merge Center - $ -% 3 Conditional Format Guil Formatting Table Styles Son Clipboard Font Alignment Number C20 Cell Ed 8 D 1 2 a 4 5 6 Artz. Co Cash Receipts Budget For July, August, and September January February March Cash Sales Collections of prior month's receivables Collections of current month's receivables Total cash receipts 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Instructions Cash Rsseigts Budget esh Buda Calibri Paste BIU- - 29 Win Text OA 23 Merge Center Alignment General $ % 991 WE 27 Cipboard Conditional Format Cell Formatting Table Styles font Format Sort Number fx A D 1 2 3 4 Arte. Co Cash Budget For January February, and March January 5 February March 6 7 8 10 11 12 13 14 15 Beginning cash balance Cash receipts Total cash available Payments for Merchandise Sales commissions Office salaries Rent Interest on bank loan January February March Preliminary cash balance Additional loan from bank Repayment of loan to bank Ending cash balance 16 17 18 19 20 21 Loan balance, end of month 22 23 24 25 26 27 28 29 30 31 Instructions Cash Receipts Budget Cash Budget Type here to search DS 11 AA == 9 W Tort BIU - AA Merge Center Gener $ - % 523 Conditional Format Cell Formatting Styles Sort beni Font Apment Nam G Budgeted Sales and Cwth Pmt for Merchandise for 1st quarter 2021 for Arta Colis provided below February 5 110,000 March 99 0005 106.000 Bidete Sales Bored Pits for merchandise Merchandise inventory Shipping S $ K000 S 5.000 5 M.000 $ 4.2005 41,000 4300 of total that is causa of total that is 25 75 A/R collection in the month of these Rection in the month following the sale AN SON les for relevant counts on Dec 31, 2010 Caths Accounts Receivables 15.000 24,000 Loan Payable to banks 5.000 amounts can only be borrowed from the bankrement of $1,000 Montypersees paid in the month incurred Sales commission of Office Salaries Rest5 15 25.000 9,000 35.000 Minimum required ending a balances Mantly interest rate an eging month lan tante Prepare a cash recepta budt for afruary February, and March for at Gambar formulary Greece further 30 Tangere she reference Pe Choral month lenary, Fahrwary and March for Art Griformula therrence 40 rod.com merchandise payment to propio Instructions Cash Recipts Budget Cash Budget Type here to search O