Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31, 2024, appears below. December 31 is the company's reporting year-end. The company uses the perpetual inventory system. Account Title Cash Accounts receivable Supplies Prepaid rent Inventory Office equipment Accumulated depreciation Accounts payable Salaries payable Notes payable (long-term) Common stock Retained earnings Dividends Sales revenue Cost of goods sold Interest expense Salaries expense Rent expense Supplies expense Utility expense Totals Debits $61,185 25,500 3,200 26,000 61,500 77,000 7,875 125,000 46,750 0 5,650 $ 439,660 Credits $ 10,010 32,100 4, 200 30,300 105,000 18,050 240,000 $439,660 Information necessary to prepare the year-end adjusting entries appears below. 1. The office equipment was purchased in 2022 and is being depreciated using the straight-line method over an eight-year useful life with no residual value. 2. Accrued salaries at year-end should be $6,300. 3. The company borrowed $30,300 on September 1, 2024. The principal is due to be repaid in 10 years. Interest is payable twice a year on each August 31 and February 28 at an annual rate of 10%. 4. The company debits supplies when supplies are purchased. Supplies on hand at year-end cost $520. 5. Prepaid rent expired during the period is $14,200. Cash dividends paid to shareholders during the year amounted to $7,875. Required: 1. Complete the worksheet below. 2-a. Use the information in the worksheet to prepare an income statement for 2024. 2-b. Use the information in the worksheet to prepare a statement of shareholders' equity for 2024. 2-c. Use the information in the worksheet to prepare a balance sheet as of December 31, 2024. 3. Prepare the necessary closing entries assuming that adjusting entries have been correctly posted to the accounts. Account Title Cash Accounts receivable Supplies Prepaid rent Inventory Office equipment Accumulated depreciation Accounts payable Salaries payable Notes payable (long-term) Interest payable Common stock Retained earnings Dividends Sales revenue Cost of goods sold Interest expense Salaries expense Rent expense Supplies expense Utilities Expense Depreciation expense Net income Totals Unadjusted Trial Balance Debit $ 61,185 25,500 3.200 26,000 61,500 77,000 7,875 125,000 46,750 5,650 439,660 Credit $ 10,010 32,100 4,200 30,300 0 105,000 18,050 240,000 Adjusting Entries Debit Credit < Req 1 Adjusted Trial Balance Debit Credit Income Statement Debit Credit Req 2A > Balance Sheet Debit Credit (Future value of an annuity) In 13 years, you are planning on retiring and buying a house in Oviedo, Florida. The house you are looking at currently costs $100,000 and is expected to increase in value each year at a rate of 6 percent. Assuming you can earn 9 percent annually on your investments, how much must you invest at the end of each of the next 13 years to be able to buy your dream home when you retire? a. If the house you are looking at currently costs $100,000 and is expected to increase in value each year at a rate of 6 percent, what will the value of the house be when you retire in 13 years? (Round to the nearest cent.) Complete this question by entering your answers in the tabs below. Req 1 Req 2A Balance at January 1, 2024 Req 2B Balance at December 31, 2024 Req 2C Use the information in the worksheet to prepare a statement of shareholders' equity for 2024. EXCALIBUR CORPORATION Statement of Shareholders' Equity For the Year Ended December 31, 2024 Common Stock Req 3 < Req 2A Retained Earnings Total Shareholders' Equity Req 2C > Req 1 Current assets: Req 2A Total current assets Total assets Use the information in the worksheet to prepare a balance sheet as of December 31, 2024. Note: Amounts to be deducted should be indicated by a minus sign. Liabilities: Req 2B Total liabilities Shareholders' equity: Req 2C EXCALIBUR CORPORATION Balance Sheet At December 31, 2024 Assets Liabilities and Shareholders' Equity Total shareholders' equity Total liabilities and shareholders' equity Req 3 Req 1 Req 2A View transaction list < 1 Prepare the necessary closing entries assuming that adjusting entries have been correctly posted to the accounts. Note: If no entry is required for a transaction/event, select "No journal entry required" in the first account field. Journal entry worksheet 2 3 Req 2B Note: Enter debits before credits. Date December 31, 2024 Record the entry to close the revenue accounts using retained earnings. Record entry Req 2C General Journal Clear entry Req|3 < Req 2C Debit Credit View general journal Req 3 > Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31, 2024, appears below. December 31 is the company's reporting year-end. The company uses the perpetual inventory system. Account Title Cash Accounts receivable Supplies Prepaid rent Inventory Office equipment Accumulated depreciation Accounts payable Salaries payable Notes payable (long-term) Common stock Retained earnings Dividends Sales revenue Cost of goods sold Interest expense Salaries expense Rent expense Supplies expense Utility expense Totals Debits $61,185 25,500 3,200 26,000 61,500 77,000 7,875 125,000 46,750 0 5,650 $ 439,660 Credits $ 10,010 32,100 4, 200 30,300 105,000 18,050 240,000 $439,660 Information necessary to prepare the year-end adjusting entries appears below. 1. The office equipment was purchased in 2022 and is being depreciated using the straight-line method over an eight-year useful life with no residual value. 2. Accrued salaries at year-end should be $6,300. 3. The company borrowed $30,300 on September 1, 2024. The principal is due to be repaid in 10 years. Interest is payable twice a year on each August 31 and February 28 at an annual rate of 10%. 4. The company debits supplies when supplies are purchased. Supplies on hand at year-end cost $520. 5. Prepaid rent expired during the period is $14,200. Cash dividends paid to shareholders during the year amounted to $7,875. Required: 1. Complete the worksheet below. 2-a. Use the information in the worksheet to prepare an income statement for 2024. 2-b. Use the information in the worksheet to prepare a statement of shareholders' equity for 2024. 2-c. Use the information in the worksheet to prepare a balance sheet as of December 31, 2024. 3. Prepare the necessary closing entries assuming that adjusting entries have been correctly posted to the accounts. Account Title Cash Accounts receivable Supplies Prepaid rent Inventory Office equipment Accumulated depreciation Accounts payable Salaries payable Notes payable (long-term) Interest payable Common stock Retained earnings Dividends Sales revenue Cost of goods sold Interest expense Salaries expense Rent expense Supplies expense Utilities Expense Depreciation expense Net income Totals Unadjusted Trial Balance Debit $ 61,185 25,500 3.200 26,000 61,500 77,000 7,875 125,000 46,750 5,650 439,660 Credit $ 10,010 32,100 4,200 30,300 0 105,000 18,050 240,000 Adjusting Entries Debit Credit < Req 1 Adjusted Trial Balance Debit Credit Income Statement Debit Credit Req 2A > Balance Sheet Debit Credit (Future value of an annuity) In 13 years, you are planning on retiring and buying a house in Oviedo, Florida. The house you are looking at currently costs $100,000 and is expected to increase in value each year at a rate of 6 percent. Assuming you can earn 9 percent annually on your investments, how much must you invest at the end of each of the next 13 years to be able to buy your dream home when you retire? a. If the house you are looking at currently costs $100,000 and is expected to increase in value each year at a rate of 6 percent, what will the value of the house be when you retire in 13 years? (Round to the nearest cent.) Complete this question by entering your answers in the tabs below. Req 1 Req 2A Balance at January 1, 2024 Req 2B Balance at December 31, 2024 Req 2C Use the information in the worksheet to prepare a statement of shareholders' equity for 2024. EXCALIBUR CORPORATION Statement of Shareholders' Equity For the Year Ended December 31, 2024 Common Stock Req 3 < Req 2A Retained Earnings Total Shareholders' Equity Req 2C > Req 1 Current assets: Req 2A Total current assets Total assets Use the information in the worksheet to prepare a balance sheet as of December 31, 2024. Note: Amounts to be deducted should be indicated by a minus sign. Liabilities: Req 2B Total liabilities Shareholders' equity: Req 2C EXCALIBUR CORPORATION Balance Sheet At December 31, 2024 Assets Liabilities and Shareholders' Equity Total shareholders' equity Total liabilities and shareholders' equity Req 3 Req 1 Req 2A View transaction list < 1 Prepare the necessary closing entries assuming that adjusting entries have been correctly posted to the accounts. Note: If no entry is required for a transaction/event, select "No journal entry required" in the first account field. Journal entry worksheet 2 3 Req 2B Note: Enter debits before credits. Date December 31, 2024 Record the entry to close the revenue accounts using retained earnings. Record entry Req 2C General Journal Clear entry Req|3 < Req 2C Debit Credit View general journal Req 3 >
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31, 2024, appears below. December 31 is the companys reporting year-end. The company uses...
-
Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31, 2018, appears below. December 31 is the company's fiscal year-end. The company uses the...
-
Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31, 2021, appears below. December 31 is the company?s reporting year-end. The company uses...
-
The current zero-coupon yield curve of semi-annually compounded rates for risk-free bonds is as follows: 1.0 Years 1.5 Years 2.0 Years 2.5 Years 3.0 Years 9.00% 10.20% 3.00% 4.00% 6.20% MATURITY 0.5...
-
Should a company be willing to accept a project that requires immediate organizational restructuring? If so, what factors should it consider?
-
Meena Distributors has an annual demand for an airport metal detector of 1,400 units. The cost of a typical detector to Meena is $400. Carrying cost is estimated to be 20% of the unit cost, and the...
-
Water at \(400 \mathrm{psi}\) is available to operate a turbine at 1750 \(\mathrm{rpm}\). What type of turbine would you suggest to use if the turbine should have an output of approximately \(200...
-
Refer to Figure which shows the computer solution THE MANAGEMENT SCIENTIST SOLUTION FOR THE INVESTMENT ADVISORS PROBLEM a. How much would the return for U.S. Oil have to increase before it would be...
-
Huegel Hollow Resort has ordered 24 rotomolded kayaks from Current Designs. Each kayak will be formed in the rotomolded oven, cooled, and then have the excess plastic trimmed away. Then, the hatches,...
-
Terence Breezeway, the CEO of Prairie Home Stores, wondered what retirement would be like. It was almost 20 years to the day since his uncle Jacob Breezeway, Prairie Home's founder, had asked him to...
-
Explain the structure/form of the supply chain management practiced by Gardenia Bakeries (KL) Sdn Bhd. Provide an appropriate diagram that illustrates the supply chain management practiced AND its...
-
(a) A parcel containing two components was received and the invoice discloses the following: Material I Material II Insurance 1,000 kgs @* 20 per kg 1,200 kgs @* 15 per kg 950 Sales tax Freight...
-
You and your fellow team members are to assume that you have been assigned to the 2023 audit of Qantas Airways Limited. You have been asked by the audit partner, as preparation for your involvement...
-
The following production data were taken from the records of the finishing department for June: Inventory in process, June 1, 25% completed Transferred to finished goods during June 280 units 4,600...
-
For Retentech Inc., the current acquisition budget is $10 per prospect. The resultant acquisition rate is 30%. The profit margin from each acquired customer is $ 25 in the first year. What is the...
-
Total cash receipts equal $20,000, total cash payments equal $14,000, beginning cash equals $10,000 and ending cash equals $22,000. What is the total cash available?
-
Discounted cash flow analysis takes into account the time value of money. The projected cash flow for Project X has been assessed and is given in the following table after allowance for taxation and...
-
Evaluate the function at the given value(s) of the independent variable. Simplify the results. (x) = cos 2x (a) (0) (b) (- /4) (c) (/3) (d) ()
-
On February 26, a hurricane destroyed the entire inventory stored in a warehouse owned by the Rockport Corporation. The following information is available from the records of the companys periodic...
-
What are the three main types of sustainability disclosures? How can those disclosures provide information to shareholders and stakeholders?
-
The Kwik Companys inventory balance on December 31, 2024, was $165,000 (based on a 12/31/2024 physical count) before considering the following transactions: 1. Goods shipped to Kwik f.o.b....
-
Companies are facing a great amount of change in every facet of their operations today. To remain competitive, companies must keep abreast of current developments in several areas. You recently got...
-
For each of the situations listed, identify the primary standard from the IMA Statement of Ethical Professional Practice that is violated (competence, confidentiality, integrity, or credibility.)...
-
Sustainability involves more than just the impact of actions on the environment. The triple bottom line recognizes that a company has to measure its impact on its triple bottom line for its long-term...
Study smarter with the SolutionInn App