| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||||||
2 | HISTORICAL | CURRENT YEAR | FORECAST | 5YR LIFE | |||||||||||||||
3 | SNAPSHOT | 2017 | 2018 | 2019 | 2020 | Q1-2020 | Q2-2020 | Q3-2020 | Q4-2020 | 2021 | Total | ||||||||
4 | NINE8 | GROSS INCOME | $4,000 | $196,812 | $248,626 | $235,254 | $74,703 | $67,271 | $68,980 | $24,300 | $97,200 | $1,017,147 | |||||||
5 | |||||||||||||||||||
6 | NET OP INCOME | -$5,620 | $13,721 | $17,931 | $106,168 | $17,397 | $37,048 | $35,101 | $16,621 | $64,253 | $302,620 | ||||||||
7 | -141% | 7% | 7% | 45% | 23% | 55% | 51% | 68% | 66% | 30% | |||||||||
8 | |||||||||||||||||||
9 | NET INCOME | -$13,859 | -$116,883 | -$194,388 | -$43,672 | -$47,832 | $14,623 | -$1,821 | -$8,643 | -$19,718 | -$432,193 | ||||||||
10 | -346% | -59% | -78% | -19% | -64% | 22% | -3% | -36% | -20% | -42% | |||||||||
11 | |||||||||||||||||||
12 | DEBT BALANCE | $0 | $57,231 | $80,590 | $3,801 | $55,261 | $47,639 | $64,523 | $3,801 | $0 | |||||||||
13 | |||||||||||||||||||
14 | NET INFUSIONS | $9,000 | $105,000 | $267,497 | -$2,000 | -$2,000 | $0 | $0 | $0 | $0 | $377,497 | ||||||||
15 | |||||||||||||||||||
16 | KERCHEVAL | GROSS INCOME | $4,000 | $91,912 | $103,066 | $109,318 | $32,280 | $26,305 | $26,433 | $24,300 | $97,200 | $514,815 | |||||||
17 | |||||||||||||||||||
18 | NET OP INCOME | $3,216 | $58,143 | $44,755 | $74,270 | $21,407 | $18,644 | $17,599 | $16,621 | $64,253 | $318,908 | ||||||||
19 | 80% | 63% | 43% | 68% | 66% | 71% | 67% | 68% | 66% | 62% | |||||||||
20 | |||||||||||||||||||
21 | NET INCOME | -$4,630 | -$8,373 | -$27,646 | $23,201 | $2,947 | $18,644 | $4,352 | -$2,742 | -$15,007 | -$9,255 | ||||||||
22 | -116% | -9% | -27% | 21% | 9% | 71% | 16% | -11% | -15% | -2% | |||||||||
23 | |||||||||||||||||||
24 | DEBT BALANCE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||||||
25 | |||||||||||||||||||
26 | NET INFUSIONS | $5,000 | $6,000 | $92,747 | $0 | $0 | $0 | $0 | $0 | $0 | $103,747 | ||||||||
27 | |||||||||||||||||||
28 | ORCHARD | GROSS INCOME | $0 | $104,900 | $145,560 | $125,936 | $42,423 | $40,966 | $42,547 | $0 | $0 | $502,332 | |||||||
29 | |||||||||||||||||||
30 | NET OP INCOME | -$8,836 | -$44,422 | -$26,824 | $31,897 | -$4,010 | $18,404 | $17,503 | $0 | $0 | -$16,288 | ||||||||
31 | -42% | -18% | 25% | -9% | 45% | 41% | #DIV/0! | #DIV/0! | -3% | ||||||||||
32 | |||||||||||||||||||
33 | NET INCOME | -$9,229 | -$108,510 | -$166,742 | -$66,873 | -$50,779 | -$4,020 | -$6,173 | -$5,901 | -$4,711 | -$422,938 | ||||||||
34 | -103% | -115% | -53% | -120% | -10% | -15% | #DIV/0! | #DIV/0! | -84% | ||||||||||
35 | |||||||||||||||||||
36 | DEBT BALANCE | $0 | $57,231 | $80,590 | $3,801 | $55,261 | $47,639 | $64,523 | $3,801 | $0 | |||||||||
37 | |||||||||||||||||||
38 | NET INFUSIONS | $4,000 | $99,000 | $174,750 | -$2,000 | -$2,000 | $0 | $0 | $0 | $0 | $273,750 | ||||||||
39 | |||||||||||||||||||