Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cash Corp Q1 Q2 Q3 Q4 Accounts Receivables Beginning Receivables Sales (m) Cash collections Ending Receivables Expected sales by quarter (millions) Q1: $80; 22: $100;

image text in transcribed

Cash Corp Q1 Q2 Q3 Q4 Accounts Receivables Beginning Receivables Sales (m) Cash collections Ending Receivables Expected sales by quarter (millions) Q1: $80; 22: $100; Q3: $125; Q4: $200 Beginning accounts receivable = $50 million Days receivables = 45 days Cash Collections = how will we compute this? Accounts payable/COGS = 60% of sales in relevant quarter Wages, taxes, and other expenses = 20% of sales in relevant quarter Interest and dividends (payments) = $10 million per quarter Major expansion planned for Q 2 costing $75 million Beginning cash balance = $8 million (minimum cash balance of $5 million required) Cash Collections = Ending Receivables = Beginning Receivables + Sales - Collections Q1 Q2 Q3 Q4 Cash Disbursements Accounts Payable/COGS Wages, taxes, other expenses Capital expenditures Long-term financing expenses (Interest and dividends) Total Cash Disbursements | Q1 Q2 Q3 Q4 Net Cash Flow Toal Cash Collections Total Cash Disbursements Net Cash Flow 01 Q2 Q3 Q4 Cash Balance Beginning Cash Balance Net Cash Flow Ending Cash Balance Minimum Cash Balance Cumulative Surplus (deficit)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Analysis And Use Of Financial Statements

Authors: Gerald I. White, Ashwinpaul C. Sondhi, Haim D. Fried

3rd Edition

0471375942, 978-0471375944

More Books

Students also viewed these Finance questions

Question

Compute the optimal order quantity of DVD players.

Answered: 1 week ago

Question

what is the website that i can get the company name for index fund

Answered: 1 week ago

Question

Why should a consultants progress be regularly monitored?

Answered: 1 week ago