Soal Latihan Anggaran Kas..... #AnggaranKas

Summary

This video explains the process of creating various financial budgets, including accounts receivable, cash receipts, cash expenditures, and temporary and final cash budgets for PT Mandiri Jaya. The script emphasizes understanding the relationship between sales, credit collections, and cash flow. Key points include calculating receivables, factoring in bad debts, and using monthly and quarterly collection patterns. It also covers projected expenditures such as materials, wages, and loan arrangements in case of cash shortfalls. The overall goal is to create accurate projections to manage cash effectively and avoid deficits, with a focus on borrowing and interest costs.

Takeaways

• 😀 Cash budgets are closely related to accounts receivable budgets, so understanding accounts receivable is essential before creating a cash budget.
• 😀 40% of sales are made on credit, while 60% are made in cash. Credit sales require careful management of receivables.
• 😀 2% of credit sales are assumed to be uncollectible, which reduces the total receivable amount (net receivables).
• 😀 The collection pattern for monthly receivables is 60% in the first month, 30% in the second month, and 10% in the third month.
• 😀 For quarterly sales, the collection pattern is 80% in the current quarter and 20% in the following quarter.
• 😀 Cash receipts come from net receivables, cash sales, and other receipts, which should be consolidated into the cash inflows table.
• 😀 The cash payments budget includes items such as raw material purchases, wages, debt repayments, dividends, and other expenses.
• 😀 The cash budget for each period starts with an opening balance, adding cash receipts, and subtracting cash payments to determine the closing balance.
• 😀 In case of a cash deficit, loans should be taken out to cover the gap, with an annual interest rate of 18% (1.5% per month).
• 😀 A loan of IDR 5,000,000 is assumed to be taken in Q2 to cover the deficit, with monthly interest payments of IDR 75,000 until the loan is repaid in Q4.
• 😀 The final cash budget integrates all inflows, outflows, and loan repayments, ensuring that any deficits are covered and interest payments are accounted for, leading to a closing cash balance of IDR 3,331,102 at the end of Q4.

Q & A

What is the primary connection between the accounts receivable budget and the cash budget?

The accounts receivable budget directly impacts the cash budget because the cash flow from receivables determines the available cash. Thus, understanding the accounts receivable collection pattern is essential for preparing an accurate cash budget.

How is the percentage of credit sales in relation to cash sales calculated?

According to the script, 40% of the sales are made on credit, while the remaining 60% is paid in cash.

How is the net receivable calculated from credit sales?

The net receivable is calculated by taking 40% of total sales (credit sales) and subtracting 2% for bad debts. This provides the actual receivable amount the company expects to collect.

What is the pattern for collecting accounts receivable based on the sales period?

For monthly sales, 60% of the receivables are collected in the first month, 30% in the second month, and 10% in the third month. For quarterly sales, 80% is collected in the same quarter and 20% in the following quarter.

What are the key components involved in the cash collection budget?

The cash collection budget includes receipts from accounts receivable (both from credit and cash sales), as well as other receipts, such as additional income occurring in specific periods (second and third quarters).

What are the major expenses factored into the cash payment budget?

The major expenses in the cash payment budget include raw material purchases, wages, debt repayments, dividend payments, and other miscellaneous expenses. These payments are scheduled according to the timeline in the script.

How is the preliminary cash forecast (Anggaran Kas Sementara) created?

The preliminary cash forecast is calculated by adding the opening balance to expected receipts and subtracting the forecasted payments. The result shows the available cash for each period, highlighting any surplus or deficit.

How does the loan policy impact the cash budget when there is a deficit?

If a cash deficit occurs, the company takes a loan to cover the shortfall. The loan, which carries an 18% annual interest rate (1.5% monthly), is assumed to be repaid by the start of the fourth quarter. This loan ensures the company maintains sufficient cash flow.

What happens to the cash balance in case of a deficit during the second quarter?

In the second quarter, the company faces a cash deficit. To cover this deficit, a loan of IDR 5,000,000 is taken, which adds interest charges to the budget and ensures that the company has enough cash to meet its obligations.

How is the interest on the loan calculated and incorporated into the budget?

The loan interest is calculated at a rate of 1.5% per month. This monthly interest amount is added to the cash payment budget as an expense, affecting the overall cash balance until the loan is paid off in the fourth quarter.