Calculate cash balances based on the information provided in the chart below and show me how you did it Pro Forma Cash Flow Cash Received Cash from Operations Cash Sales $24,198 $100,099 $122,460 Cash from Receivables $46,108 $217,218 $342,905 Subtotal Cash from Operations $70,306 $317,317 $465,366 Additional Cash Received Sales Tax, VAT, HST/GST Received $0 $0 $0 New Current Borrowing $0 $0 $0 New Other Liabilities (interest-free) $0 $0 $0 New Long-term Liabilities $0 $40,000 $0 Sales of Other Current Assets $0 $0 $0 Sales of Long-term Assets $0 $0 $0 New Investment Received $0 $0 $0 Subtotal Cash Received $70,306 $357,317 $465,366 Expenditures Year 1 Year 2 Year 3 Expenditures from Operations Cash Spending $167,000 $225,200 $229,200 Bill Payments $75,294 $124,114 $152,785 Subtotal Spent on Operations $242,294 $349,314 $381,985 Additional Cash Spent Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 Principal Repayment of Current Borrowing $0 $0 $0 Other Liabilities Principal Repayment $0 $0 $0 Long-term Liabilities Principal Repayment $16,227 $16,227 $16,227 Purchase Other Current Assets $0 $0 $0 Purchase Long-term Assets $0 $0 $0 Dividends $0 $0 $0 Subtotal Cash Spent $258,521 $365,541 $398,212 Net Cash Flow ($188,214) ($8,224) $67,154 Cash Balance
Calculate cash balances based on the information provided in the chart below and show me how you did it Pro Forma Cash Flow Cash Received Cash from Operations Cash Sales $24,198 $100,099 $122,460 Cash from Receivables $46,108 $217,218 $342,905 Subtotal Cash from Operations $70,306 $317,317 $465,366 Additional Cash Received Sales Tax, VAT, HST/GST Received $0 $0 $0 New Current Borrowing $0 $0 $0 New Other Liabilities (interest-free) $0 $0 $0 New Long-term Liabilities $0 $40,000 $0 Sales of Other Current Assets $0 $0 $0 Sales of Long-term Assets $0 $0 $0 New Investment Received $0 $0 $0 Subtotal Cash Received $70,306 $357,317 $465,366 Expenditures Year 1 Year 2 Year 3 Expenditures from Operations Cash Spending $167,000 $225,200 $229,200 Bill Payments $75,294 $124,114 $152,785 Subtotal Spent on Operations $242,294 $349,314 $381,985 Additional Cash Spent Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 Principal Repayment of Current Borrowing $0 $0 $0 Other Liabilities Principal Repayment $0 $0 $0 Long-term Liabilities Principal Repayment $16,227 $16,227 $16,227 Purchase Other Current Assets $0 $0 $0 Purchase Long-term Assets $0 $0 $0 Dividends $0 $0 $0 Subtotal Cash Spent $258,521 $365,541 $398,212 Net Cash Flow ($188,214) ($8,224) $67,154 Cash Balance
Century 21 Accounting General Journal
11th Edition
ISBN:9781337680059
Author:Gilbertson
Publisher:Gilbertson
Chapter22: End-of-fiscal-period Work For A Corporation
Section: Chapter Questions
Problem 3AP
Related questions
Question
Calculate cash balances based on the information provided in the chart below and show me how you did it
Pro Forma Cash Flow | |||
Cash Received | |||
Cash from Operations | |||
Cash Sales | $24,198 | $100,099 | $122,460 |
Cash from Receivables | $46,108 | $217,218 | $342,905 |
Subtotal Cash from Operations | $70,306 | $317,317 | $465,366 |
Additional Cash Received | |||
Sales Tax, VAT, HST/GST Received | $0 | $0 | $0 |
New Current Borrowing | $0 | $0 | $0 |
New Other Liabilities (interest-free) | $0 | $0 | $0 |
New Long-term Liabilities | $0 | $40,000 | $0 |
Sales of Other Current Assets | $0 | $0 | $0 |
Sales of Long-term Assets | $0 | $0 | $0 |
New Investment Received | $0 | $0 | $0 |
Subtotal Cash Received | $70,306 | $357,317 | $465,366 |
Expenditures | Year 1 | Year 2 | Year 3 |
Expenditures from Operations | |||
Cash Spending | $167,000 | $225,200 | $229,200 |
Bill Payments | $75,294 | $124,114 | $152,785 |
Subtotal Spent on Operations | $242,294 | $349,314 | $381,985 |
Additional Cash Spent | |||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 |
Principal Repayment of Current Borrowing | $0 | $0 | $0 |
Other Liabilities Principal Repayment | $0 | $0 | $0 |
Long-term Liabilities Principal Repayment | $16,227 | $16,227 | $16,227 |
Purchase Other Current Assets | $0 | $0 | $0 |
Purchase Long-term Assets | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
Subtotal Cash Spent | $258,521 | $365,541 | $398,212 |
Net Cash Flow | ($188,214) | ($8,224) | $67,154 |
Cash Balance |
Expert Solution
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 3 steps
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
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning