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

  1. 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

-150

0.20

-100

0.40

100

0.25

150

0.15

Vantage Sdn Bhd currently has a beginning cash balance of RM200,000 (at the beginning of month 1). The firmss required minimum cash balance, to keep on hand for future transactions, is RM150,000, determined after each months cash flow reconciliation. Thus, after considering the months 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

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions