Write a user-defined VBA function to calculate a firms return on equity using the DuPont method as defined by equation (3-29) on page 93. You will need the func-tion to accept three arguments: the net profit margin, total asset turnover ratio, and the debt ratio. Now, write another function to calculate the extended DuPont ROE as defined in equation (3-33) on page 94. This second function will require five arguments: the operating profit margin, interest burden, tax burden, total asset turnover, and the debt ratio.

Please create excel formulas and VBA code and show them

1 Elvis Products International Return on Equity Calculation 2 N Industry 2020 3 Ratio 4 Operating Profit Margin 5 Interest Burden 6 Tax Burden 7 Net Profit Margin 8 Total Asset Turnover 9 Total Debt Ratio 10 11 DuPont ROE 12 Extended DuPont ROE 13 2020 3.89% 49.23% 60.00% 1.15% 2.33x 58.45% 2019 6.09% 70.11% 60.00% 2.56% 2.34x 54.81% 3.50% 2.60x 50.00% ROE Net Profit Margin X Total Asset Turnover 1 - Total Debt Ratio (3-29) NI EBIT Sales Extended DuPont ROE - EBT Sales EBIT EBT Total Assets Total Debt 1 Total Assets (3-33) 1 Elvis Products International Return on Equity Calculation 2 N Industry 2020 3 Ratio 4 Operating Profit Margin 5 Interest Burden 6 Tax Burden 7 Net Profit Margin 8 Total Asset Turnover 9 Total Debt Ratio 10 11 DuPont ROE 12 Extended DuPont ROE 13 2020 3.89% 49.23% 60.00% 1.15% 2.33x 58.45% 2019 6.09% 70.11% 60.00% 2.56% 2.34x 54.81% 3.50% 2.60x 50.00% ROE Net Profit Margin X Total Asset Turnover 1 - Total Debt Ratio (3-29) NI EBIT Sales Extended DuPont ROE - EBT Sales EBIT EBT Total Assets Total Debt 1 Total Assets (3-33)