Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Prepare a monthly cash budget for the first quarter of the fiscal year beginning July 1, assuming the following facts: a. Cash collections typically

1. Prepare a monthly cash budget for the first quarter of the fiscal year beginning July 1, assuming the following facts:
a. Cash collections typically average 50% of charges. Cash is received, on average, 40% in the month of service, 30% in the next month, 15% in the second month after service, 5% each in the next two months and 5% is uncollectible.
b.Charges for February, March, April, May, and June were $300.000, $400,000, $400,000, $200,000 and $500,000, respectively. Charges for July, August and September are expected to be $400,000, $200,000 and $300,000.
c.The cash balance at June 30 is expected to be $100,000. Monthly interest is expected to be .1% on the end of month cash balance.
d.Cash outflows are anticipated to be 90% of average receipts for the quarter.

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

A Communication Audit Handbook Helping Organizations Communicate

Authors: Seymour Hamilton

1st Edition

0801300614, 978-0801300615

More Books

Students also viewed these Accounting questions

Question

Discuss differences in paralanguage of people in various cultures.

Answered: 1 week ago