Answered step by step
Verified Expert Solution
Link Copied!

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:image text in transcribed
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

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

Quantitative Corporate Finance

Authors: John B. Guerard Jr. Anureet Saxena, Mustafa Gultekin

2nd Edition

3030435466, 978-3030435462

More Books

Students also viewed these Finance questions