Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

IndyVenue Business Plan Financials

VIEWS: 6 PAGES: 13

									PROJECTED BALANCE SHEET
IndyVenue.com
Tommy Mitchell, Brad Shepherd, Ryan Jones


ASSETS                                              2010           2011             2012
Current Assets
Cash and Cash Equivalents                     $   528,194    $ 1,487,406    $   3,904,990
Accounts receivable                               29,565         88,695          177,390
Inventory                                               -              -                -
Prepaid expenses                                        -              -                -
Other current assets                                    -              -                -
Total Current Assets                          $   557,759    $ 1,576,101    $   4,082,380


Fixed Assets
Machinery and equipment                       $    5,000     $    5,000     $      5,000
Furniture and fixtures                                  -              -                -
Leasehold improvements                                  -              -                -
Land and buildings                                      -              -                -
Other fixed assets                                      -              -                -
(LESS accumulated depreciation on all fixed        (1,000)        (2,000)         (3,000)
assets)
Total Fixed Assets (net of depreciation)      $    4,000     $    3,000     $      2,000


Other Assets
Intangibles                                   $         -    $         -    $           -
Deposits                                                -              -                -
Goodwill                                                -              -                -
Other                                                   -              -                -
Total Other Assets                            $         -    $         -    $           -


TOTAL Assets                                  $   561,759    $ 1,579,101    $   4,084,380


LIABILITIES AND EQUITY
Current Liabilities
Accounts payable                              $    49,275    $   147,825    $    295,650
Interest payable                                        -              -                -
Taxes payable                                           -              -                -
Notes, short-term (due within 12 months)                -              -                -
Current part, long-term debt                            -              -                -
Other current liabilities                               -              -                -
Total Current Liabilities                     $    49,275    $   147,825    $    295,650


Long-Term Debt
Bank loans payable                            $         -    $         -    $           -
Notes payable to stockholders                           -              -                -
LESS: Short-term portion                                -              -                -
Other long-term debt                                    -              -                -
Total Long-Term Debt                          $         -    $         -    $           -


Total Liabilities                             $    49,275    $   147,825    $    295,650
Owners' Equity
Invested capital                $   300,000   $   300,000   $    300,000
Retained earnings - beginning             -       212,484       1,131,276
Retained earnings - current         212,484       918,792       2,357,454
Total Owners' Equity            $   512,484   $ 1,431,276   $   3,788,730


Total Liabilities and Equity    $   561,759   $ 1,579,101   $   4,084,380
-   -   -
Comparative Income Statement
IndyVenue.com

Financial statements in U.S. dollars      2010       2011          2012
Revenue
    Gross Sales                          3,285,000   9,855,000   19,710,000
    Less: Sales Returns and Allowances
      Net Sales                          3,285,000   9,855,000   19,710,000

Cost of Goods Sold
    Beginning Inventory
    Add:       70% Artist Portion        2,299,500   6,898,500   13,797,000
               Freight-in
               Direct Labor
               Indirect Expenses
    Inventory Available                  2,299,500   6,898,500   13,797,000
    Less: Ending Inventory
       Cost of Goods Sold                2,299,500   6,898,500   13,797,000

       Gross Profit (Loss)                985,500    2,956,500    5,913,000

Expenses
    Advertising                                       250,000
    Amortization
    Bad Debts
    Bandwidth/Web Hosting                  96,360     289,080      578,160
    Bank Charges                           98,550     295,650      591,300
    Charitable Contributions
    Commissions
    Contract Labor
    Depreciation                            1,000       1,000         1,000
    Dues and Subscriptions
    Employee Benefit Programs
    Insurance
    Interest
    IT Professional Fees                   75,000      25,000       25,000
    Legal and Professional Fees            20,000
    Licenses and Fees
    Miscellaneous
    Office Expense
    Payroll Taxes                          36,000      60,000       84,000
    Postage
    Rent                                    3,000       3,000         3,000
    Repairs and Maintenance
    Supplies
    Telephone                                 250         250          250
    Travel
    Utilities                               1,200       1,200         1,200
    Vehicle Expenses
    Wages                                 300,000      500,000      700,000
       Total Expenses                     631,360    1,425,180    1,983,910
     Net Operating Income      354,140     1,531,320       3,929,090

