Primer on using excel in accounting by rex a

This preview shows page 10 - 12 out of 13 pages.

Primer on Using Excel in Accounting by Rex A Schildhouse P7-1 (Determine Proper Cash Balance) Francis Equipment Co. closes its books regularly on December 31, but at the end of 2012 it held its cash book open so that a more favorable balance sheet could be prepared for credit purposes. Cash receipts and disbursements for the first 10 days of January were recorded as December transactions. The information is given below. 1. January cash receipts recorded in the December cash book totaled 2. January cash disbursements recorded in the December check register liquidated accounts payable 3. The ledger has not been closed for 2012. 4. The amount shown as inventory was determined by physical count on December 31, 2012. (a) Prepare any entries you consider necessary to correct Francis’s accounts at December 31. (b) To what extent was Francis Equipment Co. able to show a more favorable balance sheet at December 31 by holding its cash book open? (Compute working capital and the current ratio.) Assume that the balance sheet that was prepared by the company showed the following amounts:
Image of page 10

Subscribe to view the full document.

3e342596ae0fe030578ba3dc28b9f82c86a0c05b.xlsx, Problem 7-1, Page 11 of 13, 03/03/2016, 09:54:16 Name: Date: Instructor: Course: $45,640 , of which $28,000 represents cash sales, and $17,640 represents collections on account for which cash discounts of $360 were given. of $22,450 on which discounts of $250 were taken. The company uses the periodic method of inventory. Instructions: Dec 31, 12 Account Title Amount Account Title Amount Account Title Amount Account Title Amount Dec 31, 12 Account Title Amount Account Title Amount Account Title Amount Per Balance Sheet After Adjustment Current assets Debit Credit Debit Credit Cash $39,000 Amount Receivables 42,000 Amount Inventories 67,000 Amount Totals: $148,000 Formula Current Liabilities Accounts Payable $45,000 Amount Other Current Liabilities 14,200 Amount Totals: $59,200 Formula Working capital Formula Formula Current ratio: Formula to 1 Formula to 1 Intermediate Accounting , 14 th Edition by Kieso, Weygandt, and Warfield Primer on Using Excel in Accounting by Rex A Schildhouse P7-1 (Determine Proper Cash Balance) Francis Equipment Co. closes its books regularly on December 31, but at the end of 2012 it held its cash book open so that a more favorable balance sheet could be prepared for credit purposes. Cash receipts and disbursements for the first 10 days of January were recorded as December transactions. The information is given below. 1. January cash receipts recorded in the December cash book totaled 2. January cash disbursements recorded in the December check register liquidated accounts payable 3. The ledger has not been closed for 2012. 4. The amount shown as inventory was determined by physical count on December 31, 2012. (a) Prepare any entries you consider necessary to correct Francis’s accounts at December 31.
Image of page 11
Image of page 12
You've reached the end of this preview.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern