How is Part E ‘total margin’ calculated for 2017 and 2018 using info in these sh
ID: 2585580 • Letter: H
Question
How is Part E ‘total margin’ calculated for 2017 and 2018 using info in these sheets?
Week 13,Excel Workbookxls [Compatibl Insert Page Layout Formulas sReview View PDF Tell me what you want to do Home Cut Copy , Format Painter B 1 u-|·6-A- |Merge & Center . | $ . % , Condition Formatting Clipboard Font Number 2017 2016 Part B Current Ratio Part C Days Cash on Hand 8 Part D 0 Debt to Equity 27 Part E 29 Total Margin 31 36 Part F 37 Activity Statement Ratios Parts B to G A. Common Size Balance Sheet A. Com. Size
Explanation / Answer
Total Margin = Net Income/Total Income*100
Calculation of Net Income
Particulars 2017 2018 Net Income 872456 271778 Total Revenue 7957921 35654499 Total Margin 20.60% 1.84%