| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Free Cash Flow | ||||||
2 | Nyx | ||||||
3 | |||||||
4 | Year | 0 | 1 | 2 | 3 | 4 | 5 |
5 | Free Cash Flow | $21,000 | $31,956 | $221,566 | $280,112 | $772,666 | $1,335,712 |
6 | |||||||
7 | Year 0 | 0 | |||||
8 | Setup expenses | $21,000 | |||||
9 | |||||||
10 | Year 1 | Year 1 | |||||
11 | Free Cash Flow | $31,956 | |||||
12 | Quarter | 1 | 2 | 3 | 4 | ||
13 | Net Income | $7,352 | $14,116 | $21,004 | $10,465 | ||
14 | Add back Interest Expense | $0 | $0 | $0 | |||
15 | Add back amortization/depreciation | $415 | $415 | $415 | $415 | ||
16 | Increase in Capital Assets? | -$5,000 | $0 | -$5,000 | $0 | ||
17 | (Increase)decrease in Inventory? | -$5,000 | $3,000 | $0 | $0 | ||
18 | (Increase)/Decrease in Accounts Receivable? | -$3,150 | -$2,857 | -$1,988 | -$2,646 | ||
19 | Increase/(Decrease) in Accounts Payable? | $0 | $0 | $0 | $0 | ||
20 | Increase/(Decrease) in Loan Payable? | $0 | $0 | $0 | $0 | ||
21 | Other cash items? | $0 | $0 | $0 | $0 | ||
22 | Other cash items? | $0 | $0 | $0 | $0 | ||
23 | |||||||
24 | Quarterly Totals | -$5,383 | $14,674 | $14,431 | $8,234 | $31,956 | |
25 | |||||||
26 | |||||||
27 | Year 2 | Year 2 | |||||
28 | Free Cash Flow | $221,566 | |||||
29 | Quarter | 1 | 2 | 3 | 4 | ||
30 | Net Income | $11,312 | $27,056 | $153,555 | $85,268 | ||
31 | Add back Interest Expense | $0 | $0 | $0 | $0 | ||
32 | Add back amortization/depreciation | $415 | $415 | $415 | $415 | ||
33 | Increase in Capital Assets? | $0 | $0 | $0 | $0 | ||
34 | (Increase)decrease in Inventory? | -$113 | -$157 | -$1,378 | $525 | ||
35 | (Increase)/Decrease in Accounts Receivable? | -$3,010 | -$10,518 | -$66,260 | $23,626 | ||
36 | Increase/(Decrease) in Accounts Payable? | $0 | $0 | $0 | $0 | ||
37 | Increase/(Decrease) in Loan Payable? | $0 | $0 | $0 | $0 | ||
38 | Other cash items? | $0 | $0 | $0 | $0 | ||
39 | Other cash items? | $0 | $0 | $0 | $0 | ||
40 | |||||||
41 | |||||||
42 | Quarterly Totals | $8,604 | $16,796 | $86,332 | $109,834 | $221,566 | |
43 | |||||||
44 | |||||||
45 | Year 3 | Year 3 | |||||
46 | Free Cash Flow | $280,112 | |||||
47 | Quarter | 1 | 2 | 3 | 4 | ||
48 | Net Income | $46,754 | $94,617 | $153,555 | $85,266 | ||
49 | Add back Interest Expense | $0 | $0 | $0 | $0 | ||
50 | Add back amortization/depreciation | 415 | 415 | 415 | 415 | ||
51 | Increase in Capital Assets? | 0 | -10,000 | 0 | 0 | ||
52 | (Increase)decrease in Inventory? | -$468 | -$479 | -$1,057 | $204 | ||
53 | (Increase)/Decrease in Accounts Receivable? | -$23,377 | -$23,932 | -$52,846 | $10,213 | ||
54 | Increase/(Decrease) in Accounts Payable? | 0 | 0 | 0 | 0 | ||
55 | Increase/(Decrease) in Loan Payable? | 0 | 0 | 0 | 0 | ||
56 | Other cash items? | 0 | 0 | 0 | 0 | ||
57 | Other cash items? | 0 | 0 | 0 | 0 | ||
58 | |||||||
59 | |||||||
60 | Quarterly Totals | $23,324 | $60,622 | $100,067 | $96,098 | $280,112 | |
61 | |||||||
62 | |||||||
63 | Year 4 | Year 4 | |||||
64 | Free Cash Flow | $772,666 | |||||
65 | Quarter | 1 | 2 | 3 | 4 | ||
66 | Net Income | $130,981 | $253,164 | $403,619 | $229,297 | ||
67 | Add back Interest Expense | $0 | $0 | $0 | $0 | ||
68 | Add back amortization/depreciation | 415 | 415 | 415 | 415 | ||
69 | Increase in Capital Assets? | 0 | 0 | 0 | 0 | ||
70 | (Increase)decrease in Inventory? | -$1,310 | -$1,222 | -$2,814 | $521 | ||
71 | (Increase)/Decrease in Accounts Receivable? | -$65,491 | -$61,092 | -$140,718 | $26,070 | ||
72 | Increase/(Decrease) in Accounts Payable? | 0 | 0 | 0 | 0 | ||
73 | Increase/(Decrease) in Loan Payable? | 0 | 0 | 0 | 0 | ||
74 | Other cash items? | 0 | 0 | 0 | 0 | ||
75 | Other cash items? | 0 | 0 | 0 | 0 | ||
76 | |||||||
77 | |||||||
78 | Quarterly Totals | $64,596 | $191,266 | $260,502 | $256,303 | $772,666 | |
79 | |||||||
80 | |||||||
81 | Year 5 | Year 5 | |||||
82 | Free Cash Flow | $1,335,712 | |||||
83 | Quarter | 1 | 2 | 3 | 4 | ||
84 | Net Income | $319,136 | $604,108 | $457,346 | $533,790 | ||
85 | Add back Interest Expense | $0 | $0 | $0 | $0 | ||
86 | Add back amortization/depreciation | $415 | $415 | $415 | $415 | ||
87 | Increase in Capital Assets? | 0 | 0 | 0 | 0 | ||
88 | (Increase)decrease in Inventory? | -$3,191 | -$2,850 | -$1,724 | -$3,614 | ||
89 | (Increase)/Decrease in Accounts Receivable? | -$159,568 | -$142,486 | -$86,187 | -$180,708 | ||
90 | Increase/(Decrease) in Accounts Payable? | 0 | 0 | 0 | 0 | ||
91 | Increase/(Decrease) in Loan Payable? | 0 | 0 | 0 | 0 | ||
92 | Other cash items? | 0 | 0 | 0 | 0 | ||
93 | Other cash items? | 0 | 0 | 0 | 0 | ||
94 | |||||||
95 | |||||||
96 | Quarterly Totals | $156,792 | $459,187 | $369,850 | $349,883 | $1,335,712 | |