I need a ratio analysis done on the attached spreadsheet. The ratios are on the bottom of the spreadsheet.
Statutory Financials Audited AccountsCryola FD2039842981Insert Company Identification number here Cryola FD Always Latest Year End HereYear endYear endYear endYear end Enter Year End Date31.08.08Enter Below in31.08.07Enter Below in31.08.06.Enter Below in31.08.05Enter Below in Exchange rate change if not Euro0.0971Local Currency0.0971Local Currency0.0971Local Currency0.0971Local Currency € 000's€ 000's€ 000's€ 000's Turnover309,9923,192,916247,3172,547,360367,2423,782,595291,9153,006,722 Cost of Sales263,0692,709,613208,4372,146,896307,5043,167,288244,8932,522,403 Gross Profit46,923483,30338,880400,46459,739615,30747,021484,319 Operating Profit12,535129,11311,728120,79914,884153,30714,086145,086 Pre Tax Profit10,494108,08610,786111,0955,31554,7465,64658,157 Dividends- 0- 0- 0- 0- 0- 0- 0- 0 Retained Profit8,12083,6406,00361,8263,75038,6224,02941,498 Total Fixed Assets52,706542,86759,489612,737160,9221,657,497159,5971,643,852 Intangible24,021247,41313,433138,356155,4061,600,678157,6331,623,617 Tangible1,94420,0231,11211,4502,71227,9331,90019,573 Investments26,741275,43144,945462,9312,80428,88664662 Total Current Assets38,142392,86328,969298,38340,200414,05734,108351,310 Trade Debtors21,303 cward: £11.6m additional licencing business in one month alone ie July 02. 219,41916,882 cward: £11.6m additional licencing business in one month alone ie July 02. 173,88325,830266,05423,207239,028 Other Debtors4,92950,7701,61016,5804,94650,9422,88929,752 Stock6,91571,2236,11362,9657,03372,4396,29564,841 Cash At Bank1,15911,9381881,9322,39024,6221,71717,689 Amounts owed by group3,83639,5134,17743,023- 0- 0- 0- 0 Total Current Liabilities43,856451,71531,972329,30947,136485,50236,504375,996 Trade Creditors27,921 cward: Increase due to licencing. See comment above 287,58823,483 cward: Increase due to licencing. See comment above Ntiltman: Ntiltman: No sum to total to allow for other types of current assets not listed to be included in total cward: £11.6m additional licencing business in one month alone ie July 02. 241,87728,605294,63125,466262,295 Other Creditors4,55846,9522,34024,1036,62868,2704,89050,372 Short-term loans11,376117,1756,14863,32911,903122,6016,14863,329 Amounts owed to group9,20094,76313,445138,487- 0- 0 Net Current Assets /- 5,714- 58,852- 3,003- 30,926- 6,936- 71,445- 2,397- 24,686 ( Liabilities ) Long Term Liabilities21,848225,03024,688254,28988,150907,94398,7521,017,144 Long-term loans21,848225,03024,688254,28988,150907,94398,7521,017,144 Net Worth25,144258,98531,798327,52265,836678,10958,449602,022 Tangible Net Worth1,12311,57218,366189,166- 89,570- 922,569- 99,184- 1,021,595 Share Capital5836,0005836,00013,556139,63013,366137,672 Retained earnings1,11911,5305,29254,5087,73079,6173,98040,995 Other reserves14,242146,69212,478128,52744,550458,86241,102423,355 Shareholder's funds15,944164,22218,353189,03565,836678,10958,449602,022 Ratios Current Liquid DPO Ntiltman: Ntiltman: pleasure insure you have input the days in the period on line 72 is not 365 cward: £11.6m additional licencing business in one month alone ie July 02. DSO Ntiltman: Ntiltman: please ensure you have entered the days in the period on line 72 if not 365 Ntiltman: Ntiltman: No sum to total to allow for other types of current assets not listed to be included in totalGross Profit Net Profit ( Pre Tax ) Return on Equity Return on Assets Days in financial period ie 1 year = 365 days ( Input as applicable )