merger and acquisition

profileShinum
Financialanalysisexample-PattiesFoodsPFL.xlsx

Sheet1

Dates PFL - Revenues
06/07 126.18
06/08 164.087
06/09 178.975
06/10 197.081
06/11 217.026
06/12 235.847
06/13 244.782
06/14 247.648
06/15 256.843
Dates PFL - Revenue Growth
06/07
06/08 30.74
06/09 9.34
06/10 9.97
06/11 10.1
06/12 8.74
06/13 3.83
06/14 1.19
06/15 3.47
Dates PFL - Revenue Growth PFL - EBITDA Growth
06/07
06/08 30.74 6.23
06/09 9.34 -3.53
06/10 9.97 22.31
06/11 10.1 10.68
06/12 8.74 5.56
06/13 3.83 -42.72
06/14 1.19 52.98
06/15 3.47 -13.71
Dates PFL - ROA (%)
06/07 8.73
06/08 8.76
06/09 7.43
06/10 9.54
06/11 9.53
06/12 9.22
06/13 3.11
06/14 7.89
06/15 6.6
Dates PFL - ROE (%)
06/07 13.51
06/08 13.75
06/09 10.62
06/10 14.39
06/11 14.3
06/12 14.32
06/13 3.65
06/14 12.16
06/15 10.27
Dates PFL - ROE (%) PFL - ROA (%)
06/07 13.51 8.73
06/08 13.75 8.76
06/09 10.62 7.43
06/10 14.39 9.54
06/11 14.3 9.53
06/12 14.32 9.22
06/13 3.65 3.11
06/14 12.16 7.89
06/15 10.27 6.6
Dates Net Profit Margin (%) EBITDA Margin (%)
06/07 11.37 21.1
06/08 9.17 17.14
06/09 6.59 15.12
06/10 8.75 16.82
06/11 8.48 16.91
06/12 8.27 16.42
06/13 1.96 9.06
06/14 6.74 13.69
06/15 5.37 11.42
Dates PFL - ROE (%) PFL - ROA (%) Net Profit Margin (%) EBITDA Margin (%)
06/07 13.51 8.73 11.37 21.1
06/08 13.75 8.76 9.17 17.14
06/09 10.62 7.43 6.59 15.12
06/10 14.39 9.54 8.75 16.82
06/11 14.3 9.53 8.48 16.91
06/12 14.32 9.22 8.27 16.42
06/13 3.65 3.11 1.96 9.06
06/14 12.16 7.89 6.74 13.69
06/15 10.27 6.6 5.37 11.42

PFL - ROA (%) 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 8.73 8.76 7.43 9.5399999999999991 9.5299999999999994 9.2200000000000006 3.11 7.89 6.6

PFL - ROE (%) 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 13.51 13.75 10.62 14.39 14.3 14.32 3.65 12.16 10.27

PFL - Revenue Growth 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 30.74 9.34 9.9700000000000006 10.1 8.74 3.83 1.19 3.47

PFL - Revenues 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 126.18 164.08699999999999 178.97499999999999 197.08099999999999 217.02600000000001 235.84700000000001 244.78200000000001 247.648 256.84300000000002

PFL - Revenue and EBITDA growth

PFL - Revenue Growth 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 30.74 9.34 9.9700000000000006 10.1 8.74 3.83 1.19 3.47 PFL - EBITDA Growth 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 6.23 -3.53 22.31 10.68 5.56 -42.72 52.98 -13.71

PFL - Profitability Ratios

PFL - ROE (%) 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 13.51 13.75 10.62 14.39 14.3 14.32 3.65 12.16 10.27 PFL - ROA (%) 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 8.73 8.76 7.43 9.5399999999999991 9.5299999999999994 9.2200000000000006 3.11 7.89 6.6

PFL - Profit Margins

Net Profit Margin (%) 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 11.37 9.17 6.59 8.75 8.48 8.27 1.96 6.74 5.37 EBITDA Margin (%) 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 21.1 17.14 15.12 16.82 16.91 16.420000000000002 9.06 13.69 11.42

PFL - Profitability Ratios and Profit Margins

PFL - ROE (%) 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 13.51 13.75 10.62 14.39 14.3 14.32 3.65 12.16 10.27 PFL - ROA (%) 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 8.73 8.76 7.43 9.5399999999999991 9.5299999999999994 9.2200000000000006 3.11 7.89 6.6 Net Profit Margin (%) 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 11.37 9.17 6.59 8.75 8.48 8.27 1.96 6.74 5.37 EBITDA Margin (%) 06/07 06/08 06/09 06/10 06/11 06/12 06/13 06/14 06/15 21.1 17.14 15.12 16.82 16.91 16.420000000000002 9.06 13.69 11.42