Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Business Statistics A Decision Making Approach

Authors: David F. Groebner, Patrick W. Shannon, Phillip C. Fry

9th Edition

013302184X, 978-0133021844

More Books

Students also viewed these Accounting questions