Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
6th Edition
ISBN: 9780134486857
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 22, Problem 35E
Preparing a financial budget—
You recently began a job as an accounting intern at Reilly Golf Park. Your first task was to help prepare the cash budget for April and May. Unfortunately, the computer with the budget file crashed, and you did not have a backup or even a paper copy. You ran a program to salvage bits of data from the budget file. After entering the following data in the budget, you may have just enough information to reconstruct the budget.
Reilly Golf Park eliminates any cash deficiency by borrowing the exact amount needed from First Street Bank, where the current interest rate is 6% per year. Reilly Golf Park first pays interest on its outstanding debt at the end of each month. The company then repays all borrowed amounts at the end of the month with any excess cash above the minimum required but after paying monthly interest expenses. Reilly does not have any outstanding debt on April 1.
Complete the cash budget. Round interest expense to the nearest whole dollar.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
You recently began a job as an accounting intern at Regis Adventures. Your first task was to help prepare the cash budget for February and March. Unfortunately, the computer with the budget
ile crashed, and you did not have a backup or even a hard copy. You ran a program to salvage bits of data from the budget file. After entering the following data in the budget, you may have just
enough information to reconstruct the budget.
(Click the icon to view information on borrowing cash.)
Requirements
Complete the following cash budget. (For amounts with a $0 balance, make sure to enter "0" in the appropriate input field. Enter cash deficiencies with a minus sign or parentheses. Enter the net
total effects of financing with a minus sign when the amount is a net outflow. Round interest expense to the nearest whole dollar.)
Regis Adventures eliminates any cash deficiency by borrowing the exact amount needed from State
Street Bank, where the current interest rate is 6%. Regis Adventures pays…
You recently began a job as an accounting intern at Rockwall Adventures. Your first task was to help prepare the cash budget for February and March. Unfortunately, the computer with the budget file crashed, and you did not have a backup or even a hard copy. You ran a program to salvage bits of data from the budget file. After entering the following data in the budget, you may have just enough information to reconstruct the budget.
Rockwall Adventures eliminates any cash deficiency by borrowing the exact amount needed from State Street Bank, where the current interest rate is 6%. Rockwall Adventures pays interest on its outstanding debt at the end of each month. The company also repays all borrowed amounts at the end of the month as cash becomes available.
Requirement: Complete the following cash budget:
You recently began a job as an accounting intern at Reilly Adventures. Your first task was to help prepare the cash budget for February and March. Unfortunately, the computer with the budget file crashed, and
you did not have a backup or even a hard copy. You ran a program to salvage bits of data from the budget file. After entering the following data in the budget, you may have just enough information to reconstruct
the budget.
(Click the icon to view information on borrowing cash.)
Requirements
Complete the following cash budget. (For amounts with a $0 balance, make sure to enter "0" in the appropriate input field. Enter cash deficiencies with a minus sign or parentheses. Enter the net total effects of
financing with a minus sign when the amount is a net outflow. Round interest expense to the nearest whole dollar.)
Beginning cash balance
Plus: Cash collections
Reilly Adventures
Combined Cash Budget
February and March
February
$
16,700
0
Plus: Cash from sale of plant assets
$
106,800…
Chapter 22 Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Ch. 22 - Managers are required to think about future...Ch. 22 - Prob. 2TICh. 22 - Managers use results to evaluate employees...Ch. 22 - Managers work with managers in other divisions.Ch. 22 - Prob. 5TICh. 22 - Match the budget types to the definitions.Ch. 22 - Prob. 7TICh. 22 - Prob. 8TICh. 22 - Prob. 9TICh. 22 - Prob. 10TI
Ch. 22 - Prob. 11TICh. 22 - Prob. 12TICh. 22 - Prob. 13TICh. 22 - Prob. 14TICh. 22 - Prob. 15TICh. 22 - Prob. 16TICh. 22 - A company can expect to receive which of the...Ch. 22 - A company prepares a five-year budget. This budget...Ch. 22 - Which of the following is the cornerstone of the...Ch. 22 - Prob. 4QCCh. 22 - Suppose Iron City manufactures cast iron skillets....Ch. 22 - Prob. 6QCCh. 22 - Use the following information to answer questions...Ch. 22 - The budgeted income statement is part of which...Ch. 22 - Prob. 9QCCh. 22 - Use the following information to answer questions...Ch. 22 - Suppose Mallcentral sells 1,000 hardcover books...Ch. 22 - Prob. 12QCCh. 22 - Information technology has made it easier for...Ch. 22 - Prob. 1RQCh. 22 - Prob. 2RQCh. 22 - Prob. 3RQCh. 22 - What is budgetary slack? Why might managers try to...Ch. 22 - Explain the difference between strategic and...Ch. 22 - Explain the difference between static and flexible...Ch. 22 - What is a master budget?Ch. 22 - In a manufacturing company, what are the three...Ch. 22 - Why is the sales budget considered the cornerstone...Ch. 22 - Prob. 10RQCh. 22 - What is the formula used to determine the amount...Ch. 22 - What are the two types of manufacturing overhead?...Ch. 22 - How is the predetermined overhead allocation rate...Ch. 22 - What is the capital expenditures budget?Ch. 22 - Prob. 15RQCh. 22 - What are the budgeted financial statements? How do...Ch. 22 - How does the master budget for a merchandising...Ch. 22 - What is the formula used to determine the amount...Ch. 22 - What budgets are included in the financial budget...Ch. 22 - What is sensitivity analysis? Why is it important...Ch. 22 - Budgeting benefits List the three key benefits...Ch. 22 - Budgeting types Consider the following budgets and...Ch. 22 - Preparing an operating budgetsales budget Brown...Ch. 22 - Preparing an operating budgetproduction budget...Ch. 22 - Preparing an operating budgetdirect materials...Ch. 22 - Preparing an operating budgetdirect labor budget...Ch. 22 - Preparing an operating budgetmanufacturing...Ch. 22 - Preparing an operating budgetcost of goods sold...Ch. 22 - Berry expects total sales of 359,000 in January...Ch. 22 - Preparing a financial budgetschedule of cash...Ch. 22 - Preparing a financial budgetcash budget Booth has...Ch. 22 - Prob. 12SECh. 22 - Preparing an operating budgetsales budget Trailers...Ch. 22 - Preparing an operating budgetinventory, purchases,...Ch. 22 - Victors expects total sales of 702,000 for January...Ch. 22 - Prob. 16SECh. 22 - Preparing a financial budgetcash budget Wilson...Ch. 22 - Victors expects total sales of 702,000 for January...Ch. 22 - Using sensitivity analysis in budgeting Refer to...Ch. 22 - Using sensitivity analysis in budgeting Riverbed...Ch. 22 - Prob. 21ECh. 22 - Preparing an operating budgetsales budget...Ch. 22 - Preparing an operating budgetsales and production...Ch. 22 - Preparing an operating budgetdirect materials,...Ch. 22 - Preparing an operating budgetcost of goods sold...Ch. 22 - Preparing a financial budgetschedule of cash...Ch. 22 - Prob. 27ECh. 22 - Preparing the financial budgetcash budget Use the...Ch. 22 - Preparing the financial budgetcash budget Hoppy...Ch. 22 - Preparing the financial budgetbudgeted balance...Ch. 22 - Preparing an operating budgetinventory, purchases,...Ch. 22 - Preparing an operating budgetselling and...Ch. 22 - Prob. 33ECh. 22 - Preparing a financial budgetcash budget,...Ch. 22 - Preparing a financial budgetcash budget You...Ch. 22 - Use the following June actual ending balances and...Ch. 22 - Using sensitivity analysis Rucker Company prepared...Ch. 22 - Preparing an operating budgetsales, production,...Ch. 22 - Preparing an financial budgetschedule of cash...Ch. 22 - Preparing a financial budgetbudgeted income...Ch. 22 - Completing a comprehensive budgeting...Ch. 22 - Preparing an operating budgetsales budget;...Ch. 22 - Preparing a financial budgetschedule of cash...Ch. 22 - Preparing a financial budgetbudgeted income...Ch. 22 - Prob. 45APCh. 22 - Prob. 46APCh. 22 - Preparing an operating budgetsales, production,...Ch. 22 - Prob. 48BPCh. 22 - Preparing a financial budgetbudgeted income...Ch. 22 - Completing a comprehensive budgeting...Ch. 22 - Prob. 51BPCh. 22 - Preparing a financial budgetschedule of cash...Ch. 22 - Prob. 53BPCh. 22 - Belton Printing Company of Baltimore has applied...Ch. 22 - Using sensitivity analysis Holly Company prepared...Ch. 22 - Prob. 57PCh. 22 - Before you begin this assignment, read the...Ch. 22 - Prob. 1DCCh. 22 - Patrick works for McGills Computer Repair, owned...
Additional Business Textbook Solutions
Find more solutions based on key concepts
The amount that should be recorded by Company R for building under historical cost principle.
Financial Accounting (11th Edition)
What are assets limited as to use and how do they differ from restricted assets?
Accounting for Governmental & Nonprofit Entities
E6-14 Using accounting vocabulary
Learning Objective 1, 2
Match the accounting terms with the corresponding d...
Horngren's Accounting (11th Edition)
Assume you are a CFO of a company that is attempting to race additional capital to finance an expansion of its ...
Financial Accounting, Student Value Edition (4th Edition)
Discussion Analysis A13-41 Discussion Questions 1. How do managers use the statement of cash flows? 2. Describ...
Managerial Accounting (5th Edition)
Analysis of inventory errors A2 Hallam Company’s financial statements show the following. The company recently ...
FINANCIAL ACCT.FUND.(LOOSELEAF)
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.Similar questions
- You recently began a job as an accounting intern at Raymond Adventures. Your first task was to help prepare the cash budget for February and March. Unfortunately, the computer with the budget file crashed, and you did not have a backup or even a hard copy. You ran a program to salvage bits of data from the budget file. After entering the following data in the budget, you may have just enough information to reconstruct the budget. Raymond Adventures eliminates any cash deficiency by borrowing the exact amount needed from State Street Bank, where the current interest rate is 8%. Raymond Adventures pays interest on its outstanding debt at the end of each month. The company also repays all borrowed amounts at the end of the month as cash becomes available. Complete the following cash budget: Raymond Adventures Cash Budget February and March…arrow_forwardYou recently began a job as an accounting intern at Backyard Adventures. Your first task was to help prepare the cash budget for February and March. Unfortunately, the computer with the budget file crashed, and you did not have a backup or even a hard copy. You ran a program to salvage bits of data from the budget file. After entering the following data in the budget, you may have just enough information to reconstruct the budget. Backyard Adventures eliminates any cash deficiency by borrowing the exact amount needed from State Street Bank, where the current interest rate is 6%. Backyard Adventures pays interest on its outstanding debt at the end of each month. The company also repays all borrowed amounts at the end of the month as cash becomes available. Requirements: Complete the following cash budget. (For amounts with a $0 balance, make sure to enter "0" in the appropriate input field. Enter cash deficiencies with a minus sign or parentheses. Enter the net total effects of…arrow_forwardPROBLEM Irina needs to put together the cash budget for quarter two, but she can't find the bank statement listing the required minimum balance. The bank only allows withdrawals from the company's line of credit in specified increments. She knows she has to consider that requirement when determining any budgeted financing, so she looks at the previous quarter's cash budget to understand the financing. She finds the following information on the quarter 1 budget and from the bank agreement. Beginning cash balance Budgeted cash receipts Budgeted cash disbursements Budgeted financing Line of credit withdrawal increments $ 12,000 210,500 218,500 5,000 1,000 Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. How much is the cash surplus or deficiency? Amount How much is the required minimum balance? Required minimum balancearrow_forward
- Requirement 1: Please list the three major objectives of budgeting. Requirement 2: ABC Manufacturing has just hired a new controller. During her first week on the job, the controller was asked to establish a budget for operating expenses in 20Y6. Since the controller was not yet familiar with the operations of ABC Manufacturing, she decided to budget these expenses using the same procedures as the prior controller. Therefore, in order to establish a budget for operating expenses, the controller started with actual operating expenses incurred in 2017 and added 4.3%. Diana based this percentage on inflation as measured by the consumer price index. Please comment on the effectiveness of the controller's budgeting strategy.arrow_forwardYou are beginning your own business and developed a budget based on modest sales and expense assumptions. The actual results are very close to the budget at the end of the first and second months. During the third month, both cash collected and paid differ significantly from the budget. What could be the cause and what should you do?arrow_forwardYou have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembled below. The company sells many styles of earrings, but all are sold for the same price—$17 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings): January (actual) 22,600 June (budget) 52,600 February (actual) 28,600 July (budget) 32,600 March (actual) 42,600 August (budget) 30,600 April (budget) 67,600 September (budget) 27,600 May (budget) 102,600 The concentration…arrow_forward
- You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembled below. The company sells many styles of earrings, but all are sold for the same price—$16 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings): January (actual) 21,200 June (budget) 51,200 February (actual) 27,200 July (budget) 31,200 March (actual) 41,200 August (budget) 29,200 April (budget) 66,200 September (budget) 26,200 May (budget)…arrow_forwardYou have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembled below. The company sells many styles of earrings, but all are sold for the same price—$10 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings): January (actual) 20,000 June (budget) 50,000 February (actual) 26,000 July (budget) 30,000 March (actual) 40,000 August (budget) 28,000 April (budget) 65,000 September (budget) 25,000 May (budget) 100,000 The concentration of…arrow_forwardYou have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembled below. The company sells many styles of earrings, but all are sold for the same price - $10 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings): January (actual)..... 20,000 June (budget)..... 50,000 February (actual)..... 26,000 July (budget)..... 30,000 March (actual)..... 40,000 August (budget)..... 28,000 April (budget)..... 65,000 September (budget)..... 25,000…arrow_forward
- You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembled below. The company sells many styles of earrings, but all are sold for the same price—$16 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings): January (actual) 21,200 June (budget) 51,200 February (actual) 27,200 July (budget) 31,200 March (actual) 41,200 August (budget) 29,200 April (budget) 66,200 September (budget) 26,200 May (budget)…arrow_forwardYou have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembled below. The company sells many styles of earrings, but all are sold for the same price—$13 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings): January (actual) 20,600 June (budget) 50,600 February (actual) 26,600 July (budget) 30,600 March (actual) 40,600 August (budget) 28,600 April (budget) 65,600 September (budget) 25,600 May (budget) 100,600 The…arrow_forwardYou have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembled below. The company sells many styles of earrings, but all are sold for the same price-$16 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings): January (actual) February (actual) March (actual) April (budget) May (budget) Variable: Sales commissions 21, 200 27, 200 41, 200 The concentration of sales before and during May is due to Mother's Day. Sufficient inventory should be on hand at…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY