Statutory Financials Audited Accounts Cryola FD XXXXXXXXXX Insert Company Identification number here Cryola FD Always Latest Year End Here Year end Year end Year end Year end Enter Year End Date...

1 answer below »
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 )
Answered Same DayFeb 28, 2021

Answer To: Statutory Financials Audited Accounts Cryola FD XXXXXXXXXX Insert Company Identification number here...

Shakeel answered on Feb 28 2021
132 Votes
Statutory Financials
    Audited Accounts        Cryola FD            2039842981        Insert Company Identification numbe
r here
                            Cryola FD
    Always Latest Year End Here        Year end        Year end        Year end        Year end
    Enter Year End Date        31.08.08    Enter Below in    31.08.07    Enter Below in    31.08.06.    Enter Below in    31.08.05    Enter Below in
    Exchange rate change if not Euro        0.0971    Local Currency    0.0971    Local Currency    0.0971    Local Currency    0.0971    Local Currency
            € 000's        € 000's        € 000's        € 000's
    Turnover        309,992    3,192,916    247,317    2,547,360    367,242    3,782,595    291,915    3,006,722
    Cost of Sales        263,069    2,709,613    208,437    2,146,896    307,504    3,167,288    244,893    2,522,403
    Gross Profit        46,923    483,303    38,880    400,464    59,739    615,307    47,021    484,319
    Operating Profit        12,535    129,113    11,728    120,799    14,884    153,307    14,086    145,086
    Pre Tax Profit        10,494    108,086    10,786    111,095    5,315    54,746    5,646    58,157
    Dividends        - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0
    Retained Profit        8,120    83,640    6,003    61,826    3,750    38,622    4,029    41,498
    Total...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here