calculate  retention ratio

Paste 81 Format Painter Clipboard E99 BIU. Font Merge & Center $ % Alignment Number A B C D E F G H PROFIT MARGIN = NET INCOME/SALES *100=6% TOTAL ASSETS TURNOVER = SALES/TOTAL ASSETS = 2.32 EQUITY MULTIPLIE=1.79 DIVIDEND PAYOUT RATIO= 33% SO RETENTION RATIO= 67.00% NET PROFIT MARGIN X ASSETS TURNOVER X EQUITY MULTIPLIER 6% X 2.32 X 1.79 82 83 84 85 86 87 88 89 90 ROE- 91 92 93 94 95 96 97 24.92% SUSTAINABLE GROWTH RATE = SUSTAINABLE GROWTH RATE SUSTAINABLE GROWTH RATE= ROE*b/(1-ROE*b) (24.92%*67%) / (1-(24.92%*67%)) 20.04% Conditional Format Cell Formatting as Table Styles Styles Insert Delete Format Clear- Sort & Find & FilterSelect Cells Editing J K L M N 0