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
icon
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Bank reconciliation statement
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.
Similar questions
Recommended textbooks for you
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage