Could you please explain to me how the cash balances are calculated???? 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 $25,286 $17,062 $84,215

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 1E: Computing; the Cash Balance Listed below are ten items that may be found on a balance sheet....
icon
Related questions
Question

Could you please explain to me how the cash balances are calculated????

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 $25,286 $17,062 $84,215

 

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Double entry bookkeeping system
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
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
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Auditing: A Risk Based-Approach to Conducting a Q…
Auditing: A Risk Based-Approach to Conducting a Q…
Accounting
ISBN:
9781305080577
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
South-Western College Pub
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning