Write a VBA Excel DO LOOP.

Loan Amortization Schedule Use the format shown below to construct two different loan amortization schedules. One solution will be a spreadsheet only solution, labeled "Spreadsheet Solution", and the second will be a VBA soution, labeled "VBA Solution" with select portions solved on the spreadsheet and the remainder completed using VBA Spreadsheet Solution: Name a sheet "Spreadsheet Solution" as shown below and build the solution exactly as shown below Use the same font, boxing, and text wrapping. Build using formulas so that entire table will update with a change of the Amount Borrowed, APR, term or payment amount VBA Solution: Name a sheet "VBA Solution" as shown below and build the solution exactly as shown below. Use the same font, boxing, and text wrapping. Constuct the solution of rows 1 to 15 using only the spreadsheet. Use VBA to fill in the loan amortization schedule 5222 04 PR 600 Payments 120 ayment Amouet 222 0 nterest Paidon Aer 2 $19.77 96 sea39 5122 65 $19,755 31 $98 78 $2326 $9,755 31 519632 $19,5O 37 597 54 5324 50 $29 3836 $19.383 9692 $125 32 $9.2585S $19,2SSS $96 29 $325 75 $9 3328 $19,132 80 595 66 5126 38 $19006 43 10 $3AK7941 40 S$27 64 $18,751 77 Loan Amortization Schedule Use the format shown below to construct two different loan amortization schedules. One solution will be a spreadsheet only solution, labeled "Spreadsheet Solution", and the second will be a VBA soution, labeled "VBA Solution" with select portions solved on the spreadsheet and the remainder completed using VBA Spreadsheet Solution: Name a sheet "Spreadsheet Solution" as shown below and build the solution exactly as shown below Use the same font, boxing, and text wrapping. Build using formulas so that entire table will update with a change of the Amount Borrowed, APR, term or payment amount VBA Solution: Name a sheet "VBA Solution" as shown below and build the solution exactly as shown below. Use the same font, boxing, and text wrapping. Constuct the solution of rows 1 to 15 using only the spreadsheet. Use VBA to fill in the loan amortization schedule 5222 04 PR 600 Payments 120 ayment Amouet 222 0 nterest Paidon Aer 2 $19.77 96 sea39 5122 65 $19,755 31 $98 78 $2326 $9,755 31 519632 $19,5O 37 597 54 5324 50 $29 3836 $19.383 9692 $125 32 $9.2585S $19,2SSS $96 29 $325 75 $9 3328 $19,132 80 595 66 5126 38 $19006 43 10 $3AK7941 40 S$27 64 $18,751 77