Please solve with excel formulas, I need to input formulas for the correct answers Required: Prepare monthly cash budgets for January, February, and March.

KAYAK COMPANY

Cash Budget

January February March

Beginning cash balance $$34,000$ $$34,000$

Add: Cash receipts $713,000570,000620,000$

Total cash available $747,000604,000$

Less: Cash payments for

All items excluding interest

Interest on loan $340$

Total cash payments $34000$

Preliminary cash balance

Ending cash bala

nce

Loan balance

Loan balance $-$ Beginning of month

Additional loan $($loan repayment$)$

Loan balance, end of month $$0$ $$0$ $$0$