(a) Prepare Swifty's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month and for the quarter overall. October November De Swifty Corp's accounting team is putting together the cash budget for the fourth quarter of the current year. Budgeted cash receipts and cash disbursements for DM are listed below, along with other budgeted costs and additional information. October November December Budgeted cash receipts $313,000 $303,000 $328,000 Budgeted cash disbursements for DM purchases 45,300 67,400 50,600 Budgeted DL and MOH cost 138,300 145,400 151,400 Budgeted SG&A cost 124,400 127,900 123,900 . Beginning cash balance on October 1 is $22,400, minimum required balance is $20,000. Budgeted MOH cost includes $11,800 of depreciation each month. Budgeted SG&A cost includes $13,100 of depreciation each month. A line of credit is available from the bank, subject to a 4% annual interest rate; withdrawals must be made on the first of the month, and repayments must be made on the last day of the month. The withdrawals and repayments must be in $500 increments. If excess cash is available, the following spending priorities have been identified (in order of priority). 1. Equipment purchase of $30,000 (must be made at some point during this quarter with available cash or loan from the bank). 2 Research and development of $10,000 per month (could be made for any number of months or none at all). 3. Advertising of $5,000 per month (could be made for any number of months or none at all).
(a) Prepare Swifty's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month and for the quarter overall. October November De Swifty Corp's accounting team is putting together the cash budget for the fourth quarter of the current year. Budgeted cash receipts and cash disbursements for DM are listed below, along with other budgeted costs and additional information. October November December Budgeted cash receipts $313,000 $303,000 $328,000 Budgeted cash disbursements for DM purchases 45,300 67,400 50,600 Budgeted DL and MOH cost 138,300 145,400 151,400 Budgeted SG&A cost 124,400 127,900 123,900 . Beginning cash balance on October 1 is $22,400, minimum required balance is $20,000. Budgeted MOH cost includes $11,800 of depreciation each month. Budgeted SG&A cost includes $13,100 of depreciation each month. A line of credit is available from the bank, subject to a 4% annual interest rate; withdrawals must be made on the first of the month, and repayments must be made on the last day of the month. The withdrawals and repayments must be in $500 increments. If excess cash is available, the following spending priorities have been identified (in order of priority). 1. Equipment purchase of $30,000 (must be made at some point during this quarter with available cash or loan from the bank). 2 Research and development of $10,000 per month (could be made for any number of months or none at all). 3. Advertising of $5,000 per month (could be made for any number of months or none at all).
Chapter4: Financial Planning And Forecasting
Section: Chapter Questions
Problem 4P
Related questions
Question
Transcribed Image Text:(a) Prepare Swifty's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month
and for the quarter overall.
October
November
De
Transcribed Image Text:Swifty Corp's accounting team is putting together the cash budget for the fourth quarter of the current year. Budgeted cash
receipts and cash disbursements for DM are listed below, along with other budgeted costs and additional information.
October
November December
Budgeted cash receipts
$313,000 $303,000 $328,000
Budgeted cash disbursements for DM purchases
45,300
67,400
50,600
Budgeted DL and MOH cost
138,300
145,400
151,400
Budgeted SG&A cost
124,400
127,900
123,900
.
Beginning cash balance on October 1 is $22,400, minimum required balance is $20,000.
Budgeted MOH cost includes $11,800 of depreciation each month.
Budgeted SG&A cost includes $13,100 of depreciation each month.
A line of credit is available from the bank, subject to a 4% annual interest rate; withdrawals must be made on the first of
the month, and repayments must be made on the last day of the month. The withdrawals and repayments must be in $500
increments.
If excess cash is available, the following spending priorities have been identified (in order of priority).
1.
Equipment purchase of $30,000 (must be made at some point during this quarter with available cash or loan from
the bank).
2
Research and development of $10,000 per month (could be made for any number of months or none at all).
3.
Advertising of $5,000 per month (could be made for any number of months or none at all).
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
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,