Carefully study the following cash budget and determine the amount to be borrowed or repaid during each quarter, so that the company never ends a quarter with less than $50,000 cash on hand, and always repays as much debt as possible. There is no debt as of the beginning of the first quarter, and interest costs are assumed not significant in this analysis. Use the pick lists associated with the boxed areas near the bottom of the spreadsheet to determine the right amounts to borrow and repay each quarter. Correct choices will result in the boxed areas turning green. Cash budget Beginning cash Customer receipts Available cash Less: disbursements Direct materials Direct labor Factory overhead SG&A Other expense and tax Equipment purchases Total disbursements Cash surplus (deficit) Financing: Planned borrowing Planned repayment Ending cash balance First Quarter 10,000 140,000 150,000 28,000 14,000 13,500 31,000 11,000 0 97,500 52,500 52,500 Second Quarter 52,500 212,500 160,000 30,000 14,000 16,000 12,000 0 31,000 0 353,000 250,000 -140,500 -140,500 Third Quarter -140,500 59,500 200,000 41,000 15,000 20,000 13,000 0 33,000 122,000 0 -62,500 -62,500 Fourth Quarter -62,500 187,500 250,000 48,000 17,000 25,000 15,000 0 33,000 0 363,000 225,000 -175,500 -175,500
Carefully study the following cash budget and determine the amount to be borrowed or repaid during each quarter, so that the company never ends a quarter with less than $50,000 cash on hand, and always repays as much debt as possible. There is no debt as of the beginning of the first quarter, and interest costs are assumed not significant in this analysis. Use the pick lists associated with the boxed areas near the bottom of the spreadsheet to determine the right amounts to borrow and repay each quarter. Correct choices will result in the boxed areas turning green. Cash budget Beginning cash Customer receipts Available cash Less: disbursements Direct materials Direct labor Factory overhead SG&A Other expense and tax Equipment purchases Total disbursements Cash surplus (deficit) Financing: Planned borrowing Planned repayment Ending cash balance First Quarter 10,000 140,000 150,000 28,000 14,000 13,500 31,000 11,000 0 97,500 52,500 52,500 Second Quarter 52,500 212,500 160,000 30,000 14,000 16,000 12,000 0 31,000 0 353,000 250,000 -140,500 -140,500 Third Quarter -140,500 59,500 200,000 41,000 15,000 20,000 13,000 0 33,000 122,000 0 -62,500 -62,500 Fourth Quarter -62,500 187,500 250,000 48,000 17,000 25,000 15,000 0 33,000 0 363,000 225,000 -175,500 -175,500
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 3R: Review the completed master budget and answer the following questions:
Is Ranger Industries...
Related questions
Concept explainers
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Question
Transcribed Image Text:Carefully study the following cash budget and determine the amount to be borrowed or repaid
during each quarter, so that the company never ends a quarter with less than $50,000 cash on
hand, and always repays as much debt as possible. There is no debt as of the beginning of the
first quarter, and interest costs are assumed not significant in this analysis.
Use the pick lists associated with the boxed areas near the bottom of the spreadsheet to
determine the right amounts to borrow and repay each quarter. Correct choices will result in
the boxed areas turning green.
Cash budget
Beginning cash
Customer receipts
Available cash
Less: disbursements
Direct materials
Direct labor
Factory overhead
SG&A
Other expense and tax
Equipment purchases
Total disbursements
Cash surplus (deficit)
Financing:
Planned borrowing
Planned repayment
Ending cash balance
First
Quarter
10,000
150,000
140,000
28,000
13,500
14,000
11,000
0
31,000
97,500
0
52,500
52,500
0
Second
Quarter
52,500
212,500
160,000
30,000
14,000
16,000
0
12,000
0
31,000
353,000
250,000
-140,500
Third
Quarter
-140,500
59,500
200,000
41,000
15,000
20,000
13,000
0
33,000
122,000
0
-62,500
-62,500
0
Fourth
Quarter
-62,500
187,500
250,000
48,000
17,000
25,000
15,000
0
33,000
0
363,000
225,000
-175,500
-175,500
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 4 steps
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
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning