Financial Assistant Tool Con Dati

Step 1

DATI AZIENDALI Società Commerciale (Y/N) Aliquota fiscale media Inserire Anni, Trimestri o Mesi (A, T, M)

Step 2

Y 30% A

Conto Economico ANNO 1

Fatturato & Costo Venduto Vendite Lorde

ANNO 2

ANNO 3

ANNO 4

ANNO 5

2010000

2560000

2721800

3285454

-50000

-60000

-70000

-80000

-90000

1960000

2500000

2651800

3205454

3551354

Costo Materie Prime

320000

427600

431238

432513

488132

Costo Lavoro

300000

315000

330450

346364

361589

Altri Costi diretti Totale Costo Venduto

125000 745000

128750 871350

132613 894301

136591 915467

140397 990118

1215000

1628650

1757500

2289987

2561236

1

2

3

4

5

Sconti/Resi Vendite Nette

Profitto Lordo

3641354

Costi

Step 3

Costi Fissi Management Advertising Trasporti Ammortamento Assicurazioni Spese Bancarie Servizi Professionali Servizi Legali Spese di vitto/alloggio Ufficio Manutenzione Fitti e Locazioni Energia Costi Fissi 1 Costi Fissi 2 Costi Fissi 3 Costi Fissi 4 Costi Fissi 5 Costi Fissi 6

190000 50000 30000 5000 3000 1000 3906 2133 1000 4000 6000 1000 3000 8750 1000 1000 1000 6230 11974 0 329993

Totale Costi Fissi Costi Variabili Collaborazioni Benefits Tasse Sales e Marketing Telefono/Telecomunicazioni

1

191000 51500 30900 5150 3090 1030 3754 2197 1330 4120 6180 1030 3090 9110 1030 1030 1030 6120 12374 0 335065 2

90000 43000 18000 14000 6000

195000 53045 31827 45305 3183 1061 4010 2263 1670 4244 6365 1061 3183 9544 1061 1061 1061 6010 14186 0 385138 3

102700 46875 18540 14420 6180

195000 54636 32782 50464 3278 1093 3994 2331 2020 4371 6556 1093 3278 9929 1093 1093 1093 5900 16974 0 396977 4

112368 47970 19096 14853 6365

197500 56159 33695 70616 3370 1123 4046 2396 2355 4493 6739 1123 3370 10326 1123 1123 1123 5790 18080 0 424549 5

118647 51249 19669 15298 6556

129831 53734 20217 15724 6739

Cancelleria Posta Spese varie Costi Variabili 1 Costi Variabili 2 Costi Variabili 3 Costi Variabili 4 Costi Variabili 5 Costi Variabili 6 Costi Variabili 7 Totale Costi Variabili

2110 100 5557 0 0 0 0 0 0 0 178767 1

Spese Operative Interessi Ammortamenti Accantonamenti Altro Totale Spese Reddito Operativo Altri Ricavi e Spese

2

3005 106 5895 0 0 0 0 0 0 0 209659 3

3493 109 6072 0 0 0 0 0 0 0 221095 4

3941 112 6241 0 0 0 0 0 0 0 236540 5

508760 16250 32500 1250 0 558760

532287 16738 33475 1288 0 583787

594797 17240 34479 1326 0 647842

618071 17757 35514 1366 0 672707

661089 18252 36503 1404 0 717248

656240

1044863

1109658

1617279

1843988

2

3

4

5

1 Plusvalenze/Minusvalenza Altro

2680 103 5724 0 0 0 0 0 0 0 197222

10000 20000 30000

10300 20600 30900

10609 21218 31827

10927 31855 42782

11232 32464 43695

686240

1075763

1141485

1660061

1887683

Tasse sul Reddito

205872

322729

342445

498018

566305

Reddito Netto

480368

753034

799039

1162043

1321378

Profitto Proprietà

670368

944034

994039

1357043

1518878

Subtotale

Reddito Lordo Imposte

Stato Patrimoniale ATTVO Attivo Corrente Cassa e liquidità Clienti Altri crediti Magazzino Altri attivi correnti Totale Attivo Corrente Attivo Fisso Terrerni Edifici Impianti e Attrezzature Subtotale Meno Fondi di Ammonrtamento Totale Attivo Fisso Capitali Intangibili

ANNO 1 451000 350000 1200 400000 10000 1212200

ANNO 2 464530 460500 3200 612000 10300 1550530

ANNO 3 478466 871315 3000 824360 10609 2187750

ANNO 4 492820 1382454 3400 937091 10927 2826692

ANNO 5 506553 1643112 4300 1149271 11232 3314467

1 1000000 1500000 800000 3300000 400000 2900000

2 1030000 1045000 824000 2899000 412000 2487000

3 1106090 1591350 948720 3646160 424360 3221800

4 1109273 1739091 874182 3722545 437091 3285454

5 1162318 1784766 948542 3895625 449271 3446354

1

2

3

4

5

Brevetti, marchi, ecc. Meno Fondi di Ammortamto Totale Capitali Intangibili

50000 20000 30000

51500 20600 30900

53045 21218 31827

54636 21855 32782

56159 22464 33695

Altro Attivo Totale Attivo

25000 4167200

25750 4094180

26523 5467899

27318 6172246

25000 6819517

ANNO 1 600000 100000 100000 30000 90000 16000 936000

ANNO 2 618000 103000 103000 30900 92700 16480 964080

ANNO 3 636540 106090 106090 31827 95481 16974 993002

ANNO 4 640563 109273 109273 32782 98345 17484 1007719

ANNO 5 658833 112318 112318 33695 101086 17971 1036220

Capitale Netto e Passivo Passivo Corrente Fornitori Banche Altri debiti Imposte e Tasse Altro passivo corrente 1 Altro passivo corrente 2 Totale Passivo Corrente Passivo Consolidato

1 Mutui e prestiti Obbligazioni emesse Fondi di indennita fine rapporto Altre Passività Consolidate

2

3

4

5

601200 100000 30000 50000

624200 103000 30900 51500

645630 106090 31827 53045

668308 109273 32782 54636

690523 112318 33695 56159

1717200

1773680

1829594

1872718

1928916

1

2

3

4

5

Totale Netto

100000 100000 950000 1400000 2450000

100000 100000 678500 1542000 2320500

100000 100000 1853045 1685260 3638305

100000 100000 2469710 1729818 4299528

100000 100000 2918154 1872447 4890601

Totale Passività e Netto

4167200

4094180

5467899

6172246

6819517

Totale Passività Capitale Netto Capitale Sociale Riserva legale Riserve statutarie Altre Riserve

Controllo Quadratura (=0)

0

0

0

0

0

BE Chart 1

ANNO 6 4040170 -100000 3940170 522250 377043 144261 1043553 2896617

6 199400 57704 34623 88270 3462 1154 4098 2462 2695 4616 6925 1154 3462 10723 1154 1154 1154 5680 19761 0 449651 6 139392 56318 20774 16157 6925

Sales

Fixed

F+V

Total Cost

BE Chart 2

Sales

Fixed

F+V

Total Cost

Sales $

$1,960,000

0

#REF!

$329,993

$0

$329,993

Sales $

$2,500,000

0

#REF!

$335,065

$0

$335,065

Fixed $

$329,993

1

$163,333

$329,993

#REF!

#REF!

Fixed $

$335,065

1

$208,333

$335,065

#REF!

#REF!

Total Variable $

$745,000

2

$326,667

$329,993

#REF!

#REF!

Total Variable $ $871,350

2

$416,667

$335,065

#REF!

#REF!

12

$1,960,000

$329,993

#REF!

#REF!

12

$2,500,000

$335,065

#REF!

#REF!

4388 115 6413 0 0 0 0 0 0 0 250482 6 700134 18754 37508 1443 0 757838 2138779 6 11541 36082 47623

2186402 655921 1530481 1729881

ANNO 6 520492 1993930 4940 1331634 11541 3862537 6 1202709 1911128 983268 4097104 461634 3635470 6 57704 23082 34623 25750 7558380

ANNO 6 672856 115409 115409 34623 103868 18465 1060628 6 712799 115409 34623 57704 1981162 6 100000 100000 3494600 1982617 5577217 7558380

###

0

BE Chart 3

Sales

Fixed

F+V

Total Cost

BE Chart 4

Sales

Fixed

F+V

Total Cost

BE Chart 5

Sales

Sales $

$2,651,800

0

#REF!

$385,138

$0

$385,138

Sales $

$3,205,454

0

#REF!

$396,977

$0

$396,977

Sales $

$3,551,354

0

#REF!

Fixed $

$385,138

1

$220,983

$385,138

#REF!

#REF!

Fixed $

$396,977

1

$267,121

$396,977

#REF!

#REF!

Fixed $

$424,549

1

$295,946

2

$441,967

$385,138

#REF!

#REF!

Total Variable $ $915,467

2

$534,242

$396,977

#REF!

#REF!

Total Variable $ $990,118

12

$2,651,800

$385,138

#REF!

#REF!

12

$3,205,454

$396,977

#REF!

#REF!

Total Variable $ $894,301

2

$591,892

12

$3,551,354

Fixed

F+V

Total Cost

BE Chart 6

Sales

Fixed

F+V

Total Cost

BE Chart 7

Sales

Fixed

F+V

Total Cost

BE Chart 8

$424,549

$0

$424,549

Sales $

$3,940,170

0

#REF!

$449,651

$0

$449,651

Sales $

$4,328,986

0

#REF!

$474,754

$0

$474,754

Sales $

$424,549

#REF!

#REF!

Fixed $

$449,651

1

$328,348

$449,651

#REF!

#REF!

Fixed $

$474,754

1

$360,749

$474,754

#REF!

#REF!

Fixed $

$424,549

#REF!

#REF!

Total Variable $ $1,043,553

2

$656,695

$449,651

#REF!

#REF!

Total Variable $ $1,096,988

2

$721,498

$474,754

#REF!

#REF!

Total Variable $

$424,549

#REF!

#REF!

12

$3,940,170

$449,651

#REF!

#REF!

12

$4,328,986

$474,754

#REF!

#REF!

BE Chart 8

Sales

Fixed

F+V

Total Cost

BE Chart 9

Sales

Fixed

F+V

Total Cost

BE Chart 10

Sales

Fixed

F+V

$4,717,803

0

#REF!

$499,856

$0

$499,856

Sales $

$5,106,619

0

#REF!

$524,959

$0

$524,959

Sales $

$5,495,435

0

#REF!

$550,061

$0

$499,856

1

$393,150

$499,856

#REF!

#REF!

Fixed $

$524,959

1

$425,552

$524,959

#REF!

#REF!

Fixed $

$550,061

1

$457,953

$550,061

#REF!

2

$786,300

$499,856

#REF!

#REF!

Total Variable $$1,203,859

2

$851,103

$524,959

#REF!

#REF!

Total Variable $ $1,257,294

2

$915,906

$550,061

#REF!

12

$4,717,803

$499,856

#REF!

#REF!

12

$5,106,619

$524,959

#REF!

#REF!

12

$5,495,435

$550,061

#REF!

$1,150,423

Total Cost

BE Chart 11

Sales

Fixed

F+V

Total Cost

BE Chart 12

Sales

Fixed

F+V

Total Cost

$550,061

Sales $

$5,884,251

0

#REF!

$575,163

$0

$575,163

Sales $

$6,273,067

0

#REF!

$600,266

$0

$600,266

#REF!

Fixed $

$575,163

1

$490,354

$575,163

#REF!

#REF!

Fixed $

$600,266

1

$522,756

$600,266

#REF!

#REF!

#REF!

Total Variable $ $1,310,729

2

$980,709

$575,163

#REF!

#REF!

Total Variable $ $1,364,164

2

$1,045,511

$600,266

#REF!

#REF!

12

$5,884,251

$575,163

#REF!

#REF!

12

$6,273,067

$600,266

#REF!

#REF!

#REF!

Cruscotti Manageriali Istantanei Profitto Lordo e Totale Costo Venduto 1,200,000

3,000,000

1,000,000

2,500,000

800,000

2,000,000

600,000

1,500,000

400,000

1,000,000

200,000

500,000

0

0 1

2

3

Totale Costo Venduto

Dati Vendite Lorde Sconti/Resi Vendite Nette Costo Materie Prime Costo Lavoro Altri Costi diretti Totale Costo Venduto

1 2,010,000 (50,000) 1,960,000 320,000 300,000 125,000 745,000

4

5

6

Profitto Lordo

2 2,560,000 (60,000) 2,500,000 427,600 315,000 128,750 871,350

3 2,721,800 (70,000) 2,651,800 431,238 330,450 132,613 894,301

4 3,285,454 (80,000) 3,205,454 432,513 346,364 136,591 915,467

5 3,641,354 (90,000) 3,551,354 488,132 361,589 140,397 990,118

6 4,040,170 (100,000) 3,940,170 522,250 377,043 144,261 1,043,553

Profitto Lordo Management Advertising Trasporti Ammortamento Assicurazioni Spese Bancarie Servizi Professionali Servizi Legali Spese di vitto/alloggio Ufficio Manutenzione Fitti e Locazioni Energia Energia Costi Fissi 1 Costi Fissi 2 Costi Fissi 3 Costi Fissi 4 Costi Fissi 5 Costi Fissi 6 Altri costi Altri costi Altri costi Totale Costi Fissi Collaborazioni Benefits Tasse Sales e Marketing Telefono/Telecomunicazioni Cancelleria Posta Spese varie Costi Variabili 1 Costi Variabili 2 Costi Variabili 3 Costi Variabili 4 Costi Variabili 5

1,215,000 190,000 50,000 30,000 5,000 3,000 1,000 3,906 2,133 1,000 4,000 6,000 1,000 3,000 8,750 1,000 1,000 1,000 6,230 11,974 0 0 0 0 329,993 90,000 43,000 18,000 14,000 6,000 2,110 100 5,557 0 0 0 0 0

1,628,650 191,000 51,500 30,900 5,150 3,090 1,030 3,754 2,197 1,330 4,120 6,180 1,030 3,090 9,110 1,030 1,030 1,030 6,120 12,374 0 0 0 0 335,065 102,700 46,875 18,540 14,420 6,180 2,680 103 5,724 0 0 0 0 0

1,757,500 195,000 53,045 31,827 45,305 3,183 1,061 4,010 2,263 1,670 4,244 6,365 1,061 3,183 9,544 1,061 1,061 1,061 6,010 14,186 0 0 0 0 385,138 112,368 47,970 19,096 14,853 6,365 3,005 106 5,895 0 0 0 0 0

2,289,987 195,000 54,636 32,782 50,464 3,278 1,093 3,994 2,331 2,020 4,371 6,556 1,093 3,278 9,929 1,093 1,093 1,093 5,900 16,974 0 0 0 0 396,977 118,647 51,249 19,669 15,298 6,556 3,493 109 6,072 0 0 0 0 0

2,561,236 197,500 56,159 33,695 70,616 3,370 1,123 4,046 2,396 2,355 4,493 6,739 1,123 3,370 10,326 1,123 1,123 1,123 5,790 18,080 0 0 0 0 424,549 129,831 53,734 20,217 15,724 6,739 3,941 112 6,241 0 0 0 0 0

2,896,617 199,400 57,704 34,623 88,270 3,462 1,154 4,098 2,462 2,695 4,616 6,925 1,154 3,462 10,723 1,154 1,154 1,154 5,680 19,761 0 0 0 0 449,651 139,392 56,318 20,774 16,157 6,925 4,388 115 6,413 0 0 0 0 0

Costi Variabili 6 Costi Variabili 7 Totale Costi Variabili Spese Operative Interessi Ammortamenti Accantonamenti Altro Totale Spese Reddito Operativo Plusvalenze/Minusvalenza Altro Subtotale Reddito Lordo Imposte Tasse sul Reddito Reddito Netto Cassa e liquidità Clienti Altri crediti Magazzino Altri attivi correnti Totale Attivo Corrente Terrerni Edifici Impianti e Attrezzature Subtotale Meno Fondi di Ammonrtamento Totale Attivo Fisso Brevetti, marchi, ecc. Meno Fondi di Ammortamto Totale Capitali Intangibili Altro Attivo Totale Attivo Fornitori Banche Altri debiti Imposte e Tasse Altro passivo corrente 1

