Income Statement 5 Years | |||||
- | Year-1 | Year-2 | Year-3 | Year-4 | Year-5 |
Number Of customers | 700 | 840 | 1008 | 1210 | 1452 |
Revenues | $200,400 | $344,400 | $488,400 | $632,400 | $776,400 |
Salaries | $48,000 | $50,400 | $52,920 | $55,566 | $58,344 |
Utilities | $12,000 | $12,600 | $13,230 | $13,892 | $14,586 |
Insurance | $2,400 | $2,520 | $2,646 | $2,778 | $2,917 |
Advertising | $2,400 | $2,520 | $2,646 | $2,778 | $2,917 |
Misc | $9,600 | $10,080 | $10,584 | $11,113 | $11,669 |
Rent | $48,000 | $50,400 | $52,920 | $55,566 | $58,344 |
Interest | $6,924 | $7,424 | $7,961 | $8,537 | $9,149 |
Depreciation | $4,188 | $4,188 | $4,188 | $4,188 | $4,188 |
Total Operating expenses | $133,512 | $140,132 | $147,095 | $154,418 | $162,115 |
Operating Income | $66,888 | $204,268 | $341,305 | $477,982 | $614,285 |
Income Tax @30 % | $20,066 | $61,280 | $102,392 | $143,395 | $184,286 |
Net Income | $46,822 | $142,987 | $238,914 | $334,588 | $430,000 |
Income Statement 12 monthe | ||||||||||||
- | Month-1 | Month-2 | Month-3 | Month-4 | Month-5 | Month-6 | Month-7 | Month-8 | Month-9 | Month-10 | Month-11 | Month-12 |
Number Of customers | 56 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
Revenues | $11,200 | $12,200 | $13,200 | $14,200 | $15,200 | $16,200 | $17,200 | $18,200 | $19,200 | $20,200 | $21,200 | $22,200 |
Salaries | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Utilities | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Insurance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 |
Advertising | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 |
Misc | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 |
Rent | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Interest | $233 | $230 | $227 | $223 | $220 | $217 | $213 | $210 | $207 | $203 | $200 | $196 |
Depreciation | $4,188 | |||||||||||
Total Operating expenses | $10,433 | $10,430 | $10,427 | $10,423 | $10,420 | $10,417 | $10,413 | $10,410 | $10,407 | $10,403 | $10,400 | $14,584 |
Operating Income | $767 | $1,770 | $2,773 | $3,777 | $4,780 | $5,783 | $6,787 | $7,790 | $8,793 | $9,797 | $10,800 | $7,616 |
Income Tax @30 % | $20,066 | |||||||||||
Net Income | $767 | $1,770 | $2,773 | $3,777 | $4,780 | $5,783 | $6,787 | $7,790 | $8,793 | $9,797 | $10,800 | -$12,451 |
- | Month-1 | Month-2 | Month-3 | Month-4 | Month-5 | Month-6 | Month-7 | Month-8 | Month-9 | Month-10 | Month-11 | Month-12 |
Net Income | 766.666667 | 1769.92584 | 2773.20402 | 3776.50132 | 4779.81786 | 5783.1537 | 6786.5091 | 7789.884 | 8793.2786 | 9796.69301 | 10800.1273 | -12450.7028 |
Revenues | 11200 | 12200 | 13200 | 14200 | 15200 | 16200 | 17200 | 18200 | 19200 | 20200 | 21200 | 22200 |
Cash Flow Statement 5 Years | |||||
- | Year-1 | Year-2 | Year-3 | Year-4 | Year-5 |
Net Profit | $ 46,822 | $ 142,987 | $ 238,914 | $ 334,588 | $ 430,000 |
Add depreciation | $ 4,188 | $ 4,188 | $ 4,188 | $ 4,188 | $ 4,188 |
Cash Flow From Operating activities | $ 51,010 | $ 147,175 | $ 243,101 | $ 338,775 | $ 434,187 |
New Floor | $ (6,000) | ||||
LLC CORP | $ (378) | ||||
WALL GLASS | $ (5,500) | ||||
BUILD OUT | $ (5,000) | $ - | $ - | $ - | $ - |
EQUIPT | $ (25,000) | ||||
Cash Flow From Investing Activities | $ (41,878) | $ - | $ - | $ - | $ - |
Capital Invested | $ 25,000 | ||||
Loan Received | $ 40,000 | ||||
Loan Repayment | $ (6,924) | $ (7,424) | $ (7,961) | $ (8,537) | $ (9,149) |
Cash Flow From Financing activities | $ 58,076 | $ (7,424) | $ (7,961) | $ (8,537) | $ (9,149) |
Opening Balance | $ - | $ 67,208 | $ 206,958 | $ 442,099 | $ 772,337 |
Net Cash Balance | $ 67,208 | $ 206,958 | $ 442,099 | $ 772,337 | $ 1,197,375 |
Cash Flow Statement Year-1 Monthly Break Ups | ||||||||||||
- | Month-1 | Month-2 | Month-3 | Month-4 | Month-5 | Month-6 | Month-7 | Month-8 | Month-9 | Month-10 | Month-11 | Month-12 |
Net Profit | $ 767 | $ 1,770 | $ 2,773 | $ 3,777 | $ 4,780 | $ 5,783 | $ 6,787 | $ 7,790 | $ 8,793 | $ 9,797 | $ 10,800 | $ (12,451) |
Add depreciation | $ 4,188 | |||||||||||
Cash Flow From Operating activities | $ 767 | $ 1,770 | $ 2,773 | $ 3,777 | $ 4,780 | $ 5,783 | $ 6,787 | $ 7,790 | $ 8,793 | $ 9,797 | $ 10,800 | $ (8,263) |
New Floor | $ (6,000) | |||||||||||
LLC CORP | $ (378) | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
WALL GLASS | $ (5,500) | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
BUILD OUT | $ (5,000) | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
EQUIPT | $ (25,000) | |||||||||||
Cash Flow From Investing Activities | $ (41,878) | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
Capital Invested | $ 25,000 | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
Loan Received | $ 40,000 | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
Loan Repayment | $ (559) | $ (562) | $ (565) | $ (569) | $ (572) | $ (575) | $ (579) | $ (582) | $ (585) | $ (589) | $ (592) | $ (596) |
Cash Flow From Financing activities | $ 64,441 | $ (562) | $ (565) | $ (569) | $ (572) | $ (575) | $ (579) | $ (582) | $ (585) | $ (589) | $ (592) | $ (596) |
Opening Balance | $ - | $ 23,330 | $ 24,538 | $ 26,746 | $ 29,954 | $ 34,162 | $ 39,370 | $ 45,578 | $ 52,786 | $ 60,994 | $ 70,202 | $ 80,409 |
Net Cash Balance | $ 23,330 | $ 24,538 | $ 26,746 | $ 29,954 | $ 34,162 | $ 39,370 | $ 45,578 | $ 52,786 | $ 60,994 | $ 70,202 | $ 80,409 | $ 71,551 |
Balance Sheet 5 Years | |||||
- | Year-1 | Year-2 | Year-3 | Year-4 | Year-5 |
Cash | $ 67,208 | $ 206,958 | $ 442,099 | $ 772,337 | $ 1,197,375 |
Current Assets | $ 67,208 | $ 206,958 | $ 442,099 | $ 772,337 | $ 1,197,375 |
New Floor | $ 6,000 | $ 6,000 | $ 6,000 | $ 6,000 | $ 6,000 |
LLC CORP | $ 378 | $ 378 | $ 378 | $ 378 | $ 378 |
WALL GLASS | $ 5,500 | $ 5,500 | $ 5,500 | $ 5,500 | $ 5,500 |
BUILD OUT | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 |
EQUIPT | $ 25,000 | $ 25,000 | $ 25,000 | $ 25,000 | $ 25,000 |
Accumulated Depreciation | $ 4,188 | $ 8,376 | $ 12,563 | $ 16,751 | $ 20,939 |
Net Fixed Assets | $ 37,690 | $ 33,502 | $ 29,315 | $ 25,127 | $ 20,939 |
Total Assets | $ 104,898 | $ 240,461 | $ 471,413 | $ 797,464 | $ 1,218,314 |
Capital | $ 25,000 | $ 25,000 | $ 25,000 | $ 25,000 | $ 25,000 |
Accumulated Profits | $ 46,822 | $ 189,809 | $ 428,723 | $ 763,310 | $ 1,193,310 |
Total Equity Capital | $ 71,822 | $ 214,809 | $ 453,723 | $ 788,310 | $ 1,218,310 |
Bank Loan | $ 40,000 | $ 33,076 | $ 25,652 | $ 17,690 | $ 9,154 |
Loan Repayment | $ 6,924 | $ 7,424 | $ 7,961 | $ 8,537 | $ 9,149 |
Total Liabilities | $ 33,076 | $ 25,652 | $ 17,690 | $ 9,154 | $ 5 |
Total Liabilities & Equity | $ 104,898 | $ 240,461 | $ 471,413 | $ 797,464 | $ 1,218,314 |
Balance Sheet Monthly Break Ups Year-1 | ||||||||||||
- | Month-1 | Month-2 | Month-3 | Month-4 | Month-5 | Month-6 | Month-7 | Month-8 | Month-9 | Month-10 | Month-11 | Month-12 |
Cash | $23,330 | $24,538 | $26,746 | $29,954 | $34,162 | $39,370 | $45,578 | $52,786 | $60,994 | $70,202 | $80,409 | $71,551 |
Current Assets | $23,330 | $24,538 | $26,746 | $29,954 | $34,162 | $39,370 | $45,578 | $52,786 | $60,994 | $70,202 | $80,409 | $71,551 |
New Floor | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
LLC CORP | $378 | $378 | $378 | $378 | $378 | $378 | $378 | $378 | $378 | $378 | $378 | $378 |
WALL GLASS | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 | $5,500 |
BUILD OUT | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
EQUIPT | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $4,188 |
Net Fixed Assets | $41,878 | $41,878 | $41,878 | $41,878 | $41,878 | $41,878 | $41,878 | $41,878 | $41,878 | $41,878 | $41,878 | $37,690 |
Total Assets | $65,208 | $66,416 | $68,624 | $71,832 | $76,040 | $81,248 | $87,456 | $94,664 | $102,872 | $112,080 | $122,287 | $109,241 |
Capital | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
Accumulated Profits | $767 | $2,537 | $5,310 | $9,086 | $13,866 | $19,649 | $26,436 | $34,226 | $43,019 | $52,816 | $63,616 | $51,165 |
Total Equity Capital | $25,767 | $27,537 | $30,310 | $34,086 | $38,866 | $44,649 | $51,436 | $59,226 | $68,019 | $77,816 | $88,616 | $76,165 |
Bank Loan | $40,000 | $39,441 | $38,879 | $38,314 | $37,746 | $37,174 | $36,598 | $36,020 | $35,438 | $34,853 | $34,264 | $33,672 |
Loan Repayment | $559 | $562 | $565 | $569 | $572 | $575 | $579 | $582 | $585 | $589 | $592 | $596 |
Total Liabilities | $39,441 | $38,879 | $38,314 | $37,746 | $37,174 | $36,598 | $36,020 | $35,438 | $34,853 | $34,264 | $33,672 | $33,076 |
Total Liabilities & Equity | $65,208 | $66,416 | $68,624 | $71,832 | $76,040 | $81,248 | $87,456 | $94,664 | $102,872 | $112,080 | $122,287 | $109,241 |
Recomended Reading