Please provide the solution of assignment of FIN622
Assignment No. 2 Marks: 10
Khurram Farooq, a financial analyst for Star cable operators, has prepared the following
sales and cash disbursement estimates for the period February to June of the current year.
Sales (in Rs.)
Cash disbursements (in Rs.)
Khurram Farooq noticed that 30 percent of sales are on cash basis whereas 70 percent
of sales are on credit basis. 70 percent of the sales made on credit basis are collected
in 1 month after the sale, and the remaining 30 percent are collected 2 months after
sales. The firm wishes to maintain ending balance in cash account of Rs. 3000.
The beginning cash balance at May 01 is Rs.11, 500.
A) Prepare a cash budget for the months of May and June.
B) Indicate the amount for each period (May and June) whether the firm is in Excess cash or will require extra finances to meet its obligations.
Important Note: Show calculations where required as it also carry marks.