0 //////// / / / /////IEGGT'%J J   AAc"d ABc"( ASSUMP1"@ A ASSUMP2"+3 ASSUMP3"5: BAD DEBT"?I BAL1EBT" BAL2EBT" BAL3EBT" CAPACITY"  CASH1TY"dp CASH2TY"y CASH3TY" CGM1TY" DEC1TY" DEC2TY"' EXH1TY"' EXPANDY"X Z FINFACT1"D E FINFACT2"Rb INC1CT2"(5 INC2CT2"=O INC3CT2"Qa OPFACT1"B C OPFACT2">N PG0CT2"> ? RESOURCE1dw RESOURCE2| RESOURCE3 RESOURCE4 RESULTS1F G RESULTS2' WSULTS2b \GULTS2)) G9TS2hh G:TS2ii G;TS2jj G<TS2kk G=TS2ll G>TS2mm G?TS2"" P3TS2' G9TS2 G?TS2 G9TS2hh G:TS2ii G;TS2jj G<TS2kk G=TS2ll G>TS2mm G?TS2"" G9TS2oo G:TS2pp G;TS2qq G<TS2rr G=TS2ss G>TS2tt G?TS2"" G9TS2 G:TS2 G;TS2 G<TS2 G?TS2 G9TS2 G:TS2 G;TS2 G<TS2 G=TS2 G?TS2"" G@TS2y y GATS2y y GBTS2y y GCTS2y y GDTS2y y G9TS2-- G:TS2// G?TS2"" G9TS2~~ G:TS2{{ G;TS2|| G<TS2}} G=TS2zz G?TS2"" G@TS2y y GATS2y y GBTS2y y GCTS2y y GDTS2y y RN0TS2!  A ? @VPBLBq+q+q+ Matl 1 Matl 2Labor Superv Maint/RepDepr  Product Manufacturing Costs  (Total)ASSETSq+q+q+ BALANCE SHEET  Asset SideCGM TOTALq+q+q+ Matl 1 Matl 2Labor Superv Maint/RepDepr  Product Manufacturing Costs  (Total)CGM UNITq+ +q+ Matl 1 Matl 2Labor Superv Maint/RepDepr  Product Manufacturing Costs  (Unit)LIABILITIESq+q+q+ CurrentBondsStock Ret Earn LIABILITIES AND EQUITY BALANCE SHEET Liability SidePCTMARGq+2+q+ Overhead Commission MaterialsLabor Margin  Product Percentage of Selling PriceTOTAL MARGINq+q+q+Cost Margin  Product Margins and Costs  (Total)UNIT MARGINq+ +q+ Overhead Commission MaterialsLabor Margin  Product Margins and Costs  (per unit) Arial Arial Arial! Arial" Arial# Arial$  |Arial% Arial&  Arial'  Arial(  Arial)  Arial+++$+'+(+)++&+&+ !"& #0+%+&&+'+(+)3+* ++ +, +- 0+"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefinedq0*P1* 3*#1*DD 3*#1* 3*#1*22 3*#1*|| 3*#1*FF 3*#(4*"########"""!"###h5*q0*1* 3*#(4*"########"""!"###h5*q0*P1* 3*#1*DD 3*#1* 3*#1*22 3*#1*|| 3*#1*FF 3*#(4*"########"""!"###h5*q0*P1* 3*#1*DD 3*#1* 3*#1*22 3*#1*|| 3*#1*FF 3*#(4*"########"""!"###h5*q0*1* 3*#1*DD 3*#1* 3*#1*22 3*#(4*"########"""!"###h5*q0*P1* 3*#1*DD 3*#1* 3*#1*22 3*#1*|| 3*#(4*"########"""!"###h5*q0*P1* 3*#1*DD 3*#(4*"########"""!"###h5*q0*P1* 3*#1*DD 3*#1* 3*#1*22 3*#1*|| 3*#(4*"########"""!"###h5*,@@@@@@@@@@@@@@/@@ @ @@ @@@@/@ @@@@@@"@@/@ @@@@@@"@@! @ @@@@@ @+ @ @@@@@@@ 6 @ @@@@@@@@@0@@6 @ @@@@@@@@@0@@*@ @@@@@@@@*@ @@@@@@@@ @ @ @@ @@@@@@@@@@&@@@@@@@ @@@@$@@@@%"@@@% @@@% @@@0@@@@@@1@3@@@@@@@@@(@@@@ @@@@`O`O`````` ` ` ` ` ``````````````  !@@@ " @@@@#@@@#$  @ @@@ % @@&@@'' @@@@@/(@@@@@@)+@ ,2@@@ -@@@@.@@ /"@@@0 @@ 1@@@@ 2@@@#3@@@4@@5@@6 @76879@@@;@@@@ @@&<@@@@@@=>?8 `!`"`#$`%`&'`()*+,`-./`0`12`3`4`5`6789`:;`<=>?"@@"A@@"B@"C@+D@@"E@@"F@@G @H @IHJ@K@@L?M@@@N @""@@@P<Q R @@S @T@@@@@UT$V@@@@@@)W@@@@@@X@@@&Y@@@ZY&[@@@@@@@@,\@@@@@@@,]@@@@@@@0^@@@@@@@@0_@@@@@@@ABCDE`FGHIJKLMN`OPQRSTUVWXYZ[`\`]`^`_`!`@@@&a@@ b@@c@dPehSi@j@@@k@@@@l@@@m@@@n@@!o@@"p@@@!q@@@@"r@@@s@@!t@@@u@ v@@w@0x@@@@@@@y @z@@@{z|{"}@@@"~@@@@@`a`bcdefghijklmnopqrstuvwxyz{|}~@@@@!@@@!@@@!@@!@@@ @@@@ @@@@@@R0@@@@@@@@@@@@ @@@(@@@@@@@@ @@ @ @@@@@@ @@@@ @@@ @@@@#@@@ @@d@@@@@v@@ @&@@@@@@=@@@@@@@@@```````@@@@@@@@+ @.@@` @@                ''PROFORMA.WK4"Quarter /@<<1STARTUP.WK4>>C:H2..C:H2'Exhibit I ' Building Depreciation@&' Pro Forma Financial Statements "Firm +@<<1STARTUP.WK4>>C:D1..C:D1'Product Info  "Prod X  "Prod Y  "Prod Z "Capacity "Plant "Office' Maintenance' Standard Hours/Unit- @<<1STARTUP.WK4>>E:C23..E:C23- @<<1STARTUP.WK4>>E:D23..E:D23- @<<1STARTUP.WK4>>E:E23..E:E23 N N`mP:21STARTUP must be open and this drive must be default!;' Actual Hours/Unit 72@M (\B@M g?R@M ]]p}' Navigate Using' Material I /Unit- @<<1STARTUP.WK4>>E:C25..E:C25- @<<1STARTUP.WK4>>E:D25..E:D25- ?<<1STARTUP.WK4>>E:E25..E:E25 eed#' Cols A - F' Cols H - L' PgUp, PgDn, Home,' Material II/Unit- @<<1STARTUP.WK4>>E:C26..E:C26- @<<1STARTUP.WK4>>E:D26..E:D26- @<<1STARTUP.WK4>>E:E26..E:E26 `m`mXC' DIRECTORY' Exhibit I' Tab, Ctrl Tab' Capacity /Unit- ?<<1STARTUP.WK4>>E:C27..E:C27- ?<<1STARTUP.WK4>>E:D27..E:D27- ?<<1STARTUP.WK4>>E:E27..E:E27 0u0uLc' Decisions' continued' Machine Depr. /Unit- @<<1STARTUP.WK4>>E:C28..E:C28- @<<1STARTUP.WK4>>E:D28..E:D28- @<<1STARTUP.WK4>>E:E28..E:E28 }}@' Conjectures' Income Statement' Storage Cost- @<<1STARTUP.WK4>>E:C29..E:C29- @<<1STARTUP.WK4>>E:D29..E:D29- @<<1STARTUP.WK4>>E:E29..E:E29 ##4! ' Operating Facts ' continued 'Labor Info "Direct "Repair C C (#  ' Financial Facts ' continued ' Regular Time Hours/Qtr- @<<1STARTUP.WK4>>E:C31..E:C31- @<<1STARTUP.WK4>>E:D31..E:D31 c c %  ' Finished Goods ' Cash Flow Statement ' Overtime Hours/Qtr @  "N/A   '  ' continued ' continued ' Overtime Premium first- @<<1STARTUP.WK4>>E:C33..E:C33 ^hours- <<1STARTUP.WK4>>E:E33..E:E33   ) # ' Materials Inv ' continued ' Overtime Premium next- @<<1STARTUP.WK4>>E:C34..E:C34 ^hours- <<1STARTUP.WK4>>E:E34..E:E34   * C' continued' Balance Sheet!' Supervisor's Salary/Qtr- @ @<<1STARTUP.WK4>>E:C35..E:C35 ,c' Cost of Goods Mfg' continued' Workers/Supervisor- @<<1STARTUP.WK4>>E:C36..E:C36 .' continued'Material Info "Material I "Material II' Order/Delivery Cost- @<<1STARTUP.WK4>>E:C38..E:C38- @<<1STARTUP.WK4>>E:D38..E:D38H' To validate, DO NOT update the UPDATE page of the 1STARTUP.WK4' Storage Cost- Q?<<1STARTUP.WK4>>E:C39..E:C39- GzG?<<1STARTUP.WK4>>E:D39..E:D39,' file until validation is complete.(' Special Order Cost (One, Both)- @ @<<1STARTUP.WK4>>E:C40..E:C40- @<<1STARTUP.WK4>>E:E40..E:E40+'ProForma Tentative Decisions for Firm@'Decision Qtr@'Plant Capacity Info"Product X"Product Y"Product Z<@7"i<@7' Capacity Qtr 24- @ @<<1STARTUP.WK4>>E:C42..E:C42 'Material 1 Usage per unit@ @ ?  "PRODUCT"X "Y "Z .' Fixed Assets per 2000 unit expansion- P@<<1STARTUP.WK4>>E:C43..E:C43 'Material 1 Usage per unit@ @ @  'Price@@@=D    For sure?;.' Fixed Assets per 3000 unit expansion- |@<<1STARTUP.WK4>>E:C44..E:C44! 'Machine Depreciation $/unit@ @ @ 'Advertising C =:   For sure?;'' Misc O&A Expense of Expansion- @<<1STARTUP.WK4>>E:C45..E:C45'Labor force 'R & D6=    For sure?;'Accounting Info' Labor hrs/person@ 'Productionf&6"$ @P(' Coll. Rate on new A/R is about- X9v?<<1STARTUP.WK4>>E:C47..E:C47 ^to- 9v?<<1STARTUP.WK4>>E:E47..E:E47' Supervisors $/person@ @ "Repairmen, "Workers"Capacity`m!' Proportion new A/P Paid-  m9⪪?<<1STARTUP.WK4>>E:C48..E:C48'Repair Force7 :DCan't reduce Capacity!;+@y Capacity ?;' Officer Salaries/Qtr- |@<<1STARTUP.WK4>>E:C49..E:C49' Hours per person@ "MATERIAL"I  "II ' Projected Results' Office Salaries/Qtr- @<<1STARTUP.WK4>>E:C50..E:C50'Commission % Sales(\?! 'Orders for Qtr@4 @4@ ' Sales @R K-' plus amount/1000 unit expansion- @<<1STARTUP.WK4>>E:C51..E:C51'Deliv for Qtr@ ' Gross Margin^0`H @T K"' Sales Force Salaries/Qtr- P@<<1STARTUP.WK4>>E:C52..E:C52 'Spec Orders for @     ' Income K7$@a K- ' plus amount/1000 unit expansion- @ @<<1STARTUP.WK4>>E:C53..E:C53.!r  Spec. Order!;!.!4  Spec. Order!;!!' Ending Cash8!L@ K" K Guido!;(!' plus Commission on $ Sales-! (\?<<1STARTUP.WK4>>E:C54..E:C54!'for graph"'Other Op Expense""' Minimum("5@$  %K#"' Corporate Income Tax Rate-" QQ?<<1STARTUP.WK4>>E:C55..E:C55"'X"'Y"'Z #"BORROW#"INVEST/REPAY#' Distress Req9# K" " K;#'Financial Info$'Commercial Paper$$ $' Distress$"$' Minimum Cash Requirement-$ ?<<1STARTUP.WK4>>E:C57..E:C57 %'Bonds%%%%' Cash:Op Exp %A]oX?! K%' Credit Limit 90 Day-% P@<<1STARTUP.WK4>>E:C58..E:C58c& $ % $ % ' Must be positive or zero!;&&' Excess Cash/&Pj@# !"#;-&' Shares Stock Outstanding/Authorized-& P@<<1STARTUP.WK4>>E:C59..E:C59-& P@<<1STARTUP.WK4>>E:D59..E:D59''Dividends'C'<@7"'i<@72'' Cost of Bond Transaction (issue or call)-' P@<<1STARTUP.WK4>>E:C60..E:C60-' ףp= ף?<<1STARTUP.WK4>>E:D60..E:D60('ProForma Conjectures ("Firm(@('Decision Qtr(@('Pro Forma ("Firm( @( 'Decision Qtr( @ ( 'Macros)<@7")i<@7) <@7") i<@7) '\G)'/gnu{?}~{esc}{esc})'Bal Sheet Graphs*'Assumptions*' Projected Results+' Current Sales6+Ը ,,Be realistic!;+ +' Sales+ @+'Income Statement+"Product X+ "Product Y+ "Product Z + "Total",' Expected Collection Rate,IQ,' Gross Margin,^0`H @ ,' Sales8,g@t9 Uh Oh !9;9, T@t9 Whoops !9;9, #@t9 Dial 911 !9;#, @,, , -' Accts Rec.-ƚ@n -' Income-K7$@ -' Cost Goods Sold-i@- ?׏@- ,%H@#- K( @-- - .' Ending Cash.L@!."------------. "------------. "----------. "------------ /' Hire & Train/Wkr/ /' Minimum/5@"/' Gross Margin/v,n@,-/ ԋ@f@, - / oDoS@, - / hCԭ@, - 0' Personnel Dept. Fixed0H @0' Distress Req0#1' Our Avg Wage1Q@1' Distress1$1' Unit Price+1@@9  ,9;+1 @9  , 9;+1 @9  , 9;2' Expected Downtime hrs2 2'hours2' Cash:Op Exp2A]oX?%2' Unit Cost+2ܼ!@9  -9;+2 3DkmƳ@9  - 9;+2 WLّ@9  - 9;J3y   Something for nothing? CHECK Material I;3 3' Excess Cash3Pj@&3' Unit Margin+3GH&@9  /9;+3 2QH@9  / 9;+3 PgL@9  / 9;J4y   Conservation of Matter: CHECK Material II;4 +5 Capacity ?;5 5"PRODUCT5"X 5"Y 5"Z 6' Planned Units6"Production&6 @ ;&6؈ @ ;&6 @ ;7' D/time permits7"Production7 @7؈ @7 @8' Actual Units8' Available8@ @t8؈ @t8 @t9' Expected Units 9' Sales9%9!9%:' Expected Units:' End Inv:@89:@89:@89;' PgDn Operating Facts%; : FRAUD!!;;%; : FRAUD!!;;%; : FRAUD!!;;!;' PgDn Operating Expenses<'ProForma Operating Facts <"Firm<@<'Decision Qtr<@ <"Firm< @< 'Decision Qtr< @=<@7"=i<@7='Operating Expenses= 'for summary>'Materials: >"Quarter>'Labor and Capacity:)> 'PRO FORMA INPUT AND RESULTS SUMMARY >"Quarter>"Bad Debt?'End of Quarter?@?"Material 1?"Material 2 ?"Quarter?@?' Officer Salaries#? @  ?0?`T@' Units on hand-@@<<1STARTUP.WK4>>C:B75..C:B75-@@<<1STARTUP.WK4>>C:C75..C:C75@' Labor Force@' Office Salaries/@ d@   @ 'CONJECTURES / ASSUMPTIONS@2@A' Avg Cost/unit-A鷯g@<<1STARTUP.WK4>>C:B76..C:B76-AxGj@<<1STARTUP.WK4>>C:C76..C:C76A' Ind Average-A@<<1STARTUP.WK4>>C:B64..C:B64A' Salesmen Salaries/A @   A4AB'Decision quarterB@B' Our Firm-B@<<1STARTUP.WK4>>C:B83..C:B83B' Salesmen CommissionsB 0T@! , B 'OPERATING FACTSB6BC' Units on Order-C @<<1STARTUP.WK4>>C:B79..C:B79-C @<<1STARTUP.WK4>>C:C79..C:C79C' CapacityC' Packing & Shipping Exp?C ߾cE@N~N~N~NC8C`TD' $/Unit-DQQ@<<1STARTUP.WK4>>C:B80..C:B80-D@<<1STARTUP.WK4>>C:C80..C:C80D' Units/Qtr-D @<<1STARTUP.WK4>>C:B89..C:B89D' Storage ExpenseTD Ҁ @ ^ ^   D 'FINANCIAL FACTSD:DE' Number deliveriesE EE' Personnel DepartmentCE 33333g@B 0/B0;E<EF' Spec order $/unitFQQ@DF@DF' Misc Operating & AdminF X @`&F 'PROJECTED RESULTS ($ Thousands)F>F G' Other Operating ExpensesG "G@G`T H"Quarter"H' Depreciation - Office Bldg#H @ UHBHI'End of PreviousI@I"Product XI"Product YI"Product Z#I' Depreciation - Office Equip#I @ UIDIJ'Quarter statusJ'Units on hand-J@<<1STARTUP.WK4>>C:B71..C:B71-J<<1STARTUP.WK4>>C:C71..C:C71-J@<<1STARTUP.WK4>>C:D71..C:D71J' Bad Debt Expense#J @?IUK'Avg Cost/unit-KDio@<<1STARTUP.WK4>>C:B72..C:B72-KsFǵ@<<1STARTUP.WK4>>C:C72..C:C72-KCiqN@<<1STARTUP.WK4>>C:D72..C:D72K' Advertising Expense#K G@L' Research & Development#L @M' Labor Usage Hours/unit-M72@<<1STARTUP.WK4>>C:C86..C:C86-M(\B@<<1STARTUP.WK4>>C:C87..C:C87-Mg?R@<<1STARTUP.WK4>>C:C88..C:C88M "------------N' Packing & ShippingN333333} @NWoB@@NDJ?N2p@KW@ N"TotalN 0*P|@? L PO' PgDn Financial Facts O"(Fixed)O"(per Unit)O"(per Unit)O"(per Unit)'O' PgDn Income Statement SummaryP'ProForma Financial Facts P"FirmP@P'Decision QtrP@ P"FirmP @P 'Decision QtrP @Q<@7"Qi<@7Q'Income Statement SummaryR'End of Previous R"QuarterR'Total SalesR @, S'Quarter statusS@S' Decision Quarter Costs T' Cash-T@<<1STARTUP.WK4>>C:B92..C:B92T'Gross MarginT hCԭ@/ U' Accts Rec.-U@<<1STARTUP.WK4>>C:B93..C:B93 U'Cost Factors QuarterU@V' Interest Rec.-V@@<<1STARTUP.WK4>>C:B94..C:B94V' Industry Base Wage-V(\@<<1STARTUP.WK4>>C:C64..C:C64V'Operating Expense TotalV 0*P|@N W' Other Invest.-WP@<<1STARTUP.WK4>>C:B95..C:B95W' Repair Wage Rate/Hour-WzGz@<<1STARTUP.WK4>>C:D64..C:D64W " ---------W "ExpansionWDX' Cum Bldg Depr-XZ@<<1STARTUP.WK4>>C:B96..C:B96X' Interest Rates %/QtrX'Net Operating IncomeX { `c@/ N X XXpY' Cum Mach Depr-Y`@<<1STARTUP.WK4>>C:B97..C:B97Y' 90 Day Comm.-YMb@<<1STARTUP.WK4>>C:D65..C:D65Y YP@ Y|@ Z' Cum Off Eq Depr-Z@<<1STARTUP.WK4>>C:B98..C:B98Z' 90 Day Distress-Z(\@<<1STARTUP.WK4>>C:C65..C:C65Z' Investment Income Z $YZ Z @ Z @ [' Accts Payable-[ؗ@<<1STARTUP.WK4>>C:B99..C:B99[' 20-Year Bond [' AA[Mb@[' Less: Interest Expense`[ X@$Z $Y_%a[^P%\' Int. Payable/\ @<<1STARTUP.WK4>>C:B100..C:B100 \' A\ \' \ " ---------\"Material 1\"Material 2]' Comm Paper Pay./]<<1STARTUP.WK4>>C:B101..C:B101 ]' B]]'Net Income Before Taxes#] @X Z [ ] "# Deliveries#]@E E;#]@E E;^' Distress Loan/^<<1STARTUP.WK4>>C:B102..C:B102 ^' C^^ "Avg Inventory0^ @C]0^ @C]_' Bonds Payable/_|@<<1STARTUP.WK4>>C:B103..C:B1038_' (Enter Bond rate for your firms current rating)_' Income Taxes+_ I@  " ] ;_ 'Misc Optg & Admin_ Z_X @_ U ] ]a`' Ret Earnings/`@<<1STARTUP.WK4>>C:B104..C:B104`' Underwriting Fixed`P@' ` " ---------` "Capacity` @*`X @_WX ZZa' Avg Rate Bondsaa' Variablea ףp= ף?' a'Net Income After Taxesa ڟ@] _ a 'Spec Orders&a    4aa  a  ;;b' Loss Shelterbc' PgDn Resource Summaryc"PgDn Cash In d"Firmd@d'Decision Qtrd@d'Pro Forma d"Firmd @d 'Decision Qtrd @e<@7"ei<@7e <@7"e i<@73f'Resource Summary - Finished Goods Inventoriesf'Cash Flow Statement f 'unitsf @f؈ @f @h'Beginning Inventoryh"Product Xh"Product Yh"Product Zh'Beginning Cashh @Th 'm1h\@hGx{e @h{Y@i' $/UnitiDio@KisFǵ@KiCiqN@Ki 'm2ipr<@iY@wԽ@iN E@ j' Unitsj@JjJj@J/j'Operating Sources: Collections from Sales j 'laborjºt@jl+=ݚ@j%r@k' Total k- @jikjikMJ @ji%k' Beginning Accounts Receivablek @U k 'supvk ᒌd @k0sw@kwq] @ l"Total $#l@a@kkk.l' Accounts Receivable from Current Salesl @, l 'maint+repl__(@lĦҐ@lg[d@m'Goods Producedm' Less Bad Debtsm J  m 'deprmd @mz @m @n' $/Unit+n/q@o  po;+n3DkmƳ@o  po;+nd@o  po;'n' Less Ending Accounts Receivable"n ƚl , o' Units.o @  7;.o؈ @  7;.o @  7;1o' Total Operating Receiptso nÝ@k n Po 'm1o+ VHS@hfo+ VHS@hfo+ VHS@hfp' Total phU$Y@p9 ѹ32@pR"@p 'm2pK6@ifpK6@ifp<]\D@if q"Total $#q`D@ppp q 'laborqpv&'$@jfq_vq@jfq.A>@jfr'Goods Available r 'supvrm @kfr6$@kfrͿ@kfs' $/Unit+sܼ!@t  ut;+s3DkmƳ@t  ut;+sWLّ@t  ut;s 'maint+repsgJCΫ@lfsgJCΫ@lfsiJCΫ@lf t' Unitst@ @jot؈ @jot @jo t 'deprt@mft@mft@mfu' Total uX Q@kpu9 ѹ32@kpuhY@kp v"Total $#v@}n0@uuu%w' PgDn Operating Disbursements x"Firmx@x'Decision Qtrx@ x"Firmx@x 'Decision Qtrx @ x 'Pricex@@x@x@3y'Cash Flow Statement - Operating Disbursements?z'Resource Summary - Finished Goods Inventories (Continued)z' Payments for Materials+z gB@ [ z 'Margin1zƠ@x{|}~1z3QH@x{|}~1zX@x{|}~{"Product X{"Product Y{"Product Z{' Direct Labor Payroll{ hhi@{ 'Commission{@! x{@! x{ףp= ף@! x|'Goods Sold|' Supervisors Salaries| @| 'Materials|Nױ@op|,O@op|"v3Y#@op}' $/Unit}ܼ!@s}3DkmƳ@s}WLّ@s}' Repair Force Payroll} :@ } 'Labor} @qr} E$O @qr}9n@qr ~' Units0~ @9t FRAUD ! 9;0~` @9t FRAUD ! 9;0~p @9t FRAUD ! 9;~' Officer Salaries~ @? ~ 'Overhead~gJC@st~gJC@st~iJC@st' Total i@s~ ?׏@s~,%H@s~' Office Salaries d@@  "Total $#K( @' Salesmens Salaries @A 'Ending Inventory' Salesmens Commissions 0T@B  'Marginpn-Iˆ?zxNb{r?zx=<8H?zx' $/Unitܼ!@}3DkmƳ@}WLّ@}!' Plant Maintenance Expense @ 'Commission(\?{x(\?{x(\?{x ' Units5@t~ FRAUD !t~;5@t~ FRAUD !t~;5@t~ FRAUD !t~;$' Personnel Department Expense 33333g@E  'MaterialspR?|x:Y"z?|x+rG?|x' Total [ @u @uvaQ @u$' Packing and Shipping Expense ߾cE@C  'LaborDiA5?}xV?}x_`?}x "Total $#)ƨv|@' Storage Expense Ҁ @D  'Overhead*r:?~xz1i'?~x{'0?~x' Advertising Expense G@K  "Regular"Overtime "Total' R & D Expense @L ?P?P?P"Direct Labor Hours@-" @ ;9^.;1h@MMM#' Misc Optg and Admin Expense X @`' Other Expense ")' Total Operating Disbursements Cu@z P ' PgDn Cash Flow Summary "Firm@'Decision Qtr@'Cash Flow Summary "Firm @ 'Decision Qtr @ 'Overtime "Pcnt "Prem'Beginning Cash @h  'Up to?   .'Resource Summary - Materials Inventories"' Change from Operations `l@o   'Up to?   'Other Sources '  'OT Limit " Material 1" Material 2' Notes Repaid P@W 'Prev Emp@B' Beginning Inventory鷯g@AxGj@A ' $/Unit' Interest Received @@V 'Emp@@@@@ ' Units' Bonds Issued %>F:E39..F:E39 "Firm@'Decision Qtr@"'Pro Forma Position Statement @ 'End of Qtr @ <@7" i<@7 'Assets.'Resource Summary - Materials Inventories' (Continued)'Current Assets 'Cash ;W讖@ " Material 1" Material 2 ' Cash ;W讖@  'Receivables#ƚ@   ' Used in Production* VHS@K6@ ' $/Unit' Accounts Receivable ƚ@n  'Inventories o8~@  ;h @777;@777 ' Units' Interest Receivable Z  'Fixed|3@ ghy@2|@ ' Total' Materials Inventory \QI\p @ "Total $C@'Finished Goods Inventory' Product X [ @' Ending Inventory3ﮭ VHS@  None;3(K6@  None; ' $/Unit' Product Y  @7@ Can't be ;9@ No Way ! ; ' Units' Product Z vaQ @ )ƨv|@ P 'Units Sched @6؈ @6 @6N@̲@ ' Total'Other Investments $ Ӷ 4D@ P 'Hours Sched?R@Mp= ף@M3P.@M "Total $\QI\p @ 'ProportionGh z?  ;G.՚$;?  ;GvJ?  ; 'Hours Lost222 'Prop Made.?  ;.?  ;.?  ; 'Units Made  @ ? ؈ @ ?  @ ?"PgDn Fixed Assets 'Matls Sched8h @8@'Pro Forma "Firm@'Decision Qtr@"'Pro Forma Position Statement @ 'End of Qtr @<@7"i<@7 'Bond Issue1% `a% ; 'Cost of Goods Manufactured'Assets (continued) 'Bond Retire1@% `a% ;"Product X"Product Y"Product Z "Total ' Total@' Raw Material 1p\@777  7777;pGx{e @777  7777;p{Y@777  7777;Dghy@ 7 7 7"'Property, Plant, & Equipment' Raw Material 2ppr<@777  7777;pY@wԽ@777  7777;pN E@777  7777;C2|@7 7 7  ' Land C' Direct Laborpºt@  MMMM;pl+=ݚ@  MMMM;p%r@  MMMM;hhi@' Building>- P@  ' Total DirectJoʅ@PS@Pb=@P`Di@P' Less Depreciation# @XH # @  ' Manufacturing Overhead' Machinery- @W   'current|a2U¹@ ' Supervisionp ᒌd @  MMMM;p0sw@  MMMM;pwq] @  MMMM;1@  "' Less Depreciation (@Y# K@   'long|@ ' MaintenanceP$I$Iz @  ;PI$I$ @  ;P%I$I @  ;# @ U' Office Equipment - @@>   'stock@ ' Repair WagesP::Hy@  ;P1@  ;P@  ;$:@W' Less Depreciation @ZI # @   |3@ P 'ret earn>@ ' Depr - Machinery @ @ @# @ \-' Depr - BldgP @  ;P؈ @  ;P @  ;# @ U'Total Assets iۅn@   \= 'Income@] ' Total Overhead6iz@Pnz"@PO\@P@P 'Loss carryb8||   !Out of Balance by ;2 |   !  !;  ' Taxable1@  ;' Total CosthU$Y@9 ѹ32@R"@`D@"PgDn Liabilities"'Pro Forma Position Statement @ 'End of Qtr @'Thanx to Jeff Reedy!'and Bill Hostetler!'Equities'Current Liabilities' Accounts Payable) |a2U@ ' Interest Payable @[  ' Commercial Paper Payable  ' Distress Loan   |a2U¹@ P'Long Term Liabilities' Bonds Payable# |@_%% 0*D@  'Stockholders Equity' Capital Stock ' Retained Earnings @`' Plus Income ڟ@a ' Less Dividends @ # >@    U]V@   \-'Total Equities l'4n@   \="PgDn NothingA|   !  Out of Balance by ; 3 |   !   ; -U_ ArialArialArialArialTimes New RomanTimes New RomanTimes New RomanSymbol      Oc4!*d5 e&%Graphs\G  je&U Finne & Churchill  <z &Doc Info AuthorDoc Info Creation DateDoc Info Editing TimeDoc Info Last Revision DateDoc Info ObjectDoc Info PropertyDoc Info Revisions CountFM3FM3 PropertyWK3WK3 Property  h [ WJ F  s          -CMHdrh