Wildhorse Company expects to have a cash balance of $52,100 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $90,000, February $134,200 2. Payments to suppliers: January $45,500, February $51,000 3. Wages: January $35,000, February $41,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $25,000, February $31,400. These costs include depreciation of $2,300 per month. All other costs are paid as incurred. 5. Selling expenses: January $19.900, February $23,400. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize $14,400 in cash. Wildhorse has a line of credit at a local bank that enables it to borrow up to $43,300. The company wants to maintain a minimum monthly cash balance of $26,000. Prepare a cash budget for January and February. (Do not leave any answer field blank. Enter O for amounts.) WILDHORSE COMPANY Cash Budget For the Months Ending January 30 and February 28, 2022 January February

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter7: Budgeting
Section: Chapter Questions
Problem 9MC: The direct materials budget is prepared using which budgets information? A. cash payments budget B....
icon
Related questions
icon
Concept explainers
Question
WILDHORSE COMPANY
Cash Budget
$
S
January
$
Febru
Transcribed Image Text:WILDHORSE COMPANY Cash Budget $ S January $ Febru
Wildhorse Company expects to have a cash balance of $52,100 on January 1, 2022. These are the relevant monthly budget data for
the first two months of 2017.
1.
Collections from customers: January $90,000, February $134,200
2.
Payments to suppliers: January $45.500, February $51,000
3.
Wages: January $35,000, February $41,000. Wages are paid in the month they are incurred.
4.
Administrative expenses: January $25,000, February $31,400. These costs include depreciation of $2,300 per month. All
other costs are paid as incurred.
5.
Selling expenses: January $19,900, February $23,400. These costs are exclusive of depreciation. They are paid as incurred.
6.
Sales of short-term investments in January are expected to realize $14,400 in cash. Wildhorse has a line of credit at a local
bank that enables it to borrow up to $43,300. The company wants to maintain a minimum monthly cash balance of $26,000.
Prepare a cash budget for January and February. (Do not leave any answer field blank. Enter O for amounts.)
WILDHORSE COMPANY
Cash Budget
For the Months Ending January 30 and February 28, 2022
January
February
Transcribed Image Text:Wildhorse Company expects to have a cash balance of $52,100 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $90,000, February $134,200 2. Payments to suppliers: January $45.500, February $51,000 3. Wages: January $35,000, February $41,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $25,000, February $31,400. These costs include depreciation of $2,300 per month. All other costs are paid as incurred. 5. Selling expenses: January $19,900, February $23,400. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize $14,400 in cash. Wildhorse has a line of credit at a local bank that enables it to borrow up to $43,300. The company wants to maintain a minimum monthly cash balance of $26,000. Prepare a cash budget for January and February. (Do not leave any answer field blank. Enter O for amounts.) WILDHORSE COMPANY Cash Budget For the Months Ending January 30 and February 28, 2022 January February
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub