Vantage Sdn Bhd has decided to conduct cash planning for the next three months using simulation. Net
Question:
Vantage Sdn Bhd has decided to conduct cash planning for the next three months using simulation. Net cash flows (receipts minus disbursement) during the month are random variables given by the probability distribution below (where, negative values represent net cash outflows and positive values represent net cash inflows).
Net Cash Flows per Month
(RM000)......................Probability
-1500...................................0.20
-1000....................................0.40
1000....................................0.25
1500....................................0.15
Vantage Sdn Bhd currently has a beginning cash balance of RM200,000 (at the beginning of month 1). The firms's required minimum cash balance, to keep on hand for future transactions, is RM150,000, determined after each month's cash flow reconciliation. Thus, after considering the month's net cash flow results, if the resulting cash flow balance for the month is less than RM150,000, Vantage Sdn Bhd will borrow sufficient funds to bring the balance up to RM150,000. On the other hand, if the resulting balance exceeds the required RM150,000, Vantage Sdn Bhd will repay outstanding accumulated borrowings (to the extent possible given the available cash balance in excess of RM150,000, and given the amount of accumulated borrowings outstanding). Vantage Sdn Bhd has no accumulated borrowings currently (at the beginning of month 1).
Simulate the cash flows of Vantage Sdn Bhd for one year and indicate the total amount borrowed during the year and how much is owed at the end of the year.
Business Statistics a decision making approach
ISBN: 978-0133021844
9th edition
Authors: David F. Groebner, Patrick W. Shannon, Phillip C. Fry