Scribd Logo
Upload

Welcome to Scribd!

  • 27 views

    Module 7 Excel

    Uploaded by

    Ella Espenesin
    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Module 7 Excel

    Uploaded by

    Ella Espenesin
    27 views5 pages
    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.

    Original Description:

    module

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    27 views5 pages

    Module 7 Excel

    Uploaded by

    Ella Espenesin
    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5

    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