please help me with my assignments.worksheet and in excel form.

T.Ill .139% + 1:36 PM Edit 49 X New function! You can edit the text in the PDF directly! X PDF Edit Comprehensive Problem Presented below is the unadjusted trial balance of the Moises Dondoyano Information Systems for the year ended Dec. 31, 2018: Moises Dondoyano Information Systems Unadjusted Trial Balance Dec. 31, 2018 Cash P 45,000 Notes Receivable 360,000 Accounts Receivable 156,000 Office Supplies 63,000 Land 300,000 Building 1,590,000 Accumulated Depreciation-Building P 254,000 Equipment 2,150,000 Accumulated Depreciation-Equipment 612,000 Accounts Payable 213,000 Unearned Consulting Revenues 450,000 Dondoyano, Capital, 1/1/2018 2,655,000 Dondoyano, Withdrawals 600,000 Consulting Revenues 2,108,000 Salaries Expense 875,000 Repairs Expense 116,000 Miscellaneous Expense 37,000 Totals P6,292,000 P6,292,000 Additional information: a. Office supplies on hand as at Dec. 31, 2018 is P21,000. b . One-third of the unearned revenues has been earned as at Dec. 31, 2018. c. Depreciation for the year amounted to P38,000 for the building and P123,000 for the equipment. d. Salaries in the amount of P14,000 have accrued at year-end. e. The notes receivable were accepted from several customers. The notes were issued on Sept. 1, 2018 and will be settled together with a 20% interest on May 31, 2019. DO DD W Tools Mobile View Share PDF to DOC Oit.ill .1 39% + 1:36 PM Edit 48 X New function! You can edit the text in the PDF directly! X PDF Edit reparation The May 31, 2018 trial balance for Rosalina Besario Surveyors is presented as follows: Rosalina Besario Surveyors Trial Balance May 31, 2018 Cash Accounts Receivable P 210,000 930,000 Prepaid Advertising 360,000 Engineering Supplies 270,000 Survey Equipment 1,890,000 Accum. Depreciation-Survey Equipt. P 640,000 Accounts Payable 190,000 Unearned Survey Revenues 120,000 Notes Payable 500,000 Besario, Capital 1,120,000 Besario, Withdrawals 700,000 Survey Revenues 6,510,000 Salaries Expense 3,270,000 Rent Expense 960,000 Insurance Expense 250,000 Utilities Expense 160,000 Miscellaneous Expense 80,000 Totals P9,080,000 P9,080,000 The following information pertaining to the year-end adjustments is available: a. The P360,000 prepaid advertising represents expenditure made on Nov. 1, 2017 for monthly advertising over the next 18 months. b. A count of the engineering supplies at May 31, 2018 amounted to P90,000. C. Depreciation on the surveying equipment amounted to P160,000. d. One-third of the unearned survey revenues has been earned at year-end. e. At year-end, salaries in the amount of P140,000 have accrued. f. Interest of P60,000 on the notes payable has accrued at year-end. DO DO W Tools Mobile View Share PDF to DOC O