Manufacturer's Business Plan Financials

Document Sample
Manufacturer's Business Plan Financials Powered By Docstoc
					Breakaway Bicycle Company, Inc. Balance Sheet - December 31, 200X
Assets
Current Assets: Cash Accounts Receivable Less: Reserve for Bad Debts Merchandise Inventory Prepaid Expenses Notes Receivable Total Current Assets Fixed Assets: Vehicles Less: Accumulated Depreciation Furniture and Fixtures Less: Accumulated Depreciation Equipment Less: Accumulated Depreciation Total Fixed Assets Other Assets: Goodwill Total Other Assets $50,000 $20,000 5,000 15,000 5,000 500 0 $70,500

15,000 15,000 15,000 5,000 100,000 48,000

0

10,000

52,000 62,000

0 0 $132,500

Total Assets

Liabilities and Capital
Current Liabilities: Accounts Payable Sales Taxes Payable Payroll Taxes Payable Accrued Wages Payable Unearned Revenues Total Current Liabilities Long-Term Liabilities: Long-Term Notes Payable Mortgage Payable Total Long-Term Liabilities $4,200 2,000 1,523 4,125 20,000 $31,848

0 0 0 31,848

Total Liabilities

Capital: Owner's Equity

100,652 100,652 $132,500 0

Total Capital Total Liabilities and Capital

Breakaway Bicycle Company, Inc. Income Statement - 12/31/00
Revenue:
Gross Sales Less: Sales Returns and Allowances Net Sales $1,057,008 22,890 1,034,118

Cost of Goods Sold:
Beginning Inventory Add: Purchases Freight-in Direct Labor Indirect Expenses Less: Ending Inventory Cost of Goods Sold Gross Profit (Loss) $15,000 124,500 2,500 241,000 0 383,000 16,500 366,500 667,618

Expenses:
Advertising Amortization Bad Debts Bank Charges Charitable Contributions Commissions Contract Labor Credit Card Fees Delivery Expenses Depreciation Dues and Subscriptions Insurance Interest Maintenance Miscellaneous Office Expenses Operating Supplies Payroll Taxes Permits and Licenses Postage Professional Fees Property Taxes Rent Repairs Telephone Travel Utilities Vehicle Expenses Wages Total Expenses Net Operating Income 47,000 0 42,280 3,600 2,500 0 0 2,400 65,760 10,000 600 7,200 0 2,400 0 2,400 2,400 42,500 1,200 2,400 2,400 0 24,000 0 5,200 9,000 6,000 2,510 205,000 488,750 178,868

Other Income:
Gain (Loss) on Sale of Assets Interest Income Total Other Income 0 0 0 $178,868

Net Income (Loss)

Breakaway Bicycle Company, Inc. Cash Flow Worksheet for 2000
January Beginning Cash Balance Cash Inflows (Income): Accts. Rec. Collections Sales & Receipts February $3,600 8,000 75,000 $83,000 $86,600 2,500 300 200 4,500 1,200 600 14,550 7,899 200 28,000 2,800 1,200 50 200 100 500 $64,799 March $21,801 7,000 85,996 $92,996 $114,797 1,000 300 200 4,500 1,200 600 7,804 12,500 200 28,000 2,800 1,200 50 200 100 500 $61,154 2,500 $ $64,799 $21,801 $2,500 $63,654 $51,143 $0 $76,650 $68,343 April $51,143 7,850 86,000 $93,850 $144,993 3,000 300 200 4,500 1,200 600 18,800 15,000 200 28,000 2,800 1,200 50 200 100 500 $76,650 May $68,343 7,952 84,520 $92,472 $160,815 1,500 300 200 4,500 1,200 600 16,654 8,500 200 28,000 2,800 1,200 50 200 100 500 $66,504 5,100 $5,100 $71,604 $89,211 $0 $65,315 $115,221 June $89,211 6,210 85,115 $91,325 $180,536 4,500 300 200 4,500 1,200 600 14,445 6,520 200 28,000 2,800 1,200 50 200 100 500 $65,315 July $115,221 5,260 88,500 $93,760 $208,981 1,500 300 200 4,500 1,200 600 14,800 5,500 200 28,000 2,800 1,200 50 200 100 500 $61,650 10,000 $10,000 $71,650 $137,331 $0 $63,250 $167,270 August $137,331 9,850 83,339 $93,189 $230,520 2,500 300 200 4,500 1,200 600 13,200 7,700 200 28,000 2,800 1,200 50 200 100 500 $63,250 September $167,270 9,852 70,520 $80,372 $247,642 1,000 300 200 4,500 1,200 600 11,587 5,420 200 28,000 2,800 1,200 50 200 100 500 $57,857 12,000 $12,000 $69,857 $177,785 $0 $64,226 $183,947 October $177,785 7,888 62,500 $70,388 $248,173 3,000 300 200 4,500 1,200 600 12,589 8,787 200 28,000 2,800 1,200 50 200 100 500 $64,226 November $183,947 9,520 55,000 $64,520 $248,467 1,500 300 200 4,500 1,200 600 12,300 6,002 200 28,000 2,800 1,200 50 200 100 500 $59,652 8,500 $8,500 $68,152 $180,315 December $180,315 7,550 81,000 $88,550 $268,865 4,500 300 200 4,500 1,200 600 11,899 6,000 200 28,000 2,800 1,200 50 200 100 500 $62,249 18,750 $18,750 $80,999 $187,866 Total

8,500 65,000

95,432 922,490 $1,017,922

Total Cash Inflows $73,500 Available Cash Balance $73,500 Cash Outflows (Expenses): Advertising 1,500 Bank Service Charges 300 Credit Card Fees 200 Delivery 4,500 Health Insurance 1,200 Insurance 600 Inventory Purchases 13,050 Miscellaneous 15,000 Office 200 Payroll 28,000 Payroll Taxes 2,800 Rent or Lease 1,200 Subscriptions & Dues 50 Supplies 200 Taxes & Licenses 100 Utilities & Telephone 500 Subtotal Other Cash Outflows Owner's Draw Subtotal Total Cash Outflows Ending Cash Balance $69,400 500 $500 $69,900 $3,600

28,000 3,600 2,400 54,000 14,400 7,200 161,678 104,828 2,400 336,000 33,600 14,400 600 2,400 1,200 6,000 $772,706 57,350 $57,350 $830,056

Breakaway Bicycle Company, Inc. Pro Forma Balance Sheet - 12/31/00
Assets
Current Assets: Cash Accounts Receivable Less: Reserve for Bad Debts Merchandise Inventory Prepaid Expenses Notes Receivable Total Current Assets Fixed Assets: Vehicles Less: Accumulated Depreciation Furniture and Fixtures Less: Accumulated Depreciation Equipment Less: Accumulated Depreciation Buildings Less: Accumulated Depreciation Land Total Fixed Assets Other Assets: Goodwill Total Other Assets $452,578 $74,520 7,452 67,068 21,000 5,000 0 $545,646

0 0 25,000 7,000 160,000 54,000 0 0

0

18,000

106,000

0 0 124,000

0 0

Total Assets

$669,646

Liabilities and Capital
Current Liabilities: Accounts Payable Sales Taxes Payable Payroll Taxes Payable Accrued Wages Payable Unearned Revenues Short-Term Notes Payable Short-Term Bank Loan Payable Total Current Liabilities Long-Term Liabilities: Long-Term Notes Payable Mortgage Payable Total Long-Term Liabilities $5,500 400 16,000 55,880 15,060 0 0 $92,840

75,000 0 75,000

Total Liabilities

167,840

Capital: Owner's Equity

501,806

Total Capital Total Liabilities and Capital
0

501,806 $669,646

Breakaway Bicycle Company, Inc. Pro Forma Balance Sheet - 12/31/01
Assets
Current Assets: Cash Accounts Receivable Less: Reserve for Bad Debts Merchandise Inventory Prepaid Expenses Notes Receivable Total Current Assets Fixed Assets: Vehicles Less: Accumulated Depreciation Furniture and Fixtures Less: Accumulated Depreciation Equipment Less: Accumulated Depreciation Buildings Less: Accumulated Depreciation Land Total Fixed Assets Other Assets: Goodwill Total Other Assets

$815,840 $22,000 1,980 20,020 15,000 5,200 0 $856,060

0 0 25,000 9,000 160,000 60,000 0 0

0

16,000

100,000

0 0 116,000

0 0 $972,060

Total Assets

