Follow the 5 minute video to complete the projections of the cash flow statement.

### ftypisom####isomiso2avc1mp41####free##7mdat#### ####gM@#P###############h ######EH, #x264 - core 148 r2721 72d53ab - H.264/MPEG-4 AVC codec - Copyleft 2003-2016 http://www.videolan.org/x264.html - options: cabac=1 ref=1 deblock=1:0:0 analyse=0x1:0x111 me=hex subme=5 psy=1 psy_rd=1.00:0.00 mixed_ref=0 me_range=16 chroma_me=1 trellis=1 8x8dct=0 cqm=0 deadzone=21,11 fast_pskip=1 chroma_qp_offset=0 threads=4 lookahead_threads=1 sliced_threads=0 nr=0 decimate=1 interlaced=0 bluray_compat=0 stitchable=1 constrained_intra=0 bframes=3 b_pyramid=2 b_adapt=1 b_bias=0 direct=1 weightb=1 open_gop=0 weightp=2 keyint=30 keyint_min=16 scenecut=40 intra_refresh=0 rc_lookahead=30 rc=abr mbtree=1 bitrate=209 ratetol=1.0 qcomp=0.60 qpmin=10 qpmax=50 qpstep=4 vbv_maxrate=1500 vbv_bufsize=1200 nal_hrd=none filler=0 ip_ratio=1.41 aq=1:1.00###Be#WD D!o"X$813#WEV_>Xkr##$ 3 R# +#he5^9z:q#sw#9 # #,z}\\##`.U0Wx#&6l2{#D>##Qu#9##6&Vb]`# # # %'# 3lS# #n.8`VAqUj,#EVU)Rj3q#pE]cI#q#6V#~ !N;### 8_Bk?#T#eTN:lFcbvy###MR*5 ~c#$t"J#;01U4mFy#i:;#g###A#c 8 #DO2FP#.x?# Sk~#u#ReI#8#algvG$eg\\#E#$ #W o)"Z##7#:-P#%#8B## c8}Bgk1]0#g E}abG#SB##:!#B:?& C1VxlX##7H##wlJ95#_O#N#n#vn#;3Dkiv#Lr#hduc#># F## U_8a=1tBM3Ed.C#c !##r#NGp##z*3#T5-^N##:i#x#R28 n\\:R W Te-G\\$rm,HyI o#*#n9m #QIG6 #dGp\\k\\ # ##/Y#O E4_ 15S=#f- "@O(o[8#B #u#4#'*# J#9RgEO>H}'s #\\eI#8 #.%`#YCW_4#mTbM{D#|### K#|#, ##D#"I:BU H 0 B Ep#-eQm#*M]sD2-'aD_xQPQt###+t44| R3#D##\\Ej._#gN#CnYcQg#|N#}>xz}#(#*##@jj oC3hVw[K:C~s}#e#'# ^KX QJ\\N'?3FTy}`TSGv8'ctUBj1:.u#FL#8v5{(IW im!# m6~ [d/#&N#u#d[@U#ekJBi? #KkuI#I'# EN8t":c #:U#nT0#2###Z7##sJ#I#YV#ei1N8#,5*n1#ST8r.6KX+#g>A\\~AKd %###?#R#'*w #8e4^Lu# w`~#az&>"!a#y#d"#mfzObxg=I]E|*#/#[>$s# Z %0-l#{#7$#Y*2M#EStfsK~IXs##Lc# $ ##X# %'yb]i .W#/o/.v|# ##__##i+$#1#Nu#[#dhY0x###9|+}RJsr##8h## "$,6#WAG,##@#B`+#w Is K\\C#2=# B"g #t#6co3>(ZsB###A#=#,#q##_r? Hu;##Y/y#B#L###7BcEY:### #dEe{#(s# ]c9P#s~W1|Vu_##)%#?0TUM_SQ@#]O,hW mfJW}3hIuMTx##vZ.#fo:##n #r#z/x#####|#r##q!##L#u`g%v*qW*&1ND#6!jv `# >5o[#=e7 B#J&vgl>3l!H#]jQgvWtFJ? G #G G # #CrB#w0 P64`##bZ##RtDb*#?&b| #pGI 7\\\\%C\\FM4B_I#fiDr4t#i2!:]>##Z?@Q w:y66]# >rTAx** psBD|IzI o:#0?# # 9##^t*I##?0i?C)`}Pb#F R24 w\\iLHD6#ou*>o~]w#D##k{hdE##^ALy;#B#g#}!zj 9 ##$qiY#fBwKZ$!#### KaZ4nMRuS{-N| #85## ~,MIP#3^U@o/Hxm u19###*g}#|#Pqpo#@###)8 #XYXL#(:(F#b#UrW35F#@3'#,1p#! #k#w5Yc%.HqFt;#Th0 o#``SP###gm# %*g4#jeB#wj#D0# {pX t#[ #QD{JTgj^# k!_#l.h3#%#1p_":C)R,$;Wh#b7#>#D y;#DapbS8#Hm9d1kB# #R# A_G:Gv8\\##z#8&A#Ft###;m B*j6J,MSE 71#AVJ,Hf#@d p=A## #(:YCbT##_(-q}p.P(#`3(?M M8#bm #v~m H#vFq#A#J#/#]1G#i# =###~/U^y]Z9sc.#CN #t|#cI#q@ ^]#alCL#Oo##M,p##4./#m!%} x+80d^#OC5#x=u$d #G#>#Ci# o0sL0aM*|-##K#O5w}`bsw,t ?#zg#"poPx##V54,#.)##Rt#=}(N0#7. F"^#{XK&0B0+#2 X)5#y]$`#e.#eiJ##&iM( tWt?'r.#"4ykamJ# `\\j#~ U][#(ue3ML#etbG#z#K#o6ijUR?-Jz##K O=#zbc##3N2#9|#Nc#^##Z`#B##C`: #}^##M-njjW 0#!b##k#TM#^|##fj ###MV;#\\=#f?6U"LF #'c##f###a2hdTn X#F &C#1H*Y#311T-_? $.L-#w#Z#25##*{?##C/wiGU|\\zwwL~I)k+T#w@q#####PrB#g{###CF'+5*g0#(eL~o4B##zg#F#@~nt #4@u#)##k#(yVKf#hZA,h/## .#!^(~d5#'+#} [1s$#CwZ|s # >qb#35##Nh{#kO;i#H#`55#PlTV]f###0M KYh#}###zJ##WAO##d.#tW]nw:c wJ[####~R## ##ByY##9#qCC##p_ ##v(>E>1l#w"#u.#@z#[#K5p]~#IOk#@JI&k @#E8R###pt#%#~0fQ#_#$?BT*M#y#c ?KP =:PUfR] da_#N#S#I%#k=PUv_RE,A#&R'!;)v #. #?Sk# +}#d!\\\\l##!,##-_L{bUk}>`v0#P#WkbcY %"H#E###4#}#7 >##7t #cBw >#O19#>#r#~Y\\-m#obVTzAm##af# ~#,# (#*`\\'6>#*M+1a#X)rhk##`#7L8 e9`j/#K]w##S;Wvo" qATl#B7'iwjJBb_sbyJsY#",n #(Y##*Vx?2-8Jss#lS#K9{)# _#y\\ #f[t@K#{L}!dzOM##h .#[#OZ 291D}/6Ra:{#C1@v R#i##\\]N#>i#k# # g/#@ThGqLY#`Xo{){+^5 #@ t@-`8;##O?to#*n@(r#~})#" -##?@###wLvXDDQB[#'j#S##\\bd)%C#]%#ku#l9KQHc#BV!mP#| #J2/VC"2u9vNI#d! ###R/a#9fzy!)#P#w##e## # Y!r0//%#g]E#CA>| wwgu9km(CfRO J X$#Ng*%9##'##L.#{l#?yheN=#Tmy##o+KA]_#31=ey;MU##/L#Ht##r ;\Q : _Y#:J : ?## m##mN `/v}\\~Y%U?7ep![rD#W- y1{VC#c#*n#\\##K]d0-XA3j? B##"ED5xai^#o#e#D9G%}3>5m#E#+C#1[61s#b#OS #E C#,#DF# 5et# `N:S^~#r8~Xg)#FtW ; 9###\\#T#5#+o:#mN#jJmz#7"r{ )D}#~p$#:# s#u}9#W#y`|b/F#vnz ]#& ####r7(#p##vf;:#BVcG#6^]M#b| ####efUfnL{x##ri`#/#yK8m#;8'#U#/#;oKVC## #3#GG#O U #F#Nb#B~#k#L+:i### #6#(X# nN: % #JbqJ":+Z2WO###*#/) ##% %Cd c#BQT#Z #\\w r^Y#L4#U_u':=#N3_#GO T#|n{h[r#.# =t_w##O5#jc.@#b#4T=1V#"YxZ#n #S|K.WF6#k#$LOi'wc#[ y##0#w 1~#^"^#@\\I#L4%'#]f#7'|Kh#\\;>#dFI{#! z#\\J#_L Z >#W##8#RTZ rZ 0i jr[`7C}8f#Q"##g;|!Br>#%####,w ^\\#P #.P# t+C#d['q}aLE#:^#O#Z)T#V4* #_e,*"CjEF(P# zW# ] 4 eb#iuG+z#G#ZNr#0##$#i:#NWP8a#>qx##J+b#HR9| dz;t##v#%l#Q!j$d] c# Aq+##a#k#7$YgQdN# . "#@d#!". ##. v>E##4N}U#i_D!#eA!1;Rx#Y9x###)>AZMypsLnVZ#u&9>\\#f!=u"l# # 3# # ^X#/U.{n##% g#8 k5|\\XEruc?,ZGO9##cA#I0%### ##l# p}bc`6^^#,sq[ExI#JL57 Dkrb##~z#r/'k##B#^s/0y $#ZrAB#l##?#yy ##E@###4AOwA8d9#vWe! |c#u [#> A6?g| t#d#)S(#oi#k$##F,it.a9aVCp`#gg#yj'M#qpr6J[+=:N $`1KV1lM b-#Q!8#P8i#8E#&m*#VuOut ##usrL _s#`\\kXEb %Z~::#F#eaGp#b#jBo>N ##?z\\h#jn7hu n#? d,sz##i@#@`#,7xR#'fcb2#i> #jL ^w!y# 6f##Yb#f#!%Y+AZ#01L}V# }M"A94h _!###B y#YX.B B #" sI ,2("#X#^#OxE##G_V|@X# kD`Si% jM\\vw/#}M#t#obH.@IK# PQj##}#l OF+F:@#MG5#YOUo=|G;#rWf"##q#K1u 8 83bz# }0r/K#w 9KpNX#0[_IPY:#Y##Sg #>c#OG/##+q#f,#pK_p2##?M7P#|m q pJ#:CF[9l 4 U;n#UG##[|#8}#DzQ4#{ILph9\\)I#0Ypq5%#R##\\M!O-[+ cU]{2_9y&ws#@}>%rj#9d^f!*#/;#2|o]t#1#Y; \\z2#7b.w>^3 |kJph^J9?mu^jK#g@#3 }#C_PT#W ~w# # pftL tvLC'#,# s FPS/wW7h#Ahd;CDQ#AHL#CQ##Bv##_Qq>hTw#. ?#WNL8# ###%&0#d#Ef{wq{##@#DqX? 8w##={/8S#6#WlJ=,Im#V#;ZEUn##5%#XE]#L l ?F)\\a##@# yGnw!sj#&W8yh/g###$WN#s#'9S@#:K 6a /tP"R)#4#wxE"~qns+? [i#wT42ksy=Z^L[YcI ,#C#w##`t('####0(v>v#$##Z#:X#UC##/dKN(| #EuNsl>57]^^#j?i}:#.##?y[I#1BzL##cc-Cj#1#{P? lf,#|#|C#K# j#? %## OBz9@yZ"N)#R#Fhtg0#]BOZ=9b|#_W l#>O:r tOW#cB`z2{k#5$Im]#?PT#`CtMXcz'#Cf58#| [=zR9@d#`O8{'5)(#)j``&V\\####}P#Z} j##Z)i#+dmz1#3H= 4Z#'G@hx#UZ vC#Z_L/^Q# :{#GMB)d*#H;=`{wW//p#R'?\\Q#Biz*t##`#x SLfG^f3-M: #m `=xsJ#GZ?G$ES##akC^z#s #dW:0}E>SOB~DX#MS9m m2#"{xox#,ynd^#J#LK#kzuwF###lFeR %uP#}@#a#0}#N#sYgu'w$q`#h&e3rA}|7 5\\e###yLi[i+PW#fF#cT#,.#DRj##H#F#P#k x_Fa#gY.^u[J#3y&JelTxC[FB. 8O#1_QOi#-7##=##5A#)#}#WW4#R^##iqa.#m#5# V+|f}K|5[-.Zqocr#;OJc]-u8'#- __EU*#L?#`m#W##J##\\#E7 #QBYl #o2##D]w#+#"o|V: HT*R#:x\\\\_v#;"dx;h#b###/A#w>j#)###3ZX`#s#hS> pW`c#jgrl3s##u xF #-a Q#| ##=#@%#j_&Rwz# V#{$ L 5 I&\\Byev#4H#PV#igk#c5#>#}JfAx#fz##w # }P ##B###wf#h()#IL#`#Hm]~]q##ia o#0#_mi $Ab12 K##rEKzQF5vHZ##M#CVltY5.t}[###[O#YG#^a| b$9 #\\Q P hovY##P P # [ 0#5LH%A#YgLv}D]##R'! uL###].{5>n f###\\U#n# q#K/#.5# ;3^i]7[#nd#c/hE8+zl##.MfCzv\\gDU#j %#^{U^h####&? t{_}x##s~#8##BV4hDh#9_####jzn`#h;Q#b.#=cj{n zp2##N0##A# ### #$#C0y#l ag##V#E5bHF)"Yu###V#t@'$ tOl'A$#?#jXtzv# "\\dJ6nxzE|"2#x!#B #cLT J#:\\6#q###e#S#Bf#[Mt#y.W#apr,'|E* %r3{*#@0Yt H# DP,x"!%#"/JD #J[UjRtFB)###_#[rP a#]0s4 N,b#A#1O###+LM&(I"y(k##(gR lK#a&(\\"8$#/Q9"w[#@#,/!#%DD# #kUH #^##nO#Bv#RaLb_Wl#OZkI HQZ#_?{##)#S6XUETW"#|#@RX#OX##?#*aOR#j#e %##?f}FeH.x"HG #G{"iWmE##V#:~N},#P:dp>J##{#oc ZS#~f/Qw#`}"?####o#Ga?d9 '##yc O1! )#0b(4t!jHn-# ###t c,#\\##2##:###2 %AF21mt@#P#X!#%HB("##-BP#C K###E&PH eCzB#=#^ %UoK?e#TR)ob}#buL#Flx.gSk{x'B$6A4c WBW}whGcc | uWA 7jz 7tz{#2n#Q##### ####ABB# ###!##Hb# BW irWUK###K5XI*&POe@&DAhA _%#) Z16#:ZfN#n#I@w#"Q/M1yK4Se#t#D#KNqfns.#qr## =.5#yN#G#XoiG5KJR%ht#(o#:E#J@;: /ZI 0x93y7k_u:#o"+^t? [LG#y9(#t#iRZ8@{##yA\\#7,q(UZ#a#F#JeW^##L`g#A#] 6vLP##>dCx54&j##p!# %D:###0##0'#\\I *y6vE qy%KrbV&? #8#:#[#Gg/KzASy##q1r-#oj##{#vjV+ ,~ 1#_##pJ,-&54G'{!r#6{,V##>@ j#hqX]#f;#0P6.v Ej_,V#E+y4n-N|s#g{'[q?##T~D3##A#] :#t#C]z~bu)i.M"pwj#{ *#q^j ';?j}|#h.? h25 J8#D(1F#fY+Ik#0S##?9u#JN,:$T$x#6#d)n`#72#4k#h. #n x1/7{ #/#tFw#mi# #NT?|0Y#)b^a ##~} C#>D#%0A?2tw#Qg$%mv!>[>z##>! ##,#@9,&J(##"(X,# n#%qW)###rU?#bnf~O nT2/ I<_>g0GI+/vv_h#z z {##e#Eu?#$z(#V.3F9J%8C0!5-FL:[#V#8#### #####cD########!# (#)#D#bmm#/8X##C5>BpCMYu###,&[F##w#U#iO##sX wo: `#*`Kj#7 t#m5_^##CCz5C[S#2#)s5r#M##) Y[U7FzV!0_{uy-VKc/ V)##Y8 V +@\\=#d\\#9SQ##j#. ###aR `#ba-muz$b#N2t#b# 6##%2p##!#=#! H##ii#]3 #'GFE?m### D?h}vR#\\{#QE u#eaT@" l+-YNu_Ez?uwa(?u}e| QA~##dhYvLc]#4Z]{Re- & FK,ksBwiZ?tw#m #i#d.\\~svp7U#&}GI"o #c#UY o##0=`N; %wRL21u %{=#bMu\\s t##p!#%!@55ZZ#3[ ##12P#,Q#L #T#l}'d(#cWHqlj##q.5m{w#47ovrm:w#!U~6# 0 pay all interest and at lea Current month excess cash - interest payment > previous month's loan balance pay a (Principal) repayment, if any, is the MIN of the excess of (excess cash - interest paymen (AND >= 0) Note B: The current month's loan balance = previous month's loan balance + new borr Note that here, any interest not paid is included in the new borrowing. PDC COMPANY PROJECTED INCO March Sales COGS Gross margin Operating expenses Wages and commissions Rent Miscellaneous expenses Insurance Depreciation Total operating expenses Income from operations Interest expense Net income 92.000 64.400 27.600 0.460 1.150 19.550 4.600 4.600 0.460 1.150 30.360 -2.760 0.000 -2.760 PDC COMPANY PROJECTED B (March is given on page 195, table 6.1) Current assets Cash Accounts receivable Merchandise inventory Prepaid insurance Total current assets Plant Equipment, fixtures, and other Accumulated depreciation Net plant, property, and equipment Total assets Current liabilities Accounts payable Accrued wages and commissions payable Loan Total current liabilities Owners' equity Total liabilities and equity March 4.14 85.1 29.44 23.000 36.800 110.400 3.680 173.880 85.100 29.440 55.660 229.540 38.640 9.775 0.000 48.415 181.125 229.540 PDC COMPANY PROJECTED Cas Net income Adjustments to net income for cash flow + Depreciation Expense (be careful with the sign) - Change in Accounts Receivable - change in Inventory - change in prepaid insurance (be careful with the sign) + change in accounts payable + change in accrued liabilities Total Adjustments Net Cash Flow from operations Cash Flows from investing Capital Expenditures (CAPEX) ch in eqpt. Fixtures. And other Net Cash used by investments Cash flow from financing. es schedule April May 115.000 46.000 69.000 184.000 73.600 110.400 138.000 55.200 82.800 August 115.000 92.000 46.000 69.000 69.000 36.800 105.800 110.400 46.000 156.400 82.800 73.600 156.400 69.000 55.200 124.200 ases schedule April June May July June July August 149.040 123.280 110.400 97.520 80.500 128.800 96.600 80.500 64.400 229.540 252.080 207.000 178.020 110.400 149.040 123.280 110.400 119.140 103.040 83.720 67.620 gin the month with enough inventory to cover 80% of COGS + 46.0 cushion. GS is 70% of sales. d the month with enough to cover the beginning of next month. al balance sheet. g inventory. 38.640 59.570 98.210 59.570 51.520 111.090 51.520 41.860 93.380 41.860 33.810 75.670 ommissions schedule April May June 5.750 5.750 17.250 27.600 23.000 33.350 9.775 11.500 21.275 11.500 16.675 28.175 July 5.750 20.700 26.450 5.750 17.250 23.000 16.675 13.225 29.900 13.225 11.500 24.725 sh Budget April May June July 23.000 23.000 23.000 23.000 105.800 128.800 156.400 179.400 156.400 179.400 124.200 147.200 98.210 21.275 5.750 4.600 6.900 136.735 23.000 159.735 -30.935 111.090 28.175 9.200 4.600 0.000 153.065 23.000 176.065 3.335 93.380 29.900 6.900 4.600 0.000 134.780 23.000 157.780 21.620 75.670 24.725 5.750 4.600 0.000 110.745 23.000 133.745 13.455 30.935 0.000 0.000 30.935 0.000 0.464 2.871 28.064 0.000 0.421 21.199 6.865 0.000 0.103 6.865 0.000 30.935 -3.335 -21.620 -6.968 23.000 23.000 23.000 months in the forecast -- May, June, and July. nterest and at least some of the principal. 29.487 Cash receipts - disbursement n balance pay all interest and all the principal. The loan is paid off. - interest payment) and the loan balance lance + new borrowings - (principal) repayments CTED INCOME STATEMENTS April May June July 115.000 80.500 34.500 184.000 128.800 55.200 138.000 96.600 41.400 115.000 80.500 34.500 23.000 4.600 5.750 0.460 1.150 34.960 -0.460 0.000 -0.460 33.350 4.600 9.200 0.460 1.150 48.760 6.440 0.464 5.976 26.450 4.600 6.900 0.460 1.150 39.560 1.840 0.421 1.419 23.000 4.600 5.750 0.460 1.150 34.960 -0.460 0.103 -0.563 ECTED BALANCE SHEETS April May June July 23.000 46.000 149.040 3.220 221.260 23.000 73.600 123.280 2.760 222.640 23.000 55.200 110.400 2.300 190.900 29.487 46.000 97.520 1.840 174.847 92.000 30.590 61.410 282.670 92.000 31.740 60.260 282.900 92.000 32.890 59.110 250.010 92.000 34.040 57.960 232.807 59.570 11.500 30.935 102.005 180.665 282.670 51.520 16.675 28.064 96.259 186.641 282.900 41.860 13.225 6.865 61.950 188.060 250.010 33.810 11.500 0.000 45.310 187.497 232.807 TED Cash Flow Statements April May June July get number from income sta add back positive depreciatio Add Columns 176 through 18 pts - disbursements + financing r from income statement ositive depreciation ns 176 through 181 Syed Taha