PLEASE SHOW FULL SEQUENCE AND CALCULATION

You need to create cash budget for Alfa Ltd for 3 months ended on 30th September 20X7. You know: Cash at bank (01.07.20X7.) 25'000 euro; Salaries and wages monthly 10'000 euro; Interest Alfa Ltd shall pay in August 5'000 euro. Credit sales are collected 50% in the month when sales are made, and 50% in the next (following) month. Collection from credit sales are subject to 5% discount if payment is received during the month of sale, and subject to 2% discount if payment is received in the month following the sale. Creditors are paid either on a prompt category or 30 days basis. It is estimated that 10% of creditors are in the prompt category. Solution