Liabilities and Capital
Current Liabilities: Accounts Payable Sales Taxes Payable Payroll Taxes Payable Accrued Wages Payable Unearned Revenues Short-Term Notes Payable Short-Term Bank Loan Payable Total Current Liabilities Long-Term Liabilities: Long-Term Notes Payable Mortgage Payable Total Long-Term Liabilities

$7,500 800 17,500 60,000 78,000 0 0 $163,800

50,000 0 50,000 213,800

Total Liabilities

Capital: Owner's Equity

758,260 758,260 $972,060 0

Total Capital Total Liabilities and Capital

Breakaway Bicycle Company, Inc. Revenue Projections
2000
January NUMBER OF: Road Frames Mountain Frames INCOME GENERATED FROM: European Sales -Road Frames ($1,800/frame) U.S. Sales - Road ($1,800/frame) European Sales - Mountain ($1,600/frame) U.S. Sales - Mountain ($1,600/frame) 30 40 February 26 38 March 30 38 April 34 41 May 36 43 June 34 41 July 38 40 August 32 36 September 29 32 October 26 29 November 22 19 December 44 48 Total 377 445

$10,800 $43,200 $32,000 $32,000 $118,000

$9,360 $37,440 $30,400 $30,400 $107,600

$10,800 $43,200 $30,400 $30,400 $114,800

$12,240 $48,960 $32,800 $32,800 $126,800

$12,960 $51,840 $34,400 $34,400 $133,600

$12,240 $48,960 $32,800 $32,800 $126,800

$12,240 $48,960 $32,000 $32,000 $125,200

$11,520 $46,080 $28,800 $28,800 $115,200

$10,440 $41,760 $25,600 $25,600 $103,400

$9,360 $37,440 $23,200 $23,200 $93,200

$7,920 $31,680 $15,200 $15,200 $70,000

$15,840 $63,360 $38,400 $38,400 $156,000

$1,390,600

2001
January NUMBER OF: Road Frames Mountain Frames INCOME GENERATED FROM: European Sales -Road Frames ($1,800/frame) U.S. Sales - Road ($1,800/frame) European Sales - Mountain ($1,600/frame) U.S. Sales - Mountain ($1,600/frame) 40 44 February 35 42 March 36 41 April 38 46 May 42 48 June 40 45 July 38 44 August 35 38 September 32 35 October 29 32 November 25 26 December 60 65 Total 450 506

$14,400 $57,600 $35,200 $35,200 $142,400

$12,600 $50,400 $33,600 $33,600 $130,200

$12,960 $51,840 $32,800 $32,800 $130,400

$13,680 $54,720 $36,800 $36,800 $142,000

$15,120 $60,480 $38,400 $38,400 $152,400

$14,400 $57,600 $36,000 $36,000 $144,000

$13,680 $54,720 $35,200 $35,200 $138,800

$12,600 $50,400 $30,400 $30,400 $123,800

$11,520 $46,080 $28,000 $28,000 $113,600

$10,440 $41,760 $25,600 $25,600 $103,400

$9,000 $36,000 $20,800 $20,800 $86,600

$21,600 $86,400 $52,000 $52,000 $212,000

$1,619,600

Projected Revenue - 2000

$160,000 $140,000 M o n $120,000 t h $100,000 l y $80,000 R e $60,000 v e n $40,000 u e $20,000 $0 January March May July September November

Projected Revenue - 2001

$250,000

M $200,000 o n t h l $150,000 y R e $100,000 v e n u $50,000 e

$0
January March May July September November

Breakaway Bicycle Company, Inc. Projected Profit and Loss Statement - 2000
January Revenue: Gross Sales Less: Sales Returns and Allowances Net Sales Cost of Goods Sold: Materials Labor Other Direct Expenses Indirect Expenses Cost of Goods Sold Gross Profit (Loss) Expenses: Advertising Bad Debts Bank Charges Charitable Contributions Credit Card Fees Delivery Expenses Depreciation Dues and Subscriptions Insurance Interest Maintenance Miscellaneous Office Expenses Operating Supplies Payroll Taxes Permits and Licenses Postage Rent Telephone Travel Utilities Wages Wages Total Expenses Net Operating Income Other Income: Gain (Loss) on Sale of Assets Interest Income Total Other Income Net Income (Loss) Cumulative Net Income (Loss) $118,000 5,900 $112,100 February 107,600 5,380 $102,220 March $114,800 5,740 $109,060 April $126,800 6,340 $120,460 May $133,800 6,690 $127,110 June $126,800 6,340 $120,460 July $125,200 6,260 $118,940 August $115,200 5,760 $109,440 September $103,400 5,170 $98,230 October $93,200 4,660 $88,540 November $70,000 3,500 $66,500

14,160 14,160 5,310 1,770 $35,400 $76,700

12,912 12,912 4,842 1,614 $32,280 $69,940

13,776 13,776 5,166 1,722 $34,440 $74,620

15,216 15,216 5,706 1,902 $38,040 $82,420

16,056 16,056 6,021 2,007 $40,140 $86,970

15,216 15,216 5,706 1,902 $38,040 $82,420

15,024 15,024 5,634 1,878 $37,560 $81,380

13,824 13,824 5,184 1,728 $34,560 $74,880

12,408 12,408 4,653 1,551 $31,020 $67,210

11,184 11,184 4,194 1,398 $27,960 $60,580

8,400 8,400 3,150 1,050 $21,000 $45,500

2,500 5,605 300 100 0 200 5,480 888 50 600 401 200 500 200 200 3,792 100 200 3,200 400 200 500 23,757 49,373 27,327

2,500 5,111 300 100 0 200 5,480 888 50 600 401 200 500 200 200 3,792 100 200 3,200 400 1,000 500 25,005 50,927 19,013

3,000 5,453 300 100 0 200 5,480 888 50 600 401 200 500 200 200 3,792 100 200 3,200 400 1,000 500 37,917 64,681 9,939

5,000 6,023 300 100 0 200 5,480 888 50 600 401 200 500 200 200 3,792 100 200 3,200 400 1,000 500 22,701 52,035 30,385

3,000 6,356 300 100 0 200 5,480 888 50 600 401 200 500 200 200 3,792 100 200 3,200 400 1,000 500 21,861 49,528 37,443

3,000 6,023 300 100 0 200 5,480 888 50 600 401 200 500 200 200 3,792 100 200 3,200 400 1,000 500 22,701 50,035 32,385

2,500 5,947 300 100 0 200 5,480 888 50 600 401 200 500 200 200 3,792 100 200 3,200 400 1,000 500 22,893 49,651 31,729

2,000 5,472 300 100 0 200 5,480 888 50 600 401 200 500 200 200 3,792 100 200 3,200 400 1,000 500 24,093 49,876 25,004

2,000 4,912 300 100 0 200 5,480 888 50 600 401 200 500 200 200 3,792 100 200 3,200 400 1,000 500 25,509 50,932 16,279

3,000 4,427 300 100 0 200 5,480 888 50 600 401 200 500 200 200 3,792 100 200 3,200 400 1,000 500 26,733 52,671 7,909

4,000 3,325 300 100 0 200 5,480 888 50 600 401 200 500 200 200 3,792 100 200 3,200 400 1,000 500 29,517 55,353 (9,853)

0 0 0 $27,327 $27,327

0 0 0 19,013 46,340

0 0 0 $9,939 $56,279

0 0 0 $30,385 $86,664

0 0 0 $37,443 $124,107

0 0 0 $32,385 $156,492

0 0 0 $31,729 $188,221

0 0 0 $25,004 $213,225

0 0 0 $16,279 $229,504

0 0 0 $7,909 $237,413

0 0 0 ($9,853) $227,560

Breakaway Bicycle Company, Inc. Projected Profit and Loss Statement - 2001
January Revenue: Gross Sales Less: Sales Returns and Allowances Net Sales Cost of Goods Sold: Materials Labor Other Direct Expenses Indirect Expenses Cost of Goods Sold Gross Profit (Loss) Expenses: Advertising Bad Debts Bank Charges Charitable Contributions Credit Card Fees Delivery Expenses Depreciation Dues and Subscriptions Insurance Interest Maintenance Miscellaneous Office Expenses Operating Supplies Payroll Taxes Permits and Licenses Postage Rent Telephone Travel Utilities Wages Total Expenses Net Operating Income Other Income: Gain (Loss) on Sale of Assets Interest Income Total Other Income Net Income (Loss) Cumulative Net Income (Loss) $142,400 7,120 $135,280 February $130,200 6,510 $123,690 March $130,400 6,520 $123,880 April $142,000 7,100 $134,900 May $152,400 7,620 $144,780 June $144,000 7,200 $136,800 July $138,800 6,940 $131,860 August $123,800 6,190 $117,610 September $113,600 5,680 $107,920 October $103,400 5,170 $98,230 November $86,600 4,330 $82,270

17,088 17,088 6,408 2,136 $42,720 $92,560

15,624 15,624 5,859 1,953 $39,060 $84,630

15,648 15,648 5,868 1,956 $39,120 $84,760

17,040 17,040 6,390 2,130 42,600 $92,300

18,288 18,288 6,858 2,286 45,720 $99,060

15,624 15,624 5,859 1,953 39,060 $97,740

15,648 15,648 5,868 1,956 39,120 $92,740

17,040 17,040 6,390 2,130 42,600 $75,010

18,288 18,288 6,858 2,286 45,720 $62,200

15,624 15,624 5,859 1,953 $39,060 $59,170

15,648 15,648 5,868 1,956 $39,120 $43,150

2,700 6,764 300 100 200 6,000 888 50 600 401 200 500 200 200 2,750 100 400 3,200 400 1,000 500 27,495 $54,948 $37,613

2,700 6,185 300 100 200 6,000 888 50 600 401 200 500 200 200 2,923 100 400 3,200 400 1,000 500 29,229 $56,276 $28,354

3,100 6,194 300 100 200 6,000 888 50 600 401 200 500 200 200 2,894 100 400 3,200 400 1,000 500 28,935 $56,362 $28,399

5,200 6,745 300 100 200 6,000 888 50 600 401 200 500 200 200 2,754 100 400 3,200 400 1,000 500 27,543 $57,481 $34,819

3,100 7,239 300 100 200 6,000 888 50 600 401 200 500 200 200 2,630 100 400 3,200 400 1,000 500 26,295 $54,503 $44,558

3,100 6,840 300 100 200 6,000 888 50 600 401 200 500 200 200 2,896 100 400 3,200 400 1,000 500 28,959 $57,034 $40,706

2,700 6,593 300 100 200 6,000 888 50 600 401 200 500 200 200 2,894 100 400 3,200 400 1,000 500 28,935 $56,361 $36,380

2,100 5,881 300 100 200 6,000 888 50 600 401 200 500 200 200 2,754 100 400 3,200 400 1,000 500 27,543 $53,517 $21,493

2,100 5,396 300 100 200 6,000 888 50 600 401 200 500 200 200 2,630 100 400 3,200 400 500 500 26,295 $51,160 $11,041

3,100 4,912 300 100 200 6,000 888 50 600 401 200 500 200 200 2,896 100 400 3,200 400 500 500 28,959 $54,606 $4,564

4,200 4,114 300 100 200 6,000 888 50 600 401 200 500 200 200 2,894 100 400 3,200 400 500 500 28,935 $54,882 ($11,732)

0 0 0 $37,613 $37,613

0 0 0 $28,354 $65,967

0 0 0 $28,399 $94,366

0 0 0 $34,819 $129,185

0 0 0 $44,558 $173,743

0 0 0 $40,706 $214,449

0 0 0 $36,380 $250,829

0 0 0 $21,493 $272,321

0 0 0 $11,041 $283,362

0 0 0 $4,564 $287,927

0 0 0 ($11,732) $276,195

Breakaway Bicycle Company, Inc. Cash Flow Budget Worksheet - 2000
Jan Beginning Cash Balance Cash Inflows (Income): Accounts Receivable Collections Loan Proceeds Sales & Receipts Other: Feb $63,642 5,605 96,840 Mar $84,601 5,111 103,320 Apr $109,750 5,453 114,120 May $141,881 6,023 120,420 Jun $181,622 6,356 114,120 Jul $216,656 6,023 112,680 Aug $250,705 5,947 98,496 Sep $272,794 5,472 93,060 Oct $291,096 4,912 83,880 Nov $300,494 4,427 63,000 Dec $291,703 3,325 140,400 Total

0 100,000 106,200

