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
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....
Related questions
Question
Could you please explain to me how the cash balances are calculated????
Pro Forma |
|||
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 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
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
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
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
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
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning