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 transcribed
image 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 of materials are bought for cash, the other 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. a Month Sales Forecast January $45 Feb. 48 Mar. 50 Apr 152 May 63 59 Jun. July 76 Aug 83 Based on this information, prepare cash forecast for JUNE through AUGUST using the cash receipts and disbursements method. (Keep 2 decimal digits) Interpret your forecast. State the maximum funds available to be invested over this period, and the maximum funds needed to be borrowed

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

Multinational Business Finance

Authors: David Eiteman, Arthur Stonehill, Michael Moffett

15th Global Edition

129227008X, 9781292270081

More Books

Students also viewed these Finance questions

Question

What elements of multimedia-based instruction facilitate learning?

Answered: 1 week ago

Question

6.2 Explain the recruitment process.

Answered: 1 week ago