25% of sales is collected in cash at the time of the sale,50% is collected in the month following the sale,and the remaining 25% is collected in the second month following the sale.Cost of goods sold is 75% of sales.Purchases are made in the month prior to the sale,and payments for purchases are made in the month of the sale.Total other cash expenses are $60,000/month.The company's cash balance as of February 28,2004 will be $40,000.Excess cash will be used to retire short-term borrowing (if any) .Dorian has no short-term borrowing as of February 28,2004.Assume that the interest rate on short-term borrowing is 1% per month.The company must have a minimum cash balance of $25,000 at the beginning of each month.Round all answers to the nearest $100.
-Based on the information in Table 1,what is Dorian's projected cumulative short-term borrowing as of April 30,2004?
A) $15,000
B) $60,000
C) $35,150
D) None of the above
Correct Answer:
Verified