Budgets: Budgets are prepared to estimate the revenue, costs, receipts and payments for the business. There are several types of budgets prepared for a manufacturing concern. Few major types of budgets prepared by each manufacturing concert are as follows: Sales budget Cash Collection budget Production budget Raw material purchase budget Expenses Budgets Cash disbursement budget Cash Budget : The Cash budget is the final step of budgeting process. In this process the budgeted Cash collection and disbursements are shown together and budgeted cash balance is calculated for each period under the budget. To Prepare: The Cash Budget for the upcoming fiscal year Solution: The Cash Budget for the upcoming fiscal year is as follows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Beginning Cash Balance (A) $ 20,000 $ 10,000 $ 35,800 $ 25,800 Total Cash Receipts (B) $ 180,000 $ 330,000 $210,000 $230,000 $ 950,000 Total Cash Disbursements (C) $ 260,000 $ 230,000 $220,000 $240,000 $ 950,000 Cash Surplus / (Deficit) (D) = A+B-C= $ (60,000) $ 110,000 $ 25,800 $ 15,800 Loans: Borrowings (at the beginning of the quarter )(E) $ 70,000 $ - $ - $ - $ 70,000 (60000+10000) Repayments (at the end of quarter) (F) $ - $ 70,000 $ - $ - $ 70,000 Interest Payment (G) $ - $ 4,200 $ - $ - $ 4,200 (700003%2) Ending Cash Balance (D+E-F-G) $ 10,000 $ 35,800 $ 25,800 $ 15,800 $ 15,800 Note: The ending cash balance of last quarter becomes the beginning cash balance of next quarter. The Borrowing for the 1 s t quarter are made 60,000 +10,000 = 70,000 to make the deficit good and keep the minimum required ending cash balance of $10,000. Repayment of the loan $70,000 is made in the 2 n d quarter, because there is sufficient cash surplus of $110,000. And the interest is calculated for 2 quarters as the loan was taken in the beginning of 1 s t quarter and being paid at the end of 2 n d quarter. The interest is calculated as 2% of 70,000 for 2 periods = $4,200

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Can you solve this general accounting problem with appropriate steps and explanations?

Please provide the accurate answer to this general accounting problem using valid techniques.

Hollister Athletic Equipment had a balance in the Accounts Receivable account of $780,000 at the beginning of the year and a balance of $820,000 at the end of the year. Net credit sales during the year amounted to $6,570,000.

Answer 2

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 8

Ch. 8 - Prob. 1Q Ch. 8 - Prob. 2Q Ch. 8 - Prob. 3Q Ch. 8 - 8-4 What is a master budget? Briefly describe its...Ch. 8 - 8—5 Why is the sales forecast the starting point...Ch. 8 - Prob. 6Q Ch. 8 - 8-7 Why is it a good idea to create a ‘"Budgeting...Ch. 8 - 8-8 What is a self-imposed budget? What are the...Ch. 8 - Prob. 9Q Ch. 8 - Prob. 10Q

Videos

Want to see the full answer?

Chapter 8 Solutions