Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Carla Vista Company expects to have a cash balance of $64,400 on January 1, 2022. These are the relevant monthly budget data for the first

Carla Vista Company expects to have a cash balance of $64,400 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022.

1. Collections from customers: January $99,400, February $204,400.
2. Payments to suppliers: January $56,000, February $105,000.
3. Wages: January $42,000, February $56,000. Wages are paid in the month they are incurred.
4. Administrative expenses: January $29,400, February $33,600. These costs include depreciation of $1,400 per month. All other costs are paid as incurred.
5. Selling expenses: January $21,000, February $28,000. These costs are exclusive of depreciation. They are paid as incurred.
6. Sales of short-term investments in January are expected to realize $16,800 in cash. Carla Vista Company has a line of credit at a local bank that enables it to borrow up to $35,000. The company wants to maintain a minimum monthly cash balance of $28,000.

Prepare a cash budget for January and February. (List items that increase cash balance first.)

CARLA VISTA COMPANY Cash Budget choose the accounting period
enter a dollar amount

enter a dollar amount

select a cash budget item

Selling expensesRepaymentsEnding cash balanceExcess (deficiency) of available cash over disbursementsBorrowingsPayments to suppliersBeginning cash balanceTotal receiptsAdministrative expensesTotal available cashTotal disbursementsFinancingCash receiptsCollections from customersSale of short-term investmentsCash disbursementsWages

enter a dollar amount

enter a dollar amount

select a closing name for section one

Payments to suppliersBeginning cash balanceCollections from customersWagesTotal receiptsBorrowingsAdministrative expensesExcess (deficiency) of available cash over disbursementsSelling expensesRepaymentsTotal disbursementsTotal available cashCash disbursementsFinancingEnding cash balanceSale of short-term investmentsCash receipts

enter a total amount for section one

enter a total amount for section one

select a summarizing line for the first part

Cash receiptsCollections from customersBeginning cash balanceSale of short-term investmentsTotal receiptsCash disbursementsPayments to suppliersWagesRepaymentsAdministrative expensesTotal available cashTotal disbursementsSelling expensesExcess (deficiency) of available cash over disbursementsFinancingBorrowingsEnding cash balance

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

Payments to suppliersBorrowingsSale of short-term investmentsTotal receiptsCash disbursementsCash receiptsCollections from customersTotal available cashAdministrative expensesFinancingRepaymentsWagesSelling expensesEnding cash balanceExcess (deficiency) of available cash over disbursementsBeginning cash balanceTotal disbursements

select a cash budget item

Total available cashBorrowingsCash disbursementsSelling expensesEnding cash balanceTotal disbursementsWagesCollections from customersCash receiptsRepaymentsFinancingPayments to suppliersSale of short-term investmentsAdministrative expensesTotal receiptsExcess (deficiency) of available cash over disbursementsBeginning cash balance

enter a dollar amount

enter a dollar amount

select a cash budget item

Excess (deficiency) of available cash over disbursementsCash disbursementsFinancingPayments to suppliersTotal disbursementsTotal receiptsEnding cash balanceWagesAdministrative expensesBorrowingsRepaymentsSelling expensesBeginning cash balanceCollections from customersTotal available cashCash receiptsSale of short-term investments

g

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Investigation And Forensic Accounting

Authors: George A Manning

3rd Edition

0367864347, 9780367864347

More Books

Students also viewed these Accounting questions

Question

Recognize and describe the steps in the recruiting process

Answered: 1 week ago

Question

Appreciate the contribution made by a positions incumbent

Answered: 1 week ago

Question

Know how to conduct a position analysis

Answered: 1 week ago