Please send the excel file so i can see the solutions yaay

CASE 10 Aging of Accounts receivables 1 to 3 Use the following data to determine the following: Credit Sales Credit Terms Jan - P500,000 30% within the month of invoice Feb - P275,000 30% within the month after invoice Apr - P385,000 40% within 2 months after invoice 1. How much is the total collections for the month of March only? 2. How much is the total collections for the month of May only? 3. If the company was able to collect P1,000,000 as of June end, and 2% of the balance of uncollected amounts will be deemed uncollectible, how much will be deducted from accounts receivables