$2.$ Financial date : $2023$

Sales revenue :

$$October : $ $3,063,370$

$$November : $ $4,661,650$

$$December: $ $5,593,980$

Cost of goods sold$($COGS$)$: $60\%$ of Sales Revenue

Operating Expenses:

$$ October : $136,000$

$$November :$208,200$

$$December: $248,640$

Capital Expenditures $=-354,000$

Receivable period : $60\%$ Sales collection in the during the month, $40\%$ collect in the following month.

Payable period : COGS is paid for one month after purchase, it$$s $30$days $.$; for quarter $($ three months $).$

Beginning cash balance $=1,484,400$

Cash Flow

October

November

December

Sales revenue

$3,063,370$

$4,661,650$

$5,593,980$

Cost of goods sold

$136,000$

$208,200$

$248,640$

Beginning cash balance

$1,484,400$

Total cash flow

$4,683,770$

$5,389,250$

$6,465,900$

Payment to supplier

$603,209$

$9,180,050$

$1,101,660$

Operating expenses

$136,160$

$207,200$

$248,640$

Loan repayment

$1,925,100$

$2,929,500$

$3,515,400$

Capital expenditures

$-354,000$

Other income

$2,224,560$

$3,385,200$

$4,062,240$

Prepare the Cash Budget: $(40$ pts$)$

$3.$

Create a cash budget for the next three months using a spreadsheet on Excell. The budget

should include the following components:

Cash inflows:

Cash sales

Collections from credit sales

Any other income $($e$.$g$.,$ asset sales or grants$)$

Cash outflows:

Payments to suppliers

Operating expenses

Loan repayments $($if any$)$

Capital expenditures

Net cash flow: Difference between inflows and outflows.

Ending cash balance: Starting balance plus net cash flow????