subject
Business, 13.07.2021 16:40 jayloy4724

You are an accountant at Hostell Homewares Inc. The controller wants you to prepare a monthly cash budget for the next three months, based on the following budget information. September October November
Sales $300,000 $350,000 $325,000
Manufacturing costs $175,000 $200,000 $210,000
Selling and administrative expenses $50,000 $50,000 $55,000
Capital expenditures $200,000
The company expects to sell about 10% of its merchandise for cash. Of sales on account, 65% are expected to be collected in the month following the sale and the remainder the following month (second month following the sale). Depreciation, insurance and property tax expense represent $50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 75% are expected to be paid in the month in which they are incurred and the balance in the following month.
Additionally, the following account balances as of September 1….
Current Assets
Cash$50,000
Marketable securities $75,000
Accounts receivable $327,000
*July portion of A/R $77,000
*August portion of A/R $250,000
Current Liabilities
Accounts Payable $50,000
Other items of note….
Sales on account for….
July $220,000
August $250,000
Selling and administrative costs are paid in the period incurred.
Estimated income tax payment to be made in October$60,000
Regular quarterly dividend declared in October$30,000
Regular quarterly dividend paid in November$30,000
Lastly, Scott's management desires a minimum monthly cash balance of $50,000.
Instructions: Using formulas/functions wherever available, complete the following on the Input tab…
Prepare a monthly cash budget and supporting schedules for September, October, and November.
On the basis of the cash budget prepared in Part 1, what feedback would you give the controller?

ansver
Answers: 3

Other questions on the subject: Business

image
Business, 22.06.2019 01:00, nikki225
Which type of data is generally stored in different file formats, such as text files, spreadsheets, and so on?
Answers: 3
image
Business, 22.06.2019 13:00, dondre54
Explain the relationship between consumers and producers in economic growth and activity
Answers: 1
image
Business, 22.06.2019 18:30, spazzinchicago
Health insurance protects you if you experience any of the following except: a: if you have to be hospitalized b: if you damage someone's property c: if you need to visit a clinic d: if you can't work because of illness
Answers: 2
image
Business, 22.06.2019 21:00, kebo63
After hearing a knock at your front door, you are surprised to see the prize patrol from a large, well-known magazine subscription company. it has arrived with the good news that you are the big winner, having won $21 million. you have three options.(a) receive $1.05 million per year for the next 20 years.(b) have $8.25 million today.(c) have $2.25 million today and receive $750,000 for each of the next 20 years. your financial adviser tells you that it is reasonable to expect to earn 13 percent on investments.
Answers: 3
You know the right answer?
You are an accountant at Hostell Homewares Inc. The controller wants you to prepare a monthly cash b...

Questions in other subjects:

Konu
Biology, 12.02.2021 18:50
Konu
Mathematics, 12.02.2021 18:50