Taxes
   Income Tax                  (141,656)       (612,528)   (1,571,636)

     Total Income Tax          (141,656)       (612,528)   (1,571,636)

     Net Income (Loss)         212,484         918,792     2,357,454

Valuation                   PV of Net Income               1,207,016
                            Investment                       300,000
                            Value                                25%
PROJECTED CASHFLOW STATEMENT
IndyVenue.com


Cash Provided (used) by Operations                  2010       2011       2012
Net Income                                          212,484    918,792    2,357,454
Plus Depreciation                                     1,000      1,000       1,000
Change in Working Capital
            Decrease (increase) in Receivables      (29,565)   (59,130)     (88,695)
            Decrease (increase) in Inventory
            Increase (decrease) in Accts. Payable    49,275     98,550     147,825
            Cash Provided by Operations             233,194    959,212    2,417,584
Cash Provided (used) by Investments
Additions to PP&E                                    (5,000)
Other Investments
            Cash Provided by Investments             (5,000)          0           0
Cash Provided (used) by Financing Activities
            Additions (reductions) to Debt
            Net issues of Stock                     300,000
            (Dividends)
            Cash Provided by Financing Activities   300,000           0           0
Net increase (decrease) in cash                     528,194    959,212    2,417,584


Equity Valuation Cash Flow                          528,194    959,212    2,417,584
                                        IndyVenue    IndyVenue
                                                                  GOOGLE    APPLE
IndyVenue.com                              2011         2012
Liquidity Ratios
              Current Ratio                  10.83        12.76     11.91      2.11
Profitability Ratios
              Gross profit margin             30%          30%       62%       35%
              Operating profit margin         16%          20%       28%       20%
              Net Profit margin                9%          12%       21%       15%
Financial Strength
              Debt to Equity                   0%           0%        0%        0%
Efficiency and Return Ratios
              Return on Investment            25%          25%       15%       19%
              Return on equity                95%          90%       16%       23%
Assumptions                       2010            2011             2012
Songs sold                       3,285,000        9,855,000       19,710,000
Revenue/song                  $       0.30    $        0.30    $        0.30
Total Revenue                      985,500        2,956,500        5,913,000
Listeners / Hour                     5,000           15,000           30,000
Listeners / Day                    120,000          360,000          720,000
Songs/ hour                         75,000          225,000          450,000
Songs ./ per day                 1,800,000        5,400,000       10,800,000
Songs / year                   657,000,000    1,971,000,000    3,942,000,000
Purchase 0.5%                    3,285,000        9,855,000       19,710,000
Bandwidth
Listeners /minute                        83              250                 500
Bandwidth Cost / minute       $     0.0020    $      0.0020    $         0.0020 Based on 2006 Youtube/ limelight
Bandwidth/Minute              $        0.18   $         0.55   $            1.10 extra 10% based on uploads
Bandwidth/ hour               $      11.00    $       33.00    $          66.00
Bandwidth / Day               $     264.00    $      792.00    $       1,584.00
Bandwidth / Year              $     96,360    $     289,080    $        578,160



Bandwith                      one penny for every minute of video streamed
Youtube                       spends $1 million / month for 13 million views
required $11.5 million in venture capital to start
Audio file is aprox 15% - 20% of video file
Bandwicth is 20% of 1 cent for every minute


Pandora has 16 Milliong subscribers
went from 8 million to 16 million after they submited the iphone app

Pandora expects to pay 18 million in royalties in 2008
.0014 cents per song
15 songs per hour
24 hours per day

give artist buy rate
ased on 2006 Youtube/ limelight Bandwidth rates
xtra 10% based on uploads




            forbes.com    Your Tube whose dime
Valuation Ratios                  GOOGLE

                                       Company            Industry            Sector             S&P 500
P/E Ratio (TTM)                              36                   13                   34               43
P/E High - Last 5 Yrs.                      264                    4                    3               25
P/E Low - Last 5 Yrs.                        18                    1                    0                6

Beta                                             1                   1                 1                   1

Price to Sales (TTM)                           7                   1                    1                2
Price to Book (MRQ)                            5                   4                    2                3
Price to Tangible Book (MRQ)                   6                   4                    3                6
Price to Cash Flow (TTM)                      27                   4                    5               15
Price to Free Cash Flow (TTM)                 24                  21                   14               18

% Owned Institutions              --                 --                  --                 --

Dividends
                                   Company                Industry            Sector             S&P 500
Dividend Yield                    NA                               0                    0                  1
Dividend Yield - 5 Year Avg.                     0                 1                    1                  3
Dividend 5 Year Growth Rate       --                              14                   13                  9

Payout Ratio(TTM)                                0                   4                 27               86

Growth Rates
                                       Company            Industry            Sector             S&P 500
Sales (MRQ) vs Qtr. 1 Yr. Ago                  3                  (3)              (12)                 (6)
Sales (TTM) vs TTM 1 Yr. Ago                  14                    4                (4)                (2)
Sales - 5 Yr. Growth Rate                     72                  13                 11                 16

EPS (MRQ) vs Qtr. 1 Yr. Ago                   19             (4,365)             (1,178)               (21)
EPS (TTM) vs TTM 1 Yr. Ago                    (5) --                     --                 --
EPS - 5 Yr. Growth Rate                      100                  14                   5                   1

Capital Spending - 5 Yr. Growth
Rate                                          68                  12                   17               20

Financial Strength
                                       Company            Industry            Sector             S&P 500
Quick Ratio (MRQ)                            12                    2                    2                1
Current Ratio (MRQ)                          12                    2                    2                1
LT Debt to Equity (MRQ)                        0                  40                   19              151
Total Debt to Equity (MRQ)                     0                  69                   32              235
Interest Coverage (TTM)           --                               1                    0               24

Profitability Ratios
                                         Company        Industry            Sector             S&P 500
Gross Margin (TTM)                             62               11                   15               25
Gross Margin - 5 Yr. Avg.                      60               38                   36               25

EBITD Margin (TTM)                              35 --                  --                 --
EBITD - 5 Yr. Avg                               35             19                    23               15

Operating Margin (TTM)                          28              5                     2 --
Operating Margin - 5 Yr. Avg.                   29             14                    13               20

Pre-Tax Margin (TTM)                            28              6                     2                7
Pre-Tax Margin - 5 Yr. Avg.                     31             14                    11               20

Net Profit Margin (TTM)                         21                 4                  0                5
Net Profit Margin - 5 Yr. Avg.                  23                 9                  8               14

Effective Tax Rate (TTM)                        27              5                    10               17
Effecitve Tax Rate - 5 Yr. Avg.                 27             58                    21               28

Management Effectiveness
                                         Company        Industry            Sector             S&P 500
Return on Assets (TTM)                         14                  5                  2                  4
Return on Assets - 5 Yr. Avg.                  18                  9                  7                  5

Return on Investment (TTM)                      15              6                     3                  5
Return on Investment - 5 Yr. Avg.               20             13                    11                  6

Return on Equity (TTM)                          16              7                     3                9
Return on Equity - 5 Yr. Avg.                   20             14                    12               15

Efficiency
                                         Company        Industry            Sector             S&P 500
Revenue/Employee (TTM)                    1,101,592        818,319          6,226,671            484,256
Net Income/Employee (TTM)                   226,496        138,875          (141,550)             34,140

Receivable Turnover (TTM)                        8              1                  3                     7
Inventory Turnover (TTM)            --                      3,826                960                     5
Asset Turnover (TTM)                             1              0                  0                     0
Valuation Ratios                  APPLE

                                       Company            Industry            Sector             S&P 500
P/E Ratio (TTM)                              33                   21                   34               43
P/E High - Last 5 Yrs.                      108                    8                    3               25
P/E Low - Last 5 Yrs.                        16                    1                    0                6

Beta                                             2                   1                 1                   1

Price to Sales (TTM)                          5                    1                    1                2
Price to Book (MRQ)                           7                    3                    2                3
Price to Tangible Book (MRQ)                  7                    5                    3                6
Price to Cash Flow (TTM)                     29                   12                    5               15
Price to Free Cash Flow (TTM)                17                   30                   14               18

% Owned Institutions              --                 --                  --                 --

Dividends
                                   Company                Industry            Sector             S&P 500
Dividend Yield                    NA                                 0                  0                  1
Dividend Yield - 5 Year Avg.                     0                   2                  1                  3
Dividend 5 Year Growth Rate       --                                 5                 13                  9

Payout Ratio(TTM)                                0                35                   27               86

Growth Rates
                                       Company            Industry            Sector             S&P 500
Sales (MRQ) vs Qtr. 1 Yr. Ago                12                   (1)              (12)                 (6)
Sales (TTM) vs TTM 1 Yr. Ago                 12                     2                (4)                (2)
Sales - 5 Yr. Growth Rate                    39                   34                 11                 16

EPS (MRQ) vs Qtr. 1 Yr. Ago                  14                  (63)            (1,178)               (21)
EPS (TTM) vs TTM 1 Yr. Ago                   12 --                       --                 --
EPS - 5 Yr. Growth Rate                     125                   14                   5                   1

Capital Spending - 5 Yr. Growth
Rate                                         49                   23                   17               20

Financial Strength
                                       Company            Industry            Sector             S&P 500
Quick Ratio (MRQ)                                2                 1                    2                1
Current Ratio (MRQ)                              2                 2                    2                1
LT Debt to Equity (MRQ)                          0                17                   19              151
Total Debt to Equity (MRQ)                       0                28                   32              235
Interest Coverage (TTM)           --                               0                    0               24

Profitability Ratios
                                    Company        Industry            Sector             S&P 500
Gross Margin (TTM)                        35               10                   15               25
Gross Margin - 5 Yr. Avg.                 32               16                   36               25

EBITD Margin (TTM)                         22 --                  --                 --
EBITD - 5 Yr. Avg                          17                 7                 23               15

Operating Margin (TTM)                     20                 3                  2 --
Operating Margin - 5 Yr. Avg.              15                 5                 13               20

Pre-Tax Margin (TTM)                       21                 3                  2                7
Pre-Tax Margin - 5 Yr. Avg.                17                 6                 11               20

Net Profit Margin (TTM)                    15                 2                  0                5
Net Profit Margin - 5 Yr. Avg.             12                 4                  8               14

Effective Tax Rate (TTM)                   29             15                    10               17
Effecitve Tax Rate - 5 Yr. Avg.            30             55                    21               28

Management Effectiveness
                                    Company        Industry            Sector             S&P 500
Return on Assets (TTM)                    13                  4                  2                  4
Return on Assets - 5 Yr. Avg.             14                  8                  7                  5

Return on Investment (TTM)                 19              9                     3                  5
Return on Investment - 5 Yr. Avg.          22             15                    11                  6

Return on Equity (TTM)                     23             10                     3                9
Return on Equity - 5 Yr. Avg.              24             16                    12               15

Efficiency
                                    Company        Industry            Sector             S&P 500
Revenue/Employee (TTM)               1,080,063     10,428,085          6,226,671            484,256
Net Income/Employee (TTM)              161,719        208,813          (141,550)             34,140

Receivable Turnover (TTM)                  16              7                  3                     7
Inventory Turnover (TTM)                   48             11                960                     5
Asset Turnover (TTM)                        1              2                  0                     0

								
To top