Using the information above fill in the blank table by calculating the total cash receipts, total cash…

Question

Using the information above fill in the blank table by calculating the total cash receipts, total cash payments, cash balance at end of each month, cash balance at the start of the month of February. Fill in all the necessary information in the table provided

ScanSolve AI Tutor · Accepted Answer

To complete the cash flow statement, we will calculate the cash receipts, cash payments, and the cash balance at the end of each month. Assumptions: "Cash sales each month" (K10 000) are the only cash receipts. "Wages" (K1 500), "Drawings" (K1 600), and "Loan repayment" (K300) are recurring cash payments each month. For "Other payments", we assume the K1 500 for fundraising is a one-time payment occurring in January, and the K100 is a recurring payment each month. Therefore, "Other payment" for January is K1 500 + K100 = K1 600, and for subsequent months, it is K100. Calculations: January (Jan) Balance at start of Month: K5 000 Sales: K10 000 Total Cash Receipt: K10 000 Wages: K1 500 Drawings: K1 600 Loan Repayment: K300 Other payment: K1 500 (fundraising) + K100 = K1 600; Total Cash Payment: K1 500 + K1 600 + K300 + K1 600 = K5 000; Cash Balance at end of month: K5 000 + K10 000 − K5 000 = K10 000 February (Feb) Balance at start of Month: K10 000 (from end of Jan) Sales: K10 000 Total Cash Receipt: K10 000 Wages: K1 500 Drawings: K1 600 Loan Repayment: K300 Other payment: K100 Total Cash Payment: K1 500 + K1 600 + K300 + K100 = K3 500; Cash Balance at end of month: K10 000 + K10 000 − K3 500 = K16 500 March (March) Balance at start of Month: K16 500 (from end of Feb) Sales: K10 000 Total Cash Receipt: K10 000 Wages: K1 500 Drawings: K1 600 Loan Repayment: K300 Other payment: K100 Total Cash Payment: K1 500 + K1 600 + K300 + K100 = K3 500; Cash Balance at end of month: K16 500 + K10 000 − K3 500 = K23 000 April (April) Balance at start of Month: K23 000 (from end of March) Sales: K10 000 Total Cash Receipt: K10 000 Wages: K1 500 Drawings: K1 600 Loan Repayment: K300 Other payment: K100 Total Cash Payment: K1 500 + K1 600 + K300 + K100 = K3 500; Cash Balance at end of month: K23 000 + K10 000 − K3 500 = K29 500 Filled Cash Flow Table: Jan (K) — Feb (K) — March (K) — April (K)Balance at start of Month — 5 000 — 10 000 — 16 500 — 23 000 Sales — 10 000 — 10 000 — 10 000 — 10 000 Cash Receipt — 10 000 — 10 000 — 10 000 — 10 000 Wages — 1 500 — 1 500 — 1 500 — 1 500 Drawings — 1 600 — 1 600 — 1 600 — 1 600 Loan Repayment — 300 — 300 — 300 — 300 Other payment — 1 600 — 100 — 100 — 100 Cash Payment — 5 000 — 3 500 — 3 500 — 3 500 Cash Balance at end of month — 10 000 — 16 500 — 23 000 — 29 500

	Jan (K)	Feb (K)	March (K)	April (K)
Balance at start of Month	5 000	10 000	16 500	23 000
Sales	10 000	10 000	10 000	10 000
Cash Receipt	10 000	10 000	10 000	10 000
Wages	1 500	1 500	1 500	1 500
Drawings	1 600	1 600	1 600	1 600
Loan Repayment	300	300	300	300
Other payment	1 600	100	100	100
Cash Payment	5 000	3 500	3 500	3 500
Cash Balance at end of month	10 000	16 500	23 000	29 500

Using the information above fill in the blank table by calculating the total cash receipts, total cash payments, cash balance at end of each month, cash balance at the start of the month of February. Fill in all the necessary information in the table provided

Answer

Still stuck on this one?

More Accounting Questions