Q4 Financial Activities during Jan 2020 (Only these transactions during the month) AR Payments deposited in 01/2020 and cleared in the bank in 01/2020 AP Payments made in 01/2020 and cashed in the bank in 01/2020 Outstanding / Uncashed AP Checks as of 01/31/2020 AP Invoices received on 02/15/2020 for Jan 2020 services AR Invoices issued on 02/01/2020 for Jan 2020 services Depreciation Amount 15,000.00 25,000.00 3,000.00 9,000.00 25,000.00 300.00 Please update the account balances in yellow for the Financials as of 01/31/2020. Use formulas to show your work 1/31/2020 12/31/2019
Q4 Financial Activities during Jan 2020 (Only these transactions during the month) AR Payments deposited in 01/2020 and cleared in the bank in 01/2020 AP Payments made in 01/2020 and cashed in the bank in 01/2020 Outstanding / Uncashed AP Checks as of 01/31/2020 AP Invoices received on 02/15/2020 for Jan 2020 services AR Invoices issued on 02/01/2020 for Jan 2020 services Depreciation Amount 15,000.00 25,000.00 3,000.00 9,000.00 25,000.00 300.00 Please update the account balances in yellow for the Financials as of 01/31/2020. Use formulas to show your work 1/31/2020 12/31/2019
Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter6: Cash And Receivables
Section: Chapter Questions
Problem 6P
Related questions
Question
![Q4
Financial Activities during Jan 2020 (Only these transactions during the month)
AR Payments deposited in 01/2020 and cleared in the bank in 01/2020
AP Payments made in 01/2020 and cashed in the bank in 01/2020
Outstanding / Uncashed AP Checks as of 01/31/2020
AP Invoices received on 02/15/2020 for Jan 2020 services
AR Invoices issued on 02/01/2020 for Jan 2020 services
Depreciation
Please update the account balances in yellow for the Financials as of 01/31/2020. Use formulas to show your work
12/31/2019 1/31/2020
220,000.00
30,000.00 15,000.00
12,000.00
3,000.00
5,000.00
(2,000.00)
268,000.00 23,000.00
Cash
Accounts Receivable
Unbilled AR
Prepaid Expense
Fixed Assets - Gross
Accum. Depreciation
Total Assets
Accounts Payable
Credit Card Payable
Accrued Liabilities
Deferred Revenue
Total Liabilities
Equity
Retained Earnings
Total Equity
Amount
15,000.00
25,000.00
3,000.00
9,000.00
25,000.00
300.00
Difference
3,000.00
5,000.00
45,000.00 17,000.00
22,000.00
22,000.00
10,000.00
150,000.00 150,000.00
227,000.00 189,000.00
50,000.00 50,000.00
(9,000.00)
6,700.00
41,000.00 56,700.00
(222,700.00)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F807f6284-8195-4b6c-baef-1cd47f0a1008%2Fe828375e-9481-46b5-a1e2-aea2aaac3ebd%2F7n9k2e4_processed.png&w=3840&q=75)
Transcribed Image Text:Q4
Financial Activities during Jan 2020 (Only these transactions during the month)
AR Payments deposited in 01/2020 and cleared in the bank in 01/2020
AP Payments made in 01/2020 and cashed in the bank in 01/2020
Outstanding / Uncashed AP Checks as of 01/31/2020
AP Invoices received on 02/15/2020 for Jan 2020 services
AR Invoices issued on 02/01/2020 for Jan 2020 services
Depreciation
Please update the account balances in yellow for the Financials as of 01/31/2020. Use formulas to show your work
12/31/2019 1/31/2020
220,000.00
30,000.00 15,000.00
12,000.00
3,000.00
5,000.00
(2,000.00)
268,000.00 23,000.00
Cash
Accounts Receivable
Unbilled AR
Prepaid Expense
Fixed Assets - Gross
Accum. Depreciation
Total Assets
Accounts Payable
Credit Card Payable
Accrued Liabilities
Deferred Revenue
Total Liabilities
Equity
Retained Earnings
Total Equity
Amount
15,000.00
25,000.00
3,000.00
9,000.00
25,000.00
300.00
Difference
3,000.00
5,000.00
45,000.00 17,000.00
22,000.00
22,000.00
10,000.00
150,000.00 150,000.00
227,000.00 189,000.00
50,000.00 50,000.00
(9,000.00)
6,700.00
41,000.00 56,700.00
(222,700.00)
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Will you please provide the formulas (explanation) to understand the results or numbers that were added in the solution?
Solution
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Intermediate Accounting: Reporting And Analysis](https://www.bartleby.com/isbn_cover_images/9781337788281/9781337788281_smallCoverImage.jpg)
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
![Intermediate Accounting: Reporting And Analysis](https://www.bartleby.com/isbn_cover_images/9781337788281/9781337788281_smallCoverImage.jpg)
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
![College Accounting, Chapters 1-27](https://www.bartleby.com/isbn_cover_images/9781337794756/9781337794756_smallCoverImage.gif)
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
![Survey of Accounting (Accounting I)](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
![College Accounting, Chapters 1-27 (New in Account…](https://www.bartleby.com/isbn_cover_images/9781305666160/9781305666160_smallCoverImage.gif)
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning