inces General Requirement Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Using the information...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
inces General Requirement Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Using the information from the requirements in the previous tabs, complete the 'Analysis' tab. Analyze the following information: (a) By how much does the year-end estimate of future uncollectible accounts reduce net income in 2024? Bad Debt Expense (b) What is the ending balance of Allowance for Uncollectible Accounts? Ending Balance of Allowance for Uncollectible Accounts (c) What amount of cash is expected to be collected from accounts receivable? Amount expected to be collected < Balance Sheet Analysis > December 31, 2024 Assets Liabilities Current Assets: Current Liabilities: Cash 39,210 Accounts Payable 16.100 Accounts Receivable 53,400 Allowance for Uncollectible Accounts 3,100 Supplies 12,400 0 Total Current Liabilities 16,100 Total Current Assets 108,110 Long-term assets: Total Liabilities Stockholders' Equity 16,100 Notes Receivable Land 48,000 Common Stock 104,000 Retained Earnings 33 + 182,000 62,010 0 Total Stockholders' Equity 244,010 Total Assets $ 260,110 Total Liabilities & Stockholders' Equity 260,110 Adjusted Pop's Fireworks Income Statement For the year ended December 31, 2024 Revenue: Service Revenue Interest Revenue Sales Discounts Total Revenue Expenses: 154,600 960 (290) 0 $ 155,270 Salaries Expense 72,800 Supplies Expense 21,400 Bad Debt Expense 8,440 Utilities Expense 29,900 Total Expenses Net Income S Journal entry: June 3, 2021 Accounts Receivable 26,000 Service Receivable (debit) 26,000 (credit) June 8, 2021 Cash 14,210 (Debit) Sales Discount 290 (Debit) Accounts Receivable 14,500 (credit) Nov 15, 2021 Balances for uncollectible accounts 9,100 (Debit) Accounts receivable 9,100 (Credit) Dec 31, 2021 Bad debt expense 8,440 (Debit) Allowance for uncollectible accounts 8,440 (Credit) Dec 31, 2021 Interest receivables 960 (Debit) Interest revenue 960 (Credit) Dec 31, 2021 Service revenue 154,600 (Debit) Interest revenue 960 (debit) Sales discount 290 (credit) Retained earnings 155,270 (Credit) Dec 31, 2021 Retained earnings 132,540 (Debit) Salaries expense 72,800 (Credit) Utilities expense 29,900 (Credit) Supplies expense 21,400 (Credit) Bad debt expense 8,440 (Credit) Unadjusted accounts receivable balance $51,000 Add: additional services provided on account (June 3) $26,000 Less: payment received from customer (June 8) Les: accounts receivable written off (November 5) Adjusted accounts receivable balance ($14,500) ($9100) $3400 Bad debt expense equals ($53,400 * 10%) -$6000 plus $9100 equals $8440 The general ledger of Pop's Fireworks includes the following account balances in 2021: Accounts Cash Debit Credit $ 25,000 Accounts Receivable 51,000 Allowance for Uncollectible Accounts Supplies $ 6,000 12,400 Notes Receivable (8%, due in 2 years) 48,000 Land Accounts Payable 104,000 Common Stock Retained Earnings 16,100 182,000 31,800 Service Revenue Salaries Expense Utilities Expense Supplies Expense 128,600 72,800 29,900 Totals 21,400 $364,500 $364,500 In addition, the following transactions occurred during 2021 and are not yet reflected in the account balances above: June June 3 Provide additional services on account for $26,000. All services on account include terms 2/10, n/30. 8 Receive cash from customers within 10 days of the services being provided on account. The customers were originally charged $14,500. November 15 Write off customer accounts of $9,100 as uncollectible. The following information is available on December 31. a. Estimate that 10% of the balance of accounts receivable (after the transactions listed above) will not be collected. b. Accrue interest on the note receivable of $48,000, which was accepted on October 1, 2021. Interest is due each September 30. inces General Requirement Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Using the information from the requirements in the previous tabs, complete the 'Analysis' tab. Analyze the following information: (a) By how much does the year-end estimate of future uncollectible accounts reduce net income in 2024? Bad Debt Expense (b) What is the ending balance of Allowance for Uncollectible Accounts? Ending Balance of Allowance for Uncollectible Accounts (c) What amount of cash is expected to be collected from accounts receivable? Amount expected to be collected < Balance Sheet Analysis > December 31, 2024 Assets Liabilities Current Assets: Current Liabilities: Cash 39,210 Accounts Payable 16.100 Accounts Receivable 53,400 Allowance for Uncollectible Accounts 3,100 Supplies 12,400 0 Total Current Liabilities 16,100 Total Current Assets 108,110 Long-term assets: Total Liabilities Stockholders' Equity 16,100 Notes Receivable Land 48,000 Common Stock 104,000 Retained Earnings 33 + 182,000 62,010 0 Total Stockholders' Equity 244,010 Total Assets $ 260,110 Total Liabilities & Stockholders' Equity 260,110 Adjusted Pop's Fireworks Income Statement For the year ended December 31, 2024 Revenue: Service Revenue Interest Revenue Sales Discounts Total Revenue Expenses: 154,600 960 (290) 0 $ 155,270 Salaries Expense 72,800 Supplies Expense 21,400 Bad Debt Expense 8,440 Utilities Expense 29,900 Total Expenses Net Income S Journal entry: June 3, 2021 Accounts Receivable 26,000 Service Receivable (debit) 26,000 (credit) June 8, 2021 Cash 14,210 (Debit) Sales Discount 290 (Debit) Accounts Receivable 14,500 (credit) Nov 15, 2021 Balances for uncollectible accounts 9,100 (Debit) Accounts receivable 9,100 (Credit) Dec 31, 2021 Bad debt expense 8,440 (Debit) Allowance for uncollectible accounts 8,440 (Credit) Dec 31, 2021 Interest receivables 960 (Debit) Interest revenue 960 (Credit) Dec 31, 2021 Service revenue 154,600 (Debit) Interest revenue 960 (debit) Sales discount 290 (credit) Retained earnings 155,270 (Credit) Dec 31, 2021 Retained earnings 132,540 (Debit) Salaries expense 72,800 (Credit) Utilities expense 29,900 (Credit) Supplies expense 21,400 (Credit) Bad debt expense 8,440 (Credit) Unadjusted accounts receivable balance $51,000 Add: additional services provided on account (June 3) $26,000 Less: payment received from customer (June 8) Les: accounts receivable written off (November 5) Adjusted accounts receivable balance ($14,500) ($9100) $3400 Bad debt expense equals ($53,400 * 10%) -$6000 plus $9100 equals $8440 The general ledger of Pop's Fireworks includes the following account balances in 2021: Accounts Cash Debit Credit $ 25,000 Accounts Receivable 51,000 Allowance for Uncollectible Accounts Supplies $ 6,000 12,400 Notes Receivable (8%, due in 2 years) 48,000 Land Accounts Payable 104,000 Common Stock Retained Earnings 16,100 182,000 31,800 Service Revenue Salaries Expense Utilities Expense Supplies Expense 128,600 72,800 29,900 Totals 21,400 $364,500 $364,500 In addition, the following transactions occurred during 2021 and are not yet reflected in the account balances above: June June 3 Provide additional services on account for $26,000. All services on account include terms 2/10, n/30. 8 Receive cash from customers within 10 days of the services being provided on account. The customers were originally charged $14,500. November 15 Write off customer accounts of $9,100 as uncollectible. The following information is available on December 31. a. Estimate that 10% of the balance of accounts receivable (after the transactions listed above) will not be collected. b. Accrue interest on the note receivable of $48,000, which was accepted on October 1, 2021. Interest is due each September 30.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The general ledger of Pops Fireworks includes the following account balances in 2024: In addition, the following transactions occurred during 2024 and are not yet reflected in the account balances...
-
A local entrepreneur is looking for investors any new company that will develop mobile apps for behavioral health. The company requires a $15 million in start up funds. it can be capitalized with...
-
One way to delete nodes from a known position in a leftist heap is to use a lazy strategy. To delete a node, merely mark it deleted. When a findMin or deleteMin is performed, there is a potential...
-
Which is a correct sequence that ends with the stage that implants? a. Morula, blastocyst. embryonic disk, gastrula b. Ovulation. fertilization, cleavage, morula, earty blastocyst c. Embryonic disk,...
-
a) For this question, you will need to use this function, which returns the real value of the square root of anyPosVal: Extend your algorithm for Question 2 to i) Calculate the hypotenuse ii)...
-
In 2014, Barker contacted Price about a van Price had advertised for sale. The advertisement described the van as a 1994 Ford E350. Barker and Price agreed to meet, and, on April 9, Barker inspected...
-
Peninsula Candy Company makes three types of candy bars: Chewy, Chunky, and Choco-Lite (Lite). Sales volume for the annual budget is determined by estimating the total market volume for candy bars...
-
Relational Databases are based on relational models and relational math. Write a brief description and history of the relational model.?
-
17. (a) If f is differentiable at xo, prove that lim-0 | (b) If limo 2h - exists, is f differentiable at xo? f(xo+N)- f(xoh) = f(x). zh 14 .. LECTURE 1 The Derivative (Definition and...
-
Case Study - Managing Multicultural Teams The reading is taken from Harvard Business Review, 2006. Please access the reading from the reading list under "Session 10: Working in multicultural teams."...
-
Consider the following data collected in the lab. Fill in the calculated values. Be sure to record the mass and density of the liquid to the correct number of significant figures. Mass Of Graduated...
-
Your bond portfolio has a probability of default of 3%/year, loss given default of 60%, and a weighted average contractual rate of 5.5%/year. A) What is the expected loss per year? B) What is the...
-
Each summary should include a descriptive and evaluative paragraph on the following attributes: Include the origins of the model (who developed it, when was it developed, and the context under which...
-
Option trading 1 Mike buys 6 call options (contracts) on Boeing. Mike does not hold Boeing stock or other option positions. The options expire in five months. The premium is c=$19.97. How much cash...
-
You are given a sequence of 6000 mRNA bases (mature mRNA without introns) and told that this sequence encodes an ion channel. How would you use this sequence to determine: a) The number of amino acid...
-
The test statistic in the NeymanPearson Lemma and the likelihood ratio test statistic K are intimately related. Consider testing H 0 : = 0 versus H a : = a , and let * denote the test statistic...
-
The following selected transactions relate to contingencies of Classical Tool Makers, Inc., which began operations in July 2024. Classicals fiscal year ends on December 31. Financial statements are...
-
The shareholders equity of Proactive Solutions, Inc., included the following at December 31, 2024: Additional Information: Proactive had 7 million shares of preferred stock authorized, of which 2...
-
Howarth Manufacturing Company purchased equipment on June 30, 2020, at a cost of $800,000. The residual value of the equipment was estimated to be $50,000 at the end of a five-year life. The...
-
What are the most recently available levels of 3-month and 10-year yields on Treasury securities?
-
A portfolio has an expected rate of return of 20% and standard deviation of 30%. T-bills offer a safe rate of return of 7%. Would an investor with risk-aversion parameter A = 4 prefer to invest in...
-
Can the Sharpe (reward-to-volatility) ratio, S = [E(rC) rf]/C, of any combination of the risky asset and the risk-free asset be different from the ratio for the risky asset taken alone, [E(rP) ...
Study smarter with the SolutionInn App