please provide a cash budget for the year using the format and information provided and also a balance sheet for the year(december 31st)

the business is an ice cream shop that is expected to make $90,007 yearly by selling 10,012 products a year

the cash budget should include 12 periods or 4 periods(if you decide to do the 4 period one each of the 4 periods should the information accumulated of 3 months)

Company Name Cash Budget For the Period Period 1 Period n 1 2 5 6 Beginning Cash Balance Add: Cash Receipts: Collections from customers Collections from other sources Total Cash Receipts Total Available Cash Less: Cash Payments: List separately Total Cash Payments Excess (Deficiency) of Total Available Cash over Total Cash Payments Financing Borrow Repay Ending Cash Balance 7 8 9 10 11 12 Frozy's Income Statement Year ending December 31st, 2021 Revenue Ice cream 50,004 Milkshakes 20,000 Ice cream cakes 20,003 15,013 1989 Cost of goods sold Gross profit Ezpenses Ulilit: bills Salaries and wages 44,982 Advertising 300 Telephone and Internet S8 Total expenses * $10.4 Let Income 5271750 Expenses Expected Monthly Cost Expected Yearly Cost Rent none none Salaries and Wages 44,928 1.251 15,018 Supplies: Technological, Equipment, and Furniture (computers, software, copy machine, desks, chairs, etc.), other 300 Adrertising and Other Promotions 140.20 1682.4 Utilities: Heat, Electricity, etc. 70.50 846 Telephone and Internet Insurance ilone ilone Other (specify) alone 110ne Other (specify) Ilone mone Company Name Cash Budget For the Period Period 1 Period n 1 2 5 6 Beginning Cash Balance Add: Cash Receipts: Collections from customers Collections from other sources Total Cash Receipts Total Available Cash Less: Cash Payments: List separately Total Cash Payments Excess (Deficiency) of Total Available Cash over Total Cash Payments Financing Borrow Repay Ending Cash Balance 7 8 9 10 11 12 Frozy's Income Statement Year ending December 31st, 2021 Revenue Ice cream 50,004 Milkshakes 20,000 Ice cream cakes 20,003 15,013 1989 Cost of goods sold Gross profit Ezpenses Ulilit: bills Salaries and wages 44,982 Advertising 300 Telephone and Internet S8 Total expenses * $10.4 Let Income 5271750 Expenses Expected Monthly Cost Expected Yearly Cost Rent none none Salaries and Wages 44,928 1.251 15,018 Supplies: Technological, Equipment, and Furniture (computers, software, copy machine, desks, chairs, etc.), other 300 Adrertising and Other Promotions 140.20 1682.4 Utilities: Heat, Electricity, etc. 70.50 846 Telephone and Internet Insurance ilone ilone Other (specify) alone 110ne Other (specify) Ilone mone