Please only use the numbers provided here in the Excel Template and solve for Cash Budget.

Input Area: $ Beginning A/R a. Collection period b. Collection period C. Collection period 265 45 60 30 APP F 35% Q1 Q2 Q3 Q4 Sales 620 $ 670 620 730 Output Area: Q4 Q1 Q2 Q3 620 670 a. Beg A/R $ coll from curr gtr sales Total Cash Coll 310 335 645 $ $ 45 -day collection period Q1 Beginning receivables $ 265.00 $ Sales 620.00 Cash collections (575.00) Ending receivables $ 310.00 Q2 310.00 670.00 (645.00) 335.00 Q3 335.00 620.00 (645.00) 310.00 Q4 310.00 730.00 (675.00) 365.00 $ $ b. $ $ 60 day collection period Beginning receivables $ 265.00 $ Sales 620.00 Cash collections (471.67) Ending receivables $ 413.33 $ 413.33 670.00 (636.67) 446.67 446.67 620.00 (653.33) 413.33 413.33 730.00 (656.67) 486.67 $ $ c. $ 30-day collection period Beginning receivables $ 265.00 $ Sales 620.00 Cash collections (678.33) Ending receivables 206.67 $ 206.67 670.00 (653.33) 223.33 223.33 620.00 (636.67) 206.67 206.67 730.00 (693.33) 243.33 $ $