Question: Write a user-defined function to calculate a firms return on equity using the DuPont method as defined by equation (3-29) on page 93. You will

 Write a user-defined function to calculate a firms return on equity

Write a user-defined 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.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

Please create excel formulas and show them

1 Elvis Products International Return on Equity Calculation 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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!