High-Cost Universal Service Support

High-Cost Universal Service Support

Copy of 3005-Rate-of-Return-Data-Upload-Template_DRAFT (1).xlsm

High-Cost Universal Service Support

OMB: 3060-0986

Document [xlsx]
Download: xlsx | pdf

Overview

Summary
3005a BalanceSheet
3005b IncomeStatement
3005c Cashflow


Sheet 1: Summary






Mandatory fields that are blank





Worksheet Input Item Line Item Error Status





3005a BalanceSheet Study Area Code <010> Study Area Code can not be blank





3005a BalanceSheet Study Area Name <015> Study Area Name can not be blank





3005a BalanceSheet Program Year <020> Program Year can not be blank





3005a BalanceSheet Contact Name - Person USAC should contact regarding this data <030> Contact Name - Person USAC should contact regarding this data can not be blank

Number of fields with invalid data
3005a BalanceSheet Contact Telephone Number - Number of person identified in data line <030> <035> Contact Telephone Number - Number of person identified in data line <030> can not be blank
3005a BalanceSheet
0
3005a BalanceSheet Contact Telephone Email Address - Email Address of person identified in data line <030> <039> Contact Telephone Email Address - Email Address of person identified in data line <030> can not be blank
3005b IncomeStatement
0
3005c Cashflow Explanation for cell C20 5 OK
3005c Cashflow
0
3005c Cashflow Explanation for cell C39 22 OK





3005c Cashflow Explanation for cell C45 27 OK














Totals that can not be zero





Worksheet Input Item Line Item Error Status





3005a BalanceSheet Total Assets 24 Total Assets can not be zero for both prior year and current year. Please complete the 3005a BalanceSheet worksheet (columns C and/or D).





3005a BalanceSheet Total Liabilities and Equity 59 Total Liabilities and Equity can not be zero for both prior year and current year. Please complete the 3005a BalanceSheet worksheet (columns G and/or H).





3005b IncomeStatement Input items for prior year
OK





3005b IncomeStatement Input items for current year
OK

Sheet 2: 3005a BalanceSheet

(3005a) Operating Report for Privately-Held Rate of Return Carriers


FCC Form 481


Balance Sheet - Data Collection Form


OMB Control No. 3060-0986


Page 1 of 3


July 2013










<010> Study Area Code

<010>


<015> Study Area Name

<015>


<020> Program Year

<020>


<030> Contact Name - Person USAC should contact regarding this data

<030>


<035> Contact Telephone Number - Number of person identified in data line <030>

<035>


<039> Contact Telephone Email Address - Email Address of person identified in data line <030>

<039>


















CERTIFICATION
We hereby certify that the entries in this report are in accordance with the accounts and other records of the system and reflect the status of the system to the best of our knowledge and belief.

















Signature
Date



PART A. BALANCE SHEET
ASSETS BALANCE PRIOR YEAR BALANCE END OF PERIOD LIABILTIES AND STOCKHOLDERS' EQUITY BALANCE PRIOR YEAR BALANCE END OF PERIOD
CURRENT ASSETS


CURRENT LIABILITIES


1. Cash and Equivalents

25. Accounts Payable

2. Cash-RUS Construction Fund

26. Notes Payable

3. Affiliates:

27. Advance Billings and Payments


a. Telecom, Accounts Receivable

28. Customer Deposits


b. Other Accounts Receivable

29. Current Mat. L/T Debt


c. Notes Receivable

30. Current Mat. L/T Debt-Rur. Dev.

4. Non-Affiliates:

31. Current Mat.-Capital Leases


a. Telecom, Accounts Receivable

32. Income Taxes Accrued


b. Other Accounts Receivable

33. Other Taxes Accrued


c. Notes Receivable

34. Other Current Liabilities

5. Interest and Dividends Receivable

35. Total Current Liabilities (25 thru 34) 0 0
6. Material-Regulated

LONG-TERM DEBT


7. Material-Nonregulated

36. Funded Debt-RUS Notes

8. Prepayments

37. Funded Debt-RTB Notes

9. Other Current Assets

38. Funded Debt-FFB Notes

10. Total Current Assets (1 Thru 9) 0 0 39. Funded Debt-Other





40. Funded Debt-Rural Develop. Loan

NONCURRENT ASSETS


41. Premium (Discount) on L/T Debt

11. Investment in Affiliated Companies

42. Reacquired Debt


a. Rural Development

43. Obligations Under Capital Lease


b. Nonrural Development

44. Adv. From Affiliated Companies

12. Other Investments

45. Other Long-Term Debt


a. Rural Development

46. Total Long-Term Debt (36 thru 45) 0 0

b. Nonrural Development

OTHER LIAB. & DEF. CREDITS


13. Nonregulated Investments

47. Other Long-Term Liabilities

14. Other Noncurrent Assets

48. Other Deferred Credits

15. Deferred Charges

49. Other Jurisdictional Differences

16. Jurisdictional Differences

50. Total Other Liabilities and Deferred Credits (47 thru 49) 0 0
17. Total Noncurrent Assets (11 thru 16) 0 0 EQUITY






51. Cap. Stock Outstanding & Subscribed

PLANT, PROPERTY, AND EQUIPMENT


52. Additional Paid-in-Capital

18. Telecom, Plant-in-Service

53. Treasury Stock

19. Property Held for Future Use

54. Membership and Cap. Certificates

20. Plant Under Construction

55. Other Capital

21. Plant Adj., Nonop. Plant & Goodwill

56. Patronage Capital Credits

22. Less Accumulated Depreciation

57. Retained Earnings or Margins

23. Net Plant (18 thru 21 less 22) 0 0 58. Total Equity (51 thru 57) 0 0








24. TOTAL ASSETS (10+17+23) 0 0 59. TOTAL LIABILITIES AND EQUITY (35+46+50+58) 0 0

Sheet 3: 3005b IncomeStatement

(3005b) Operating Report for Privately-Held Rate of Return Carriers


FCC Form 481


Balance Sheet - Data Collection Form


OMB Control No. 3060-0986


Page 2 of 3


July 2013










<010> Study Area Code

<010>


<015> Study Area Name

<015>


<020> Program Year

<020>


<030> Contact Name - Person USAC should contact regarding this data

<030>


<035> Contact Telephone Number - Number of person identified in data line <030>

<035>

<039> Contact Telephone Email Address - Email Address of person identified in data line <030>

<039>














PART B. STATEMENTS OF INCOME AND RETAINED EARINGS OR MARGINS
ITEM PRIOR YEAR THIS YEAR
1. Local Network Services Revenues

2. Network Access Services Revenues

3. Long Distance Network Services Revenues

4. Carrier Billing and Collection Revenues

5. Miscellaneous Revenues

6. Uncollectible Revenues

7. Net Operating Revenues (1 thru 5 less 6) 0 0
8. Plant Specific Operations Expense

9. Plant Nonspecific Operations Expense (Excluding Depreciation & Amortization)

10. Depreciation Expense

11. Amortization Expense

12. Customer Operations Expense

13. Corporate Operations Expense

14. Total Operating Expenses (8 thru 13) 0 0
15. Operating Income or Margins (7 less 14) 0 0
16. Other Operating Income and Expenses

17. State and Local Taxes

18. Federal Income Taxes

19. Other Taxes

20. Total Operating Taxes (17+18+19) 0 0
21. Net Operating Income or Margins (15+16-20) 0 0
22. Interest on Funded Debt

23. Interest Expense - Capital Leases

24. Other Interest Expense

25. Allowance for Funds Used During Construction

26. Total Fixed Charges (22+23+24-25) 0 0
27. Nonoperating Net Income

28. Extraordinary Items

29. Jurisdictional Differences

30. Nonregulated Net Income

31. Total Net Income or margins (21+27+28+29+30-26) 0 0
32. Total Taxes Based on Income

33. Retained Earnings or Margins Beginning-of-Year

34. Miscellaneous Credits Year-to-Date

35. Dividends Declared (Common)

36. Dividends Declared (Preferred)

37. Other Debits Year-to-Date

38. Transfers to Patronage Capital

39. Retained Earnings or Margins end-of-Period [(31+33+34)-(35+36+37+38)] 0 0
40. Patronage Capital Beginning-of-Year

41. Transfers to Patronage Capital

42. Patronage Capital Credits Retired

43. Patronage Capital End-of-Year (40+41-42) 0 0
44. Annual Debt Service Payments

45. Cash Ratio [(14+20-10-11)/7] 0.00 0.00
46. Operating Accrual Ratio [(14+20+26)/7] 0.00 0.00
47. TIER [(31+26)/26] 0.00 0.00
48. DSCR [(31+26+10+11)/44] 0.00 0.00

Sheet 4: 3005c Cashflow

(3005c) Operating Report for Privately-Held Rate of Return Carriers


FCC Form 481


Balance Sheet - Data Collection Form


OMB Control No. 3060-0986


Page 3 of 3


July 2013










<010> Study Area Code

<010>


<015> Study Area Name

<015>


<020> Program Year

<020>


<030> Contact Name - Person USAC should contact regarding this data

<030>


<035> Contact Telephone Number - Number of person identified in data line <030>

<035>


<039> Contact Telephone Email Address - Email Address of person identified in data line <030>

<039>

















PART C. STATEMENTS OF CASH FLOWS
1. Beginning Cash (Cash and Equivalents plus RUS Construction Fund)
CASH FLOWS FROM OPERATING ACTIVITIES
2. Net Income
Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities
3. Add: Depreciation

4. Add: Amortization

5. Other (Explain)


Changes in Operating Assets and Liabilities
6. Decrease/(Increase) in Accounts Receivable
7. Decrease/(Increase) in Materials and Inventory
8. Decrease/(Increase) in Prepayments and Deferred Charges
9. Decrease/(Increase) in Other Current Assets
10. Increase/(Decrease) in Accounts Payable
11. Increase/(Decrease) in Advance Billings & Payments
12. Increase/(Decrease) in Other Current Liabilities
13. Net Cash Provided/(Used) by Operations 0
CASH FLOWS FROM FINANCING ACTIVITIES
14. Decrease/(Increase) in Notes Receivable
15. Increase/(Decrease) in Notes Payable
16. Increase/(Decrease) in Customer Deposits
17. Net Increase/(Decrease) in Long Term Debt (Including Current Maturities)
18. Increase/(Decrease) in Other Liabilities & Deferred Credits
19. Increase/(Decrease) in Capital Stock, Paid-in Capital, Membership and Capital Certificates & Other Capital
20. Less: Payment of Dividends
21. Less: Patronage Capital Credits Retired
22. Other (Explain)


23. Net Cash Provided/(Used) by Financing Activities 0
CASH FLOWS FROM INVESTING ACTIVITIES
24. Net Capital Expenditures (Property, Plant & Equipment)
25. Other Long-Term Investments
26. Other Noncurrent Assets & Jurisdictional Differences
27. Other (Explain)


28. Net Cash Provided/(Used) by Investing Activities 0
29. Net Increase/(Decrease) in Cash 0
30. Ending Cash 0
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy