Kota Fibres Ltd
1.How did Mehta construct his financial forecast? Using the financial forecast, prepare to show the "cash cycle" of the firm (i.e. the flow of funds through the working-capital accounts of the firm).
Mr. Mehta developed a monthly forecast of financial statements by using the current operating assumptions. As an alternative way of looking at the forecasted funds flows, Mr. Mehta also prepared a forecast of cash receipts and disbursements. To prepare a financial forecast, Mr. Mehta would improve on various parameters. Cost of goods sold would run at 73.7 percent of gross sales - a figure that was up from recent years because of increasing price competition. Operating expenses would be about 6 percent of sales - also up from recent years to include the addition of a quality control department, two new sales agents, and three young nephews in whom she hoped to built an allegiance to the Pundir family business. The company's income tax rate was 30 percent and, although accrued monthly, was actually paid quarterly in March, June, September, and December. The exercise tax (at 15 percent of sales) was different from income tax and was collected at the factory gate as trucks left to make deliveries to customers and regional warehouses. To determine Cash Cycle we need to calculate the Operating Cycle:
Operating Cycle
a)Finding the inventory period
Inventory turnover = COGS ' Avg. Inventory = Rs 66.993.380 ' Rs 7.596.408 = 8.82 times
Inventory period = 365 ' 8.82 times = 41 days
b)Finding the average collection period average collection period = Acc. Receivable ' (Annual Sales ' 365) = Rs 10.921.389 ' (Rs 90.900.108 ' 365) = 44 days
OPERATING CYCLE = Inventory Period + Average Collection Period = 41 days + 44 days = 85 days
Cash Cycle
Average payment period = Acc. Payable ' (Annual Purchase ' 365) = Rs 3.403.854 ' (Rs 50.824.483 ' 365) = 24 days
CASH
Mr. Mehta developed a monthly forecast of financial statements by using the current operating assumptions. As an alternative way of looking at the forecasted funds flows, Mr. Mehta also prepared a forecast of cash receipts and disbursements. To prepare a financial forecast, Mr. Mehta would improve on various parameters. Cost of goods sold would run at 73.7 percent of gross sales - a figure that was up from recent years because of increasing price competition. Operating expenses would be about 6 percent of sales - also up from recent years to include the addition of a quality control department, two new sales agents, and three young nephews in whom she hoped to built an allegiance to the Pundir family business. The company's income tax rate was 30 percent and, although accrued monthly, was actually paid quarterly in March, June, September, and December. The exercise tax (at 15 percent of sales) was different from income tax and was collected at the factory gate as trucks left to make deliveries to customers and regional warehouses. To determine Cash Cycle we need to calculate the Operating Cycle:
Operating Cycle
a)Finding the inventory period
Inventory turnover = COGS ' Avg. Inventory = Rs 66.993.380 ' Rs 7.596.408 = 8.82 times
Inventory period = 365 ' 8.82 times = 41 days
b)Finding the average collection period average collection period = Acc. Receivable ' (Annual Sales ' 365) = Rs 10.921.389 ' (Rs 90.900.108 ' 365) = 44 days
OPERATING CYCLE = Inventory Period + Average Collection Period = 41 days + 44 days = 85 days
Cash Cycle
Average payment period = Acc. Payable ' (Annual Purchase ' 365) = Rs 3.403.854 ' (Rs 50.824.483 ' 365) = 24 days
CASH