Estimated Cash flow (12 years) 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
1 2 3 4 5 6 7 8 9 10 11 12
Year 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Revenue
Yearly subscriptions $118,500.00 $244,110.00 $356,029.55 $379,831.91 $400,118.38 $412,121.93 $424,485.59 $437,220.16 $450,336.76 $463,846.87 $477,762.27 $492,095.14
Daily subscriptions $20,000.00 $20,600.00 $21,218.00 $21,854.54 $22,510.18 $23,185.48 $23,881.05 $24,597.48 $25,335.40 $26,095.46 $26,878.33 $27,684.68
3 day subscriptions $6,000.00 $9,270.00 $12,730.80 $13,112.72 $13,506.11 $13,911.29 $14,328.63 $14,758.49 $15,201.24 $15,657.28 $16,127.00 $16,610.81
Monthly subscriptions $2,900.00 $4,480.50 $6,153.22 $6,337.82 $6,527.95 $6,723.79 $6,925.50 $7,133.27 $7,347.27 $7,567.68 $7,794.72 $8,028.56
Hourly usage (over 30 min) $13,000.00 $22,660.00 $31,283.82 $33,218.90 $34,890.77 $35,937.50 $37,015.62 $38,126.09 $39,269.87 $40,447.97 $41,661.41 $42,911.25
Sponsors $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00
Advertising $20,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00
Total Revenue $220,400.00 $381,120.50 $507,415.39 $534,355.89 $557,553.39 $571,879.99 $586,636.39 $601,835.48 $617,490.55 $633,615.26 $650,223.72 $667,330.43
Expenses
Spring Installation costs incl
Employees:
Exec Dir - Part time commitment (20%) $13,440.00 $13,843.20 $14,258.50 $14,686.25 $15,126.84 $15,580.64 $16,048.06 $16,529.50 $17,025.39 $17,536.15 $18,062.24 $18,604.10
Operations Manager $54,600.00 $56,238.00 $57,925.14 $59,662.89 $61,452.78 $63,296.36 $65,195.26 $67,151.11 $69,165.65 $71,240.62 $73,377.83 $75,579.17
Bicycle Repair Technician $49,140.00 $50,614.20 $52,132.63 $53,696.60 $55,307.50 $56,966.73 $58,675.73 $60,436.00 $62,249.08 $64,116.55 $66,040.05 $68,021.25
Storefront and Repair Shop rent $15,600.00 $16,068.00 $16,550.04 $17,046.54 $17,557.94 $18,084.68 $18,627.22 $19,186.03 $19,761.61 $20,354.46 $20,965.10 $21,594.05
Warehouse to store bikes during off-season
Bicycle Repair Tools incl
Bicycle Maintenance Contract
Customer service, etc, provided by BIXI $22,000.00 $22,660.00 $23,339.80 $24,039.99 $24,761.19 $25,504.03 $26,269.15 $27,057.23 $27,868.94 $28,705.01 $29,566.16 $30,453.15
Website upkeep $10,000.00 $10,300.00 $10,609.00 $10,927.27 $11,255.09 $11,592.74 $11,940.52 $12,298.74 $12,667.70 $13,047.73 $13,439.16 $13,842.34
Marketing/promotional expenses $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00
Insurance (ballpark estimate) $50,000.00 $51,500.00 $53,045.00 $54,636.35 $56,275.44 $57,963.70 $59,702.61 $61,493.69 $63,338.50 $65,238.66 $67,195.82 $69,211.69
Legal fees $2,000.00 $2,060.00 $2,121.80 $2,185.45 $2,251.02 $2,318.55 $2,388.10 $2,459.75 $2,533.54 $2,609.55 $2,687.83 $2,768.47
Replacements due to theft and vandalism $20,000.00 $20,600.00 $21,218.00 $21,854.54 $22,510.18 $23,185.48 $23,881.05 $24,597.48 $25,335.40 $26,095.46 $26,878.33 $27,684.68
Replacements due to end of lifespan of bicycles $0.00 $0.00 $0.00 $0.00 $106,336.27 $10,952.64 $16,921.82 $17,429.48 $17,952.36 $91,282.34 $26,543.18 $31,200.69
Parts replacement on bicycles $3,500.00 $5,407.50 $5,569.73 $5,736.82 $5,908.92 $6,086.19 $6,268.77 $6,456.84 $6,650.54 $6,850.06 $7,055.56 $7,267.23
Battery replacements $0.00 $0.00 $100.00 $400.00 $1,000.00 $400.00 $100.00 $100.00 $400.00 $1,000.00 $400.00 $100.00
Replacement of kiosks $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $27,672.16 $114,009.31 $293,573.97 $120,952.47 $31,145.26
Administration $40,017.00 $40,992.51 $41,997.29 $43,032.20 $44,098.17 $45,196.12 $46,327.00 $47,491.81 $48,691.56 $49,927.31 $51,200.13 $52,511.13
Contingency
Capital Reserve Contribution
Total Expenses $330,297.00 $340,283.41 $348,866.91 $357,904.92 $473,841.34 $387,127.86 $402,345.30 $440,359.82 $537,649.59 $801,577.87 $574,363.86 $499,983.21
Debt Service
Profit or Loss for the Year -$109,897.00 $40,837.09 $158,548.48 $176,450.97 $83,712.05 $184,752.13 $184,291.09 $161,475.66 $79,840.95 -$167,962.60 $75,859.86 $167,347.22
Reserve Account Balance -$109,897.00 -$69,059.91 $89,488.57 $265,939.54 $349,651.59 $534,403.72 $718,694.81 $880,170.47 $960,011.42 $792,048.82 $867,908.68 $1,035,255.90
Inflation rate 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3%
Price of one new bike $1,000.00 $1,030.00 $1,060.90 $1,092.73 $1,125.51 $1,159.27 $1,194.05 $1,229.87 $1,266.77 $1,304.77 $1,343.92 $1,384.23
Interest rate 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6%