Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Estimated cash receipt from Collections of Accounts Receivables 1074680 1074240 1128400 1181520 Total Cash Receipt 1074680 1074240 1128400 1181520 Less: Estimated Cash Payments for Manufacturing
Estimated cash receipt from | ||||
Collections of Accounts Receivables | 1074680 | 1074240 | 1128400 | 1181520 |
Total Cash Receipt | 1074680 | 1074240 | 1128400 | 1181520 |
Less: Estimated Cash Payments for | ||||
Manufacturing Costs | 676200 | 708250 | 743850 | 731835 |
Wages, Taxes, and other Cost | 393000 | 417000 | 432000 | 459000 |
Interest Payment | 135000 | 135000 | 135000 | 135000 |
Capital Expenditure (purchase machinary) | 0 | 0 | 0 | 525000 |
Total Cash Payment | 1204200 | 1260250 | 1310850 | 1850835 |
Cash Increase (Decrease) | -129520 | -186010 | -182450 | -669355 |
Cash Balance at Beginning of Quarter | 305000 | 305000 | 305000 | 305000 |
Less: Minimum Cash Balance | 125000 | 125000 | 125000 | 125000 |
Excess (Deficiency) | ||||
Estimated cash receipt from | ||||
Collections of Accounts Receivables | 1074680 | 1074240 | 1128400 | 1181520 |
Total Cash Receipt | 1074680 | 1074240 | 1128400 | 1181520 |
Less: Estimated Cash Payments for | ||||
Manufacturing Costs | 676200 | 708250 | 743850 | 731835 |
Wages, Taxes, and other Cost | 393000 | 417000 | 432000 | 459000 |
Interest Payment | 135000 | 135000 | 135000 | 135000 |
Capital Expenditure (purchase machinary) | 0 | 0 | 0 | 525000 |
Total Cash Payment | 1204200 | 1260250 | 1310850 | 1850835 |
Cash Increase (Decrease) | -129520 | -186010 | -182450 | -669355 |
Cash Balance at Beginning of Quarter | 305000 | 305000 | 305000 | 305000 |
Less: Minimum Cash Balance | 125000 | 125000 | 125000 | 125000 |
Excess (Deficiency) |
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