Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Listed Volatility And Variance Derivatives

Authors: Yves Hilpisch

1st Edition

1119167914, 978-1119167914

More Books

Students also viewed these Finance questions

Question

What is the preferred personality?

Answered: 1 week ago

Question

What is the relationship between humans?

Answered: 1 week ago