Complete the excel sheet, before looking at the videos SHORT VIDEOS about 5-8 minutes long. there are problems with the excel sheet. Fix them first then start. Should not take very long. The problems are.

Equipment, fixtures, and other is 85.1 in March and moves to 92 in April.

Accumulated depreciation starts at 29.44 in march and increases thereafter. THANK YOU

Schedule 1: Sales Forecast Credit sales Cash sales Note: credit sales collected in 1 mo Schedule 2: Cash Collections Cash sales this month Credit sales last month Total collections Sales schedule March 92.000 40% 36.800 60% 55.200 55.200 Purchases schedule Schedule 3: Purchases March Ending inventory See note #3. 110.400 COGS See note #2. 64.400 Total needed 174.800 Beginning inventory See note #1 97.520 Purchases (total needed - beg inv) 77.280 COGS % of sales 70% #1: Begin the month with cushion 46 #2: COGS is 70% of sales. Beg. Inv. % of COGS 80% #3: End the month with en Note #4: March ending inventory matches the inventory on the initial balance sheet. Note #5: need August COGS forecast in order to calculate July ending inventory. Note #6: inventory policy is beginning inventory = 80% of COGS + cushion. Schedule 4: Purchase disbursements 50% of last month's purchases 50% of this month's purchases Purchase disbursements 50% 50% Schedule 5: Wages and commissions Wages, fixed commissions, 15% of sales Total wages and commissions Wages and commissions schedu March 5.75 5.750 15% 13.800 19.550 Schedule 6: disbursements -- wages and commissions 50% of last month's wages and commissions 50% 50% of this month's wages and commissions 50% Total disbursements -- wages and commissions Cash Budget Minimum cash balance Beginning cash balance Cash receipts: collections from customers Total cash available for needs before financing Cash disbursements: merchandise wages and commissions miscellaneous expenses, % of sales rent Truck purchase Total disbursements Minimum cash balance desired Total cash needed Excess of total cash Financing new borrowing interest repayments (PRINCIPAL REPAYMENTS) loan balance interest rate, % Total effects of financing 23.000 5% 4.600 6.900 1.50% Cash balance Note: The financing entries for April are different from the rest of the months in the fo Note A: Current month excess cash - interest payment > 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. Sales COGS Gross margin Operating expenses Wages and commissions Rent Miscellaneous expenses Insurance Depreciation Total operating expenses Income from operations Interest expense Net income PDC COMPANY PROJECTED INCOME STA March 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 (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 PDC COMPANY PROJECTED BALANCE March 4.14 85.1 29.44 23.000 36.800 110.400 3.680 173.880 92.000 30.590 61.410 235.290 38.640 9.775 0.000 48.415 186.875 235.290 ales schedule April May June July 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 hases schedule April May 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. nitial balance sheet. ding inventory. cushion. 38.640 59.570 98.210 59.570 51.520 111.090 51.520 41.860 93.380 41.860 33.810 75.670 commissions 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 Cash 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 30.935 -3.335 -21.620 23.000 23.000 23.000 the months in the forecast -- May, June, and July. ll interest and at least some of the principal. 0.000 if Excess of total cash 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#