ASSETS
LIABILITIES & EQUITY
Cash
10,525
$
Revolving line of credit
Accounts Receivable
27,000
$
Accounts Payable
Inventories
30,000
$
Current Portion
Prepaid
2,000
$
Total Current Liabilities
Total Current Assets
69,525
$
Net Fixed Assets
300,000
$
Long Term Debt
Loan payable to stockholders
Total Long term debt
Total liabilities
Common Stock
Additional paid in capital
Retained Earnings
Total SHE
TOTAL ASSETS
369,525
$
TOTAL LIABILITIES & EQUITY
Revenues $1,747,698
Costs of sales $1,050,270
Gross Profit $697,428
less selling and marketing
$125,000
less admin expenses $285,850
EBITDA $286,578
Depreciation $14,500
EBIT $272,078
Interest $9,650
EBT $262,428
Taxes (35%) $118,093
NET INCOME
$144,335
Income Statement for year ended Dec. 31, xxxx
Balance Sheet for year ended Dec. 31, 2014
20,000
$
5,000
$
15,000
$
40,000
$
45,500
$
60,500
$
106,000
$
146,000
$
1,000
$
25,000
$
197,525
$
223,525
$
369,525
$
ASSUMPTIONS
Projected Growth Rate:
15.00%
Tax Rate:
35.00%
Year 1
Year 2
Year 3
Year 4
ASSETS
Cash
222,025
$
487,188
$
815,042
$
1,216,009
$
Accounts Receivable
31,050
$
35,708
$
41,064
$
47,223
$
Inventories
34,500
$
39,675
$
45,626
$
52,470
$
Prepaid
2,300
$
2,645
$
3,042
$
3,498
$
Total Current Assets
289,875
$
565,215
$
904,773
$
1,319,201
$
Net Fixed Assets
285,500
$
271,000
$
256,500
$
242,000
$
TOTAL ASSETS
575,375
$
836,215
$
1,161,273
$
1,561,201
$
Assumptions
1. All current assets except cash and current liabilities are increassed by 15%
2. Fixed assets are derived by deducting the depreacition of $15,00 every year
3. cash is the balancing figure
4. retained earning = opning balance + net profit of the year
Year 1
Year 2
Year 3
Year 4
Revenues $2,009,853 $2,311,331 $2,658,030 $3,056,735
Costs of sales $1,207,811 $1,388,982 $1,597,329 $1,836,929
Gross Profit $802,042 $922,349 $1,060,701 $1,219,806
less selling and marketing $143,750 $165,313 $190,109 $218,626
less admin expenses $300,143 $315,150 $330,907 $347,452
EBITDA $358,150 $441,886 $539,684 $653,728
Depreciation $14,500 $14,500 $14,500 $14,500
EBIT $343,650 $427,386 $525,184 $639,228
Interest $9,650 $9,650 $9,650 $9,650
EBT $334,000 $417,736 $515,534 $629,578
Taxes (35%) $116,900 $146,208 $180,437 $220,352
NET INCOME
$217,100
$271,529
$335,097
$409,225
Assumptions
1. Revenue, cost of sales and selling expenses are increased by 15%
2.Admin expense are increased by 5% ever year
3. cash is the balancing figure
4. Interest and deoprecaition are same in all years
Year 5
Year 1
Year 2
Year 3
LIABILITIES & EQUITY
1,716,639
$
Revolving line of credit
23,000
$
26,450
$
30,418
$
54,307
$
Accounts Payable
5,750
$
6,613
$
7,604
$
60,341
$
Current Portion
15,000
$
15,000
$
15,000
$
4,023
$
Total Current Liabilities
43,750
$
48,063
$
53,022
$
1,835,309
$
227,500
$
Long Term Debt
30,500
$
15,500
$
500
$
Loan payable to stockholders
60,500
$
60,500
$
60,500
$
Total Long term debt
91,000
$
76,000
$
61,000
$
Total liabilities
134,750
$
124,063
$
114,022
$
Common Stock
1,000
$
1,000
$
1,000
$
Additional paid in capital
25,000
$
25,000
$
25,000
$
Retained Earnings
414,625
$
686,153
$
1,021,251
$
Total SHE
440,625
$
712,153
$
1,047,251
$
2,062,809
$
TOTAL LIABILITIES & EQUITY
575,375
$
836,216
$
1,161,273
$
Year 5
$3,515,245
$2,112,468
$1,402,777
$251,420
$364,825
$786,532
$14,500
$772,032
$9,650
$762,382
$266,834
$495,548
Year 4
Year 5
34,980
$
40,227
$
8,745
$
10,057
$
500
$
44,225
$
50,284
$
-
$
-
$
60,500
$
60,500
$
60,500
$
60,500
$
104,725
$
110,784
$
1,000
$
1,000
$
25,000
$
25,000
$
1,430,476
$
1,926,025
$
1,456,476
$
1,952,025
$
1,561,201
$
2,062,809
$