0 0 178,767 508,760 16,250 32,500 1,250 0 558,760 656,240 10,000 20,000 30,000 686,240 205,872 480,368 451,000 350,000 1,200 400,000 10,000 1,212,200 1,000,000 1,500,000 800,000 3,300,000 400,000 2,900,000 50,000 20,000 30,000 25,000 4,167,200 600,000 100,000 100,000 30,000 90,000

0 0 197,222 532,287 16,738 33,475 1,288 0 583,787 1,044,863 10,300 20,600 30,900 1,075,763 322,729 753,034 464,530 460,500 3,200 612,000 10,300 1,550,530 1,030,000 1,045,000 824,000 2,899,000 412,000 2,487,000 51,500 20,600 30,900 25,750 4,094,180 618,000 103,000 103,000 30,900 92,700

0 0 209,659 594,797 17,240 34,479 1,326 0 647,842 1,109,658 10,609 21,218 31,827 1,141,485 342,445 799,039 478,466 871,315 3,000 824,360 10,609 2,187,750 1,106,090 1,591,350 948,720 3,646,160 424,360 3,221,800 53,045 21,218 31,827 26,523 5,467,899 636,540 106,090 106,090 31,827 95,481

0 0 221,095 618,071 17,757 35,514 1,366 0 672,707 1,617,279 10,927 31,855 42,782 1,660,061 498,018 1,162,043 492,820 1,382,454 3,400 937,091 10,927 2,826,692 1,109,273 1,739,091 874,182 3,722,545 437,091 3,285,454 54,636 21,855 32,782 27,318 6,172,246 640,563 109,273 109,273 32,782 98,345

0 0 236,540 661,089 18,252 36,503 1,404 0 717,248 1,843,988 11,232 32,464 43,695 1,887,683 566,305 1,321,378 506,553 1,643,112 4,300 1,149,271 11,232 3,314,467 1,162,318 1,784,766 948,542 3,895,625 449,271 3,446,354 56,159 22,464 33,695 25,000 6,819,517 658,833 112,318 112,318 33,695 101,086

0 0 250,482 700,134 18,754 37,508 1,443 0 757,838 2,138,779 11,541 36,082 47,623 2,186,402 655,921 1,530,481 520,492 1,993,930 4,940 1,331,634 11,541 3,862,537 1,202,709 1,911,128 983,268 4,097,104 461,634 3,635,470 57,704 23,082 34,623 25,750 7,558,380 672,856 115,409 115,409 34,623 103,868

Altro passivo corrente 2 Totale Passivo Corrente Mutui e prestiti Obbligazioni emesse Fondi di indennita fine rapporto Altre Passività Consolidate Totale Passività Capitale Sociale Riserva legale Riserve statutarie Altre Riserve Totale Netto Totale Passività e Netto

16,000 936,000 601,200 100,000 30,000 50,000 1,717,200 100,000 100,000 950,000 1,400,000 2,450,000 4,167,200

16,480 964,080 624,200 103,000 30,900 51,500 1,773,680 100,000 100,000 678,500 1,542,000 2,320,500 4,094,180

16,974 993,002 645,630 106,090 31,827 53,045 1,829,594 100,000 100,000 1,853,045 1,685,260 3,638,305 5,467,899

17,484 1,007,719 668,308 109,273 32,782 54,636 1,872,718 100,000 100,000 2,469,710 1,729,818 4,299,528 6,172,246

17,971 1,036,220 690,523 112,318 33,695 56,159 1,928,916 100,000 100,000 2,918,154 1,872,447 4,890,601 6,819,517

18,465 1,060,628 712,799 115,409 34,623 57,704 1,981,162 100,000 100,000 3,494,600 1,982,617 5,577,217 7,558,380