Scribd
Upload
65 views5 pages

Module 7 Excel

This document contains financial statements for a regular agency fund as of December 31, 20X1. It includes a statement of financial position, notes to the financial statements, and a statement of financial performance. The statement of financial position shows total assets of $795,000, including current assets of $135,000 and non-current assets of $660,000. Total liabilities are $10,000, resulting in net assets/equity of $785,000. The statement of financial performance indicates revenues of $650,000 and expenses of $426,800, resulting in a surplus from current operations of $223,200 and an overall surplus for the period of $890,200.

Uploaded by

Ella Espenesin
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
65 views5 pages

Module 7 Excel

This document contains financial statements for a regular agency fund as of December 31, 20X1. It includes a statement of financial position, notes to the financial statements, and a statement of financial performance. The statement of financial position shows total assets of $795,000, including current assets of $135,000 and non-current assets of $660,000. Total liabilities are $10,000, resulting in net assets/equity of $785,000. The statement of financial performance indicates revenues of $650,000 and expenses of $426,800, resulting in a surplus from current operations of $223,200 and an overall surplus for the period of $890,200.

Uploaded by

Ella Espenesin
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Name of Entity

Statement of Financial Position


Regular Agency Fund
As at December 31, 20x1

ASSETS Notes
Current Assets
Cash and Cash Equivalents 45,000.00
Receivables, net 78,000.00
Inventories 12,000.00
Total Current Assets 135,000.00

Noncurrent Assets
Property Plan and Equipment 1 660,000.00
Total Noncurrent Assets 660,000.00

TOTAL ASSETS 795,000.00

LIABILITIES
Current Liabilities
Financial Liabilities 10,000.00
10,000.00

TOTAL LIABILITIES 10,000.00

TOTAL ASSETS less TOTAL LIABILITIES 785,000.00

NET ASSETS/EQUITY
Accumulated Surplus/ (Deficit) 785,000.00
TOTAL NET ASSETS/EQUITY 785,000.00

Name of Entity
Notes to Financial Statements
December 31, 20X1

Note1: Property Plant and Equipment


This account consist of the following

Buidlings 500,000.00
Office Equipment 450,000.00
Total Cost 950,000.00
Accumulated Depreciations- Buildings 200,000.00
Accumulated Depreciations- Equipment 90,000.00
Total Accumulated Depreciation 290,000.00

Propert, Plant and Equipment, net 660,000.00

Note 2: Tax Revenue


This account consist of the following

Immigration Tax 100,000.00


Tax Revenue 100,000.00

Note 3: Service and Business Income


This account consist of the following

Permit Fees 200,000.00


Registration Fees 160,000.00
Other Service Income 10,000.00
Power Supply System Fees 100,000.00
Landing and Parking Fees 80,000.00
Service and Business Income 550,000.00

Note 4: Personnel Services


This account consist of the following

Salaries and Wages, Regular 200,000.00


PERA 50,000.00
Personnel Services 250,000.00

Note 5: Maintenance and Other Operating Expenses


This account consist of the following

Travelling Expenses- Foreign 1,800.00


Office Supplies Expenses 63,000.00
Water Expenses 1,000.00
Electricity Expenses 5,000.00
Telephone Expenses 2,000.00
Janitorial Expenses 10,000.00
Security Expenses 12,000.00
Maintenancce and Other Operating Expenses 94,800.00

Note 6: Non-cash Expenses


This account consist of the following

Depreciation- Buildings & Other Structures 50,000.00


Depreciation- Machinery & Equipment 30,000.00
Impairment Loss- Loans and Receivables 2,000.00
Non-cash Expenses 82,000.00
Name of Entity
Statement of Financial Perfomance
Regular Agency Fund
For the year Ended December 31, 20x1

REVENUE Notes
Tax Revenue 2 100,000.00
Service and Business Income 3 550,000.00
TOTAL REVENUE 650,000.00

Less: CURRENT OPERATING EXPENSES


Personnel Services 4 250,000.00
Maintenancce and Other Operating Expenses 5 94,800.00
Non-cash Expenses 6 82,000.00

TOTAL CURRENT OPERATING EXPENSES 426,800.00

SURPLUS/ (DEFICIT) FROM CURRENT OPERATIONS 223,200.00

Net Financial Assitance/ Subsidy 667,000.00

SURPLUS/ (DEFICIT) FOR THE PERIOD 890,200.00


s

You might also like