please help with the green boxes

O sharpe's les 10 percent in for at motor de percent la cortected as the month fedewey the sale od percent codected the second this thesis November and December were $120,000 and 517/000, respectively Sharpe's was con percent of speeders sales pece and reprochen we het hy gehestored sales are made in February, and payment is made in March In Sharepky 510,000 per month for rent and 530,000 per month for other pentrs. Ta progants $21. made each quarter The company's cash balance on December 2016 $22.000, balance of $15.000 must be at Ashwyth.com dan cepat offin the month flowing the month officient and a wall. Innhom (1) ce potreby chce the beginning of the moth. Thus, the fim espects to nedan 60.500 in Apothesest vabe bed at the bag of Apeland 3.300) wed for April bepud at the beginning of May Complete the below ating cell recente pla data pris cakeslarien lam ces a simple cell reference is all yed. To formalar cell reference or a med cell reference may be referred. If a specifical function is the wed, the directions will speelty the use of fonction de typical data interface fastest, make a referrace to the cell in which the data is frond. Make your computationly in the green cells highlighted below. In all these directed the researce at the date in your formas, rally the Ghea Data section Ghee Data: Purchase Cash celictions of sales) 1045 Cath collections one month after sales of s) 6040 3096 Cuih collections two months atliet sales of satis) Rent 510,000.00 Quartelytuses $93.500.00 1248 Yetty intentate $15.00.00 Mun cash balance $20.000.00 Other spendium Months in a year 13 Monthly interest rate 2. Prepare a cash budget for Sharpe covenng the first seven months of 2017 The Sharpe Corporation's projected sales for the first eight months of 2017 are as follows below Sales (Torecasted Purchases (60% of sales price) November $220,000.00 $50,000.00 December $175,000.00 $70,000.00 Jamsary $90,000.00 $81,000.00 February $120,000.00 $141.000.00 March $135,000.00 S180,000.00 April $240.000,00 $162.000.00 May $300,000.00 S135.000.00 Jese $270,000.00 890,000.00 July $225,000.00 August 5150,000.00 Cash receipts Collections On month after sale (1096) One month after sale (6096) Second month after sale (30%) Total cash receipts Cash disbursements Payments (one-month lag of purchases made the previous month) Rest Other expenses Taxes Total cash disbursements $10,000.00 20,000.00 $0.00 S10,000.00 $20,000.00 S0.00 $10,000.00 $30,000.00 $22.500,00 510,000.00 $20,000.00 SOLO $10,000.00 $20,000.00 $0.00 510,000.00 $20,000.00 323,500.00 $10,000,00 $20,000.00 $0.00 Net change in cash for the period Plus Beginning cash balance Less Interest on short-term borrowing Equals Ending cash balance before short-term borrowing $0.00 S0.00 S0.00 $0.00 $0.00 515,000.00 $15,000.00 $15.000.00 $15,000.00 $15,000.00 $15,000.00 New financing needed Cash balance before repayment Repayment S0.00 $0.00 S0.00 ($15,000.00) $0.00 $0.00 58.00 $0.00 {$15.100.00) $0.00 Repayment Ending a balance Camilave booming $23,000.00 $0.00 515.000,00 $30,000.00 $45,000.00 $15,000.00 10,000.00 1. She has 5.200.000 notes payabled in July that must be reprodot negotiated for an exten: Will the tim have plecarb to repay the ce? Them have a plecach to pay the notes in July