Question
PT ABCD has sales projections (in million rupiahs) for the following four quarters: Q1 Q2 Q3 Q4 Q1* Sales 410 395 440 500 950 Account
PT ABCD has sales projections (in million rupiahs) for the following four quarters:
Q1 | Q2 | Q3 | Q4 | Q1* | |
Sales | 410 | 395 | 440 | 500 | 950 |
Account receivables at the beginning of this year were IDR 150 million. PT ABCD has an average collection period of 45 days.
PT ABCD purchases from suppliers on each quarter are 40% of the estimated sales of the next quarter, and the average account payable period is 30 days. Salaries, taxes, and other expenses for each quarter are 30% of sales. The dividend is IDR 20 million, paid quarterly.
PT ABCD plans a capital expenditure in the second quarter of IDR 150 million. The company has an initial cash balance of Rp. 85 million with a minimum balance of Rp. 85 million. Assume that the company must borrow the funds needed in the short term at an interest rate of 5% per quarter and the interest is paid in the following quarter.
Prepare a cash budget for PT ABCD! (Assuming 1 quarter = 90 days)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started