Answered step by step
Verified Expert Solution
Link Copied!

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

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_2

Step: 3

blur-text-image_3

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

Managerial Decision Modeling Business Analytics With Spreadsheet

Authors: Nagraj Balakrishnan, Barry Render, Ralph Stair, Charles Munson

4th Edition

1501515101, 978-1501515101

More Books

Students also viewed these Accounting questions

Question

1. Explain why it may make sense for companies to merge.

Answered: 1 week ago

Question

6) Discuss why exploring data is crucial to better modeling

Answered: 1 week ago

Question

Self-awareness is linked to the businesss results.

Answered: 1 week ago

Question

1. Too reflect on self-management

Answered: 1 week ago

Question

Food supply

Answered: 1 week ago