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

Maharaj Garage & Car Supplies sells a variety of automobile cleaning gadgets including a variety of hand vacuums. The business began the first quarter (January to March) of 2024 with 20 (Mash up Dirt) deep clean, cordless vacuums at a total cost of $126,800. During the quarter, the business completed the following transactions relating to the "Mash up Dirt" brand. January 8 January 31 February 4 February 10 February 28 March 4 March 10 March 31 March 31 105 vacuums were purchased at a cost of $6,022 each. In addition, the business paid a freight charge of $518 cash on each vacuum to have the inventory shipped from the point of purchase to their warehouse. The sales for January were 85 vacuums which yielded total sales revenue of $768,400. (25 of these units were sold on account to Mandys Cleaning Supplies, a longstanding customer) A new batch of 65 vacuums was purchased at a total cost of $449,800 8 of the vacuums purchased on February 4 were returned to the supplier, as they were…

Tutor give me ans

I'm waiting for solution