bbc_fncl.xls
of 12
-
Upload
saravanan-rasaya -
Category
Documents
-
view
218 -
download
0
Transcript of bbc_fncl.xls
-
7/28/2019 bbc_fncl.xls
1/12
Breakaway Bicycle Company, Inc.
Balance Sheet - December 31, 2000
Assets
Current Assets:
Cash RM 50,000.00
Accounts Receivable RM 20,000.00
Less: Reserve for Bad Debts 5,000 15,000
Merchandise Inventory 5,000
Prepaid Expenses 500
Notes Receivable 0
Total Current Assets RM 70,500.00
Fixed Assets:
Vehicles 15,000
Less: Accumulated Depreciation 15,000 0
Furniture and Fixtures 15,000
Less: Accumulated Depreciation 5,000 10,000
Equipment 100,000Less: Accumulated Depreciation 48,000 52,000
Total Fixed Assets 62,000
Other Assets:
Goodwill 0
Total Other Assets 0
Total Assets RM 132,500.00
Liabilities and Capital
Current Liabilities:
Accounts Payable RM 4,200.00
Sales Taxes Payable 2,000
Payroll Taxes Payable 1,523
Accrued Wages Payable 4,125
Unearned Revenues 20,000
Total Current Liabilities RM 31,848.00
Long-Term Liabilities:
Long-Term Notes Payable 0
Mortgage Payable 0
Total Long-Term Liabilities 0
Total Liabilities 31,848
Capital:
-
7/28/2019 bbc_fncl.xls
2/12
Breakaway Bicycle Company, Inc.
Income Statement - 12/31/00
Revenue:Gross Sales ###
Less: Sales Returns and Allowances 22,890
Net Sales 1,034,118
Cost of Goods Sold: Beginning Inventory RM 15,000.00
Add: Purchases 124,500
Freight-in 2,500Direct Labor 241,000
Indirect Expenses 0
383,000
Less: Ending Inventory 16,500
Cost of Goods Sold 366,500
Gross Profit (Loss) 667,618
Expenses:
Advertising 47,000Amortization 0
Bad Debts 42,280
Bank Charges 3,600
Charitable Contributions 2,500
Commissions 0
Contract Labor 0
Credit Card Fees 2,400
Delivery Expenses 65,760
Depreciation 10,000
Dues and Subscriptions 600Insurance 7,200
Interest 0
Maintenance 2,400
Miscellaneous 0
Office Expenses 2,400
Operating Supplies 2,400
Payroll Taxes 42,500
Permits and Licenses 1,200
Postage 2,400
Professional Fees 2,400
Property Taxes 0
Rent 24,000
Repairs 0
Telephone 5,200
Travel 9,000
Utilities 6,000
Vehicle Expenses 2,510
Wages 205,000
Total Expenses 488,750
Net Operating Income 178,868
-
7/28/2019 bbc_fncl.xls
3/12
Breakaway Bicycle Company, Inc.Cash Flow Worksheet for 2000
January February March April May June July August September October November December Total
Beginning Cash Balance ### ### ### ### ### ### ### ### ### ### ###
Cash Inflows (Income):
Accts. Rec. Collections 8,500 8,000 7,000 7,850 7,952 6,210 5,260 9,850 9,852 7,888 9,520 7,550 95,432
Sales & Receipts 65,000 75,000 85,996 86,000 84,520 85,115 88,500 83,339 70,520 62,500 55,000 81,000 922,490
Total Cash Inflows ### ### ### ### ### ### ### ### ### ### ### ### ###
Available Cash Balance ### ### ### ### ### ### ### ### ### ### ### ###
Cash Outflows (Expenses):
Advertising 1,500 2,500 1,000 3,000 1,500 4,500 1,500 2,500 1,000 3,000 1,500 4,500 28,000
Bank Service Charges 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Credit Card Fees 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Delivery 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 54,000
Health Insurance 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 14,400
Insurance 600 600 600 600 600 600 600 600 600 600 600 600 7,200
Inventory Purchases 13,050 14,550 7,804 18,800 16,654 14,445 14,800 13,200 11,587 12,589 12,300 11,899 161,678
Miscellaneous 15,000 7,899 12,500 15,000 8,500 6,520 5,500 7,700 5,420 8,787 6,002 6,000 104,828
Office 200 200 200 200 200 200 200 200 200 200 200 200 2,400Payroll 28,000 28,000 28,000 28,000 28,000 28,000 28,000 28,000 28,000 28,000 28,000 28,000 336,000
Payroll Taxes 2,800 2,800 2,800 2,800 2,800 2,800 2,800 2,800 2,800 2,800 2,800 2,800 33,600
Rent or Lease 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 1,200 14,400
Subscriptions & Dues 50 50 50 50 50 50 50 50 50 50 50 50 600
Supplies 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Taxes & Licenses 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Utili ties & Telephone 500 500 500 500 500 500 500 500 500 500 500 500 6,000
Subtotal ### ### ### ### ### ### ### ### ### ### ### ### ###
Other Cash Outflows
Owner's Draw 500 2,500 5,100 10,000 12,000 8,500 18,750 57,350
Subtotal ### $ ### RM 0.00 ### RM 0.00 ### RM 0.00 ### RM 0.00 ### ### ###
Total Cash Outflows ### ### ### ### ### ### ### ### ### ### ### ### ###
Ending Cash Balance ### ### ### ### ### ### ### ### ### ### ### ###
-
7/28/2019 bbc_fncl.xls
4/12
Breakaway Bicycle Company, Inc.
Pro Forma Balance Sheet - 12/31/00
Assets
Current Assets:
Cash RM 452,578.00
Accounts Receivable RM 74,520.00
Less: Reserve for Bad Debts 7,452 67,068
Merchandise Inventory 21,000
Prepaid Expenses 5,000
Notes Receivable 0
Total Current Assets ###
Fixed Assets:
Vehicles 0
Less: Accumulated Depreciation 0 0
Furniture and Fixtures 25,000
Less: Accumulated Depreciation 7,000 18,000
Equipment 160,000
Less: Accumulated Depreciation 54,000 106,000
Buildings 0
Less: Accumulated Depreciation 0 0
Land 0
Total Fixed Assets 124,000
Other Assets:
Goodwill 0
Total Other Assets 0
Total Assets ###
Liabilities and Capital
Current Liabilities:
Accounts Payable RM 5,500.00
Sales Taxes Payable 400
Payroll Taxes Payable 16,000
Accrued Wages Payable 55,880
Unearned Revenues 15,060Short-Term Notes Payable 0
Short-Term Bank Loan Payable 0
Total Current Liabilities ###
Long-Term Liabilities:
Long-Term Notes Payable 75,000
Mortgage Payable 0
Total Long-Term Liabilities 75,000
Total Liabilities 167,840
-
7/28/2019 bbc_fncl.xls
5/12
Breakaway Bicycle Company, Inc.
Pro Forma Balance Sheet - 12/31/01
Assets
Current Assets:
Cash RM 815,840.00
Accounts Receivable RM 22,000.00
Less: Reserve for Bad Debts 1,980 20,020
Merchandise Inventory 15,000
Prepaid Expenses 5,200
Notes Receivable 0Total Current Assets RM 856,060.00
Fixed Assets:
Vehicles 0
Less: Accumulated Depreciation 0 0
Furniture and Fixtures 25,000
Less: Accumulated Depreciation 9,000 16,000
Equipment 160,000
Less: Accumulated Depreciation 60,000 100,000
Buildings 0
Less: Accumulated Depreciation 0 0
Land 0Total Fixed Assets 116,000
Other Assets:
Goodwill 0
Total Other Assets 0
Total Assets RM 972,060.00
Liabilities and Capital
Current Liabilities:
Accounts Payable RM 7,500.00
Sales Taxes Payable 800
Payroll Taxes Payable 17,500
Accrued Wages Payable 60,000Unearned Revenues 78,000
Short-Term Notes Payable 0Short-Term Bank Loan Payable 0
Total Current Liabilities RM 163,800.00
Long-Term Liabilities: Long-Term Notes Payable 50,000
Mortgage Payable 0Total Long-Term Liabilities 50,000
Total Liabilities 213,800
-
7/28/2019 bbc_fncl.xls
6/12
Breakaway Bicycle Company, Inc.Revenue Projections2000
January February March April May June July August September October November
NUMBER OF:
Road Frames 30 26 30 34 36 34 38 32 29 26 22
Mountain Frames 40 38 38 41 43 41 40 36 32 29 19
INCOME GENERATED FROM:
European Sales -Road Frames ($1,800/frame) RM 10,800.00 RM 9,360.00 RM 10,800.00 RM 12,240.00 RM 12,960.00 RM 12,240.00 RM 12,240.00 RM 11,520.00 RM 10,440.00 RM 9,360.00 RM 7,920.0
U.S. Sales - Road ($1,800/frame) RM 43,200.00 RM 37,440.00 RM 43,200.00 RM 48,960.00 RM 51,840.00 RM 48,960.00 RM 48,960.00 RM 46,080.00 RM 41,760.00 RM 37,440.00 RM 31,680.0European Sales - Mountain ($1,600/frame) RM 32,000.00 RM 30,400.00 RM 30,400.00 RM 32,800.00 RM 34,400.00 RM 32,800.00 RM 32,000.00 RM 28,800.00 RM 25,600.00 RM 23,200.00 RM 15,200.0
U.S. Sales - Mountain ($1,600/frame) RM 32,000.00 RM 30,400.00 RM 30,400.00 RM 32,800.00 RM 34,400.00 RM 32,800.00 RM 32,000.00 RM 28,800.00 RM 25,600.00 RM 23,200.00 RM 15,200.0
### ### ### RM 126,800.00 ### ### ### ### RM 103,400.00 RM 93,200.00 RM 70,000.0
2001January February March April May June July August September October November
NUMBER OF:Road Frames 40 35 36 38 42 40 38 35 32 29 25
Mountain Frames 44 42 41 46 48 45 44 38 35 32 26
INCOME GENERATED FROM:
European Sales -Road Frames ($1,800/frame) RM 14,400.00 RM 12,600.00 RM 12,960.00 RM 13,680.00 RM 15,120.00 RM 14,400.00 RM 13,680.00 RM 12,600.00 RM 11,520.00 RM 10,440.00 RM 9,000.0
U.S. Sales - Road ($1,800/frame) RM 57,600.00 RM 50,400.00 RM 51,840.00 RM 54,720.00 RM 60,480.00 RM 57,600.00 RM 54,720.00 RM 50,400.00 RM 46,080.00 RM 41,760.00 RM 36,000.0
European Sales - Mountain ($1,600/frame) RM 35,200.00 RM 33,600.00 RM 32,800.00 RM 36,800.00 RM 38,400.00 RM 36,000.00 RM 35,200.00 RM 30,400.00 RM 28,000.00 RM 25,600.00 RM 20,800.0
U.S. Sales - Mountain ($1,600/frame) RM 35,200.00 RM 33,600.00 RM 32,800.00 RM 36,800.00 RM 38,400.00 RM 36,000.00 RM 35,200.00 RM 30,400.00 RM 28,000.00 RM 25,600.00 RM 20,800.0
### ### ### RM 142,000.00 ### ### ### ### RM 113,600.00 ### RM 86,600.0
-
7/28/2019 bbc_fncl.xls
7/12
-
7/28/2019 bbc_fncl.xls
8/12
January
February
March April May June July August
September
October
November
December
RM 0.00
RM 50,000.00
RM 100,000.00
RM 150,000.00
RM 200,000.00
RM 250,000.00
Projected Revenue - 2001
Mont
hlyRevenu
e
-
7/28/2019 bbc_fncl.xls
9/12
Breakaway Bicycle Company, Inc.
Projected Profit and Loss Statement - 2000
January February March April May June July August September October November
Revenue:
Gross Sales ### 107,600 ### ### ### ### ### ### ### ### ###Less: Sales Returns and Allowances 5,900 5,380 5,740 6,340 6,690 6,340 6,260 5,760 5,170 4,660 3,500
Net Sales ### ### ### ### ### ### ### ### ### ### ###
Cost of Goods Sold:
Materials 14,160 12,912 13,776 15,216 16,056 15,216 15,024 13,824 12,408 11,184 8,400
Labor 14,160 12,912 13,776 15,216 16,056 15,216 15,024 13,824 12,408 11,184 8,400
Other Direct Expenses 5,310 4,842 5,166 5,706 6,021 5,706 5,634 5,184 4,653 4,194 3,150
Indirect Expenses 1,770 1 ,614 1,722 1,902 2,007 1,902 1,878 1,728 1 ,551 1 ,398 1 ,050
Cost of Goods Sold ### ### ### ### ### ### ### ### ### ### ###
Gross Profit (Loss) ### ### ### ### ### ### ### ### ### ### ###
Expenses:
Advertising 2,500 2,500 3,000 5,000 3,000 3,000 2,500 2,000 2,000 3,000 4,000
Bad Debts 5,605 5,111 5,453 6,023 6,356 6,023 5,947 5,472 4,912 4,427 3,325
Bank Charges 300 300 300 300 300 300 300 300 300 300 300
Charitable Contributions 100 100 100 100 100 100 100 100 100 100 100
Credit Card Fees 0 0 0 0 0 0 0 0 0 0 0
Delivery Expenses 200 200 200 200 200 200 200 200 200 200 200
Depreciation 5,480 5,480 5,480 5,480 5,480 5,480 5,480 5,480 5,480 5,480 5,480
Dues and Subscriptions 888 888 888 888 888 888 888 888 888 888 888
Insurance 50 50 50 50 50 50 50 50 50 50 50
Interest 600 600 600 600 600 600 600 600 600 600 600
Maintenance 401 401 401 401 401 401 401 401 401 401 401
Miscellaneous 200 200 200 200 200 200 200 200 200 200 200
Office Expenses 500 500 500 500 500 500 500 500 500 500 500
Operating Supplies 200 200 200 200 200 200 200 200 200 200 200
Payroll Taxes 200 200 200 200 200 200 200 200 200 200 200
Permits and Licenses 3,792 3,792 3,792 3,792 3,792 3,792 3,792 3,792 3,792 3,792 3,792
Postage 100 100 100 100 100 100 100 100 100 100 100
Rent 200 200 200 200 200 200 200 200 200 200 200Telephone 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200
Travel 400 400 400 400 400 400 400 400 400 400 400
Utilities 200 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Wages 500 500 500 500 500 500 500 500 500 500 500
Wages 23,757 25,005 37,917 22,701 21,861 22,701 22,893 24,093 25,509 26,733 29,517
Total Expenses 49,373 50,927 64,681 52,035 49,528 50,035 49,651 49,876 50,932 52,671 55,353
Net Operating Income 27,327 19,013 9,939 30,385 37,443 32,385 31,729 25,004 16,279 7,909 (9,853)
Other Income:Gain (Loss) on Sale of Assets 0 0 0 0 0 0 0 0 0 0 0
Interest Income 0 0 0 0 0 0 0 0 0 0 0
Total Other Income 0 0 0 0 0 0 0 0 0 0 0
Net Income (Loss) ### 19,013 ### ### ### ### ### ### ### ### ###
Cumulative Net Income (Loss) ### 46,340 ### ### ### ### ### ### ### ### ###
-
7/28/2019 bbc_fncl.xls
10/12
Breakaway Bicycle Company, Inc.
Projected Profit and Loss Statement - 2001
January February March April May June July August September October November Revenue:
Gross Sales ### ### ### ### ### ### ### ### ### ### ###
Less: Sales Returns and Allowances 7,120 6,510 6,520 7,100 7,620 7,200 6,940 6,190 5,680 5,170 4,330
Net Sales ### ### ### ### ### ### ### ### ### ### ###
Cost of Goods Sold:
Materials 17,088 15,624 15,648 17,040 18,288 15,624 15,648 17,040 18,288 15,624 15,648
Labor 17,088 15,624 15,648 17,040 18,288 15,624 15,648 17,040 18,288 15,624 15,648
Other Direct Expenses 6,408 5,859 5,868 6,390 6,858 5,859 5,868 6,390 6,858 5,859 5,868
Indirect Expenses 2,136 1,953 1 ,956 2,130 2,286 1,953 1,956 2,130 2,286 1,953 1,956Cost of Goods Sold ### ### ### 42,600 45,720 39,060 39,120 42,600 45,720 ### ###
Gross Profit (Loss) ### ### ### ### ### ### ### ### ### ### ###
Expenses:
Advertising 2,700 2,700 3,100 5,200 3,100 3,100 2,700 2,100 2,100 3,100 4,200
Bad Debts 6,764 6,185 6,194 6,745 7,239 6,840 6,593 5,881 5,396 4,912 4,114
Bank Charges 300 300 300 300 300 300 300 300 300 300 300
Charitable Contributions 100 100 100 100 100 100 100 100 100 100 100
Credit Card Fees 200 200 200 200 200 200 200 200 200 200 200
Delivery Expenses 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000
Depreciation 888 888 888 888 888 888 888 888 888 888 888
Dues and Subscriptions 50 50 50 50 50 50 50 50 50 50 50
Insurance 600 600 600 600 600 600 600 600 600 600 600
Interest 401 401 401 401 401 401 401 401 401 401 401
Maintenance 200 200 200 200 200 200 200 200 200 200 200
Miscellaneous 500 500 500 500 500 500 500 500 500 500 500
Office Expenses 200 200 200 200 200 200 200 200 200 200 200
Operating Supplies 200 200 200 200 200 200 200 200 200 200 200
Payroll Taxes 2,750 2,923 2,894 2,754 2,630 2,896 2,894 2,754 2,630 2,896 2,894
Permits and Licenses 100 100 100 100 100 100 100 100 100 100 100Postage 400 400 400 400 400 400 400 400 400 400 400
Rent 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200 3,200
Telephone 400 400 400 400 400 400 400 400 400 400 400
Travel 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 500 500 500
Utilities 500 500 500 500 500 500 500 500 500 500 500
Wages 27,495 29,229 28,935 27,543 26,295 28,959 28,935 27,543 26,295 28,959 28,935
Total Expenses ### ### ### ### ### ### ### ### ### ### ###
Net Operating Income ### ### ### ### ### ### ### ### ### ### ###
Other Income:
Gain (Loss) on Sale of Assets 0 0 0 0 0 0 0 0 0 0 0
Interest Income 0 0 0 0 0 0 0 0 0 0 0
Total Other Income 0 0 0 0 0 0 0 0 0 0 0
Net Income (Loss) ### ### ### ### ### ### ### ### ### ### ###
Cumulative Net Income (Loss) ### ### ### ### ### ### ### ### ### ### ###
-
7/28/2019 bbc_fncl.xls
11/12
Breakaway Bicycle Company, Inc.
Cash Flow Budget Worksheet - 2000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Beginning Cash Balance ### ### ### ### ### ### ### ### ### ### ###
Cash Inflows (Income):
Accounts Receivable Collections 0 5,605 5,111 5,453 6,023 6,356 6,023 5,947 5,472 4,912 4,427 3,325 58,654
Loan Proceeds 100,000 100,000
Sales & Receipts 106,200 96,840 103,320 114,120 120,420 114,120 112,680 98,496 93,060 83,880 63,000 140,400 1,246,536
Other: 0
0
0
Total Cash Inflows ### ### ### ### ### ### ### ### ### ### ### ### ###
Available Cash Balance ### ### ### ### ### ### ### ### ### ### ### ###
Cash Outflows (Expenses):
Advertising 2,500 2,500 3,000 5,000 3,000 3,000 2,500 2,000 2,000 3,000 4,000 5,000 37,500
Bank Service Charges 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Credit Card Fees 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Delivery 5,480 5,480 5,480 5,480 5,480 5,480 5,480 5,480 5,480 5,480 5,480 5,480 65,760
Health Insurance 3,000 3 ,000 3 ,000 3 ,000 3,000 3 ,000 3,000 3,000 3 ,000 3 ,000 3 ,000 3,000 36,000
Insurance 600 600 600 600 600 600 600 600 600 600 600 600 7,200
Interest 401 401 401 401 401 401 401 401 401 401 401 401 4,812
Inventory Purchases 14,160 12,912 13,776 15,216 16,056 15,216 15,024 13,824 12,408 11,184 8,400 18,720 166,896Miscellaneous 7,580 6,956 7,388 8,108 8,528 8,108 8,012 7,412 6,704 6,092 4,700 9,860 89,448
Office 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Payroll 37,917 37,917 37,917 37,917 37,917 37,917 37,917 37,917 37,917 37,917 37,917 37,917 4 55,004
Payroll Taxes 3,792 3,792 3,792 3,792 3,792 3,792 3,792 3,792 3,792 3 ,792 3,792 3,792 45,504
Professional Fees 0 0 0 0 0 0 0 0 0 0 0 0 0
Rent or Lease 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000
Subscriptions & Dues 50 50 50 50 50 50 50 50 50 50 50 50 600
Supplies 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Taxes & Licenses 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Utilities & Telephone 900 900 900 900 900 900 900 900 900 900 900 900 10,800
Other: 0
Travel 200 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 200 10,400
Maintenance 200 200 200 200 200 200 200 200 200 200 200 200 2,400
0
Subtotal ### ### ### ### ### ### ### ### ### ### ### ### ###
Other Cash Out Flows:
Capital Purchases 60,000 60,000
Loan Principal 2,778 2,778 2,778 2,778 2 ,778 2,778 2 ,778 2,778 2,778 2,778 2,778 2 ,778 33,336
Owner's Draw 0
Other: 0
0Subtotal ### ### ### ### ### ### ### ### ### ### ### ### ###
Total Cash Outflows ### ### ### ### ### ### ### ### ### ### ### ### ###
Ending Cash Balance ### ### ### ### ### ### ### ### ### ### ### ###
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.
-
7/28/2019 bbc_fncl.xls
12/12
Breakaway Bicycle Company, Inc.
Cash Flow Budget Worksheet - 2001
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Beginning Cash Balance ### ### ### ### ### ### ### ### ### ### ###
Cash Inflows (Income):
Accts. Rec. Collections 0 5,605 5,111 5,453 6,023 6,356 6,023 5,947 5,472 4,912 4,427 3,325 58,654
Loan Proceeds 0
Sales & Receipts 128,160 117,180 117,360 127,800 137,160 129,600 124,920 111,420 102,240 93,060 77,940 190,800 1,457,640
Other: 0
Total Cash Inflows ### ### ### ### ### ### ### ### ### ### ### ### ###
Available Cash Balance ### ### ### ### ### ### ### ### ### ### ### ###
Cash Outflows (Expenses):
Advertising 2,700 2,700 3,100 5,200 3,100 3,100 2,700 2,100 2,100 3,100 4,200 5,500 39,600
Bank Service Charges 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Credit Card Fees 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Delivery 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 72,000
Health Insurance 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 36,000
Insurance 600 600 600 600 600 600 600 600 600 600 600 600 7,200
Interest 401 401 401 401 401 401 401 401 401 401 401 401 4,812
Inventory Purchases 17,088 15,624 15,648 17,040 18,288 15,624 15,648 17,040 18,288 15,624 15,648 17,040 198,600Miscellaneous 9,044 8,312 8,324 9,020 9,644 8,312 8,324 9,020 9,644 8,312 8,324 9,020 105,300
Office 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Payroll 44,583 44,583 44,583 44,583 44,583 44,583 44,583 44,583 44,583 44,583 44,583 44,583 534,996
Payrol l Taxes 4,458 4,458 4,458 4,458 4,458 4,458 4,458 4,458 4,458 4,458 4,458 4,458 53,496
Professional Fees 0 0 0 0 0 0 0 0 0 0 0 0 0
Rent or Lease 2,100 2,100 2,100 2,100 2,100 2,100 2,100 2,100 2,100 2,100 2,100 2,100 25,200
Subscriptions & Dues 50 50 50 50 50 50 50 50 50 50 50 50 600
Supplies 400 400 400 400 400 400 400 400 400 400 400 400 4,800
Taxes & Licenses 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Utili ties & Telephone 900 900 900 900 900 900 900 900 900 900 900 900 10,800
Other: 0
Travel 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 500 500 500 200 9,700
Maintenance 200 200 200 200 200 200 200 200 200 200 200 200 2,400
0
Subtotal ### ### ### ### ### ### ### ### ### ### ### ### ###
Other Cash Out Flows:
Capital Purchases 0
Loan Principal 2,778 2,778 2,778 2,778 2,778 2,778 2,778 2,778 2,778 2,778 2,778 2,778 33,336
Owner's Draw 0
Other: 0
0Subtotal ### ### ### ### ### ### ### ### ### ### ### ### ###
Total Cash Outflows ### ### ### ### ### ### ### ### ### ### ### ### ###
Ending Cash Balance ### ### ### ### ### ### ### ### ### ### ### ###
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.
