Fixed Expenses:

Rent- 42,000

Insurance: $1,300

CEO salary: 60,000

COO salary: 45,000

CMO salary: 45,000

CFO salary: 45,000

Advertising: 5,000

Furniture: $4,000

Kitchen expenses:

Espresso Machine - $3,700

Oven- $3,000

Refrigerators- $4,000

Coffee Roaster-$3,000

Equipment;

Water filtration- $8,000

Self/Service Copy machine;

1-$3,000

2-$6,000

Variable expenses:

Employees:

Part-time:10 $1

Full-time: 5 $30,000

Manager; 1 $40,000

Total Labor and wages; $345,200

Utilities:

Gas: $14,400

Electricity: $7,200

Wifi: $1,200

Garbage: $2,136

Recycle: $300

Total Utilities; $22,500

Inventory;

( paper cups, filters, stirrers, straws, Lids, ink, paper etc.)

Total inventory; $31,500

Raw materials:

(Coffee Beans, Flour, Sugar, Oil, Milk or milk alternatives, etc.)

Total Raw Materials; $27,350

I need help filling out the cash budget for (Jan-March)

$907,937 Income Statement For the Year Ended December 31, 2022 Revenue: Revenue earned Expenses: Fixed expenses (Itemized below, plz $ extend the table if necessary) Advertising $5,000 CFO salary $45,000 CMO salary $45,000 COO salary $45,000 CEO salary $60,000 Insurance $1,300 Rent $42,000 Kitchen Expenses $13,700 Equipment $14,000 Loan (1 yr loan) $110,000 Interest Expense(10% interest $9,000 rate) $352,000 Total Fixed Expenses Variable expenses (Itemized below, plz extend the table if necessary) Employees Utilities Inventory Raw Materials $345,200 $22,500 $31,500 $27,350 Total Variable Expenses $ 426,550 Total Expenses $778,550 $_129,387 Income before income tax Income Tax expense (around 10%-20% depend on your ownership type) Net Income $_19,408_ $_109,9790 Cash Budget for your business (Jan-March, 2022) Jan. Feb. Cash receipts March $ Total Cash Receipts Cash Disbursements Total cash disbursements End-of-Month Balance Beginning cash Balance +Cash receipts -Cash disbursements Cash (end of month) Borrowing Repayment Final cash balance Monthly Surplus (Deficit) $907,937 Income Statement For the Year Ended December 31, 2022 Revenue: Revenue earned Expenses: Fixed expenses (Itemized below, plz $ extend the table if necessary) Advertising $5,000 CFO salary $45,000 CMO salary $45,000 COO salary $45,000 CEO salary $60,000 Insurance $1,300 Rent $42,000 Kitchen Expenses $13,700 Equipment $14,000 Loan (1 yr loan) $110,000 Interest Expense(10% interest $9,000 rate) $352,000 Total Fixed Expenses Variable expenses (Itemized below, plz extend the table if necessary) Employees Utilities Inventory Raw Materials $345,200 $22,500 $31,500 $27,350 Total Variable Expenses $ 426,550 Total Expenses $778,550 $_129,387 Income before income tax Income Tax expense (around 10%-20% depend on your ownership type) Net Income $_19,408_ $_109,9790 Cash Budget for your business (Jan-March, 2022) Jan. Feb. Cash receipts March $ Total Cash Receipts Cash Disbursements Total cash disbursements End-of-Month Balance Beginning cash Balance +Cash receipts -Cash disbursements Cash (end of month) Borrowing Repayment Final cash balance Monthly Surplus (Deficit)