| Pro Forma Income Statement |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Existing Operations And BIP Project |
|
Project Title: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Historical |
|
Forecast Period |
|
Historical Year 1 |
Historical Year 2 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
| Revenues |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Network Services Revenues: |
|
|
|
|
|
|
|
| Local Voice Service |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
| Broadband Data Service |
- |
- |
- |
- |
- |
- |
- |
| Video Service |
- |
- |
- |
- |
- |
- |
- |
| Middle Mile Revenues |
- |
- |
- |
- |
- |
- |
- |
| Network Access Service Revenues |
- |
- |
- |
- |
- |
- |
- |
| Universal Service Fund |
- |
- |
- |
- |
- |
- |
- |
| Toll Service/Long Distance Voice |
- |
- |
- |
- |
- |
- |
- |
| Installation Revenues |
- |
- |
- |
- |
- |
- |
- |
| Amortized Grant Revenue BIP |
- |
- |
- |
- |
- |
- |
- |
| Other Operating Revenues |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Uncollectible Revenues |
|
|
|
|
|
|
|
| Total Revenues |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
|
|
|
|
|
|
|
| Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Backhaul |
- |
- |
- |
- |
- |
- |
- |
| IP/Interconnection |
- |
- |
- |
- |
- |
- |
- |
| Video Content If Applicable |
- |
- |
- |
- |
- |
- |
- |
| Spectrum If Applicable |
- |
- |
- |
- |
- |
- |
- |
| Network Maintenance/Monitoring |
- |
- |
- |
- |
- |
- |
- |
| Utilities |
- |
- |
- |
- |
- |
- |
- |
| Sales/Marketing |
- |
- |
- |
- |
- |
- |
- |
| Customer Care |
- |
- |
- |
- |
- |
- |
- |
| Corporate G&A |
- |
- |
- |
- |
- |
- |
- |
| Property Tax |
- |
- |
- |
- |
- |
- |
- |
| Other Operating Expense |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Expenses |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
|
|
|
|
|
|
|
| EBITDA |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
|
|
|
|
|
|
|
| Depreciation Non BIP Assets |
- |
- |
- |
- |
- |
- |
- |
| Depreciation BIP Assets |
- |
- |
- |
- |
- |
- |
- |
| Amortization |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
| Interest Expense - Non BIP Debt |
- |
- |
- |
- |
- |
- |
- |
| Interest Income |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
| Income Taxes |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
| Net Income (Loss) |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
| TIER |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Existing Operations And BIP Project |
|
Project Title: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Historical |
Forecast Period |
| Assets |
|
Historical Year 1 |
Historical Year 2 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
| Current Assets |
|
|
|
|
|
|
|
|
|
Cash |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
Marketable Securities |
- |
- |
- |
- |
- |
- |
- |
|
Accounts Receivable |
- |
- |
- |
- |
- |
- |
- |
|
Other Current Assets |
- |
- |
- |
- |
- |
- |
- |
|
|
- |
- |
- |
- |
- |
- |
- |
|
Total Current Assets |
- |
- |
- |
- |
- |
- |
- |
| Non-Current Assets |
|
|
|
|
|
|
|
|
|
Amortizable Asset - Net |
- |
- |
- |
- |
- |
- |
- |
|
Plant in Service Non BIP Assets |
- |
- |
- |
- |
- |
- |
- |
|
Accumulated Depreciation Non BIP Assets |
- |
- |
- |
- |
- |
- |
- |
|
Plant in Service BIP Assets |
- |
- |
- |
- |
- |
- |
- |
|
Accumulated Depreciation BIP Assets |
- |
- |
- |
- |
- |
- |
- |
|
Other Non-Current Assets |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
Total Non-Current Assets |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
Total Assets |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
|
|
|
|
|
|
|
|
| Liabilities and Equity |
|
Historical Year 1 |
Historical Year 2 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
|
|
|
|
|
|
Accounts Payable |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
Current Portion - Non BIP Debt |
- |
- |
- |
- |
- |
- |
- |
|
Current Portion - BIP Loans |
- |
- |
- |
- |
- |
- |
- |
|
Current Portion - Deferred Grant Revenue BIP |
- |
- |
- |
- |
- |
- |
- |
|
Other Current Liabilities |
- |
- |
- |
- |
- |
- |
- |
|
|
- |
- |
- |
- |
- |
- |
- |
|
Total Current Liabilities |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
| Non-Current Liabilities |
|
|
|
|
|
|
|
|
|
Existing Non BIP Debt |
- |
- |
- |
- |
- |
- |
- |
|
Deferred Grant Revenue BIP |
- |
- |
- |
- |
- |
- |
- |
|
Other Non-Current Liabilities |
- |
- |
- |
- |
- |
- |
- |
|
|
- |
- |
- |
- |
- |
- |
- |
|
Total Non-Current Liabilities |
- |
- |
- |
- |
- |
- |
- |
|
Total Liabilities |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
|
|
|
|
|
|
|
|
| Equity |
|
|
|
|
|
|
|
|
|
Capital Stock |
- |
- |
- |
- |
- |
- |
- |
|
Additional Paid-In Capital |
- |
- |
- |
- |
- |
- |
- |
|
Patronage Capital Credits |
- |
- |
- |
- |
- |
- |
- |
|
Retained Earnings |
- |
- |
- |
- |
- |
- |
- |
|
|
- |
- |
- |
- |
- |
- |
- |
|
Total Equity |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
|
|
|
|
|
|
|
|
|
Total Liabilities and Equity |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
|
|
|
|
|
|
|
|
|
Current Ratio |
- |
- |
- |
- |
- |
- |
- |
| Pro Forma Statement of Cash Flows |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Existing Operations And BIP Project |
|
Project Title: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Historical |
|
Forecast Period |
|
Historical Year 1 |
Historical Year 2 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
|
|
|
|
|
|
|
| Beginning Cash |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
|
|
|
|
|
|
|
| CASH FLOWS FROM OPERATING ACTIVITIES: |
|
|
|
|
|
|
|
| Net Income (Loss) |
- |
- |
- |
- |
- |
- |
- |
Adjustments to Reconcile Net Income (Loss) to Net Cash From Operating Activities: |
- |
- |
- |
- |
- |
- |
- |
| Add: Depreciation Non BIP Assets |
- |
- |
- |
- |
- |
- |
- |
| Add: Depreciation BIP Assets |
- |
- |
- |
- |
- |
- |
- |
| Add: Amortization |
- |
- |
- |
- |
- |
- |
- |
| Less: Amortized Grant Revenue BIP |
- |
- |
- |
- |
- |
- |
- |
| Changes in Assets and Liabilities: |
- |
- |
- |
- |
- |
- |
- |
| Accounts Receivable |
- |
- |
- |
- |
- |
- |
- |
| Other Current Assets |
- |
- |
- |
- |
- |
- |
- |
| Other Non-Current Assets |
- |
- |
- |
- |
- |
- |
- |
| Accounts Payable |
- |
- |
- |
- |
- |
- |
- |
| Other Current Liabilities |
- |
- |
- |
- |
- |
- |
- |
| Other Non-Current Liabilities |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Cash From Operating Activities |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
|
|
|
|
|
|
|
| CASH FLOWS FROM FINANCING ACTIVITIES: |
|
|
|
|
|
|
|
| Proceeds from Sale of Equity |
- |
- |
- |
- |
- |
- |
- |
| Proceeds from BIP Grant |
- |
- |
- |
- |
- |
- |
- |
| Proceeds from BIP Loans |
- |
- |
- |
- |
- |
- |
- |
| Proceeds from Non BIP Debt |
- |
- |
- |
- |
- |
- |
- |
| Repayments of BIP Loans |
- |
- |
- |
- |
- |
- |
- |
| Repayments of Non BIP Debt |
- |
- |
- |
- |
- |
- |
- |
| Payments of Patronage Capital Credits |
- |
- |
- |
- |
- |
- |
- |
| Payments of Dividends |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Cash From Financing Activities |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
|
|
|
|
|
|
|
| CASH FLOWS FROM INVESTING ACTIVITIES: |
|
|
|
|
|
|
|
| Capital Expenditures Non BIP Operations |
- |
- |
- |
- |
- |
- |
- |
| Capital Expenditures BIP |
- |
- |
- |
- |
- |
- |
- |
| Additions to Amortizable Assets |
- |
- |
- |
- |
- |
- |
- |
| Change in Marketable Securities- Net |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Cash From Investing Activities |
$- |
$- |
$- |
$- |
$- |
$- |
$- |
|
|
|
|
|
|
|
|
| Increase (Decrease) in Cash |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
| Ending Cash |
$- |
$- |
$- |
$- |
$- |
$- |
$- |