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 |
$- |
$- |
$- |
$- |
$- |
$- |
$- |