financial management

CCL Quad Your Co Yr1 Yr2 Yr3 Yr4 Yr5 Total

INC STMT rev growth calc 13.30% 7.69% 10.49% Rev 2,000$ 2,210 $ 2,442 $ 2,698 $ 2,981 $ 12,331 $ COGS ratio -72.00% -79.41% -75.70% COGS (1,514) $ (1,673) $ (1,849) $ (2,043) $ (2,257) $ (9,335) $ gross profit ratio 28.00% 20.59% 24.30% Gross Profit 486 $ 537 $ 593 $ 656 $ 724 $ 2,996$ SG&A ratio -13.50% -8.68% -11.09% SG&A (222) $ (245) $ (271) $ (299) $ (331) $ (1,368) $ oper profit ratio 14.50% 11.92% 13.21% Oper Profit 264 $ 292 $ 323 $ 356 $ 394 $ 1,629$ int expense ratio -2.50% -1.43% -1.97% Int Expense (39) $ (43) $ (48) $ (53) $ (59) $ (242) $ pretax income ratio 12.00% 10.48% 11.24% Pretax Income 225 $ 248 $ 275 $ 303 $ 335 $ 1,386$ tax ratio -4.00% -0.45% -2.23% Taxes (45) $ (49) $ (54) $ (60) $ (66) $ (274) $ NET INC net profit ratio 8.00% 10.03% 9.02% Net Income 180 $ 199 $ 220 $ 243 $ 269 $ 1,112$ Net Margins 9.0% 9.0% 9.0% 9.0% 9.0% 9.0% revenue/employee 240,000 $ 196,340 $ 218,170 $ Rev/Empl 9.2 10.1 11.2 12.4 13.7

DIVIDENDS Net Income 180 $ 199 $ 220 $ 243 $ 269 $ Dividend Payout Ratio 45% 50% 55% 60% 65% Dividends (81) $ (100) $ (121) $ (146) $ (175) $ (623) $ Retained Earnings 99 $ 100 $ 99 $ 97 $ 94 $ Cum Retained Earnings 99 $ 199 $ 298 $ 395 $ 489 $

ASSETS cash (sales) days 30.00 40.00 35.00 Cash 111 $ 112 $ 113 $ 113 $ 111 $ avg collection period 122.00 59.05 90.52 Accts Rec 496 $ 548 $ 606 $ 669 $ 739 $ avg age inventory 83.00 26.86 54.93 Inventory 228 $ 252 $ 278 $ 307 $ 340 $ revenues / PP&E 1.50 2.49 2.00 PP&E 1,001 $ 1,106 $ 1,223 $ 1,351 $ 1,493 $ other assets (plug) 608 $ 682 $ 765 $ 857 $ 961 $ TOT ASSETS Total Assets 2,444$ 2,701$ 2,984$ 3,297$ 3,643$

tot asset turnover 0.490 1.147 0.818 Est. Assets 2,444 $ 2,701 $ 2,984 $ 3,297 $ 3,643 $ other assets (plug) Other-Plug 608 $ 682 $ 765 $ 857 $ 961 $

LIABS accts payable days 212.00 71.77 141.89 Accts Pay 589 $ 650 $ 719 $ 794 $ 877 $ Current LTD 205 $ 218 $ 234 $ 253 $ 276 $ Long Term Debt 1,307 $ 1,389 $ 1,489 $ 1,611 $ 1,756 $ capital ratio 10.0% 18.0% 10.0% Capital 244 $ 244 $ 244 $ 244 $ 244 $ Retained Earnings 99 $ 199 $ 298 $ 395 $ 489 $ TOT LIABS+EQ Tot Liabs+Eq 2,444$ 2,701$ 2,984$ 3,297$ 3,643$

total assets 2,444 $ 2,701 $ 2,984 $ 3,297 $ 3,643 $ less: capital, A/P, R/E (932) $ (1,094) $ (1,261) $ (1,434) $ (1,611) $ total loans needed 1,512 $ 1,607 $ 1,723 $ 1,864 $ 2,032 $ net LTD 1,307 $ 1,389 $ 1,489 $ 1,611 $ 1,756 $

LOAN PAYMENT LTD 1,512 $ 1,607 $ 1,723 $ 1,864 $ 2,032 $ interest rate (set interest rate @ 6%) 6.0% 6.0% 6.0% 6.0% 6.0% term (yrs) 10.0 10.0 10.0 10.0 10.0 payment 205 $ 218 $ 234 $ 253 $ 276 $

TARGET RETURN Net Income 180 $ 199 $ 220 $ 243 $ 269 $ Required Rate of Return 25.0% 0.80 0.64 0.51 0.41 0.33 NPVs 144 $ 128 $ 113 $ 100 $ 88 $ 572 $ Capital Investment 244 $ 244 $ Equity Stake 43%

IRR (PROOF) IRR 77.3% (244) $ 180 $ 199 $ 220 $ 243 $ 269 $ IRR Calc on Div Payments 35.5% (244) $ Div Pmts 81 $ 100 $ 121 $ 146 $ 175 $

5 Year Financial Projections (only post PDF docs)

NEW 7830 May.June 2017 -- REVISED EX for 5 YR PROJ 06/01/17