1. Calculating Cash Collections The Taylor Company has projected the following quarterly sales amounts for the upcoming FY. Q1, Q2, Q3, and Q4 have projected sales of $680k, $770k, $750k, and $920k, respectively. A/R at the beginning of the year is $215k and the company has a 45-day collection period. Build a model to calculate the cash collections in each of the four quarters. Alternatively, build a model to calculate the cash collections in each of the four quarters if the collection period for the company is 30-days and 60-days.