nright Company expects to have a cash balance of $64,380 on January 1, 2014. These...

50.1K

Verified Solution

Question

Accounting

nright Company expects to have a cash balance of $64,380 on January 1, 2014. These are the relevant monthly budget data for the first two months of 2014.

1. Collections from customers: January $89,380, February $164,380.
2. Payments to suppliers: January $58,380, February $93,380.
3. Wages: January $31,608, February $41,608. Wages are paid in the month they are incurred.
4. Administrative expenses: January $22,608, February $25,608. These costs include depreciation of $1,000 per month. All other costs are paid as incurred.
5. Selling expenses: January $16,608, February $21,608. These costs are exclusive of depreciation. They are paid as incurred.
6. Sales of short-term investments in January are expected to realize $13,608 in cash. Enright has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $38,380.

Prepare a cash budget for January and February.

ENRIGHT COMPANY Cash Budget For the Two Months Ending February 28, 2014

Jan Feb

Beginning Cash Balance 64,380 ?
Add Cash Receipts
Collections from Customers 89,380 164,380
Sale of Short Term Investments 13,608 0
Total Receipts 102988 164,380
Total Available Cash ? ?
Less Cash Disbursements
Wages 58,380 58,380
Payments to Suppliers 31,608 41,608
Administrative Expenses 21,608 24608
Selling Expenses 16,608 21,608
Total Disbursements ? ?
Excess (Deficiency) of Available Cash Over Disbursements ? ?
Add Borrowings 0 ?
Less Repayments 0 0

Ending Cash Balance

I answered most of the question. Can anyone help me:)

?

?

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students