Faste -6 } 1: 2 B BI U fx fx E F A A __ G...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Faste -6 } 1: 2 B BI U fx fx E F A A __ G HIH & General Conditional Formatting Insert Format as Table $ % 9 0.00 .00 0 Cell Styles Delete Format Editing Sensitivity Add-i Problem 3-3B Preparing adjusting entries, adjusted trial balance, and financial statements P1 P2 P3 P4 P5 Following is the unadjusted trial balance for Alonzo Institute as of December 31. The Institute provides one-on-one training to individuals who pay tuition directly to the business and offers extension training to groups in off-site locations. Shown after the trial balance are items a through h that require adjusting entries as of December 31. Cash Accounts receivable Teaching supplies ALONZO INSTITUTE Unadjusted Trial Balance December 31 Credit Debit $ 60,000 0 70,000 Prepaid insurance 19,000 Prepaid rent 3,800 Professional library 12,000 Accumulated depreciation-Professional library. |+2| $ 2,500 Equipment 40,000 Accumulated depreciation-Equipment Accounts payable Salaries payable Unearned revenue Common stock Retained earnings 20,000 11,200 0 28,600 11,000 60,500 Dividends 20,000 Tuition revenueEF 129,200 Training revenue 69068 68,000 Depreciation expense-Professional library PETIMO 0 Depreciation expense-Equipment FO Salaries expense 159TORAN $44,200 Insurance expense lifelin 0 Rent expense 29,600 Teaching supplies expense 45H Advertising expense 51+1369369 19.000 13,400 $331,000 $331,000 Utilities expense Totals " 1 Required K - M N 0 P 1. Complete the Trial Balance section of the worksheet as demonstrated in class on 2/27/24. 2. Prepare the necessary adjusting journal entries for items a through h and enter adjustments in the adjustment section of the worksheet - be sure to cross reference each adjusting with the appropriate letter as demonstrated in the video from 2/27/24. 3. Prepare the adjusted trial balance section of the worksheet as demonstrated in the video from 2/27/24. 4. From the Adjusted Trial Balance, prepare the company's income statement and statement of retained earnings for the year, and prepare its balance sheet as of December 31. The Retained Earnings account balance was $60,500 on December 31 of the prior year. Check (2e) Cr. Training Revenue, $28,600 (2) Cr. Tuition Revenue, $5,750 (3) Adj. trial balance totals, $344,600 (4) Net income, $54,200 Required 1. Prepare T-accounts (representing the ledger) with balances from the unadjusted trial balance. L 2. Prepare the necessary adjusting journal entries for items a through h and post them to the T-accounts. Assume that adjusting entries are made only at year- end. 3. Update balances in the T-accounts for the adjusting entries and prepare an adjusted trial balance. 4. Prepare Wells Technical Institute's income statement and statement of retained earnings for the year and prepare its balance sheet as of December 31. The Retained Earnings account balance was $80,000 on December 31 of the prior year. Check (2e) Cr. Training Revenue, $5,000 (2) Cr. Tuition Revenue, $7,500 (3) Adj. trial balance totals, $345,700 (4) Net income, $49,600 L Worksheet + $1487845) Select destination and press ENTER or choose Faste -6 } 1: 2 B BI U fx fx E F A A __ G HIH & General Conditional Formatting Insert Format as Table $ % 9 0.00 .00 0 Cell Styles Delete Format Editing Sensitivity Add-i Problem 3-3B Preparing adjusting entries, adjusted trial balance, and financial statements P1 P2 P3 P4 P5 Following is the unadjusted trial balance for Alonzo Institute as of December 31. The Institute provides one-on-one training to individuals who pay tuition directly to the business and offers extension training to groups in off-site locations. Shown after the trial balance are items a through h that require adjusting entries as of December 31. Cash Accounts receivable Teaching supplies ALONZO INSTITUTE Unadjusted Trial Balance December 31 Credit Debit $ 60,000 0 70,000 Prepaid insurance 19,000 Prepaid rent 3,800 Professional library 12,000 Accumulated depreciation-Professional library. |+2| $ 2,500 Equipment 40,000 Accumulated depreciation-Equipment Accounts payable Salaries payable Unearned revenue Common stock Retained earnings 20,000 11,200 0 28,600 11,000 60,500 Dividends 20,000 Tuition revenueEF 129,200 Training revenue 69068 68,000 Depreciation expense-Professional library PETIMO 0 Depreciation expense-Equipment FO Salaries expense 159TORAN $44,200 Insurance expense lifelin 0 Rent expense 29,600 Teaching supplies expense 45H Advertising expense 51+1369369 19.000 13,400 $331,000 $331,000 Utilities expense Totals " 1 Required K - M N 0 P 1. Complete the Trial Balance section of the worksheet as demonstrated in class on 2/27/24. 2. Prepare the necessary adjusting journal entries for items a through h and enter adjustments in the adjustment section of the worksheet - be sure to cross reference each adjusting with the appropriate letter as demonstrated in the video from 2/27/24. 3. Prepare the adjusted trial balance section of the worksheet as demonstrated in the video from 2/27/24. 4. From the Adjusted Trial Balance, prepare the company's income statement and statement of retained earnings for the year, and prepare its balance sheet as of December 31. The Retained Earnings account balance was $60,500 on December 31 of the prior year. Check (2e) Cr. Training Revenue, $28,600 (2) Cr. Tuition Revenue, $5,750 (3) Adj. trial balance totals, $344,600 (4) Net income, $54,200 Required 1. Prepare T-accounts (representing the ledger) with balances from the unadjusted trial balance. L 2. Prepare the necessary adjusting journal entries for items a through h and post them to the T-accounts. Assume that adjusting entries are made only at year- end. 3. Update balances in the T-accounts for the adjusting entries and prepare an adjusted trial balance. 4. Prepare Wells Technical Institute's income statement and statement of retained earnings for the year and prepare its balance sheet as of December 31. The Retained Earnings account balance was $80,000 on December 31 of the prior year. Check (2e) Cr. Training Revenue, $5,000 (2) Cr. Tuition Revenue, $7,500 (3) Adj. trial balance totals, $345,700 (4) Net income, $49,600 L Worksheet + $1487845) Select destination and press ENTER or choose
Expert Answer:
Related Book For
Managerial Statistics
ISBN: 9780534389314
1st Edition
Authors: S. Christian Albright, Wayne L. Winston, Christopher Zappe
Posted Date:
Students also viewed these accounting questions
-
In ABC analysis, class A items typically represent of the dollar usage. A. 40%; 60% B. 80%; 20% C. 20%; 60% D. 20%; 80% of the SKUs but account for
-
Following is the unadjusted trial balance for Augustus Institute as of December 31, 2013, which initially records prepaid expenses and unearned revenues in balance sheet accounts. The Institute...
-
In 2017, Barlow moved from Chicago to Miami to start a new job, incurring costs of $1,200 to move household goods and $2,500 in temporary living expenses. Barlow was not reimbursed for any of these...
-
Translate the following amounts of foreign currency into an equivalent number of U.S. dollars using the exchange rates in Exhibit 15.7. a. 800,000 b. 350,000 c. 50,000 Exchange Rate (in foreign...
-
Find the indefinite integral. sin 3 x cos x dx
-
Why does collusion pose unique prevention and detection challenges?
-
Lyman Company bottles and distributes Livit, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2012,...
-
Consider two oppositely charged atoms with charges of +1 and -1 units, respectively. The two atoms interact with each other through electrostatic (Coulombic) and van der Waals forces, and reach an...
-
A random sample of 13 parking meters (out of 150 parking meters total) in a beach community showed the following incomes for a day. Assume the incomes are normally distributed. $3.60 $4.50 $2.80...
-
What is: a. the mass, b. Net force, c. And acceleration? From = 40 N 140 Frict 12 N+ = 100 Fthrust = 20 N = 40 N Egav=
-
If more field lines leave a closed surface than enter that surface, then O an error has been made since the number of field lines entering a surface must equal those leaving the surface. a net...
-
As the notes and previous question indicated, the unit vector indicates the direction of a vector. If you have a velocity of a bus described in vector form as v = (4.5, -2, -6 )m/s. then if you...
-
A cyclist is coasting at 15 m/s when she starts down a 460 m long slope that is 30 m high. The cyclist and her bicycle have a combined mass of 70 kg. A steady 12 N drag force due to air resistance...
-
2.78 Archaeologists measure a pre-Columbian ceremonial structure and obtain the dimensions shown. Determine (a) the magnitude and (b) the direction cosines of the position vector from point A to...
-
Create a marketing campaign for an invented company. Your task for this assignment is to invent three domestic companies as potential subjects for your final project. For example, you may choose to...
-
In a certain school district, 3% of the faculty use none of their sick days in a school year. Find the probability that 5 faculty members selected at random used no sick days in a given year.
-
What is the difference between short-term and long-term capital?
-
A business is considering two type of containers to package its product, one made of plastic and the other of biodegradable cardboard with native wild flower seeds embedded in the packaging, designed...
-
Complete the crossword puzzle below: Clues Across 2 Amount of uncertainty that exists about the future operations of a business 4 The V in CVP analysis 6 The amount provided by the sale of a product...
Study smarter with the SolutionInn App