On January 1, Hi-r-Ed Wired Connection opened for business across the street from Northside University. The company charges students a monthly fee of $20 and $1 for each hour they are online. During January, 500 students signed up for the service, and each will have until the fifth of the following month to pay the monthly fee. By the end of January, 200 students had paid the monthly fee. Student usage, payable at the time connected, was 4,500 hours during January. Assume that Hi-r-Ed uses the accrual basis of accounting. Required: 1. Prepare the Revenues section of Hi-r-Ed's income statement for the month of January. Hi-r-Ed Wired Connection Income Statement (partial) For the Month Ended January 31 Revenues: Membership fees Online usage fees Total revenue 2. Prepare the Cash Receipts section of Hi-r-Ed's statement of cash flows for the month of January. Hi-r-Ed Wired Connection Statement of Cash Flows (partial) For the Month Ended January 31 Cash received from: Membership fees Online usage fees 3. In addition to the Cash account, what other account will appear on Hi-r-Ed's balance sheet at the end of January? What amount will be in this account?

On January 1, Hi-r-Ed Wired Connection opened for business across the street from Northside University. The company charges students a monthly fee of $20 and $1 for each hour they are online. During January, 500 students signed up for the service, and each will have until the fifth of the following month to pay the monthly fee. By the end of January, 200 students had paid the monthly fee. Student usage, payable at the time connected, was 4,500 hours during January. Assume that Hi-r-Ed uses the accrual basis of accounting. Required: 1. Prepare the Revenues section of Hi-r-Ed's income statement for the month of January. Hi-r-Ed Wired Connection Income Statement (partial) For the Month Ended January 31 Revenues: Membership fees Online usage fees Total revenue 2. Prepare the Cash Receipts section of Hi-r-Ed's statement of cash flows for the month of January. Hi-r-Ed Wired Connection Statement of Cash Flows (partial) For the Month Ended January 31 Cash received from: Membership fees Online usage fees 3. In addition to the Cash account, what other account will appear on Hi-r-Ed's balance sheet at the end of January? What amount will be in this account?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter21: Cash Budgeting (cashbud)

Section: Chapter Questions

Problem 1R: On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is...

See similar textbooks

Similar questions

