Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Agarwal, Incorporated, has a 5 0 - day average collection period and wants to maintain a minimum cash balance of $ 3 5 million, which

Agarwal, Incorporated, has a 50-day average collection period and wants to maintain a minimum cash balance of $35 million, which is what the company currently has on hand. The company currently has a receivables balance of $192 million and has developed the following sales and cash disbursement budgets (in millions):
\table[[,Q1,Q2,Q3,Q4],[Sales,$405,$ 477,$ 558,$ 522],[Total cash disbursement,279,415,652,434]]
Complete the following cash budget for the company.
Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers in millions rounded to the nearest whole million dollar amount, e.g.,32.
\table[[AGARWAL, INCORPORATED],[Cash Budget],[(in millions)],[,Q1,Q2,Q3,Q4],[Beginning receivables,$,192vv,$,225vv,$,265vv,$,310vv],[Sales,,405,,477,,558,,522],[Cash collections,,372vv,,437vv,,513,,542],[Ending receivables,$,225(,$,\table[[265vv]],$,310,$,290vv],[Total cash collections,\bar ($),372vv,\bar ($$),437vv,\bar ($$),513,\bar ($),7542],[Total cash disbursements,,279,,415,,652,,434],[Net cash inflow,$,93(,$,\table[[22vv]],$,139\times ,$,108vv],[Beginning cash balance,$,35vv,$,128,$,150vv,$,11],[Net cash inflow,,93,,22vv,,139\times ,,108],[Ending cash balance,$,35\times ,$,35\times ,$,35\times ,$,35\times ],[Minimum cash balance,$,35\times ,$,35\times ,$,35\times ,$,35\times ],[Cumulative surplus (deficit),$,93,$,115vv,$,24\times ,$,84vv]]
image text in transcribed

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

Healthcare Finance An Introduction To Accounting And Financial Management

Authors: Louis Gapenski

1st Edition

1567930905, 978-1567930900

More Books

Students also viewed these Finance questions