Assignment Tasks

only fill ? box

B Total Fixed Assets Other Assets: Trademarks OMR 464,531 OMR 595,761 Patents Security Deposits 480,374 374,961 Other Assets Total Other Assets LIABILITIES Current Liabilities: Current maturities of long-tern OMR 152,289 OMR 169,554 Billings in excess of costs and estimated earnings on uncompleted contracts 26,273 23,583 Accounts Payable 358,457 401,241 Business Credit Cards 72,847 76,027 Sales Tax Payable 22,334 25,406 Payroll Liabilities 22,365 26,956 Accrued liabilities 16,249 14,380 Deferred income taxes 12,959 13,835 Total Current Liabilities Long-Term Liabilities: Notes Payable OMR 88,245 OMR 75,377 Mortgage Payable 108,856 130,293 Less: Current portion of Long-te (12,000) (12,000) CW DATALess: Current portion of Long-te 2 (12,000) (12,000) Total Long-Term Liabilities EQU Capital Stock/Partner's Equity OMR 20,000 OMR 20,000 Opening Retained Earnings 449,182 452,076 Dividends Paid/Owner's Draw (15,000) (15,000) Net Income (Loss) 14,041 10,719 Total Equity Table 2: AAA Company Income Statement AAA CONSTRUCTION COMPANY, INC. INCOME STATEMENT YEARS ENDED DECEMBER 31, 2019, 2018 AND 2017 2019 2018 2017 CONTRACT REVENUE OMR 6,827,798 OMR 6,207,089 OMR 7.454,302 CONTRACT COSTS 5,732,911 5,211,737 4,992,475 Gross profit GENERAL AND ADMINISTRATIVE E OMR 582,386 OMR 529.442 OMR 443.399 Operating profit OTHER INCOME (EXPENSE) Customer finance charges TOMR 8,163 OMR 7.421 OMR 5,438 Miscellaneous income 5,888 5,353 3,896 Gain on sale of assets 5,566 5,060 5,447 CW DATA Type here to search OAAA Interest income 5.574 5,067 4,975 Interest expense (40 225) (36,568) (36,498) Total other income (expense Earnings before income tax expense INCOME TAX EXPENSE OMR 30,373 OMR 27.612 OMR 21,760 NET EARNINGS Table 3: AAA Company Cash Flow Statement AAA CONSTRUCTION COMPANY, INC. STATEMENTS OF CASH FLOWS DECEMBER 31, 2019, 2018 AND 2017 2019 2018 2017 OPERATING ACTIVITIES Net earnings OMR 99,112 OMR 90,102 OMR 90,360 Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation Gain on sale of assets (5,511) (5,010) (6,272) Change in allowance for doul 3,314 3,013 6,542 Change in deferred income ta" 2,959 2,690 (5,559) (Increase) decrease in: Accounts receivable - trade 419,375 381,250 563,017 CW DATAAccounts receivable -trade 419,375 381,250 Accounts receivable - other 563,017 11,887 10,806 14,825 Costs and estimated earnings in excess of billings on uncompleted contracts 30,507 27,734 20,754 Inventory 37,463 34,057 32,773 Prepaid expenses 15,887 14,443 12,009 Increase (decrease): Accounts payable - trade 38,902 35,365 42,487 AAA Com Billings in excess of costs and estimated earnings on uncompleted contracts 16,915 15,377 11,213 Federal income tax payable 20,308 18,462 12,744 Accrued liabilities 19,169 17,426 17,126 NET CASH PROVIDED BY OPERATING ACTIVITIES INVESTING ACTIVITIES Proceeds from sale of assets OMR 12,448 OMR 11,316 OMR 8,876 Purchase of property and equip (57,611) (52,374) (76,768) NET CASH USED IN INVESTING ACTIVITIES FINANCING ACTIVITIES Proceeds from issuance of lon OMR 62,721 OMR 57,019 OMR 50,151 CW DATA Type here to search O HiCING ACTIVITIES Proceeds from issuance of lon, OMR 62,721 OMR 57,019 OMR Reduction of long-term debt (279,547) 50,151 (254,134) NET CASH USED IN FINANCING ACTIVITIES (217,063) NET INCREASE IN CASH Cash at beginning of year ? OMR 59,823 Cash at end of year ? 89.854 It is required to find the value in this cell Any missing/incorrect data should be reasonably i able 4: Detailed Transactions during 2018 Detailed Description of Transaction Amount AAA invested cash in the business. OMR 362,662 Paid for office rent for the month 13,746 Withdrew cash for personal use 59,384 Received a cash payment for services provided 127,881 Purchased gasoline on account 3,955 Made a cash payment on the note payable 128,048 Paid for utilities 32,552 Paid for employee salaries 218,413 Collected of accounts receivable 132,682 CW DATA OBALANCE SHEETS DECEMBER 31, 2019, 2018 AND 2017 2019 2018 2017 ASSETS Current Assets: Cash OMR 565,052 OMR 693,320 Certificate of deposit 15,449 19,638 Accounts receivable - trade, net 329,975 254,416 Accounts receivable - other 12,205 10,633 Costs and estimated earnings in excess of billings on uncompleted contracts 23,687 29,980 Inventory 144,525 182,140 Prepaid Expenses 24,337 28,177 Employee Advances 15,000 Total Current Assets Fixed Assets: Land OMR 2,110,232 OMR 1,720,145 Buildings 787,589 617,841 Furniture and Equipment 234,819 278,637 Computer Equipment 58,321 55,490 Vehicles 109,989 145,690 Less: Accumulated Depreciation Total Fixed Assets CW DATA