This question stems from a revenue cycle and current accounts management chapter of my texbook. I need to show work and submit in excel, thank you for any help in advance! The question is 16.8

16.8 Pediatric Partners has forecasted billed charges for the first six months of the year as shown in the table below. Based on historic collection patterns, Pediatric Partners expects to collect charges as follows: 5 percent within 30 days, 85 percent within 60 days, and5 percent within 90 days. The remaining 5 percent is expected to be uncollectible. What should be budgeted for cash collections in each of the months January through June? Month Billed Charges Cash Collections January February March April May June $ 99,000 99,000 99,000 105,000 105,000 105,000