Master Budget - Solutions 5. The Storm Meadows Resort is preparing a cash budget for July. Management has collected the following information: a. The cash balance on June 30 is $275000. b. Actual services provided in May and June and projected services for July are: Cash services Credit services May $195000 675000 June July $180000 $175000 927000 810000 1/3 of credit services are collected in the month of service and 2/3 are collected in the following month, c. During July, $85000 of cleaning supplies will be purchased. Accounts are usually paid for over two months: 75% in the month of purchase, 25% in the month following purchase. Accounts payable (the remaining balance owed) on June 30th is $17500. Salaries and wages paid in July will be $725000. Depreciation on equipment used for the resort for July will be $204000. d. e. Other cash expenses for July will be $192000. f. 8. The resort must repay a short-term loan during July. The payment is $72000, including interest. Prepare a cash budget for July.

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter4: Financial Planning And Forecasting
Section: Chapter Questions
Problem 4P
icon
Related questions
Question
Master Budget - Solutions
5.
The Storm Meadows Resort is preparing a cash budget for July. Management has collected the following information:
a. The cash balance on June 30 is $275000.
b. Actual services provided in May and June and projected services for July are:
Cash services
Credit services
May
$195000
675000
June
July
$180000
$175000
927000
810000
1/3 of credit services are collected in the month of service and 2/3 are collected in the following month,
c. During July, $85000 of cleaning supplies will be purchased. Accounts are usually paid for over two months: 75% in the month of
purchase, 25% in the month following purchase. Accounts payable (the remaining balance owed) on June 30th is $17500.
Salaries and wages paid in July will be $725000.
Depreciation on equipment used for the resort for July will be $204000.
d.
e.
Other cash expenses for July will be $192000.
f.
8.
The resort must repay a short-term loan during July. The payment is $72000, including interest.
Prepare a cash budget for July.
Transcribed Image Text:Master Budget - Solutions 5. The Storm Meadows Resort is preparing a cash budget for July. Management has collected the following information: a. The cash balance on June 30 is $275000. b. Actual services provided in May and June and projected services for July are: Cash services Credit services May $195000 675000 June July $180000 $175000 927000 810000 1/3 of credit services are collected in the month of service and 2/3 are collected in the following month, c. During July, $85000 of cleaning supplies will be purchased. Accounts are usually paid for over two months: 75% in the month of purchase, 25% in the month following purchase. Accounts payable (the remaining balance owed) on June 30th is $17500. Salaries and wages paid in July will be $725000. Depreciation on equipment used for the resort for July will be $204000. d. e. Other cash expenses for July will be $192000. f. 8. The resort must repay a short-term loan during July. The payment is $72000, including interest. Prepare a cash budget for July.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage