Assume that ALL the B&M(Brick-and-Mortar) sales were on account and that the payments would be received monthly for one year. The interest rate is found in C20. Use the payment function to calculate the installment amount the business will receive for B&M sales of each month. Include these values in column G.

Can you help me with the formula?

5 300000000_Excel Data [Ream File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Calibri v 11 V A ab Wrap Text General 60% - A * Cut @ Copy Format Painter Paste BIU- . == Merge & Center - $ - % to 98 Conditional Format as Accents Formatting Table Clipboard Font Alignment Number > f E H I J Rating B c D F G 1 Your Name Corporation 2 Business Analysis 3 2019 Shipping Monthly Income from E-commerce Brick-and-mortar Monthly Total EC-B&M 4. for EC Months B & M Income 5 January $555,000 $540,000 $1,095,000 $15,000 $11,100 6 February $452,000 $775,000 $1,227,000 $323,000 $22,600 7 March $300,000 $550,000 $850,000 -$250,000 $15,000 8 April $267,000 $340,000 $607,000 -$73,000 $13,350 9 May $500,670 $220,000 $720,670 $280,670 $10,013.40 10 June $430,000 $230,000 $660,000 $200,000 $21,500 11 July $510,000 $555,000 $1,065,000 -$45,000 $10,200 12 August $980,000 $1,005,000 $1,985,000 $25,000 $19,600 13 September $780,000 $900,500 $1,680,500 -$120,500 $15,600 14 October $500,000 $640,000 $1,140,000 $140,000 $25,000 15 November $430,000 $275,000 $705,000 $155,000 $21,500 16 December $976,000 $770,000 $1,746,000 $206,000 $19,520 17 Total $6,680,670 $6,800,500 5 18 19 20 Annual Interest Rate 5.25% 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Y2019 + Ready 5 300000000_Excel Data [Ream File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Calibri v 11 V A ab Wrap Text General 60% - A * Cut @ Copy Format Painter Paste BIU- . == Merge & Center - $ - % to 98 Conditional Format as Accents Formatting Table Clipboard Font Alignment Number > f E H I J Rating B c D F G 1 Your Name Corporation 2 Business Analysis 3 2019 Shipping Monthly Income from E-commerce Brick-and-mortar Monthly Total EC-B&M 4. for EC Months B & M Income 5 January $555,000 $540,000 $1,095,000 $15,000 $11,100 6 February $452,000 $775,000 $1,227,000 $323,000 $22,600 7 March $300,000 $550,000 $850,000 -$250,000 $15,000 8 April $267,000 $340,000 $607,000 -$73,000 $13,350 9 May $500,670 $220,000 $720,670 $280,670 $10,013.40 10 June $430,000 $230,000 $660,000 $200,000 $21,500 11 July $510,000 $555,000 $1,065,000 -$45,000 $10,200 12 August $980,000 $1,005,000 $1,985,000 $25,000 $19,600 13 September $780,000 $900,500 $1,680,500 -$120,500 $15,600 14 October $500,000 $640,000 $1,140,000 $140,000 $25,000 15 November $430,000 $275,000 $705,000 $155,000 $21,500 16 December $976,000 $770,000 $1,746,000 $206,000 $19,520 17 Total $6,680,670 $6,800,500 5 18 19 20 Annual Interest Rate 5.25% 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Y2019 + Ready