HELLO KINDLY ANSWER THESE PLEASE. THANK YOU!!
Please send the soft copy link here of MS Excel and also the picture of the answer here. Thank you so much
Required
Sheet 1: Chart of Accounts
Sheet 2. Journal
Sheet 3. Ledger
Sheet 4. Trial Balance
Weddings 'R" Us Chart of Accounts Balance Sheet Accounts Income Statement Accounts Assets Income 110 Cash 410 Consulting Revenues 120 Accounts Receivable 420 Referral Revenues 130 Supplies 140 Prepaid Rent Expenses 150 Prepaid Insurance 510 Salaries Expense 160 Service Vehicle 520 Supplies Expense 165 Accumulated Depreciation 530 Rent Expense 170 Office Equipment 540 Insurance Expense 175 Accumulated Depreciation 550 Utilities Expense Liabilities 560 Depreciation Expense - Service Vehicle 210 Notes Payable 570 Depreciation Expense - Office Equipment 220 Accounts Payable 580 Miscellaneous Expense 230 Salaries Payable 590 Interest Expense 24o Utilities Payable 250 Interest Payable 260 Uneamed Referral Revenues Owner's Equity 310 Perez-Manolo, Capital 320 Perez-Mahala, Withdrawals 330 Income Summary May 1 L Maria Concepcion Jennifer Perez-Manaio is a social entrepreneur from the South. She is into a lot of interesting causes. Her fine taste is preeminent such that she is considered an authority in planning weddings. Upon the advice and prodding of an esteemed colleague. Bendalyn Landicho, Perez-Manolo decided to organize her wedding consultancy. She invested P250,000 into this entity. Rented office space and paid two months' rent in advance, P8,000. Maria Concepcion Jennifer Perez-Manaio issued a promissory note for a P210,000 loan from Metrobank. This avaitment will be used for the acquisition of a service vehicle. The note carries a 20% interest per annum. The arrangement with the bank is that both the interest and the principai are payable in full in one year. Hired an office assistant and an account executive each with a P7,800 monthly salary. 0r, each is to receive P300 per day for the 26-day work month. No entry is necessary at this point. They started work immediately. Acquired service vehicle for P420,000. Paid Prudential Guarantee and Assurance, Inc. P14,400 for a one-year comprehensive insurance coverage on the service vehicle. Acquired office equipment from Fair and Square Emporium for P60.00U: paying P15,000 in cash and the balance next month. 8 Purchased supplies on credit for P18,000 from San Jose Merchandising. 9 Paid San Jose Merchandising P10,000 of the amount owed. 10 Coordinated and finalized simple bridal arrangements for three couples and collected fees of P8,800 per couple. Services include prospecting and selecting the church and reception location, couturier, caterer, car service, flowers, souvenirs and invitations. 13 Paid salaries P6,600. The entity pays salaries every two Saturdays. 15 The entity is earning additional revenues by referring consulting clients to friendly hotels, caterers, printers, and couturiers. Received P10,000 advance fees for three clients referred. Coordinated and finalized elaborate bridal arrangements for three couples and billed fees of P12,000 per couple. Additional services include documents preparation, consultation with an feng shui expert as to the ideal wedding date for prosperity and harmony, provision for limousine service and honeymoon trip. 25 Perez-Manalo withdrew P14,000 for personal expenses. 27 Paid salaries, P7,200. 30 Received the ICC-BayanTel telephone bill, P1,400. 30 Received P24,000 from two clients for services billed last May 19. 31 Settled the electricity bill of P3,000 for the month. Requirement: 1. Create a MS Excel file. 2. Create the following sheets using the transactions and chart of accounts above: Sheet 1: Chart of Accounts Sheet 2: Journal Sheet 3: Ledger Sheet 4: Trial Balance 3. Use the basic formulas in excel to arrive at the most efficient way of solving accounting transactions
