NordProd Financial Diagnostic Analysis

Extract

[...] Also, the the treasury is better with the loan. 4. [...]

[...] This is the short-term mobilized money NET WORTH (bottom of the balance sheet) CASH ASSETS-CASH LIABILITIES 301573+136959-0 438 532 This ratio shows that the cash flow is positive and a positive cash flow shows a fairly satisfactory profitability. This is the short-term mobilized money Conclusion: The FRNG is positive and the BFR is positive: the company generates a positive cash flow INCOME STATEMENT EXPENSES AMOUNT REVENUES AMOUNT PURCHASE OF GOODS 092 CA HT 970 OPERATING COSTS 226 FINANCIAL PRODUCTS 26 120 PERSONNEL EXPENSES 398 TAXES AND DUTIES 390 903 DEPRECIATION 865 718 OPERATING RESULT" 633 FINANCIAL CHARGES 178 580 FINANCIAL RESULT 152 460 CURRENT RESULT BEFORE TAX 173 TAXES ON PROFIT 506 101 NET RESULT 072 Comments on the income statement: ELEMENTS FORMULA CALCULATION INTERPRETATIONS MARGIN RATE - merchandise purchases) / CA) x 100 ((31639970-11814092) /31639970) *100 63% The margin rate refers to the profitability generated on sales. [...]