Total Cash Inflows Available Cash Balance Cash Outflows (Expenses): Advertising Bank Service Charges Credit Card Fees Delivery Health Insurance Insurance Interest Inventory Purchases Miscellaneous Office Payroll Payroll Taxes Professional Fees Rent or Lease Subscriptions & Dues Supplies Taxes & Licenses Utilities & Telephone Other: Travel Maintenance Subtotal Other Cash Out Flows: Capital Purchases Loan Principal Owner's Draw Other: Subtotal Total Cash Outflows Ending Cash Balance

$206,200 $206,200 2,500 300 200 5,480 3,000 600 401 14,160 7,580 200 37,917 3,792 0 2,000 50 200 100 900 200 200 $79,780 60,000 2,778

$102,445 $166,087 2,500 300 200 5,480 3,000 600 401 12,912 6,956 200 37,917 3,792 0 2,000 50 200 100 900 1,000 200 $78,708

$108,431 $193,032 3,000 300 200 5,480 3,000 600 401 13,776 7,388 200 37,917 3,792 0 2,000 50 200 100 900 1,000 200 $80,504

$119,573 $229,323 5,000 300 200 5,480 3,000 600 401 15,216 8,108 200 37,917 3,792 0 2,000 50 200 100 900 1,000 200 $84,664

$126,443 $268,324 3,000 300 200 5,480 3,000 600 401 16,056 8,528 200 37,917 3,792 0 2,000 50 200 100 900 1,000 200 $83,924

$120,476 $302,098 3,000 300 200 5,480 3,000 600 401 15,216 8,108 200 37,917 3,792 0 2,000 50 200 100 900 1,000 200 $82,664

$118,703 $335,359 2,500 300 200 5,480 3,000 600 401 15,024 8,012 200 37,917 3,792 0 2,000 50 200 100 900 1,000 200 $81,876

$104,443 $355,148 2,000 300 200 5,480 3,000 600 401 13,824 7,412 200 37,917 3,792 0 2,000 50 200 100 900 1,000 200 $79,576

$98,532 $371,326 2,000 300 200 5,480 3,000 600 401 12,408 6,704 200 37,917 3,792 0 2,000 50 200 100 900 1,000 200 $77,452

$88,792 $379,888 3,000 300 200 5,480 3,000 600 401 11,184 6,092 200 37,917 3,792 0 2,000 50 200 100 900 1,000 200 $76,616

$67,427 $367,921 4,000 300 200 5,480 3,000 600 401 8,400 4,700 200 37,917 3,792 0 2,000 50 200 100 900 1,000 200 $73,440

$143,725 $435,428 5,000 300 200 5,480 3,000 600 401 18,720 9,860 200 37,917 3,792 0 2,000 50 200 100 900 200 200 $89,120

58,654 100,000 1,246,536 0 0 0 $1,405,190

37,500 3,600 2,400 65,760 36,000 7,200 4,812 166,896 89,448 2,400 455,004 45,504 0 24,000 600 2,400 1,200 10,800 0 10,400 2,400 0 $968,324 60,000 33,336 0 0 0 $93,336 $1,061,660

2,778

2,778

2,778

2,778

2,778

2,778

2,778

2,778

2,778

2,778

2,778

$62,778 $142,558 $63,642

$2,778 $81,486 $84,601

$2,778 $83,282 $109,750

$2,778 $87,442 $141,881

$2,778 $86,702 $181,622

$2,778 $85,442 $216,656

$2,778 $84,654 $250,705

$2,778 $82,354 $272,794

$2,778 $80,230 $291,096

$2,778 $79,394 $300,494

$2,778 $76,218 $291,703

$2,778 $91,898 $343,530

Note 1. Breakaway hopes to secure a $100,000 loan to purchase and install three new workstations to handle the expected increase in bicycle orders. The additional $40,000 would provide working capital during the expansion period. The loan would be for three years at a 9% interest rate.

Breakaway Bicycle Company, Inc. Cash Flow Budget Worksheet - 2001
Jan Beginning Cash Balance Cash Inflows (Income): Accts. Rec. Collections Loan Proceeds Sales & Receipts Other: Total Cash Inflows Available Cash Balance Cash Outflows (Expenses): Advertising Bank Service Charges Credit Card Fees Delivery Health Insurance Insurance Interest Inventory Purchases Miscellaneous Office Payroll Payroll Taxes Professional Fees Rent or Lease Subscriptions & Dues Supplies Taxes & Licenses Utilities & Telephone Other: Travel Maintenance Subtotal Other Cash Out Flows: Capital Purchases Loan Principal Owner's Draw Other: Subtotal Total Cash Outflows Ending Cash Balance Feb $32,058 0 128,160 5,605 117,180 Mar $60,937 5,111 117,360 Apr $89,066 5,453 127,800 May $123,789 6,023 137,160 Jun $168,670 6,356 129,600 Jul $210,320 6,023 124,920 Aug $247,321 5,947 111,420 Sep $269,258 5,472 102,240 Oct $280,168 4,912 93,060 Nov $284,334 4,427 77,940 Dec $271,759 3,325 190,800 Total

58,654 0 1,457,640 0 $1,516,294

$128,160 $128,160

$122,785 $154,843

$122,471 $183,408

$133,253 $222,319

$143,183 $266,972

$135,956 $304,626

$130,943 $341,263

$117,367 $364,688

$107,712 $376,970

$97,972 $378,140

$82,367 $366,701

$194,125 $465,884

2,700 300 200 6,000 3,000 600 401 17,088 9,044 200 44,583 4,458 0 2,100 50 400 100 900 1,000 200 $93,324

2,700 300 200 6,000 3,000 600 401 15,624 8,312 200 44,583 4,458 0 2,100 50 400 100 900 1,000 200 $91,128

3,100 300 200 6,000 3,000 600 401 15,648 8,324 200 44,583 4,458 0 2,100 50 400 100 900 1,000 200 $91,564

5,200 300 200 6,000 3,000 600 401 17,040 9,020 200 44,583 4,458 0 2,100 50 400 100 900 1,000 200 $95,752

3,100 300 200 6,000 3,000 600 401 18,288 9,644 200 44,583 4,458 0 2,100 50 400 100 900 1,000 200 $95,524

3,100 300 200 6,000 3,000 600 401 15,624 8,312 200 44,583 4,458 0 2,100 50 400 100 900 1,000 200 $91,528

2,700 300 200 6,000 3,000 600 401 15,648 8,324 200 44,583 4,458 0 2,100 50 400 100 900 1,000 200 $91,164

2,100 300 200 6,000 3,000 600 401 17,040 9,020 200 44,583 4,458 0 2,100 50 400 100 900 1,000 200 $92,652

2,100 300 200 6,000 3,000 600 401 18,288 9,644 200 44,583 4,458 0 2,100 50 400 100 900 500 200 $94,024

3,100 300 200 6,000 3,000 600 401 15,624 8,312 200 44,583 4,458 0 2,100 50 400 100 900 500 200 $91,028

4,200 300 200 6,000 3,000 600 401 15,648 8,324 200 44,583 4,458 0 2,100 50 400 100 900 500 200 $92,164

5,500 300 200 6,000 3,000 600 401 17,040 9,020 200 44,583 4,458 0 2,100 50 400 100 900 200 200 $95,252

39,600 3,600 2,400 72,000 36,000 7,200 4,812 198,600 105,300 2,400 534,996 53,496 0 25,200 600 4,800 1,200 10,800 0 9,700 2,400 0 $1,115,104 0 33,336 0 0 0 $33,336 $1,148,440

2,778

2,778

2,778

2,778

2,778

2,778

2,778

2,778

2,778

2,778

2,778

2,778

$2,778 $96,102 $32,058

$2,778 $93,906 $60,937

$2,778 $94,342 $89,066

$2,778 $98,530 $123,789

$2,778 $98,302 $168,670

$2,778 $94,306 $210,320

$2,778 $93,942 $247,321

$2,778 $95,430 $269,258

$2,778 $96,802 $280,168

$2,778 $93,806 $284,334

$2,778 $94,942 $271,759

$2,778 $98,030 $367,854

Note 1. Breakaway hopes to secure a $100,000 to purchase and install three new workstations in year 1 to handle the expected increase in bicycle orders. The additional $40,000 would provide working capital during the expansion period. The loan will be paid back over three years at a 9% interest rate.


				
DOCUMENT INFO
Shared By:
Categories:
Tags: Marketing
Stats:
views:306
posted:12/18/2007
language:English
pages:12