{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-28T08:27:35-04:00", "answer_date": "2024-06-28 08:27:35", "is_docs_available": null, "is_excel_available": null, "is_pdf_available": null, "count_file_available": 0, "main_page": "student_question_view", "question_id": "4274640", "url": "\/study-help\/questions\/i-need-help-with-this-exercise-i-can-figure-it-4274640", "question_creation_date_js": "2024-06-28T08:27:35-04:00", "question_creation_date": "Jun 28, 2024 08:27 AM", "meta_title": "[Solved] I need help with this exercise. I can fig | SolutionInn", "meta_description": "Answer of - I need help with this exercise. I can figure it out E7-8 section b. Can you please help? E7-8 Prepare bank reconciliat | SolutionInn", "meta_keywords": "help,exercise,figure,e7-8,section,prepare,bank,reconciliation,adjusting,entries,information,pertains", "question_title_h1": "I need help with this exercise. I can figure it out E7-8 section b. Can you please help? E7-8 Prepare bank reconciliation and adjusting entries", "question_title": "I need help with this exercise. I can figure it out E7-8", "question_title_for_js_snippet": "I need help with this exercise I can figure it out E7 8 section b Can you please help E7 8 Prepare bank reconciliation and adjusting entries The following information pertains to Joyce Company 1 Cash balance per bank, July 31, $7,328 2 July bank service charge not recorded by the depositor $38 3 Cash balance per books, July 31, $7,364 4 Deposits in transit, July 31, $2,700 5 Note for $2,000 collected for Joyce Company in July by the bank, plus interest $36 less fee $20 The collection has not been recorded by Joyce Company, and no interest has been accrued 6 Outstanding checks, July 31, $686 Instructions (a) Prepare a bank reconciliation at July 31, 2014 (b) Journalize the adjusting entries at July 31 on the books of Joyce Company NOTE Enter a number in cells requesting a value enter either a number or a formula in cells with a (a) JOYCE COMPANY Bank Reconciliation July 31, 2014 Cash balance per bank statement Add Deposits in transit Less Outstanding checks Adjusted cash balance per bank Cash balance per books Add Collection of note receivable Less Bank service charge Adjusted cash balance per books (b) July 31 July 31 $7,328 2,700 10,028 686 9,342 $7,364 2,036 9,400 58 $9,342 Cash balance per bank statement Cash balance per books Account Account 10,028 686 Account 9,342 Account 9,400 58 9,342 ls with a E7 9 Prepare bank reconciliation and adjusting entries This information relates to the Cash account in the ledger of Treanor Company Balance September 1 $16,400 Cash deposited $64,000 Balance September 30 $17,600 Checks written $62,800 The September bank statement shows a balance of $16,500 at September 30 and the following memoranda Credits Collection of $1,800 note plus interest $30 Interest earned on checking account $1,830 45 Debits NSF checks H Kane Safety deposit box rent At September 30, deposits in transit were $4,738 and outstanding checks totaled $2,383 Instructions (a) Prepare the bank reconciliation at September 30, 2014 (b) Prepare the adjusting entries at September 30, assuming (1) the NSF check was from a customer on account, and (2) no interest had been accrued on the note NOTE Enter a number in cells requesting a value enter either a number or a formula in cells with a (a) TREANOR COMPANY Bank Reconciliation September 30, 2014 Cash balance per bank statement Add Deposits in transit $16,500 4,738 21,238 2,383 18,855 Less Outstanding checks Adjusted cash balance per bank Cash balance per books Add Collection of note receivable Interest earned Less NSF check Safety deposit box rent Adjusted cash balance per books (b) Sept 30 Cash $1,800 30 $560 60 45 3,678 620 3,058 3,058 Interest Interest on Account 30 45 30 Accounts Receibable Cash 560 30 Miscelleaneur Expenses Cash 60 30 Cash 560 60 2,383 Accounts Payable 2,383 bits $560 60 n cells with a E7 14 Prepare a cash budget for two months Enright company expects to have a cash balance of $46,000 on January 1, 2014 These are the relevant monthly budget data for the first two months of 2014 1 Collection from customers January $71,000, February $146,000 2 Payments to suppliers January $40,000, February $75,000 3 Wages January $30,000, February $40,000 Wages are paid in the month they are incurred 4 Administrative expenses January $21,000, February $24,000 These costs include depreciation of $1,000 per month All other costs are paid as incurred 5 Selling expenses January $15,000, February $20,000 These costs are exclusive of depreciation They are paid as incurred 6 Sales of short term investments in January are expected to realize $12,000 in cash Enright has a line of credit at a local bank that enables it to borrow up to $25,000 The company want to maintain a minimum monthly cash balance of $20,000 Instructions Prepare a cash budget for January and February NOTE Enter a number in cells requesting a value enter either a number or a formula in cells with a ENRIGHT COMPANY Cash Budget For the Two Months Ending February 28, 2014 January $46,000 February $24,000 71,000 12,000 83,000 129,000 146,000 0 146,000 170,000 40,000 30,000 20,000 15,000 105,000 24,000 75,000 40,000 23,000 20,000 158,000 12,000 0 0 $24,000 8,000 0 $20,000 Beginning cash balance Add Cash receipts Collections from customers Sale of short term investments Total receipts Total available cash Less Cash disbursements Payments to suppliers Wages Administrative expenses Selling expenses Total disbursements Excess (deficiency) of available cash over disbursements Financing Add Borrowings Less Repayments Ending cash balance n cells with a quot", "question_description": "

I need help with this exercise. I can figure it out E7-8 section b. Can you please help?<\/p>\"image E7-8 Prepare bank reconciliation and adjusting entries The following information pertains to Joyce Company. 1. Cash balance per bank, July 31, $7,328. 2. July bank service charge not recorded by the depositor $38. 3. Cash balance per books, July 31, $7,364. 4. Deposits in transit, July 31, $2,700. 5. Note for $2,000 collected for Joyce Company in July by the bank, plus interest $36 less fee $20. The collection has not been recorded by Joyce Company, and no interest has been accrued. 6. Outstanding checks, July 31, $686. Instructions (a) Prepare a bank reconciliation at July 31, 2014. (b) Journalize the adjusting entries at July 31 on the books of Joyce Company. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a \"?\" . (a) JOYCE COMPANY Bank Reconciliation July 31, 2014 Cash balance per bank statement Add: Deposits in transit Less: Outstanding checks Adjusted cash balance per bank Cash balance per books Add: Collection of note receivable Less: Bank service charge Adjusted cash balance per books (b) July 31 July 31 $7,328 2,700 10,028 686 9,342 $7,364 2,036 9,400 58 $9,342 Cash balance per bank statement Cash balance per books Account Account 10,028 686 Account 9,342 Account 9,400 58 9,342 ls with a \"?\" . E7-9 Prepare bank reconciliation and adjusting entries This information relates to the Cash account in the ledger of Treanor Company. Balance September 1 - $16,400; Cash deposited - $64,000 Balance September 30 - $17,600; Checks written - $62,800 The September bank statement shows a balance of $16,500 at September 30 and the following memoranda. Credits Collection of $1,800 note plus interest $30 Interest earned on checking account $1,830 45 Debits NSF checks: H. Kane Safety deposit box rent At September 30, deposits in transit were $4,738 and outstanding checks totaled $2,383. Instructions (a) Prepare the bank reconciliation at September 30, 2014. (b) Prepare the adjusting entries at September 30, assuming (1) the NSF check was from a customer on account, and (2) no interest had been accrued on the note. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a \"?\" . (a) TREANOR COMPANY Bank Reconciliation September 30, 2014 Cash balance per bank statement Add: Deposits in transit $16,500 4,738 21,238 2,383 18,855 Less: Outstanding checks Adjusted cash balance per bank Cash balance per books Add: Collection of note receivable Interest earned Less: NSF check Safety deposit box rent Adjusted cash balance per books (b) Sept. 30 Cash $1,800 30 $560 60 45 3,678 620 3,058 3,058 Interest Interest on Account 30 45 30 Accounts Receibable Cash 560 30 Miscelleaneur Expenses Cash 60 30 Cash 560 60 2,383 Accounts Payable 2,383 bits $560 60 n cells with a \"?\" . E7-14 Prepare a cash budget for two months Enright company expects to have a cash balance of $46,000 on January 1, 2014. These are the relevant monthly budget data for the first two months of 2014. 1. Collection from customers: January $71,000, February $146,000. 2. Payments to suppliers: January $40,000, February $75,000. 3. Wages: January $30,000, February $40,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $21,000, February $24,000. These costs include depreciation of $1,000 per month. All other costs are paid as incurred. 5. Selling expenses: January $15,000, February $20,000. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize $12,000 in cash. Enright has a line of credit at a local bank that enables it to borrow up to $25,000. The company want to maintain a minimum monthly cash balance of $20,000. Instructions Prepare a cash budget for January and February. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a \"?\" . ENRIGHT COMPANY Cash Budget For the Two Months Ending February 28, 2014 January $46,000 February $24,000 71,000 12,000 83,000 129,000 146,000 0 146,000 170,000 40,000 30,000 20,000 15,000 105,000 24,000 75,000 40,000 23,000 20,000 158,000 12,000 0 0 $24,000 8,000 0 $20,000 Beginning cash balance Add: Cash receipts Collections from customers Sale of short-term investments Total receipts Total available cash Less: Cash disbursements Payments to suppliers Wages Administrative expenses Selling expenses Total disbursements Excess (deficiency) of available cash over disbursements Financing Add: Borrowings Less: Repayments Ending cash balance n cells with a \"?"", "transcribed_text": "", "related_book": { "title": "Data Analysis And Decision Making", "isbn": "538476125, 978-0538476126", "edition": "4th Edition", "authors": "Christian Albright, Wayne Winston, Christopher Zappe", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/415.jpg", "uri": "\/textbooks\/data-analysis-and-decision-making-4th-edition-415", "see_more_uri": "" }, "free_related_book": { "isbn": "364211203X", "uri": "\/textbooks\/overview-of-the-pmbok-guide-short-cuts-for-pmp-certification-1st-edition-978-3642112034-298253", "name": "Overview Of The Pmbok Guide Short Cuts For Pmp Certification", "edition": "1st Edition" }, "question_posted": "2024-06-28 08:27:35", "see_more_questions_link": "\/study-help\/questions\/business-marketing-2022-June-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/squirrel-tree-services-reports-the-following-amounts-on-december-31-207958", "description": "Squirrel Tree Services reports the following amounts on December 31. In addition, the company reported the following cash flows. Required: 1. Prepare a balance sheet. 2. Prepare a statement of...", "stars": 3 }, { "url": "\/study-help\/psychology\/3-what-is-the-evidence-for-the-effectiveness-of-treatment-1982383", "description": "3. What is the evidence for the effectiveness of treatment approaches for dangerous offenders?", "stars": 3 }, { "url": "\/consider-flat-plate-subject-to-parallel-flow-top-and-bottom", "description": "Consider a flat plate subject to parallel flow (top and bottom) characterized by U = 5 m\/s, T = 20C. (a) Determine the average convective heat transfer coefficient, convective heat transfer rate, and...", "stars": 3 }, { "url": "\/study-help\/questions\/101-cpa-now-sells-print-materials-and-an-app-to-9882066", "description": "101) CPA Now sells print materials and an app to help its customers prepare for the CPA exam. Along with these products, the company also provides updates to the app and coaching services. The...", "stars": 3 }, { "url": "\/study-help\/questions\/the-purple-company-this-project-will-give-you-an-opportunity-1416125", "description": "The Purple Company This project will give you an opportunity to apply your knowledge of accounting principles and procedures to a corporation. You will handle the accounting work of The Purple...", "stars": 3 }, { "url": "\/study-help\/questions\/8-4-3-parker-corporation-which-operates-on-a-7318514", "description": "8 - 4 3 Parker Corporation, which operates on a calendar year, expects to sell 6 , 0 0 0 units in October, and expects sales to increase 2 0 % each month thereafter. Sales price is expected to stay...", "stars": 3 }, { "url": "\/study-help\/questions\/the-psychiatric-hospitals-pl-is-a-classic-twosided-marketplace-that-991023", "description": "The Psychiatric Hospitals P&L is a classic two-sided marketplace that matches Healthcare Facilities (HCFs) who need last minute shifts filled with Healthcare Professionals (HCPs) nearby who happen to...", "stars": 3 }, { "url": "\/study-help\/questions\/question-1-b-configuration-and-customization-are-two-types-of-1004546", "description": "QUESTION 1 (b) Configuration and customization are two types of processes in ERP system which enable an organisation to tailor its business processes. Compare and contrast between configuration and...", "stars": 3 }, { "url": "\/study-help\/questions\/when-conducting-a-review-on-any-business-the-first-thing-991937", "description": "When conducting a review on any business, the first thing that needs to be completed is a SWOT Analysis (strengths, weaknesses, opportunities, and threats). This analysis helps a business know where...", "stars": 3 }, { "url": "\/study-help\/questions\/how-did-you-accomplish-your-goals-for-this-experience-991685", "description": ". How did you accomplish your goals for this experience? 2. What did you learn about yourself through this experience? 3. Were your expectations for this experience realistic? Why or why not? 4. What...", "stars": 3 }, { "url": "\/study-help\/questions\/case-study-towards-the-end-of-the-1990s-the-iconic-1004297", "description": "Case study Towards the end of the 1990s the iconic British garment company Burberry was in trouble. For the financial year ending 31 March 1998, profits plunged from 62 million to 25 million. The...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/information-for-the-sandy-manufacturing-company-for-the-month-of-4274639", "next": "\/study-help\/questions\/a-vast-majority-of-raw-materials-are-delivered-from-varied-4274641" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "I need help with this exercise. I can figure it out E7-8", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/i-need-help-with-this-exercise-i-can-figure-it-4274640" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } }t_id": "1" } }