Question: 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
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. Elvis Products International Return on Equity Calculation Ratio 2020 2019 Industry 2020 Operating Profit Margin 3.89% 6.09% Interest Burden 49.23% 70.11% Tax Burden 60.00% 60.00% Net Profit Margin 1.15% 2.56% 3.50% Total Asset Turnover 2.33x 2.34x 2.60x Total Debt Ratio 58.45% 54.81% 50.00% DuPont ROE Extended DuPont ROE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
