The following is a list of financial statement account balances for the year ending Dec $31,2025.$

Using this list of account balances, answer the following questions within this file:

Please do not use $ sign $($All $ in $000$s$).$

$(1)$ Prepare a Cash Budget for $2025$

Cash $1,888$

Wages and Benefits $4,230$

Equipment Repairs and Maintenance $34$

Rent $1,590$

Income Tax Expense $120$

Fleet & Equipment $5,100$

Cost of Sales $-$ Fuel $500$

Accounts Payable $180$

Marketable Securities $100$

Accounts Receivable $800$

Operating Lease Expense $-$ Trailers $830$

Salaries and Benefits $460$

Sales #####

Notes Payable $50$

Accumulated Depreciation $3,734$

Selling and Administrative expenses $420$

Utilities $80$

Office Supplies $40$

Subcontractors $-$ Owner Operators $110$

Salaries and Benefits $-$ Executives $360$

Capital Lease Obligations $1,180$

Depreciation Expense $620$

Common stock $($no change$)1,600$

Interest Expense $12$

Facility Maintenance $150$

Retaines Earning $2024700$

Dividends paid none

Cash Budget Prepration for $2025$

Assumption:

Ending Cash $2024$ is $$278$

$($All $ in $000$s$)$

Monthly sales are broken down as stated on the Cash Budget

Use $2025$ sales forecast to reach monthly $\%$

Amount of Sales in Cash: $40\%$

Amount of Sales on Credit: $60\%$

Of the credit sales, $70\%$ are collected one month after

Of the credit sales, $30\%$ are collected two months after

All Selling & Admin. Expenses are incurred in the current month.

Amount of Selling & Admin. Expenses in cash: $20\%$

Amount of Selling & Admin. Expenses on credit: $80\%$

Of the credit portion, $100\%$ is collected one month after

Most Expenses are paid evenly over twelve months

Income Taxes are paid in equal quarterly installments, in Mar$/$Jun$/$Sept$/$Dec

Sales $2025$: $10000$

Sales $2024$: $9000$

Cash ending $2024$:$278$

give it in an excel format