Of Sharpe's tales, 10 percent is for cash, anoths 60 percet is collected in the month Totowany the tale, and 30 percent we collected in the second month following the sale. November and December sales for 2016 were 5920,000 and 5173.000, respectively Sharpe'e raw materials cast 60 percent of its product's final tales pelice and we pachased two month advance of salt. The per is paid one month aftet maks delivery Pat amplech for Apri sales are made in February, and payment is made in March In addition, Shpepaya 510.000 per month for rent and $20,000 per month for other expenditures prepayment of 22.500 each beach The company cash balance on December 31, 2016, we $22.000. balance of $15.00 mt benne. Autan hanteeded to the chance paid odlin the month following the month of financing if sufficient and we availableInterest on short term lomi (12ptomis paid my wing to meet stated that place at the being of the month. Thus, the finespects to need an additional 0500 in Apel herefde will be the beam April and the 103. 111/13 - 11.300wwe be paid at the beginning of May Complete the belowing cell referraces to the date or presion calculations to imple call me all you need. Toen www cell referenceramicell reference may be preferred. If a speelfie Excel function is to be the direct will specify thewe of the Denetinumerical dan inte a celor functie Instead, make a reference to the cell in which the data is found. Make your computation only in die prees cells highlighted below. Beall ans, les directed the earliest appearance of the in your formules rally the Ghen Date section. Giren Data Purchases of sales Cashcolection of salen) 1096 Cash collections one month after sales of sale) 6096 Cash collections two months after sales (of sales 3045 Rent 510.000,00 Quartedly tases $22.500.00 Yearty interest rate 1290 Yearly interest rate Minimum cash balance Other expenditures Months in a year 1296 $15,000.00 $20,000.00 12 Monthly interest rate Prepare a cash budget for Sharpe covering the first seven months of 2017. The Sharpe Corporation's projected sales for the first night months of 2017 are as follows below Sales (forecasted Purchases (60% of sales price) November 5230,000.00 $54,000.00 December $175.000,00 $72,000.00 January 390,000.00 $81,000,00 February $120,000.00 $144,000.00 March $135,000.00 $180,000.00 April $340,000.00 $160,000.00 May $300,000.00 $135,000.00 June $370,000.00 $90,000.00 July $325.000.00 August $150,000.00 Cash receipts Collections On month after sale (109) One month after sale (6096) Second month after sale (1996) Total cash receipts Cash distrements Payment one month lay of purchases made the previous month Rent Othere - S10,000.00 S200000.00 $0.00 $10,000.00 $20,000.00 S0.00 $10,000.00 $30,000.00 $31.500.00 $10,000.00 $20.000,00 SIL 510,000,00 $20,000.00 50.00 $10,000.00 50.000.00 $10,000.00 550.000,00 F On month after sale (10%) One month after sale (60%) Second month after sale (309) Tetal cash receipts Cash disbursements Payments (one month ag of pachases made the previous month) Rent Other expenses Tours Total cash bursements S10,000.00 $20,000.00 $0.00 $10,000.00 $20,000.00 $10,000.00 $20,000.00 522 500.00 $10,000.00 529,000.00 S200 $10,000.00 $20,000.00 50.00 $10,000.00 $20,000.00 522.500.00 $10,000.00 $20,000.00 $0.00 $0.00 Net change in case for the period Par: Beginnmg cash balance Less Intest on short term borrowing Equal Ending cash bilance before short term borrowing $0.00 $0.00 SOLOD 50.00 S. SI5,000.00 15.000.00 $15.000,00 $15.000,00 $15,000.00 $15,000.00 New funded Cache balance before payment Pepayment yahbalance Cusve bote $0.00 5.00 SO.DO ($15,000,00 50.00 522,000.00 50.00 $35.000.00 530,000.00 545,000.00 SI5.000.00 500.000,00 Shape has 5300.000 in pepayabile da Jay ftst be repaid meated for intention Wat the firm hare ample cash to repay the note! hvemple cash to repay the notes in July Of Sharpe's tales, 10 percent is for cash, anoths 60 percet is collected in the month Totowany the tale, and 30 percent we collected in the second month following the sale. November and December sales for 2016 were 5920,000 and 5173.000, respectively Sharpe'e raw materials cast 60 percent of its product's final tales pelice and we pachased two month advance of salt. The per is paid one month aftet maks delivery Pat amplech for Apri sales are made in February, and payment is made in March In addition, Shpepaya 510.000 per month for rent and $20,000 per month for other expenditures prepayment of 22.500 each beach The company cash balance on December 31, 2016, we $22.000. balance of $15.00 mt benne. Autan hanteeded to the chance paid odlin the month following the month of financing if sufficient and we availableInterest on short term lomi (12ptomis paid my wing to meet stated that place at the being of the month. Thus, the finespects to need an additional 0500 in Apel herefde will be the beam April and the 103. 111/13 - 11.300wwe be paid at the beginning of May Complete the belowing cell referraces to the date or presion calculations to imple call me all you need. Toen www cell referenceramicell reference may be preferred. If a speelfie Excel function is to be the direct will specify thewe of the Denetinumerical dan inte a celor functie Instead, make a reference to the cell in which the data is found. Make your computation only in die prees cells highlighted below. Beall ans, les directed the earliest appearance of the in your formules rally the Ghen Date section. Giren Data Purchases of sales Cashcolection of salen) 1096 Cash collections one month after sales of sale) 6096 Cash collections two months after sales (of sales 3045 Rent 510.000,00 Quartedly tases $22.500.00 Yearty interest rate 1290 Yearly interest rate Minimum cash balance Other expenditures Months in a year 1296 $15,000.00 $20,000.00 12 Monthly interest rate Prepare a cash budget for Sharpe covering the first seven months of 2017. The Sharpe Corporation's projected sales for the first night months of 2017 are as follows below Sales (forecasted Purchases (60% of sales price) November 5230,000.00 $54,000.00 December $175.000,00 $72,000.00 January 390,000.00 $81,000,00 February $120,000.00 $144,000.00 March $135,000.00 $180,000.00 April $340,000.00 $160,000.00 May $300,000.00 $135,000.00 June $370,000.00 $90,000.00 July $325.000.00 August $150,000.00 Cash receipts Collections On month after sale (109) One month after sale (6096) Second month after sale (1996) Total cash receipts Cash distrements Payment one month lay of purchases made the previous month Rent Othere - S10,000.00 S200000.00 $0.00 $10,000.00 $20,000.00 S0.00 $10,000.00 $30,000.00 $31.500.00 $10,000.00 $20.000,00 SIL 510,000,00 $20,000.00 50.00 $10,000.00 50.000.00 $10,000.00 550.000,00 F On month after sale (10%) One month after sale (60%) Second month after sale (309) Tetal cash receipts Cash disbursements Payments (one month ag of pachases made the previous month) Rent Other expenses Tours Total cash bursements S10,000.00 $20,000.00 $0.00 $10,000.00 $20,000.00 $10,000.00 $20,000.00 522 500.00 $10,000.00 529,000.00 S200 $10,000.00 $20,000.00 50.00 $10,000.00 $20,000.00 522.500.00 $10,000.00 $20,000.00 $0.00 $0.00 Net change in case for the period Par: Beginnmg cash balance Less Intest on short term borrowing Equal Ending cash bilance before short term borrowing $0.00 $0.00 SOLOD 50.00 S. SI5,000.00 15.000.00 $15.000,00 $15.000,00 $15,000.00 $15,000.00 New funded Cache balance before payment Pepayment yahbalance Cusve bote $0.00 5.00 SO.DO ($15,000,00 50.00 522,000.00 50.00 $35.000.00 530,000.00 545,000.00 SI5.000.00 500.000,00 Shape has 5300.000 in pepayabile da Jay ftst be repaid meated for intention Wat the firm hare ample cash to repay the note! hvemple cash to repay the notes in July