Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Nunez Company has a line of credit at a local bank. It can borrow up to $24,000. The company wants to keep a minimum monthly
Nunez Company has a line of credit at a local bank. It can borrow up to $24,000. The company wants to keep a minimum monthly cash balance of $23,000.
Prepare a cash budget for January and February.
NUNEZ COMPANY Cash Budget For the Two Months Ending February 29, 2020 | |||||||
---|---|---|---|---|---|---|---|
Month | |||||||
Jan | Feb | Total | |||||
select an opening cash budget item Ending Cash BalanceDisbursementsBeginning Cash BalanceCash ReceiptsTotal ReceiptsTotal FinancingTotal DisbursementsFinancingExcess of Available Cash Over Cash DisbursementsTotal Available Cash | $enter a dollar amount | $enter a dollar amount | $enter a total for the row | ||||
select between addition and deduction AddLess: select an opening name for section one Total FinancingExcess of Available Cash Over Cash DisbursementsFinancingTotal ReceiptsBeginning Cash BalanceCash ReceiptsEnding Cash BalanceTotal Available Cash | |||||||
select a cash budget item Manufacturing OverheadRepaymentCollection From CustomersIncome Tax ExpenseDirect LabourCollection Of Notes ReceivableSelling And Administrative ExpensesBorrowingPurchase Of LandSale Of Marketable SecuritiesDirect Materials | enter a dollar amount | enter a dollar amount | enter a total for the row | ||||
select a cash budget item BorrowingDirect MaterialsManufacturing OverheadIncome Tax ExpenseRepaymentCollection Of Notes ReceivablePurchase Of LandCollection From CustomersSelling And Administrative ExpensesDirect LabourSale Of Marketable Securities | enter a dollar amount | enter a dollar amount | enter a total for the row | ||||
select a closing name for section one DisbursementsEnding Cash BalanceCash ReceiptsTotal FinancingTotal Available CashExcess of Available Cash Over Cash DisbursementsTotal DisbursementsFinancingBeginning Cash BalanceTotal Receipts | enter a total amount for section one | enter a total amount for section one | enter a total amount for section one | ||||
select a summarizing line for the first part Total FinancingTotal Available CashBeginning Cash BalanceTotal ReceiptsTotal DisbursementsExcess of Available Cash Over Cash DisbursementsFinancingDisbursementsCash ReceiptsEnding Cash Balance | enter a total amount for the first part | enter a total amount for the first part | enter a total amount for the first part | ||||
select between addition and deduction AddLess: select an opening name for section two Total FinancingDisbursementsEnding Cash BalanceTotal DisbursementsBeginning Cash BalanceExcess of Available Cash Over Cash DisbursementsFinancingTotal Available Cash | |||||||
select a cash budget item RepaymentCollection Of Notes ReceivableDirect MaterialsPurchase Of LandSale Of Marketable SecuritiesSelling And Administrative ExpensesIncome Tax ExpenseManufacturing OverheadBorrowingDirect LabourCollection From Customers | enter a dollar amount | enter a dollar amount | enter a total for the row | ||||
select a cash budget item Manufacturing OverheadIncome Tax ExpenseCollection From CustomersRepaymentCollection Of Notes ReceivablePurchase Of LandDirect LabourSale Of Marketable SecuritiesDirect MaterialsSelling And Administrative ExpensesBorrowing | enter a dollar amount | enter a dollar amount | enter a total for the row | ||||
select a cash budget item Manufacturing OverheadCollection Of Notes ReceivableSale Of Marketable SecuritiesBorrowingSelling And Administrative ExpensesIncome Tax ExpenseDirect LabourPurchase Of LandCollection From CustomersDirect MaterialsRepayment | enter a dollar amount | enter a dollar amount | enter a total for the row | ||||
select a cash budget item Sale Of Marketable SecuritiesRepaymentBorrowingSelling And Administrative ExpensesCollection From CustomersCollection Of Notes ReceivableManufacturing OverheadDirect MaterialsPurchase Of LandDirect LabourIncome Tax Expense | enter a dollar amount | enter a dollar amount | enter a total for the row | ||||
select a closing name for section two FinancingTotal Available CashTotal DisbursementsBeginning Cash BalanceTotal FinancingDisbursementsExcess of Available Cash Over Cash DisbursementsEnding Cash Balance | enter a total amount for section two | enter a total amount for section two | enter a total amount for section two | ||||
select a summarizing line for the second part Total FinancingCash ReceiptsDisbursementsBeginning Cash BalanceTotal DisbursementsTotal ReceiptsExcess of Available Cash Over Cash DisbursementsTotal Available CashFinancingEnding Cash Balance | enter a total amount for the second part | enter a total amount for the second part | enter a total amount for the second part | ||||
select an opening name for section three Cash ReceiptsBeginning Cash BalanceFinancingExcess of Available Cash Over Cash DisbursementsEnding Cash BalanceDisbursementsTotal ReceiptsTotal DisbursementsTotal FinancingTotal Available Cash: | |||||||
select a cash budget item Selling And Administrative ExpensesCollection From CustomersDirect LabourCollection Of Notes ReceivableDirect MaterialsRepaymentSale Of Marketable SecuritiesManufacturing OverheadBorrowingIncome Tax ExpensePurchase Of Land | enter a dollar amount | enter a dollar amount | enter a total for the row | ||||
select a cash budget item Collection From CustomersManufacturing OverheadPurchase Of LandDirect MaterialsSelling And Administrative ExpensesCollection Of Notes ReceivableBorrowingDirect LabourIncome Tax ExpenseRepaymentSale Of Marketable Securities | enter a dollar amount | enter a dollar amount | enter a total for the row | ||||
select a closing name for section three Total Available CashExcess of Available Cash Over Cash DisbursementsTotal FinancingDisbursementsTotal DisbursementsCash ReceiptsEnding Cash BalanceFinancingBeginning Cash BalanceTotal Receipts | enter a total amount for section three | enter a total amount for section three | enter a total amount for section three | ||||
select a closing cash budget item Ending Cash BalanceTotal ReceiptsDisbursementsBeginning Cash BalanceTotal FinancingTotal Available CashExcess of Available Cash Over Cash DisbursementsFinancingTotal DisbursementsCash Receipts | $enter a total amount for the cash budget | $enter a total amount for the cash budget | $enter a total amount for the cash budget |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started