Template Appendix 2 Table 2: Balance Sheet Horizontal Analysis* Vertical Analysis 20X2 20X3 20X4 20X5 20X6 20X2 20X3 20X4 20X5 20X6 ASSETS Current assets: Cash and cash equivalents N/A -8.32% 22.06% -48.55% -95.12% 33.58% 21.11% 16.48% 6.98% 0.53% Accounts receivable, net N/A 111.01% 68.19% 363.34% -82.03% 5.45% 7.88% 13.28% 50.69% 14.05% Prepaid expenses & Other assets N/A 158.60% -68.31% 139.89% -53.35% 7.60% 13.48% 4.28% 8.45% 6.08% Notes receivable - related parties N/A 0.00% -100.00% 0.00% 0.00% 0.00% 0.52% 0.00% 0.00% 0.00% Notes receivable N/A 26.78% -49.49% -61.01% 128.04% 24.89% 12.50% 6.32% 2.03% 7.14% Total current assets N/A 13.14% -27.38% 105.02% -73.56% 71.52% 65.49% 40.36% 68.16% 27.79% N/A 0.00% 0.00% 0.00% 0.00% 0.00% Property, plant, and equipment, net N/A 90.18% 21.23% -13.24% -25.42% 26.31% 34.31% 41.66% 29.77% 34.24% Security deposits N/A -100.00% 0.00% 0.00% 0.00% 1.98% 0.00% 0.00% 0.00% 33.11% Notes receivable - related parties N/A -100.00% 0.00% 0.00% 0.00% 0.20% 0.00% 0.00%% 0.00% 0.00% Other Assets N/A 0.00% 76.03% -86.05% 52.46% 0.00% 10.20% 17.98% 2.07% 4.86% Total Assets N/A 45.82% -0.15% 21.40% -35.15% 100.00% 100.00% 100.00% 100.00% 100.00% LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable N/A 3.89% 66.22% -8.56% 2.81% 23.79% 16.95% 28.22% 21.25% 33.69% Accrued expenses N/A 5.65% -49.36% -4.11% 1045.20% 8.77% 6.35% 3.22% 2.55% 44.96% Notes payable N/A 468.84% -9.16% 79.10% -94.37% 5.94% 23.17% 21.08% 31.11% 2.70% Notes payable - related party N/A 18.00% -100.00% 0.00% 0.00% 4.28% 3.47% 0.00% 0.00% 0.00% Deferred Revenue N/A -19.37% -41.96% 34.58% -63.44% 2.52% 1.39% 0.81% 0.90% 0.51% Current portion of capital lease N/A 557.37% -36.02% -68.70% -74.91% 2.87% 12.95% 8.30% 2.14% 0.83% Convertible notes payable N/A 0.00% 13734.40% -100.00% 0.20% 0.14% 19.21% 0.00% 26.01% Total current liabilities N/A 94.21% 25.28% -12.99% 21.66% 48.38% 64.43% 80.84% 57.94% 108.69% Long-term notes payable N/A 0.00% -8.40% -92.18% -37.26% 0.00% 3.13% 2.87% 0.18% 0.18% Convertible notes payable N/A 0.00% 0.00% -100.00% 0.00% 0.00% 0.00% 30.07% 0.00% 0.00% Capital lease - long term N/A 66.23% 31.18% -79.82% -100.00% 4.09% 4.66% 3.21% 0.53% 0.00% Total liabilities N/A 100.71% 61.75% -39.13% 20.36% 52.47% 72.21% 116.99% 58.66% 108.87% Stockholders' equity Capital Stock N/A 19.68% 17.49% 35.98% 4.67% 417.10% 342.31% 402.80% 451.18% 728.23% Retained Earnings (Accum. Deficits) N/A 24.11% 33.26% 18.52% 16.64% -369.57% -314.52% -419.78% -409.84% -737.11% Total stockholders' equity N/A -14.76% -161.04% -395.42% -113.92% 47.53% 27.79% -16.99% 41.34% -8.87% Total liabilities and stockholders' equity N/A 45.82% 0.15% 21.40% -35.15% 100.00% 100.00% 100.00% 100.00% 100.00%
