Uncategorized
How To Find And Save Your Company’s Annual Reports – Step By Step Guide
PRADA Group | |||||||||||
Statements of Movements in Equity | |||||||||||
Years ended 31 January | |||||||||||
2016 | 2015 | 2014 | 2013 | ||||||||
€ – | € – | € – | € – | ||||||||
Balance at 1 February | 30,97,377 | 30,18,147 | 27,01,540 | 23,30,492 | |||||||
Dividends | (2,82,177) | (2,84,699) | (2,90,849) | (2,36,928) | |||||||
Share capital Increase | 1,014 | 409 | |||||||||
Acquistion of Marchesi Angelo sri | (2,359) | ||||||||||
Capital injenction in subsidiaries | 2,125 | 40 | |||||||||
Transaction with non controlling share holders | (1,728) | (765) | |||||||||
Comprehensive Income for the year (recycled to PL) | 2,87,588 | 3,58,959 | 6,09,722 | 6,12,918 | |||||||
Comprehensive Income for the year (not yet recycled to PL) | 2,456 | 5,326 | (2,032) | (4,982) | |||||||
Balance as at 31 January | 31,04,530 | 30,97,377 | 30,18,147 | 27,01,540 | |||||||
PRADA Group | |||||||||||
Balance Sheets | |||||||||||
as at 31 January | |||||||||||
2016 | 2015 | 2014 | 2013 | ||||||||
€ – | € – | € – | € – | ||||||||
Assets | |||||||||||
Current Assets | |||||||||||
Cash and Cash Equivalent | 7,22,214 | 6,80,601 | 7,08,966 | 5,68,414 | |||||||
Trade Receivable (net) | 2,85,504 | 2,54,183 | 3,46,284 | 3,08,405 | |||||||
Inventories (net) | 5,26,941 | 6,92,672 | 6,54,545 | 4,49,903 | |||||||
Derivative Financial Instrument | 7,045 | 11,682 | 6,287 | 13,984 | |||||||
Receivable from and advance payment to related parties | 14,964 | 19,629 | 3,240 | 5,993 | |||||||
Other Current Assets | 2,53,375 | 2,29,671 | 1,80,633 | 1,14,897 | |||||||
Total Current Assets | 18,10,043 | 18,88,438 | 18,99,955 | 14,61,596 | |||||||
Non Current Assets | |||||||||||
Property, Plant and Equipment | 15,42,684 | 15,17,779 | 14,74,218 | 12,30,192 | |||||||
Intangible Assets | 9,21,800 | 9,32,238 | 9,43,304 | 9,01,289 | |||||||
Associated Undertaking | 11,775 | 17,354 | 30,529 | 21,186 | |||||||
Deferred tax assets | 2,47,266 | 2,80,572 | 2,80,893 | 2,01,245 | |||||||
Other non current assets | 1,23,361 | 1,13,954 | 91,353 | 69,867 | |||||||
Derivative Financial Instrument- Non current | 721 | 1,106 | 1,430 | ||||||||
Receivable from and advance payment to related parties | 5,499 | 17,429 | 1,487 | ||||||||
Total Non Current Assets | 28,46,886 | 28,68,117 | 28,38,832 | 24,26,696 | |||||||
Total Assets | 46,56,929 | 47,56,555 | 47,38,787 | 38,88,292 | |||||||
Liabilities and Shareholders Equity | |||||||||||
Current Liabilities | |||||||||||
Short term financial payable and Overdraft | 1,51,211 | 2,70,766 | 2,63,335 | 61,909 | |||||||
Payable to related related parties – Current | 5,542 | 5,244 | 3,083 | 4,894 | |||||||
Trade Payable | 2,56,094 | 2,81,699 | 4,37,420 | 3,48,534 | |||||||
Tax Payable | 65,467 | 80,744 | 1,33,914 | 1,32,145 | |||||||
Derivative financial Instruments- Current | 13,634 | 11,095 | 56,772 | 3,803 | |||||||
Obligation under finance lease- current | 21 | 524 | |||||||||
Other Current Liabilities | 1,44,827 | 1,42,271 | 2,20,480 | 1,54,666 | |||||||
Total Current Liabilities | 6,36,775 | 7,91,819 | 11,15,025 | 7,06,475 | |||||||
Non Current Liability | |||||||||||
Long term financial Payables | 5,47,628 | 5,20,475 | 2,55,203 | 2,07,950 | |||||||
Obligation under finance lease non current | 19 | ||||||||||
Long term employee benefits | 67,211 | 69,405 | 85,754 | 63,279 | |||||||
Provision for risks and charges | 82,323 | 69,233 | 63,695 | 52,660 | |||||||
Deferred Tax Liabilities | 31,140 | 36,882 | 41,634 | 42,671 | |||||||
Other Non current Liability | 1,79,072 | 1,61,317 | 1,28,752 | 98,982 | |||||||
Derivative financial Instruments- Non current | 8,250 | 10,047 | 17,283 | 1,469 | |||||||
Payable to related related parties – Non Current | 13,384 | 13,247 | |||||||||
Total Non Current Liabilities | 9,15,624 | 8,67,359 | 6,05,705 | 4,80,277 | |||||||
Total Liability | 15,52,399 | 16,59,178 | 17,20,730 | 11,86,752 | |||||||
Share Capital | 2,55,882 | 2,55,882 | 2,55,882 | 2,55,882 | |||||||
Total Other Reserve | 24,01,500 | 23,55,023 | 21,63,129 | 18,53,325 | |||||||
Translation Reserve | 1,44,791 | 1,38,547 | 1,30,996 | (49,438) | |||||||
Net Income of the Year | 2,78,329 | 3,30,888 | 4,50,730 | 6,27,785 | |||||||
Equity Attributable to owners of the group | 30,80,502 | 30,80,340 | 30,00,737 | 26,87,554 | |||||||
Equity Attributable to non controlling interest | 24,028 | 17,037 | 17,410 | 13,986 | |||||||
Total equity | 31,04,530 | 30,97,377 | 30,18,147 | 27,01,540 | |||||||
Total liability and Total equity | 46,56,929 | 47,56,555 | 47,38,877 | 38,88,292 | |||||||
Net Current Assets | 17,13,268 | 10,96,619 | 7,84,930 | 7,55,121 | |||||||
Total Assets less current liabilities | 40,20,154 | 39,64,736 | 36,23,852 | 31,81,817 | |||||||
PRADA Group | |||||||||||
Income Statements | |||||||||||
Years ended 31 January | |||||||||||
2016 | 2015 | 2014 | 2013 | ||||||||
€ – | € – | € – | € – | ||||||||
Net Revenue | 31,84,069 | 35,47,771 | 35,51,696 | 35,87,347 | |||||||
Cost of Goods sold | (8,94,957) | (9,80,206) | (10,01,117) | (9,38,698) | |||||||
Gross margin | 22,89,112 | 25,67,565 | 25,50,579 | 26,48,649 | |||||||
Operating expenses | (18,57,931) | (20,64,672) | (18,49,028) | (17,09,412) | |||||||
EBIT | 4,31,181 | 5,02,893 | 7,01,551 | 9,39,237 | |||||||
Interest and other financial Income | (18,003) | (29,872) | (34,304) | (17,357) | |||||||
Dividends from Investments | 2,252 | 2,311 | 455 | 1,016 | |||||||
Income before tax | 4,15,430 | 4,75,332 | 6,67,702 | 9,22,896 | |||||||
Taxation | (1,31,240) | (1,41,994) | (2,08,484) | (2,85,091) | |||||||
Net income for the year | 2,84,190 | 3,33,338 | 4,59,218 | 6,37,805 | |||||||
Net Income non controlling interest | 5,861 | 2,450 | 8,488 | 10,020 | |||||||
Net Income Group | 2,78,329 | 3,30,888 | 4,50,730 | 6,27,785 | |||||||
Basic and Diluted earning per share | 0.109 | 0.129 | 0.176 | 0.245 | |||||||
Working Area | |||||||||||
This is a place where you can copy and paste formulas, play with calculations and generally have fun whilst being able to see the data you are currently working on. | |||||||||||
PRADA Group | |||||||||||
Restated Statements of Movements in Equity | |||||||||||
Years ended 31 January | |||||||||||
2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2016 | 2015 | 2014 | 2013 | ||
$’000 | $’000 | $’000 | $’000 | $’000 | $’000 | € – | € – | € – | € – | ||
Balance at 1 February | 30,97,377.0 | 30,18,147.0 | 27,01,540.0 | 23,30,492.0 | |||||||
Operating Comprehensive Income | |||||||||||
Transaction with non controlling share holders | (1,728.0) | (765.0) | 0.0 | 0.0 | |||||||
Comprehensive Income for the year (recycled to PL) | 2,87,588.0 | 3,58,959.0 | 6,09,722.0 | 6,12,918.0 | |||||||
Comprehensive Income for the year (not yet recycled to PL) | 2,456.0 | 5,326.0 | (2,032.0) | (4,982.0) | |||||||
Other Financial Comprehensive Income | |||||||||||
Acquistion of Marchesi Angelo sri | 0.0 | 0.0 | (2,359.0) | 0.0 | |||||||
Capital injenction in subsidiaries | 0.0 | 0.0 | 2,125.0 | 40.0 | |||||||
Total Comprehensive Income | 33,85,693.0 | 33,81,667.0 | 33,08,996.0 | 29,38,468.0 | |||||||
Transaction with shareholders | |||||||||||
Share capital Increase | 1,014.0 | 409.0 | 0.0 | 0.0 | |||||||
Dividends | (2,82,177.0) | (2,84,699.0) | (2,90,849.0) | (2,36,928.0) | |||||||
Equity at the end of the year | 31,04,530.0 | 30,97,377.0 | 30,18,147.0 | 27,01,540.0 | |||||||
PRADA Group | |||||||||||
Restated Statements of Financial Position | |||||||||||
as at 31 January | |||||||||||
2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2016 | 2015 | 2014 | 2013 | ||
$’000 | $’000 | $’000 | $’000 | $’000 | $’000 | € – | € – | € – | € – | ||
Operating Assets | |||||||||||
Cash and Cash Equivalent | 7,22,214 | 6,80,601 | 7,08,966 | 5,68,414 | 7,22,214 | 6,80,601 | 7,08,966 | 5,68,414 | |||
Trade Receivable (net) | 2,85,504 | 2,54,183 | 3,46,284 | 3,08,405 | 2,85,504 | 2,54,183 | 3,46,284 | 3,08,405 | |||
Inventories (net) | 5,26,941 | 6,92,672 | 6,54,545 | 4,49,903 | 5,26,941 | 6,92,672 | 6,54,545 | 4,49,903 | |||
Receivable from and advance payment to related parties | 14,964 | 19,629 | 3,240 | 5,993 | 14,964 | 19,629 | 3,240 | 5,993 | |||
Other Current Assets | 2,53,375 | 2,29,671 | 1,80,633 | 1,14,897 | 2,53,375 | 2,29,671 | 1,80,633 | 1,14,897 | |||
Property, Plant and Equipment | 15,42,684 | 15,17,779 | 14,74,218 | 12,30,192 | |||||||
Intangible Assets | 9,21,800 | 9,32,238 | 9,43,304 | 9,01,289 | |||||||
Associated Undertaking | 11,775 | 17,354 | 30,529 | 21,186 | |||||||
Deferred tax assets | 2,47,266 | 2,80,572 | 2,80,893 | 2,01,245 | |||||||
Other non current assets | 1,23,361 | 1,13,954 | 91,353 | 69,867 | |||||||
Receivable from and advance payment to related parties | 0 | 5,499 | 17,429 | 1,487 | |||||||
Total operating Assets | 18,10,043 | 18,88,438 | 18,99,955 | 14,61,596 | 46,49,884 | 47,44,152 | 47,31,394 | 38,72,878 | |||
Operating Liability | |||||||||||
Short term financial payable and Overdraft | 1,51,211.0 | 2,70,766.0 | 2,63,335.0 | 61,909.0 | |||||||
Payable to related related parties – Current | 5,542 | 5,244 | 3,083 | 4,894 | |||||||
Trade Payable | 2,56,094 | 2,81,699 | 4,37,420 | 3,48,534 | |||||||
Tax Payable | 65,467 | 80,744 | 1,33,914 | 1,32,145 | |||||||
Obligation under finance lease- current | 21 | 524 | |||||||||
Other Current Liabilities | 1,44,827 | 1,42,271 | 2,20,480 | 1,54,666 | |||||||
Obligation under finance lease non current | 19 | ||||||||||
Long term employee benefits | 67,211 | 69,405 | 85,754 | 63,279 | |||||||
Provision for risks and charges | 82,323 | 69,233 | 63,695 | 52,660 | |||||||
Deferred Tax Liabilities | 31,140 | 36,882 | 41,634 | 42,671 | |||||||
Other Non current Liability | 1,79,072 | 1,61,317 | 1,28,752 | 98,982 | |||||||
Payable to related related parties – Non Current | 13,384 | 13,247 | |||||||||
Total opearting Liability | 9,82,887 | 11,17,561 | 13,91,472 | 9,73,530 | |||||||
Net Operating Assets | 36,66,997 | 36,26,591 | 33,39,922 | 28,99,348 | |||||||
Financial Obligation | |||||||||||
Long term financial Payables | 5,47,628 | 5,20,475 | 2,55,203 | 2,07,950 | |||||||
Derivative financial Instruments- Non current | 8,250 | 10,047 | 17,283 | 1,469 | |||||||
Derivative financial Instruments- Current | 13,634.0 | 11,095.0 | 56,772.0 | 3,803.0 | |||||||
Total Financial obligation | 5,69,512.0 | 5,41,617.0 | 3,29,258.0 | 2,13,222.0 | |||||||
Financial Assets | |||||||||||
Derivative Financial Instrument | 7,045.0 | 11,682.0 | 6,287.0 | 13,984.0 | |||||||
Derivative Financial Instrument- Non current | 721.0 | 1,106.0 | 1,430.0 | ||||||||
Total Financial Assets | 7,045.0 | 12,403.0 | 7,393.0 | 15,414.0 | |||||||
Net Financial Obligation | 5,62,467.0 | 5,29,214.0 | 3,21,865.0 | 1,97,808.0 | |||||||
Share Capital | 2,55,882.0 | 2,55,882.0 | 2,55,882.0 | 2,55,882.0 | |||||||
Total Other Reserve | 24,01,500.0 | 23,55,023.0 | 21,63,129.0 | 18,53,325.0 | |||||||
Translation Reserve | 1,44,791.0 | 1,38,547.0 | 1,30,996.0 | (49,438.0) | |||||||
Net Income of the Year | 2,78,329.0 | 3,30,888.0 | 4,50,730.0 | 6,27,785.0 | |||||||
Equity Attributable to owners of the group | 30,80,502.0 | 30,80,340.0 | 30,00,737.0 | 26,87,554.0 | |||||||
Equity Attributable to non controlling interest | 24,028.0 | 17,037.0 | 17,410.0 | 13,986.0 | |||||||
Total equity | 31,04,530.0 | 30,97,377.0 | 30,18,147.0 | 27,01,540.0 | |||||||
Total NFO + Equity | 36,66,997.0 | 36,26,591.0 | 33,40,012.0 | 28,99,348.0 | |||||||
PRADA Group | |||||||||||
Restated Statements of Financial Performance | |||||||||||
Years ended 31 January | |||||||||||
2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2016 | 2015 | 2014 | 2013 | ||
$’000 | $’000 | $’000 | $’000 | $’000 | $’000 | € – | € – | € – | € – | ||
Operating Income | |||||||||||
Net Revenue | 31,84,069.0 | 35,47,771.0 | 35,51,696.0 | 35,87,347.0 | |||||||
Total Operating Income | 31,84,069.0 | 35,47,771.0 | 35,51,696.0 | 35,87,347.0 | |||||||
COGS | (8,94,957.0) | (9,80,206.0) | (10,01,117.0) | (9,38,698.0) | |||||||
Operating Expenses | (18,57,931.0) | (20,64,672.0) | (18,49,028.0) | (17,09,412.0) | |||||||
Operating Profit before Income tax | 4,31,181.0 | 5,02,893.0 | 7,01,551.0 | 9,39,237.0 | |||||||
Tax Expenses | (1,31,240.0) | (1,41,994.0) | (2,08,484.0) | (2,85,091.0) | |||||||
Other operating Comprehensive Income | |||||||||||
Dividends from Investments | 2,252.0 | 2,311.0 | 455.0 | 1,016.0 | |||||||
Comprehensive Operating Income after tax | 3,02,193.0 | 3,63,210.0 | 4,93,522.0 | 6,55,162.0 | |||||||
Net Financial Income | (18,003.0) | (29,872.0) | (34,304.0) | (17,357.0) | |||||||
Comprehensive net profit | 2,84,190.0 | 3,33,338.0 | 4,59,218.0 | 6,37,805.0 | |||||||
PRADA Group | |||||||||||
RATIOS | |||||||||||
Years ended 31 January | |||||||||||
2016 | 2015 | 2014 | 2013 | ||||||||
Profitability Ratios | |||||||||||
Gross Profit Margin | Gross profit/sales | 19.26% | |||||||||
Net Profit Margin | Net profit after tax/sales | ||||||||||
Return on Assets | Net profit after tax/total assets | ||||||||||
Efficiency (or Asset Management) Ratios | |||||||||||
Inventory Turnover Ratio | Cost of goods sold/ending inventory | 189.20% | |||||||||
Days of Inventory | Inventory/av.daily cost of goods sold | ||||||||||
Total Asset Turnover Ratio | Sales/total assets | ||||||||||
Current Asset Turnover Ratio | Sales/current assets | ||||||||||
Average Collection Period (Days Receivable) | Accounts receivable/av.daily credit sales | ||||||||||
Liquidity Ratios | |||||||||||
Current Ratio | Current assets/current liabilities | ||||||||||
Quick Ratio 1 | (Current assets – inventory – prepayments)/current liabilities | 0.90% | |||||||||
Quick Ratio 2 | (Current assets – inventory – prepayments – receivables)/current liabilities | ||||||||||
Financial Structure Ratios | |||||||||||
Debt/Equity Ratio | Debt/equity | ||||||||||
Equity Ratio | Equity/total assets | ||||||||||
Times Interest Earned | Earnings before interest & tax/interest | ||||||||||
Market Ratios | |||||||||||
Earnings per Share (EPS) | Net profit after tax/nos of issued ordinary shares | ||||||||||
Dividends per Share (DPS) | Dividends/number of issued ordinary shares | ||||||||||
Dividend Yield Ratio | Dividends per share/market price per share | ||||||||||
Price Earnings Ratio | Market price per share/earnings per share | ||||||||||
Net Asset Backing per Share Ratio | Net assets (owners equity)/number of shares issued | ||||||||||
Market/Book Ratio | Market price per share/net asset backing per share | 5.20% | |||||||||
Ratios Based on Reformulated Financial Statements | |||||||||||
Dividend Payout Ratio | Dividends/comprehensive income | ||||||||||
Return on Equity (ROE) | Comprehensive Income/shareholders’ equity | ||||||||||
Return on Net Operating Assets (RNOA) | Operating income after tax (OI)/net operating assets (NOA) | ||||||||||
Net Borrowing Cost (NBC) | Net fin. expenses after tax/net financial obligations | ||||||||||
Profit Margin (PM) | Operating income after tax (OI)/sales | ||||||||||
Operating Liability Leverage (OLLEV) | Av.operating liabilities/av.net operating assets | ||||||||||
Financial Leverage (FLEV) | Av.net financial obligations/av.shareholders’ equity | ||||||||||
Return on Operating Assets (ROOA) | (OI after tax + implicit interest after tax)/av.operating assets | ||||||||||
Operating Liability Leverage Spread (OLSPREAD) | ROOA – short-term borrowing rate (after tax) | ||||||||||
Asset Turnover (ATO) | Sales/net operating assets (NOA) | ||||||||||
Growth in Sales | Change in sales/prior period’s sales | ||||||||||
Growth in Operating Income | Change in OI after tax/prior period’s OI after tax | ||||||||||
Growth in Net Operating Assets | Change in NOA/opening NOA | ||||||||||
Growth in Shareholders’ Equity | Change in shareholders’ equity/opening shareholders’ equity | ||||||||||
Economic profit | (RNOA – cost of capital) x net operating assets (NOA) | ||||||||||
OPTION 1: BUNNINGS | |||||||||||
Time period | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Cashflow | -77 | -4 | 5 | 15 | 20 | 20 | 20 | 25 | 25 | 10 | 13 |
NPV | $5.88 | ||||||||||
IRR | 11.4% | ||||||||||
Time period | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Cashflow | -77 | -4 | 5 | 15 | 20 | 20 | 20 | 25 | 25 | 10 | 13 |
Cumulative Cashflow | -77 | -81 | -76 | -61 | -41 | -21 | -1 | 24 | 49 | 59 | 72 |
Payback Period | 6 years | 14.6 | days | ||||||||
0.48 | months | ||||||||||
0.04 | years | ||||||||||
OPTION 2: COLES | |||||||||||
Time period | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Cashflow | -135 | -5 | -1 | 10 | 15 | 15 | 20 | 20 | 20 | 25 | 13.5 |
NPV | -$66.61 | ||||||||||
IRR | -0.3% | ||||||||||
Time period | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Cashflow | -135 | -5 | -1 | 10 | 15 | 15 | 20 | 20 | 20 | 25 | 13.5 |
Cumulative Cashflow | -135 | -140 | -141 | -131 | -116 | -101 | -81 | -61 | -41 | -16 | -2.5 |
Payback Period | Investment is never paid back within 10 years |