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
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.
Step by Step Solution
3.45 Rating (155 Votes )
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