50.1K

Verified Solution

Link Copied!

The following information relates to Sammy $($Pty$)$ Ltd for the three months ended $31$ December $2023$:

Actual Budgeted

October November December

R R R

Sales $(50\%$ for cash$)90000010000001200000$

Purchases $(30\%$ for cash $70\%$ on credit$)8000009000001000000$

Salaries and wages paid $250003000035000$

Other expenses $150001700021000$

Additional information.

$$ Debtors settle their accounts as follows: $50\%$ in the month of sale, $30\%$ in the month after the month of sale, and $15\%$ in the second month after the month of sale while the remaining $5\%$ are considered irrecoverable.

$$ Trade creditors are paid as follows: $60\%$ in the month of purchase, $30\%$ in the month after the purchase while the remaining $10\%$ is paid in the second month after the purchase.

$$ Wages and salaries and all the other expenses are paid as they are incurred every month.

$$ Other expenses include depreciation of R$10000$ every month.

$$ A loan of R$120000$ was taken $5$ years ago. Interest on the loan is $10\%$ per annum. The annual interest expense is spread evenly through the year and is paid as it is incurred. $75\%$ of the loan will be repaid in December $2023.$

$$ The favourable bank balance at the end of October was R$15000.$

Required:

Prepare the Cash Budget for the months of November and December $2023.(15)$

Answer & Explanation Solved by verified expert

See Answer