make a Balance sheet using this information in the Trial Balance. Separate BS for 2022 and 2023.
Fantastic news! We've Found the answer you've been seeking!
Question:
make a Balance sheet using this information in the Trial Balance. Separate BS for 2022 and 2023.
Transcribed Image Text:
A B 1 2 234 C D E J.K HOTEL CEBU TRIAL BALANCE AS OF DECEMBER 31, 2022 and 2023 5 AMOUNTS 6 ACCOUNT CODE 7 10001 ACCOUNT DESCRIPTION Cash in Bank 2022 MOVEMENTS 2023 1,308,300 405,000 1,713,300 8 10002 9 10003 Accounts Receivable Allowance for Doubtful Accounts Expense 552,980 178,000 730,980 10,000 - 13,800 23,800 10 10004 Prepaid Insurance 200,000 240,000 440,000 11 10005 Prepaid Audit Expense 50,000 50,000 12 10006 Office Supplies 120,000 25,000 145,000 13 10007 Cleaning Supplies 110,000 30,000 140,000 14 10008 Room Supplies 150,000 20,000 170,000 15 10009 Linens and Bedding Inventory 180,000 61,500 241,500 16 10010 Food and Beverages Inventory 200,000 116,000 316,000 17 10011 Retail Inventory 160,000 90,000 250,000 18 10012 Building 1,300,000 1,300,000 19 10013 Accumulated Depreciation - Building 130,000 130,000 20 10014 Hotel Equipment 220,000 335,000 555,000 21 10015 Accumulated Depreciation - Hotel Equipment 44,000 - 64,000 108,000 22 10016 Furniture and Fixtures 150,000 278,000 428,000 23 10017 Accumulated Depreciation - Furniture and Fixtures 37,500 59,000 96,500 24 10018 Investment in equity securities - FVOCI 120,000 120,000 25 20001 Accounts Payable 190,000 496,700 686,700 26 20002 Interest Payable 9,500 18,000 27,500 27 20003 Notes Payable 210,000 350,000 560,000 28 30001 Ungarnod Rovonuo 05.500 118.000 313.500 A B 1 2 234 C D E J.K HOTEL CEBU TRIAL BALANCE AS OF DECEMBER 31, 2022 and 2023 5 AMOUNTS 6 ACCOUNT CODE 7 10001 ACCOUNT DESCRIPTION Cash in Bank 2022 MOVEMENTS 2023 1,308,300 405,000 1,713,300 8 10002 9 10003 Accounts Receivable Allowance for Doubtful Accounts Expense 552,980 178,000 730,980 10,000 - 13,800 23,800 10 10004 Prepaid Insurance 200,000 240,000 440,000 11 10005 Prepaid Audit Expense 50,000 50,000 12 10006 Office Supplies 120,000 25,000 145,000 13 10007 Cleaning Supplies 110,000 30,000 140,000 14 10008 Room Supplies 150,000 20,000 170,000 15 10009 Linens and Bedding Inventory 180,000 61,500 241,500 16 10010 Food and Beverages Inventory 200,000 116,000 316,000 17 10011 Retail Inventory 160,000 90,000 250,000 18 10012 Building 1,300,000 1,300,000 19 10013 Accumulated Depreciation - Building 130,000 130,000 20 10014 Hotel Equipment 220,000 335,000 555,000 21 10015 Accumulated Depreciation - Hotel Equipment 44,000 - 64,000 108,000 22 10016 Furniture and Fixtures 150,000 278,000 428,000 23 10017 Accumulated Depreciation - Furniture and Fixtures 37,500 59,000 96,500 24 10018 Investment in equity securities - FVOCI 120,000 120,000 25 20001 Accounts Payable 190,000 496,700 686,700 26 20002 Interest Payable 9,500 18,000 27,500 27 20003 Notes Payable 210,000 350,000 560,000 28 30001 Ungarnod Rovonuo 05.500 118.000 313.500
Expert Answer:
Answer rating: 100% (QA)
To create balance sheets for 2022 and 2023 well organize the trial balance information into the standard balance sheet format Lets start with the bala... View the full answer
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Posted Date:
Students also viewed these accounting questions
-
Company produces 99,000 units and sells 100,000 The full unit costs are: DM$ 8 DL4 VOH17 FOH15 Which method of inventory costing will be higher and by how much?
-
Risk Assessment TECH1008 Your company was hired to restore a home originally built in the early 1970's. The task is to deconstruct the two-storey home down to the studs. Once complete you will...
-
Determine the transfer function from U(s) to Y(s) for the following block diagram. Provided are some recommended steps to take: a. Label each signal (line with arrow) b. Write the equation for each...
-
For brands is it more important to create big idea that is required to drive a customer connection or can it be stifled by corporate requirements to measure performance with automation and generate...
-
Write structures for the following bicyclic alkanes: (a) Bicyclo [1.1.0] butane (b) Bicyclo [2.1.0] pentane (c) 2-Chlorobicyclo [3.2.0] heptane (d) 7-Methylbicyclo [2.2.1] heptane
-
Deer Lake Inc. uses a job order costing system with manufacturing overhead applied to products at a rate of 150% of direct labor cost. Find the missing amounts by treating each case independently....
-
Consider each sequence of vertices from Graph \(A\) in Figure 12.79. Determine if it is only a walk, both a walk and a path, both a walk and a trail, all three, or none of these. 1. \(b ightarrow c...
-
Flossmoor Company uses the accounts receivable aging method to estimate uncollectible accounts. At the beginning of the year, the balance of the Accounts Receivable account was a debit of $88,430,...
-
You own a piece of raw land in an up-and-coming area in Gotham City. The costs to construct a building increase disproportionately with the size of the building. A building of q square feet costs...
-
An infinite slab of dielectric material dielectric constant x is placed in a unif electric field of magnitude E. The fiel perpendicular to the surface of the slab. field inside the slab is (A) E E%E0...
-
1. Learn the detail background on ERP systems. Discuss how you would integrate ERP systems internal and external across your entire organization or an organization of your choice? Then discuss the...
-
A rotating light is located 17 feet from a wall. The light completes one rotation every 4 seconds. Find the rate at which the light projected onto the wall is moving along the wall when the light's...
-
Selecting one private bank and one government bank in the PHilippines.(BPI AND LAND BANK) Then, comparing and contrasting (similarities and differences) its vision, mission, goals, objectives,...
-
What is the FV of a 3-year $100 annuity, if the quoted interest rate is 10%, compounded semiannually? Please show the calculations in detail for Financial calculator
-
Data foran art supplies companyfor the yearare as follows: Finished goods inventory, beginning balance $300,000 Work-in-process inventory, endingbalance 215,000 Underapplied manufacturing overhead...
-
Show how the given percentage was derived based on the sample data. Write 1-2 sentences explaining how the confidence interval would be interpreted. Based on this interval, provide one value that...
-
The following account balances were taken from the accounting records of Tyson Company for the year ended December 31, 2023: Interest revenue Accounts payable Retained earnings Supplies Dividends...
-
Borrowing costs should be recognised as an expense and charged to the profit and loss account of the period in which they are incurred : A. If the borrowing costs relate to qualifying asset B. If the...
-
The file named Mavs.xlsx contains statistics for the great 20022003 Dallas Mavericks basketball team. Player names are listed in column A, statistical categories are listed in row 3, and statistical...
-
Your local womens clothing store pays $200 for a suit. The weekly demand for suits is estimated as follows: Assume each woman who buys a suit purchases $80 of additional garments, on which the store...
-
You are thinking of opening a restaurant that will have six four-person tables. Each day the restaurant is open, there are two lunch seatings and three dinner seatings. In addition: The restaurant...
-
Open systems theory suggests that the external environment affects a companys ability to function. Identify any similarities between the contingency approach and open systems theory.
-
The contingency approach suggests that a firm will be more successful when what occurs?
-
If a nepotism policy were necessary, how could Syd make certain that it would not have negative effects on the organization?
Study smarter with the SolutionInn App