Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I'm stuck on the cash budget, please help: The cash balance at January 1 is $65,275. The company requires a minimum cash balance of $50,000.
I'm stuck on the cash budget, please help:
The cash balance at January 1 is $65,275. The company requires a minimum cash balance of $50,000. | ||||||
If the balance falls below this threshhold, the company may borrow from a local bank at a monthly interest rate of .50%. | ||||||
The company plans to purchase $200,000 in new equipment during February. It also plans to pay $100,000 in dividends during January. | ||||||
Assume that all direct labor, manufacturing overhead, and selling and administrative expenses are paid in the same month they are incurred. | ||||||
Instructions: Prepare a cash budget for the first quarter. | ||||||
Dogs R Us | ||||||
Cash Budget | ||||||
For the Quarter Ended March 31 | ||||||
January | February | March | Quarter | |||
Beginning cash balance | $ 65,275.00 | |||||
Add: cash collections from customers | 923,175.00 | 797,725.00 | 826,800.00 | 2,547,700.00 | ||
Total cash available | 988,450.00 | 797,725.00 | 826,800.00 | 2,547,700.00 | ||
Less: Cash disbursements | ||||||
Merchandise purchases | 280,871.75 | 319,642.50 | 363,820.20 | 964,334.45 | ||
Direct labor | 164,700.00 | 182,700.00 | 206,100.00 | 553,500.00 | ||
Manufacturing overhead | 55,806.25 | 59,181.25 | 63,568.75 | 178,556.25 | ||
Selling and administrative | 36,980.00 | 39,630.00 | 42,280.00 | 118,890.00 | ||
Equipment purchase | 200,000.00 | |||||
Dividends | 100,000.00 | |||||
Total cash disbursements | $ 638,358.00 | |||||
Excess (deficiency) of cash available over disbursements | ||||||
Financing | ||||||
Borrowings | ||||||
Repayments | ||||||
Interest | ||||||
Total Financing | ||||||
Ending Cash Balance |
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