[...] VAT 000 000 300 265 278 LIST OF VARIABLES 000 700 685 119 175 FIXED COSTS 000 600 652 165 148 DEPRECIATION ALLOWANCES 400 000 400 000 400 000 400 000 400 000 GROSS RESULT BEFORE TAXES 76 000 133 700 194 963 259 981 328 955 28% IS 21 280 37 436 54 590 72 795 92 107 NET RESULT" 54 720 96 264 140 373 187 186 236 848 PROVISIONS FOR DEPRECIATION 400 000 400 000 400 000 400 000 400 000 CAF ECONOMIC 454 720 496 264 540 373 587 186 636 848 1 2 3 4 5 BFR (36 days of Gross Sales)" 292 000 306 600 321 930 338 027 354 928 VARIATION OF BFR 292 000 14 600 15 330 16 097 16 901 RECOVERY OF BFR 337 181 NET TREASURY FLOW TABLE 1 2 3 4 5 JOBS INVESTMENT * 000 VAR BFR 292 000 14 600 15 330 16 097 16 901 RESOURCES CAF 454 720 496 264 540 373 587 186 636 848 RECOVERY BFR 337 181 CASH FLOW 000 162 720 481 664 525 043 571 090 957 128 CASH FLOW ACTUALISE 000 153 509 428 679 440 837 452 357 715 222 CASH FLOW ACTUALISE CUMULES 000 491 811 976 975 524 618 190 603 VAN with a rate of 190 603 TRI 8,796% DRCI So be 4 years 9 months 4,73 For a rate of TRI = 13 237 For a rate of TRI = 51 585 - CASH FLOW = ECONOMIC CASH FLOW + RECOVERY BFR - INVESTMENT - VARIATION BFR - CASH FLOW ACTUALISED : example for year N = 162720*(1+6%) = 153 509 - Calculation of TRI: to find the TRI, we will take two rates, each of which gives negative and positive VAN. - The VAN is equal to the sum of the actualised cash-flows = 190603 For a rate of the TRI = =-2000000+(162720*(1+9%) +(481664*(1+9%) +(525043*(1+9%) +(571090*(1+9%) +(957128*(1+9%) = -13237 For a rate of the TRI = =-2000000+(162720*(1+8%) +(481664*(1+8%) +(525043*(1+8%) +(571090*(1+8%) +(957128*(1+8%) = 51585. [...]

[...] The higher the rate, the more comfortable the company's result will be. EBE CA - Merchandise purchases - operating expenses - taxes and fees - Personnel charges 31639970-11814092-9845226-390903-6775398 351 The EBE is the part of the added value that returns to the capital factor. [...]

[...] MOST INTERESTING FINANCING MODE FOR THE NORDPROD GROUP Loan Table Loan Capital Interest Capital Amortization Remaining Capital 1 000 56 000 400 000 000 2 000 44 800 400 000 000 3 000 33 600 400 000 800 000 4 800 000 22 400 400 000 400 000 5 400 000 11 200 400 000 - Interest 56000 = (2000000*2.8%) - Remaining Capital = capital - capital amortization = 2000000-400000 (e.g. for the first year) - Capital N+1 = remaining capital of N BALANCE SHEET WITH A LOAN OF 2,000,000 EUROS FOR INNOVATION INVESTMENT FUNCTIONAL CONSOLIDATED BALANCE SHEET ASSETS AMOUNT LIABILITIES MONTANT FIXED ASSETS CAPITAL 340 000 INTANGIBLE ASSETS 250 RESERVE 16 982 PROPERTY, PLANT AND EQUIPMENT 106 NEW REPORT 246 654 FINANCIAL ASSETS 19 514 NET RESULT 1 252 925 LOAN YEAR * 4 034 869 LOAN YEAR 493 CURRENT ASSET CURRENT LIABILITY" STOCKS 769 317 ACCOUNTS PAYABLE 288 ACCOUNTS RECEIVABLE 023 TAXES AND SOCIAL CONTRIBUTIONS 252 163 OTHER BUSINESS DEBTS 901 368 ASSETS* 1 845 573 ADVANCED FIXED CHARGES 136 959 TOTAL 9 890 742 TOTAL 9 890 742 *1845573 = availability before loan + borrowed capital - repayment (capital + interest) = 301573 + 2000000-56000-400000 - Loan + 1 year = 4034869 = previous loan + borrowed capital-loan amortization = 2434869+2000000-400000 BALANCE SHEET WITH LOAN CHARGES AMOUNT REVENUES MONTANT PURCHASE OF GOODS 092 CA HT 970 OPERATING COSTS 226 FINANCIAL PRODUCTS 26 120 PERSONNEL COSTS 398 TAXES AND DUTIES", " 390 903 DEPRECIATION 865 718 OPERATING RESULT 633 FINANCIAL CHARGES* 234 580 FINANCIAL RESULT - 208 460 CURRENT PROFIT BEFORE TAXES 173 TAXES ON PROFIT 487 248 NET RESULT 1 252 925 *financial charges = previous financial charges + interest on the new loan = 178580+56000 = 234580 Current result before tax = operating result + financial result = 1948633-208460 Net result = current result before tax - tax = 1740173-(1740173*20%) =1252925 BALANCE WITH A CREDIT LOAN OF 275000 EUROS FOR THE INNOVATION INVESTMENT RENTAL FUNCTIONAL CONSOLIDATED BALANCE SHEET ASSETS AMOUNT LIABILITIES MONTANT FIXED ASSETS CAPITAL 340 000 INTANGIBLE ASSETS" 250 RESERVE 16 982 TANGIBLE ASSETS 106 NEW REPORT 246 654 FINANCIAL ASSETS 19 514 NET RESULT 245 LOAN YEAR 869 LOAN YEAR 493 CURRENT ASSET CURRENT LIABILITY" STOCKS" 769 317 ACCOUNTS PAYABLE 288 ACCOUNTS RECEIVABLE 023 TAXES AND SOCIAL CONTRIBUTIONS" 190 843 OTHER BUSINESS DEBTS 901 368 ASSETS* 26 573 ADVANCED FIXED CHARGES 136 959 TOTAL"" 742 TOTAL 742 *26573 = availability before credit-loan-rent = 301573 - 275000 BALANCE SHEET WITH RENT CHARGES AMOUNT REVENUES MONTANT PURCHASE OF GOODS 092 CA HT 970 OPERATING COSTS* 226 FINANCIAL PRODUCTS 26 120 PERSONNEL COSTS 398 TAXES AND DUTIES", " 390 903 DEPRECIATION 865 718 OPERATING RESULT 633 FINANCIAL CHARGES 178 580 FINANCIAL RESULT - 152 460 CURRENT PROFIT BEFORE TAXES 173 TAXES ON PROFIT 425 928 NET RESULT 245 *operating expenses = operating expenses before leasing + leasing rent = 9845226+275000 - For leasing, note that the loan + 1 year and - 1 year has not changed. [...]