On January 1, a flower shop contracts with customers to provide flowers for their wedding on June 2. The total contract price is $3,000, payable in equal installments for the next six months on the first of each month (with the first payment due January 1). How much will be recorded as revenue during the month of April?
Review the following transactions and prepare any necessary journal entries for Woodworking Magazine. Woodworking Magazine provides one issue per month to subscribers for a service fee of $240 per year. Assume January 1 is the first day of operations for this company, and no new customers join during the year. A. On January 1, Woodworking Magazine receives advance cash payment from forty customers for magazine subscription services. Handyman had yet to provide subscription services as of January 1. B. On April 30, Woodworking recognizes subscription revenues earned. C. On October 31, Woodworking recognizes subscription revenues earned. D. On December 31, Woodworking recognizes subscription revenues earned.
On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is attempting to project cash receipts and disbursements through April 30. On May 1, a note payable of 10,000 will be due. This amount was borrowed on January 1 to carry the company through its first four months of operation. The unit purchase cost of the companys single product, a box of Sweet Pleasures chocolates, is 12. The unit sales price is 28. Projected purchases and sales in units for the first four months are: Sales terms call for a 5% discount if paid within the same month that the sale occurred. It is expected that 50% of the billings will be collected within the discount period, 25% by the end of the month after purchase, 19% in the following month, and 6% will be uncollectible. Approximately 60% of the purchases are paid for in the month purchased. The rest are due and payable in the next month. Total fixed marketing and administrative expenses for each month include cash expenses of 5,000 and depreciation on equipment of 2,000. Variable marketing and administrative expenses total 6 per unit sold. All marketing and administrative expenses are paid as incurred. REQUIREMENT You have been asked to prepare a cash budget for the next four months to see if the loan can be repaid. Review the worksheet CASHBUD that follows these requirements. The problem data have already been entered in the Data Section of the worksheet.
If a customer owed your company $100 on the first day of the month, then purchased $200 of goods on credit on the fifth and paid you $50 on fifteenth, the customers ending balance for the month would show a (debit or credit) of how much?
Whole Leaves wants to upgrade their equipment, and on January 24 the company takes out a loan from the bank in the amount of $310,000. The terms of the loan are 6.5% annual interest rate, payable in three months. Interest is due in equal payments each month. Compute the interest expense due each month. Show the journal entry to recognize the interest payment on February 24, and the entry for payment of the short-term note and final interest payment on April 24. Round to the nearest cent if required.
Marc Associates employs Janet Evanovich at its law firm. Her gross income for June is $7,500. Payroll for the month of June follows: federal income tax of $650, state income tax of $60, local income tax of $30, FICA Social Security tax rate at 6.2%, FICA Medicare tax rate at 1.45%, health-care insurance premium of $300, donations to a charity of $50, and pension plan contribution of $200. The employee is responsible for covering 40% of his or her health insurance premium. A. Record the journal entry to recognize employee payroll for the month of June; dated June 30, 2017. B. Record remittance of the employees salary with cash on July 1.
Toren Inc. employs one person to run its solar management company. The employees gross income for the month of May is $6,000. Payroll for the month of May is as follows: FICA Social Security tax rate at 6.2%, FICA Medicare tax rate at 1.45%, federal income tax of $400, state income tax of $75, health-care insurance premium of $200, and union dues of $50. The employee is responsible for covering 30% of his or her health insurance premium. A. Record the journal entry to recognize employee payroll for the month of May, dated May 31, 2017. B. Record remittance of the employees salary with cash on June 1.
Mr X enrolls in a 12-month customer service assistance program for a computer software from CYBER COMPANY costing P1,200 per month on August 1, 20x8. Given that the computer assistance occurs evenly throughout the year, CYBER COMPANY uses the “proportion of time” as its measure for membership revenue, what is the amount of sales revenue to be recognized on December 31?
On May 31, Marty’s Ice Cream Shop sells gift cards for $5,000. Customers redeem $1,200 in June, $2,100 in July, and $1,400 in August. Marty’s experience is that any unredeemed gift cards as of August 31 are not likely to be redeemed. Calculate the amount of gift card revenue each month.
Below are four scenarios for a local Midas Muffler shop for the month of December.Scenario 1: On December 1, the balance of maintenance supplies totals $400. On December 15, the shop purchases an additional $200 of maintenance supplies with cash. By the end of December, only $100 of maintenance supplies remain.Scenario 2: On December 4, Midas receives $6,000 cash from a local moving company inan agreement to provide truck maintenance of $1,000 each month for the next six months, beginning in December.Scenario 3: Mechanics have worked the final four days in December, earning $600, but have not yet been paid. Midas plans to pay its mechanics on January 2.Scenario 4: Customers receiving $250 of maintenance services from Midas on December 29 have not been billed as of the end of the month. These customers will be billed on January 3 and are expected to pay the full amount owed on January 6.Required:For each of the scenarios:1. Indicate the type of adjusting entry needed.2. Record the…
Texas Roadhouse opened a new restaurant in October. During its first three months of operation, the restaurant sold gift cards in various amounts totaling $3,500. The cards are redeemable for meals within one year of the purchase date. Gift cards totaling $728 were presented for redemption during the first three months of operation prior to year-end on December 31. The sales tax rate on restaurant sales is 4%, assessed at the time meals (not gift cards) are purchased. Texas Roadhouse will remit sales taxes in January.Required:1. Record (in summary form) the $3,500 in gift cards sold (keeping in mind that, in actuality, the firm would record each sale of a gift card individually).2. Record the $728 in gift cards redeemed. (Hint: The $728 includes a 4% sales tax of $28.)3. Determine the balance in the Deferred Revenue account (remaining liability for gift cards) Texas Roadhouse will report on the December 31 balance sheet.
On January 25, Choo Choco Factory hired an employee who works five days a week from Monday to Friday and receives a weekly salary of $400 every Friday. Suppose January 31 falls on Wednesday, which of the following is correct on January 31? Select one: a. debit salaries expense and credit cash by $400 b. debit salaries expense and credit salaries payable by $240 c. debit salaries expense and credit cash by $240 d. debit salaries expense and credit salaries payable by $400