BEST/WORST CASE SCENARIO DEVELOPMENT

profilehomeworkhelp22
annual_report.pdf

Annual Report Annual Report Baldwin C57912 Round: 3Dec. 31, 2016

Balance Sheet DEFINITIONS: Common Size: The common size column simply represents each item as a percentage of total assets for that year. Cash: Your end-of-year cash position. Accounts Receivable: Reflects the lag between delivery and payment of your products. Inventories: The current value of your inventory across all products. A zero indicates your company stocked out. Unmet demand would, of course, fall to your competitors. Plant & Equipment: The current value of your plant. Accum Deprec: The total accumulated depreciation from your plant. Accts Payable: What the company currently owes suppliers for materials and services. Current Debt: The debt the company is obligated to pay during the next year of operations. It includes emergency loans used to keep your company solvent should you run out of cash during the year. Long Term Debt: The company's long term debt is in the form of bonds, and this represents the total value of your bonds. Common Stock: The amount of capital invested by shareholders in the company. Retained Earnings: The profits that the company chose to keep instead of paying to shareholders as dividends.

ASSETS 2016 Common

Size

2015

Cash $17,277 18.3% $15,155 Account Receivable $6,623 7.0% $7,895 Inventory $22,100 23.4% $16,033 Total Current Assets $46,000 48.8% $39,083

Plant & Equipment $103,600 110.0% $113,800 Accumulated Depreciation ($55,253) -58.6% ($53,107) Total Fixed Assets $48,347 51.2% $60,693 Total Assets $94,346 100.0% $99,777 LIABILITIES & OWNER'S EQUITY

Accounts Payable $5,040 5.3% $4,093 Current Debt $0 0.0% $5,635 Long Term Debt $37,250 39.5% $37,250 Total Liabilities $42,290 44.8% $46,978

Common Stock $27,660 29.3% $25,660 Retained Earnings $24,397 25.9% $27,140 Total Equity $52,057 55.2% $52,800 Total Liab. & O. Equity $94,346 100.0% $99,777

Cash Flow Statement The Cash Flow Statement examines what happened in the Cash Account during the year. Cash injections appear as positive numbers and cash withdrawals as negative numbers. The Cash Flow Statement is an excellent tool for diagnosing emergency loans. When negative cash flows exceed positives, you are forced to seek emergency funding. For example, if sales are bad and you find yourself carrying an abundance of excess inventory, the report would show the increase in inventory as a huge negative cash flow. Too much unexpected inventory could outstrip your inflows, exhaust your starting cash and force you to beg for money to keep your company afloat.

Cash Flows from Operating Activities 2016 2015 NetIncome(Loss) ($2,743) ($1,246) Depreciation $6,907 $7,587 Extraordinary gains/losses/writeoffs ($1,190) ($15) Accounts Payable $947 ($3,212) Inventory ($6,067) $16,324 Accounts Receivable $1,272 ($50)

Net cash from operation ($874) $19,388 Cash Flows from Investing Activities Plant Improvements $6,630 $0 Cash Flows from Financing Activities Dividends Paid $0 $0 Sales of Common Stock $2,000 $4,800 Purchase of Common Stock $0 $0 Cash from long term debt $0 $0 Retirement of long term debt $0 ($6,935) Change in current debt(net) ($5,635) ($2,098)

Net Cash from financing activities ($3,635) ($4,233) Net Change in cash position $2,121 $15,155 Closing cash position $17,277 $15,155

Annual Report Page 1

Annual Report Baldwin C57912 Round: 3Dec. 31, 2016 2016 Income Statement

(Product Name) Baker Bead Bid Bold Buddy NA NA NA 2016 Total

Common Size

Sales $22,742 $14,507 $19,780 $11,780 $11,768 $0 $0 $0 $80,577 100.0%

Variable Costs: Direct Labor $6,907 $5,679 $5,210 $3,418 $4,136 $0 $0 $0 $25,349 31.5% Direct Material $7,409 $4,915 $7,578 $4,931 $5,068 $0 $0 $0 $29,902 37.1% Inventory Carry $365 $1,628 $0 $640 $19 $0 $0 $0 $2,652 3.3% Total Variable $14,681 $12,222 $12,788 $8,989 $9,223 $0 $0 $0 $57,903 71.9%

Contribution Margin $8,061 $2,285 $6,992 $2,790 $2,545 $0 $0 $0 $22,674 28.1%

Period Costs: Depreciation $2,200 $2,427 $1,080 $720 $480 $0 $0 $0 $6,907 8.6% SG&A: R&D $0 $0 $715 $0 $581 $0 $0 $0 $1,296 1.6% Promotions $1,500 $1,000 $1,100 $1,500 $800 $0 $0 $0 $5,900 7.3% Sales $2,000 $1,600 $1,300 $2,000 $800 $0 $0 $0 $7,700 9.6% Admin $351 $224 $305 $182 $181 $0 $0 $0 $1,242 1.5% Total Period $6,051 $5,250 $4,500 $4,402 $2,843 $0 $0 $0 $23,045 28.6%

Net Margin $2,011 ($2,965) $2,492 ($1,611) ($298) $0 $0 $0 ($371) -0.5%

Definitions: Sales: Unit Sales times list price. Direct Labor: Labor costs incurred to produce the product that was sold. Inventory Carry Cost: the cost unsold goods in inventory. Depreciation: Calculated on straight-line. 15-year depreciation of plant value. R&D Costs: R&D department expenditures for each product. Admin: Administration overhead is estimated at 1.5% of sales. Promotions: The promotion budget for each product. Sales: The sales force budget for each product. Other: Chargs not included in other categories such as Fees, Write offs, and TQM. The fees include money paid to investment bankers and brokerage firms to issue new stocks or bonds plus consulting fees your instructor might assess. Write-offs include the loss you might experience when you sell capacity or liquidate inventory as the result of eliminating a production line. If the amount appears as a negative amount, then you actually made money on the liquidation of capacity or inventory. EBIT: Earnings Before Interest and Taxes. Short Term Interest: Interest expense based on last year''s current debt, including short term debt, long term notes that have become due, and emergency loans, Long Term Interest: Interest paid on outstanding bonds. Taxes: Income tax based upon a 35% tax rate. Profit Sharing: Profits shared with employees under the labor contract. Net Profit: EBIT minus interest, taxes, and profit sharing.

Other ($1,090) -1.4% EBIT $719 0.9% Short Term Interest $0 0.0% Long Term Interest $4,939 6.1% Taxes ($1,477) -1.8% Profit Sharing $0 0.0% Net Profit ($2,743) -3.4%

Annual Report Page 2