lick here to enter cengagenow h X My Home CengageNOWv2| Online teachin x n/takeAssignment/takeAssignmentMain.do?invoker3D&takeAssignmentSessionLocator=D&inprogress%3Dfalse eBook Calculator Schedule of cash payments for a service company Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $83,000 April 78,900 May 71,800 Depreciation, insurance, and property taxes represent $18,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 68% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule of cash payments for selling and administrative expenses for March, April, and May. Horizon Financial Inc. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending May 31 March April May March expenses: Paid in March Paid in April April expenses: Paid in April Paid in May May expenses: Paid in May

lick here to enter cengagenow h X My Home CengageNOWv2| Online teachin x n/takeAssignment/takeAssignmentMain.do?invoker3D&takeAssignmentSessionLocator=D&inprogress%3Dfalse eBook Calculator Schedule of cash payments for a service company Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $83,000 April 78,900 May 71,800 Depreciation, insurance, and property taxes represent $18,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 68% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule of cash payments for selling and administrative expenses for March, April, and May. Horizon Financial Inc. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending May 31 March April May March expenses: Paid in March Paid in April April expenses: Paid in April Paid in May May expenses: Paid in May

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter1: Business Transactions (ptrans)

Section: Chapter Questions

Problem 7R

See similar textbooks

Similar questions

Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas where indicated on the worksheet. Check to be sure that your balance sheet balances. Enter your name in cell A1. Save the completed file as MASTER2. Print the worksheet when done. Also print your formulas using fit-to-1 page scaling. Check figures: Borrowing (cell B78), $7,280; forecasted net income (cell D95), $40,200; total assets (cell D105), $507,600.
need asap Given: FABM Company, a service firm rendering computerizedaccounting services has the following transactions for themonth of June 2018:June 1Owner invested his savings worth P10, 000, 000 intothe business.June 3He bought P1.5 M worth of equipmentJune 5He also invested furniture and fixtures with 250,000June 7Rendered services to clients worth 150, 000 andreceived cash payment immediatelyJune 10Rendered services to clients worth 250, 000 onaccountJune 12Purchased computer supplies amounting to 30,000and issued a promissory noteJune 14Rendered services to clients worth 650, 000 withterms 50% down, balance on accountJune 15Paid salaries of employees worth 45,000June 18Collected half of the amount due last June 10June 20Paid the total amount due for utilities amounting to55, 000June 22Cash receipts amounting to 75,000 from cash salesservicesJune 24Paid the whole amount due on the noteJune 26Paid Philhealth contribution of the employeesamounting to 5,000June 28Borrowed P150,000…
SEARCH ASK CHAT MATH SOLVER Question Jack Shellenkamp owns and manages a computer repair service, which had the following trial balance on December 31, 2009 (the end of its fiscal year) BYTE REPAIR SERVICETrial BalanceDecember 31, 2009Cash $ 8,000Accounts Receivable 15,000Parts Inventory 13,000Prepaid Rent 3,000Shop Equipment 21,000Accounts Payable $19,000Jack Shellenkamp, Capital 41,000$60,000 $60,000Summarized transactions for January 2010 were as follows:1. Advertising costs, paid in cash, $1,000.2. Additional repair parts inventory acquired on account $4,000.3. Miscellaneous expenses, paid in cash, $2,000.4. Cash collected from customers in payment of accounts receivable $14,000.5. Cash paid to creditors for accounts payable due $15,000.6. Repair parts used during January $4,000. (Hint: Debit this to Repair Parts Expense.)7. Repair services performed during January: for cash $6,000; on account $9,000.8. Wages for January, paid in cash, $3,000.9.…
Solve the following, Ps. add Purchases of P100,000 on Case No.1 (3-5) to complete the problem.
Complete the following problems on an excel spreadsheet. Number your problems on a different tab. PA3 requires two special journals and a subsidiary ledger. PA3. The following transactions occurred for Donaldson Inc. during the month of July. Record the transactions for Donaldson Inc. in the proper special journal and subsidiary ledger. Jul. 1 Sold 50 items to Palm Springs Inc. and offered terms of 2/10, n/30, $4,000 on July 1, and issued invoice #12 on account number #312 Jul. 5 Sold 20 thing-a-jigs to Miami Inc. for $2,150 cash on July 5, and issued invoice #13 Jul. 8 Sold 30 what-is to Smith Mfg. for $5,000 and offered terms of 2/10, n/30; issued invoice #14 on account number #178 Jul. 9 Received payment from Palm Springs Inc. Jul. 22 Received payment from Smith Mfg. after expiration of the discount period
Using the QBO Sample Company, Craig's Design and Landscaping Services, complete the following. 1. Create Sales Receipt. Select Create (+) icon > Sales Receipt Select Customer: Dukes Basketball Camp Select Sales Receipt Date: Current Date Select Payment Method: Check Enter Reference No.: 432 Select Deposit to: Undeposited Funds Select Product/Service: Landscaping: Maintenance and Repair Enter QTY: 9 Enter Rate: 33.00 What is the Total for the Sales Receipt? (Answer this question in the table shown below. Round your answer to 2 decimal places.) Select Save and leave the Sales Receipt form open 2. View the Transaction Journal for the Sales Receipt. From the bottom of the Dukes Basketball Camp Sales Receipt, select More > Transaction Journal What are the Account and Amount Debited? (Answer this question in the table shown below. Round your answer to 2 decimal places.) What are the Account and Amount Credited? (Answer this question in the table shown below. Round your…
Roshaun Gould started a web consulting firm called Gould Solutions. He began operations and completedseven transactions in April that resulted in the following accounts, which all have normal balances. Cash . . . . . . . . . . . . . . . . . . $20,000Office supplies. . . . . . . . . . 750Prepaid rent . . . . . . . . . . . . 1,800Office equipment. . . . . . . $12,250Accounts payable. . . . . . . 12,250R. Gould, Capital. . . . . . . . 15,000R. Gould, Withdrawals. . . . . . . . . $ 5,200Consulting fees earned . . . . . . . . 20,400Miscellaneous expenses . . . . . . . 7,650 Required 1. Prepare a trial balance for this business as of the end of April. 2. The following seven transactions produced the account balances shown above. a. Gould invested $15,000 cash in the business. b. Paid $1,800 cash in advance for next month’s rent expense. c. Paid $7,650 cash for miscellaneous expenses. d. Purchased office supplies for $750 cash. e. Purchased $12,250 of office equipment on credit (with accounts…
USE MS EXCEL AND SHOW FORMULAS USED PLEASEEE Presented below are the transactions of Weirdo Beauty Salon for the month of January. 2020 Jan. 5 Received P25,500 from various customers as salon income 7 Purchased salon equipment on account, P7,500 8 Bought salon chairs and reception table from Plums Trading on account, P12,000 10 Returned defective chair to Plums Trading valued at P1,000 11 Made partial payment to Plums Trading P2,500 12 Purchased salon supplies paying P3,000 cash 15 The owner, Ms. Matutina, invested a table worth P1,750 Required: (a) Prepare the journal entries. (b) Prepare the T-Accounts. USE MS EXCEL AND SHOW FORMULAS USED PLEASEEE
Marked out of 20.00P Flag questionusing the income summary account for the month ofSiren MarketingAdjusted Trial BalanceMay 31, 2022Account TitleCashDebitCredit$8, 600Accounts Receivable$2, 500Prepaid Insurance$2,700 Accounts PayableUnearned RevenueKirk, Capital$1, 200$1, 800$5, 880Kirk, Withdrawals$1,600Service Revenue$8, 620Advertising Expenselnsurance ExpenseRent Expense Total$790$450$860$17,500 $17,500No comma or dollar sign should be included in the imput icklPrepare the closing entries in the proper order. For transactions that have more than 1 debit or more than 1 deditDebitAccount Title and Explanation Date May 31
Entity A, a VAT-registered business, had total sales of ₱3,000,000 and total purchases of ₱1,200,000 (both exclusive of VAT) during 20x1. Show all your solutions 1. How much is the Output VAT? 2. How much is the Input VAT? 3. How much VAT should Entity A remit to the BIR? 4. What is the journal entry to record the sales? 5. What is the journal entry to record the purchases? 6. What is the offsetting entry needed in order to present the net VAT payable in the statement of financial position
Directions: Show complete solutions. Take a picture of your solutions and paste in word. Submit the word file version to my email no later than 10:30am today. Thanks. Problem 1: Quarry Company, a manufacturer of small tools, provided the following information for the year ended December 31, 2020. Inventory at December 31, based on physical count – P1,750,000 Accounts payable at December 31 – P1,200,000 Net sales – P8,500,000 Additional information: Included in the physical count were tools billed to a customer FOB shipping point on December 31, 2020. These tools had a cost of P28,000 and were billed at P35,000. The shipment was in loading dock waiting to be picked up by the common carrier. Goods in transit from a vendor to Quarry Company on December 31, 2020. The invoice cost was P50,000 and the goods were shipped FOB shipping point on December 29, 2020. Work in Process inventory costing P20,000 was sent to an outside processor for plating on December 30, 2020. Tools returned by…
Questtion A: why not there will be accounts recevable? "Purchased widgets from Traders International for 100,000 in 20-Jun cash. FOB Destination. The freight cost of 5,000 paid in cash" Buyer paid on be half of seller. Question B: Please share followings: Prepare the ledgers for revenue and expenses only Prepare the closing journal for revenue and expenses the trial balance