Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PT Cleo has projected sales (in million rupiah) for the next four Qs as follows: Trade receivables at the beginning of this year was Rp
PT Cleo has projected sales (in million rupiah) for the next four Qs as follows:
Trade receivables at the beginning of this year was Rp 300 million. PT CLEO has an average collection period of 45 days. PT CLEO's purchases from suppliers in each Quarter are 50% of the estimated sales for the next Quarter, and the average account payable period is 36 days. Salaries, taxes and other expenses for each Quarter are 30% of sales. Dividend is Rp 20 million paid quarterly. PT CLEO plans capital expenditure in the second quarter of Rp 300 million. The company has an initial cash balance of Rp 190 million with a minimum balance of Rp 190 million. Assume that the company has to borrow the funds needed in the short term at an interest rate of 5% per Q and interest is paid in the following Quarter. Companies can also invest more funds in short-term marketable securities at a rate of 4% per quarter and paid in the following quarter Prepare short term financial planning for PT CLEO! (Assuming 1 Q = 90 days)Q1 Q 2 Q3 Q4 Q1* 820 790 880 1000 1000*(1+54%)
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