Cash and Liquidity Management; Short Term Finance and Planning question

A Clothing Manufacturer reported the following data in its financial statement for the year ended Dec 31, 2019: - EBIT of $16,725,000 with quarterly production of 350,000 units - Accounts Receivable of $5,000,000 - Accounts Payable of $800,000 - Cash cycle (operating cycle - payables period) of 157 days - Standard deviation of $12,000,000 / day - Ending cash balance of $7,000,000 for end of year 2019 - Expenses and Costs: > COGS : 23% of sales > Capital expenditure : $20,000,000 / quarter > Other expenses : 15% of sales > Broker commission of $140 / transaction - Other incomes: > Investments in securities with 13% return > Building rent income $3,000,000 at every end of the semester > Land rent income of $70,000 per quarter

In year 2020, it is estimated that product selling price / unit will increase by $12, however the production capacity remains the same. In year 2021, the units produced will increase by 50,000 units, however the selling price will be the same as in 2020. Inventories are purchased one quarter before sales happened.

Optimal cash balance per quarter is $70,000,000 and reserve fund of $80,000,000 can only be used in Q4. The company is receiving an loan facility offer with interest of 7% p.a., and the principal can be repaid at the end of the year.

Questions: a. Calculate cash balance for investments and cash balance needed to redeem the securities, as well as the average cash balance. b. Create a short term financial plan for each quarter, please include: beginning cash balance, net cash inflow, new short term borrowing, interest, repayment of short-term borrowing, ending cash balance, and minimum cash balance

any help is gladly appreciated thank you !