Satellite Attachment I

Satellite Attachment I - Pro Forma 5-Year Financial Forecast.xls

Broadband Initiatives Program - Rural Libraries, Technical Assistance, and Satellite Grants

Satellite Attachment I

OMB: 0572-0145

Document [xlsx]
Download: xlsx | pdf

Overview

Upload Instructions
Existing & Project Income Stmt
Existing & Project Bal Sheet
Existing & Project Cash Flow


Sheet 1: Upload Instructions

Please Note:
There are three tabs in this workbook. Failing to complete and submit all three tabs could delay RUS' review or affect the final decision.

Sheet 2: Existing & Project Income Stmt

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









Sheet 3: Existing & Project Bal Sheet


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

Sheet 4: Existing & Project Cash Flow

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 $- $- $- $- $- $- $-
File Typeapplication/vnd.ms-excel
File TitlePro Forma 5-Year Financial Forecast Single_App
AuthorRChanda
Last Modified Bykristin.lough
File Modified2010-03-25
File Created2010-01-15

© 2024 OMB.report | Privacy Policy