Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Readability of 3 uncertainty analyses Pro Forma Cash Flow Cash Received Cash from Operations Cash Sales $0 $0 $0 Cash from Receivables $128,939 $270,176 $327,221
Readability of 3 uncertainty analyses
Pro Forma Cash Flow | |||
Cash Received | |||
Cash from Operations | |||
Cash Sales | $0 | $0 | $0 |
Cash from Receivables | $128,939 | $270,176 | $327,221 |
Subtotal Cash from Operations | $128,939 | $270,176 | $327,221 |
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 | $0 | $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 | $128,939 | $270,176 | $327,221 |
Expenditures | Year 1 | Year 2 | Year 3 |
Expenditures from Operations | |||
Cash Spending | $58,819 | $63,654 | $70,689 |
Bill Payments | $72,830 | $173,380 | $191,356 |
Subtotal Spent on Operations | $131,649 | $237,034 | $262,045 |
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 | $14,500 | $14,500 | $14,500 |
Purchase Other Current Assets | $0 | $0 | $0 |
Purchase Long-term Assets | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
Subtotal Cash Spent | $146,149 | $251,534 | $276,545 |
Net Cash Flow | ($17,209) | $18,642 | $50,676 |
Cash Balance | $6,281 | $24,923 | $75,599 |
Pro Forma Balance Sheet | |||
Assets | |||
Current Assets | |||
Cash | $6,281 | $24,923 | $75,599 |
Accounts Receivable | $48,486 | $83,363 | $91,699 |
Inventory | $7,780 | $7,251 | $7,976 |
Other Current Assets | $0 | $0 | $0 |
Total Current Assets | $62,547 | $115,537 | $175,274 |
Long-term Assets | |||
Long-term Assets | $62,160 | $62,160 | $62,160 |
Accumulated Depreciation | $1,200 | $2,300 | $3,400 |
Total Long-term Assets | $60,960 | $59,860 | $58,760 |
Total Assets | $123,507 | $175,397 | $234,034 |
Liabilities and Capital | Year 1 | Year 2 | Year 3 |
Current Liabilities | |||
Accounts Payable | $14,064 | $14,267 | $15,859 |
Current Borrowing | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 |
Subtotal Current Liabilities | $14,064 | $14,267 | $15,859 |
Long-term Liabilities | $101,500 | $87,000 | $72,500 |
Total Liabilities | $115,564 | $101,267 | $88,359 |
Paid-in Capital | $10,000 | $10,000 | $10,000 |
Retained Earnings | ($15,150) | ($2,057) | $64,130 |
Earnings | $13,093 | $66,187 | $71,546 |
Total Capital | $7,943 | $74,130 | $145,675 |
Total Liabilities and Capital | $123,507 | $175,397 | $234,034 |
Net Worth | $7,943 | $74,130 | $145,675 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started