MS Excel 1. Prepare a supporting schedule trial balance) for each line item in the a. Statement of financial position b. Statement of comprehensive income 2. Obtain the increase/(decrease) in amount from 2019 to 2020. 3. Present as a percentage the increase/(decrease) obtained in No. 3 4. Present also as part of the support excel file for the four (4) FS required in MS Word. Important Notes on the Preparation of Important Notes on the Preparation of Statement of Financial Position Statement of Comprehensive Income Cash and cash equivalents line item include: Cost of Services include: Cash on hand and in banks Salaries and wages Short term deposits SSS and other contributions Light and water Tuition fee and other receivables line item Depreciation and amortization include: Sports and academic development expense Tuition fee receivables Extra-curricular activities expense Advances to employees Rent expense Nontrade receivables Retirement expense Accrued rent receivables Office supplies expense Advances to stockholders MIS expense Accrued interest receivables Uniform and outfits expense Allowance for doubtful accounts Recruitment and placement expense Library Expense Inventories line item include: Professional fees Inventories - Uniform Material processing expense Inventories - Supplies Inventories - Materials General and admin expense include: Janitorial and security services Other current assets line item include: Repairs and maintenance Advances to suppliers Transportation and communication Creditable withholding taxes Taxes and licenses Prepaid insurances and licenses Clinical expenses Provision for doubtful accounts Property and Equipment line item include: Representation expense Land Impairment loss Land improvements Miscellaneous Accumulated Depreciation - Land improvements Provision for income tax include: Building Provision for income tax - current Accumulated Depreciation - Building Provision for income tax - deferred Furnitures and Fixtures Accumulated Depreciation - Furnitures and Items of other comprehensive income: Fixtures Changes in revaluation reserve for FA in Laboratory Equipment FVOCI Accumulated Depreciation - Laboratory Changes in revaluation increment on land Equipment Changes in remeasurement gain/(loss) on Library Books retirement obligation Accumulated Depreciation - Library Books Construction in progress Other noncurrent asset line item include: Advances to contractors Software costs Financial assets at Fair Value through Other Comprehensive Income Accounts and other payable line item include: Accounts Payable Accrued expenses Contract liability Deposits liability Alumni fees payable Important Notes on the Preparation of Statement of Changes in Equity The following are the effects of the adoption of certain accounting standards to some accounts (only the first two items): Retained earning - unappropriated (12,789,569) Revaluation reserve on FVOCI (406,317) Cash dividends reserve on FVOCI (74,482,880) Important Notes on the Preparation of Statement of Cash Flows For statement of cash flows other items: 2020 2019 Provision for impairment loss 813,551 Movement in retirement liability (14,580,797) 3,871,823 Movement in tuition and other receivables* (8,351,353) (40,195,487) Movement in inventories (933,309) (4,809,873) Movement in other current assets* (10,922,293) 4,723,919 Movement in accounts payable and other liabilities* 29,686,914 74,699,813 Income taxes paid** (16,056,361) (18,703,506) Interest received** 4,886,955 3,380,317 Interest paid** (12,940,762) Acquisition of property and equipment** (168,250,269) (147,732,202) Acquisition of investment property** (152,751,487) Acquisition of software costs** (105,000) (105,000) Decrease (increase) in other noncurrent assets 2,051,761 (18,101,616) Payment for additions to land** (1,174,791) (20,521,289) Proceeds from sale of property** 367,201 60,715 Payment of dividends** (79,319,240) (74,920,501) Cash and cash equivalents at beginning of the year ? 435,796,757 *There are reconciliation items included in the amounts. Use these amounts in plotting the increase/(decrease) of these balances. Do not compare it as against the actual increase/decrease) in amounts in the line items. **Use these amounts in the actual receipt or payments for items mentioned