Just need help with the Short-Term Financial Plan. Everything above is correct. Please also show work so I can follow along. Thank you Construct a short-term financial plan

Midwest Tire also maintains a minimum cash balance of $800. The ending cash balance is $800 this year. Suppose Midwest Tire can make short-term investments and obtain a quarterly return of 1% and can borrow short-term loan at the rate of 2% quarterly. In the end of this year, there is no balance on either the short-term investment or borrowing account. Also assume that the interest income or cost does not add to the value of the principal. Construct a short-term financial plan taking into account the opportunities to borrow and invest on a quarterly basis.

Chapter 18 - Midwest Tire Company Input Area 01 1550 S 1,600 prior Credit sales Credit purchases Cash disbursements 1,500 S 1,400 $ 1,700 $ Wages, taxes, and expenses Intcrest 180 80 168 80 204 80 186 80 AR at the beginning of the year 600 Collection Period Payable Period Collections from current period sales Collection from prior period sale Payables on current period purchases Payables on prior period purchases 60 60 33% 67% 33% 67% % of purchases for next Q sales Wages, tax, other as % of sales Interest & Dividend Minimum Cash Balance Borrowing rate Invested securities 75% 12% 80 800 2% 1% Building a Cash Budget Sales Project Cash Collections AR. beginning- Cash collections from prior period credit sales S 1,500.00 S 1,400.00 S 1,700.00 $ 1,550.00 1,600.00 600 500 1,100 S 1,000 S 1,000 933 567 S 1.133 517 1,500 S 1,650 1,133 S 1,033 Cash collections from current period credit sales Total cash collections 467 S 1,467 S 933 S A.R. Ending Purchase Proiection Cash Disbursements Payment for purchases from prior perio