Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Below is the sales forecast, in dollars, for the upcoming year for Houseware Store. Houseware store collects 15% of each month's sales in cash, 49%

image text in transcribedimage text in transcribed

Below is the sales forecast, in dollars, for the upcoming year for Houseware Store. Houseware store collects 15% of each month's sales in cash, 49% one month later, and 32% the second month after the sale. 4% of sales are bad debt. A given month's purchases are 60% of the forecasted sales amount for that month and 15% of the previous months sales forecast( 14 of materials are bought for cash, the other 34 are paid on net 30 terms). The other cash flows for JUNE through AUGUST are $35 interest income to be received in JUNE, a principal repayment of $30 in JULY, interest payment of $50 in JUNE, tax payments of $80 in AUGUST, cash proceeds from asset sale of $65 in AUGUST, and payment for asset acquisitions of $45 in JULY. The company's policy mandates that a minimum of $150 be kept in cash at all times. Ending cash in MAY is projected to be $215, and the company has no outstanding short-term borrowing or investments at that time. Month Sales Forecast January $45 Feb. 148 Mar. 50 Apr. 52 May 63 Jun. 59 July 176 |Aug. 83 Based on this information, prepare cash forecast for JUNE through AUGUST using the cash receipts and disbursements method. (Keep 2 decimal digits)

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

Financial Management For Nurse Managers And Executives

Authors: Cheryl Jones, Steven A. Finkler, Christine T. Kovner, Jason Mose

5th Edition

ISBN: 0323415164, 9780323415163

More Books

Students also viewed these Finance questions

Question

What do their students end up doing when they graduate?

Answered: 1 week ago

Question

What processes are involved in perceiving?

Answered: 1 week ago