I’ve got the task of working out Ratios on a set of accounts, based on the Profit and Loss accounts and the Balance Sheet.
Profit & Loss Accounts Previous Turnover123,000Current Turnover * 12,122,000,000Cost of Sales8,550,000,000Gross Profit * 3,572,000,000Overheads88,000,000Depreciation/Amortisation * 24,000,000Operating Profit3,460,000,000Total Finance Costs * -391,000,000Total Interest Receivable * 201,547,000Other expense before tax-317,800,000Other income before tax284,000,000Profit before Tax * 4,654,347,000Total Tax Charge1,025,000,000Minority Interests202,000,000Retained Profit3,427,347,000Total Directors’ Remuneration * 110,000,000Fixed Assets Disposal Loss * 0Fixed Assets Disposal Profit * 0Non-Cash Charge * -156,000,000Non-Cash Income * 227,000,000Exceptional Loss * 32,000,000Exceptional Profit * 27,000,000Dividends * 1,393,000,000
Balance SheetNon-Current Assets Total Net Book Value * 0- Land and Building0- Plant and Machinery3,076,000,000- Other Assets863,000,000Intangible Assets * 23,318,000,000- Investments2,552,000,000Total Non-Current Assets23,318,000,000Current Assets Finished Goods * 6,177,000,000Raw Materials * 0Trade Debtors * 5,240,000,000Corporation Tax Debtor1,025,000,000Other Debtors * 1,600,000,000Cash in hand and at Bank * 2,309,000,000Other Current Assets239,500,000Total Current Assets * 16,590,500,000Total Assets39,908,500,000Current Liabilities Trade Creditors * 4,407,000,000Corporation Tax Creditor * 0Other Creditors * 65,000,000Deferred Tax Creditor599,000,000Director’s Loan Account0Debt due within 1 year * 227,000,000- Bank (< 1 year)110,000,000- HP/Leasing (< 1 year)13,000,000- Inter-company (< 1 year)0Total creditors due within 1 year * 5,298,000,000Non-Current Liabilities Director’s Loan Account0 1 year * ">Debt due > 1 year * 6,464,000,000- Bank (> 1 year)6,437,000,000- HP/Leasing (> 1 year)17,000,000- Inter-company (> 1 year)0- Preference Shares506,260,000Other Non-current Liabilities85,000,000Total Non-Current Liabilities6,549,000,000Total Liabilities11,847,000,000Tangible Net Worth * 4,743,500,000Equity Share Capital787,987,000Retained Profits2,680,253,000Reserves910,000,000Funds attributable to shareholders4,378,240,000Other Input Required Total additions to Tangible Fixed Assets0- Capitalised Interest0Sale of Investments0Fixed Assets Sale0Depreciation on Sale of Fixed Asset0Proceeds from the sale of new shares187,000,000Fixed Asset Investment Income0
Ratios Sales Growth9855184.55%9855184.55%Gross Profit Margin29.4729.47%Operating Profit Margin28.5428.54%Interest Cover23.09-10.39Breakeven Sales-3673071202.13-3673071202Margin of Safety130.30130.30%Pre-tax Profit Margin38.4038.40%Gearing 141.06Debtor Days157.78157.78Creditor Days708.13188.14Stock Turnover Days185.99185.99Current Ratio3.133.13Quick Ratio1.971.97Breakeven Gross Margin0.010.01Cashflow Interest Cover 0ROCE101.920Net Working Assets to Sales57.8357.83Business Cycle343.77343.77Funding Gap / (Funding)-364.36155.64PBIT Total Funding0.330.45EBITDA40908000004,090,800,000I need to work out some of the Ratios, I given them a go and worked out most of them.
The ones in Bold I have no idea of how the results are obtained nor the calculations.
would anybody with any accounting experiences shed some light?
The value should equal to the coloum on the right.
Thanks
