Assume that all the B&M sales were on account and that payments would be recieved monthly for one year. The interest rate is found in C20. Use payment fuction to calculate the installement amont the business will recieve for B&M sales for each month. include these values in column G.

Can you help me with formula?

B&M (Brick-and-mortar)

File Home Insert Page Layout Formulas Data Review X Calibri V11 Or Insert I U Paste A Percentag $ - % .00 View Help Tell me what you wa T Conditional Formatting Format as Table Delete Cell Styles Format Styles Cells D-A- 60 00.0 Clipboard Font Alignment Number C20 fax 5.25% 1 N 3 4. 5 January 6 February 7 March 8 April 9 May 10 June 11 July 12 August 13 September 14 October 15 November 16 December 17 Total B C D E F G Your Name Corporation Business Analysis 2019 E-commerce Brick-and-mortar Monthly Total EC-B&M Shipping Monthly Income from for EC Months B & M Income $555,000 $540,000 $1,095,000 $15,000 $11,100 $452,000 $775,000 $1,227,000-$323,000 $22,600 $300,000 $550,000 $850,000 $250,000 $15,000 $267,000 $340,000 $607,000 -$73,000 $13,350 $500,670 $220,000 $720,670 $280,670 $10,013,40 $430,000 $230,000 $660,000 $200,000 $21,500 $510,000 $555,000 $1,065,000 -$45,000 $10,200 $980,000 $1,005,000 $1,985,000 -$25,000 $19,600 $780,000 $900,500 $1,680,500 -$120,500 $15,600 $500,000 $640,000 $1,140,000 $140,000 $25,000 $430,000 $275,000 $705,000 $155,000 $21,500 $976,000 $770,000 $1,746,000 $206,000 $19,520 $6,680,670 $6,800,500 5 18 19 20 Annual Interest Rate 21 5.25% File Home Insert Page Layout Formulas Data Review X Calibri V11 Or Insert I U Paste A Percentag $ - % .00 View Help Tell me what you wa T Conditional Formatting Format as Table Delete Cell Styles Format Styles Cells D-A- 60 00.0 Clipboard Font Alignment Number C20 fax 5.25% 1 N 3 4. 5 January 6 February 7 March 8 April 9 May 10 June 11 July 12 August 13 September 14 October 15 November 16 December 17 Total B C D E F G Your Name Corporation Business Analysis 2019 E-commerce Brick-and-mortar Monthly Total EC-B&M Shipping Monthly Income from for EC Months B & M Income $555,000 $540,000 $1,095,000 $15,000 $11,100 $452,000 $775,000 $1,227,000-$323,000 $22,600 $300,000 $550,000 $850,000 $250,000 $15,000 $267,000 $340,000 $607,000 -$73,000 $13,350 $500,670 $220,000 $720,670 $280,670 $10,013,40 $430,000 $230,000 $660,000 $200,000 $21,500 $510,000 $555,000 $1,065,000 -$45,000 $10,200 $980,000 $1,005,000 $1,985,000 -$25,000 $19,600 $780,000 $900,500 $1,680,500 -$120,500 $15,600 $500,000 $640,000 $1,140,000 $140,000 $25,000 $430,000 $275,000 $705,000 $155,000 $21,500 $976,000 $770,000 $1,746,000 $206,000 $19,520 $6,680,670 $6,800,500 5 18 19 20 Annual Interest Rate 21 5.25%