F18 X V fx =SUM(F12:F17) A B C D E F G H July August September October November Expected rentals 145 152 148 96 61 10 0 0 ~ OR UT A W N - Expected rental amounts 205,000 $ 183,000 $ 147,000 67,000 Expected resort fees 10,485 9,590 7,420 5,630 Expected reservation fees 17,550 16,040 12,080 9,950 Cash Balance Before Receipts $ 184,440 $ 156,400 $ 66,320 10 11 Receipts: 12 Resort Fees You fill in the 13 Reservation Fees You 14 Finders Fees 20.00% 36,600 29,400 Am 15 Key Keeping Fees 2,100 2,100 2,100 onc Reimbursement from Purchases and 16 Contractor Payments on Behalf of Owners 17 Miscellaneous 18 Total Receipts on the 5th of the month $ 38,700 $ 31,500 19 20 rach Dalanan after Dagainte 252 100 c I len that952 10 Cash Budget Template Hurr. Simul. Template + Ready Type here to search O Ei m G 57OF Mos