Based on given income statement & balance sheet: (a) Calculate DuPont ratio, liquidity & net profit margin ratio (c) Do horizontal analysis for income statement for last four years (d) Do vertical analysis for Balance-sheet for all five years Income StatementBalance sheet31/3/1731/3/1831/3/1931/3/2031/3/2131/3/1731/3/1831/3/1931/3/2031/3/21Equity Sales 4500000660000081675009732937.511461157.81Shareholders Fund 20000002000000200000020000002000000COGS 2925000423600051764406091827.37084766.501Reserves & Surplus 411437.46581181694.972241474.8233595935.5975279553.45 Total Equity 2411437.4663181694.974241474.8235595935.5977279553.45Gross Pofit 1575000236400029910603641110.24376391.312 Indirect Expenses 360000528000653400778635916892.625Liabilities Debt 1200000900000675000506250379687.5EBITDA 1215000183600023376602862475.23459498.687Creditors 443835.6164519287.6712603971.5068640641.2055670926.0625Dep & Amortisation 251309.589233842.8493217781.7074206612.4173195654.4124Total Liabilities 1643835.6161419287.6711278971.5071146891.2051050613.562 EBIT 963690.4111602157.1512119878.2932655862.7833263844.275Total Equity + Liabilities 4055273.0824600982.6415520446.336742826.8028330167.013Interest 18000013500010125075937.556953.125 Assets EBT 783690.4111467157.1512018628.2932579925.2833206891.15Fixed Assets 1848690.4111714847.5621597065.8541510453.4371434799.025Tax 195922.6027366789.2877504657.0732644981.3207801722.7874Inventory 975000141200017254802030609.12361588.834 Cash balance 800075.8219859340.55891459468.9692348465.6353560365.752PAT 587767.80821100367.8631513971.2191934943.9622405168.362Debtors 431506.8493614794.5205738431.5068853298.6301973413.4033 Total Assets 4055273.0824600982.6415520446.336742826.8028330167.013Net Margin Ratio 0.1306150680.1667224030.1853653160.1988036970.209853874(Pat/sales , net profit ratio) Dividends 176330.3425330110.3589454191.3658580483.1886721550.5087Transfer to reserves 411437.4658770257.50411059779.8541354460.7731683617.854 In excel