Front Range Furniture is preparing a Cash Budget for the second quarter of the coming year. Management would like to give you additional exposure to budgeting during your internship and has assigned you the task of preparing this Cash Budget. You will present this to your accounting supervisor for review. The following data has been forecasted: April May Sales $150,000 $157,000 Merchandise Purchases 107,000 112,400 Operating Expenses Payroll Advertising 13,600 14,280 5,400 5,700 Rent Depreciation 2,500 2,500 7,500 7,500 End of April balances Bank loan payable 26,000 Additional data: A. Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50% in the month following the sale and 50% in the month thereafter. Total sales in March were $125,000. B. Purchases are all on credit, with 40% paid in the month of purchase; the balance is paid in the following month. C. Operating expenses are paid in the month they are incurred. D. A minimum cash balance of $25,000 is required at the end of each month. E. Loans are used to maintain the minimum cash balance. At the end of each month; interest of 1% per month is paid on the outstanding loan balance as of the beginning of the month. Repayments are made whenever excess cash is available. Required: 1. Prepare the company's cash budget for May on the next page. Show the ending loan balance at May 1.
Front Range Furniture is preparing a Cash Budget for the second quarter of the coming year. Management would like to give you additional exposure to budgeting during your internship and has assigned you the task of preparing this Cash Budget. You will present this to your accounting supervisor for review. The following data has been forecasted: April May Sales $150,000 $157,000 Merchandise Purchases 107,000 112,400 Operating Expenses Payroll Advertising 13,600 14,280 5,400 5,700 Rent Depreciation 2,500 2,500 7,500 7,500 End of April balances Bank loan payable 26,000 Additional data: A. Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50% in the month following the sale and 50% in the month thereafter. Total sales in March were $125,000. B. Purchases are all on credit, with 40% paid in the month of purchase; the balance is paid in the following month. C. Operating expenses are paid in the month they are incurred. D. A minimum cash balance of $25,000 is required at the end of each month. E. Loans are used to maintain the minimum cash balance. At the end of each month; interest of 1% per month is paid on the outstanding loan balance as of the beginning of the month. Repayments are made whenever excess cash is available. Required: 1. Prepare the company's cash budget for May on the next page. Show the ending loan balance at May 1.
Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter8: Budgeting
Section: Chapter Questions
Problem 4PA: Budgeted income statement and supporting budgets for three months Bellaire Inc. gathered the...
Related questions
Question
100%
Answer both questions 1 and 2.if answered within 45mins,it would be appreciable!!!
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
Knowledge Booster
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.Recommended textbooks for you
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College