|
Discounted Cash Flow Valuation
<br />Y1 Y2 Y3 Y4 Y5 Discount Rate 10%15%
<br />$3,000,079 $12,825,338 $16,015,641 $18,017,596 $18,828,388 Enterprise Value 9,281,437$ 8,258,396$
<br />$1,632,571 $6,979,241 $8,715,328 $9,804,744 $10,245,957
<br />Gross Profit $1,367,508 $5,846,097 $7,300,313 $8,212,852 $8,582,431 Multiple Valuation Multiple FY5
<br />$1,467,931 $0 $0 $0 $0 Gross Profit 2 $17,164,861
<br />$828,684 $2,522,006 $2,554,508 $2,588,635 $2,624,468 Operating Income 3 $17,873,888
<br />Operating Income ($929,107)$3,324,091 $4,745,805 $5,624,218 $5,957,963
<br />$330,678 $1,482,040 $1,885,168 $2,137,192 $2,237,749
<br />Net Income ($1,259,785)$1,842,051 $2,860,637 $3,487,025 $3,720,214
<br />100.00%100.00%100.00%100.00%100.00%
<br />54.42%54.42%54.42%54.42%54.42%
<br />Gross Profit 45.58%45.58%45.58%45.58%45.58%
<br />48.93%0.00%15.95%0.00%0.00%
<br />27.62%19.66%29.63%14.37%13.94%
<br />Operating Income -30.97%25.92%29.63%31.22%31.64%
<br />11.02%11.56%11.77%11.86%11.88%
<br />Net Income -41.99%14.36%17.86%19.35%19.76%
<br />Y1 Y2 Y3 Y4 Y5
<br />$0 $746,672 $2,560,562 $5,103,580 $8,399,714
<br />($1,253,328)$1,867,879 $2,886,466 $3,512,854 $3,746,042
<br />$0 $0 $0 $0 $0
<br />$2,000,000 ($53,989)($343,448)($216,720)$0
<br />$746,672 $1,813,890 $2,543,018 $3,296,134 $3,746,042
<br />$746,672 $2,560,562 $5,103,580 $8,399,714 $12,145,756
<br />Y1 Y2 Y3 Y4 Y5
<br />$928,315 $2,716,377 $5,233,566 $8,503,871 $12,224,085
<br />$1,000,000 $946,011 $602,563 $385,843 $385,843
<br />($259,785)$1,582,266 $4,442,903 $7,929,928 $11,650,142
<br />$740,215 $2,528,277 $5,045,466 $8,315,771 $12,035,985
<br />Owners Equity
<br />Liabilities & Owners Equity
<br />Cash from Operating Activities
<br />Cash from Investing Activities
<br />Cash from Financing Activities
<br />Total Change in Cash
<br />Ending Cash Balance
<br />YEAR-END BALANCE SHEET
<br />FROM MONTH 1 YEAR 1 TO MONTH 12 YEAR 5
<br />Assets
<br />Liabilities
<br />ITDA Expenses
<br />STATEMENT OF CASH FLOWS
<br />FROM MONTH 1 YEAR 1 TO MONTH 12 YEAR 5
<br />Starting Cash Balance
<br />ANALYSIS (%)
<br />Sales Revenue
<br />Cost of Goods Sold
<br />Startup Expenses
<br />Operating Expenses
<br />Sales Revenue
<br />Cost of Goods Sold
<br />Startup Expenses
<br />Operating Expenses
<br />ITDA Expenses
<br />Annual Financial Statements
<br />ANNUAL PRO FORMA VALUATION ANALYSIS
<br />FROM MONTH 1 YEAR 1 TO MONTH 12 YEAR 5
|