Prepare Cash Budget from Budgeted Transactions Prepare a cash budget for the month ended May 31,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare Cash Budget from Budgeted Transactions Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $89,000 on May 1, 2019. The following budgeted transactions for May 2019 present data related to anticipated cash receipts and cash disbursements: 1. For May, budgeted cash sales are $65,000 and budgeted credit sales are $505,000. (Credit sales for April were $450,000.) In the month of sale, 40% of credit sales are collected, with the balance collected in the month following sale. 2. Budgeted merchandise purchases for May are $285,000. (Merchandise purchases in April were $240,000.) In the month of purchase, 70% of merchandise purchases are paid for, and the balance is paid for in the following month. 3. Budgeted cash disbursements for salaries and operating expenses for May total $170,000. 4. During May, $25,000 of principal repayment and $4,000 of interest payment are due to the bank. 5. A $20,000 income tax deposit is due to the federal government during May. 6. A new delivery truck will be purchased during May for $7,000 cash and an $8,000 note payable. Depreciation for May will be $525. Prepare a cash budget for Campton Company for the month of May 2019. Campton Company Cash Budget For the Month Ended May 31, 2019 Beginning cash balance $ 89,000 Cash receipts: Cash sales 65,000 Collections on credit sales 505,000 x Cash available $ 0 x Cash disbursements: Payments for merchandise $ 285,000 x Salaries and operating expense payments 0 x Principal and interest payment 0 x Income tax deposit 0 x Payment on truck Total cash disbursements Ending cash balance Check 0 x $ 0 x $ 0 x Prepare Cash Budget from Budgeted Transactions Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $89,000 on May 1, 2019. The following budgeted transactions for May 2019 present data related to anticipated cash receipts and cash disbursements: 1. For May, budgeted cash sales are $65,000 and budgeted credit sales are $505,000. (Credit sales for April were $450,000.) In the month of sale, 40% of credit sales are collected, with the balance collected in the month following sale. 2. Budgeted merchandise purchases for May are $285,000. (Merchandise purchases in April were $240,000.) In the month of purchase, 70% of merchandise purchases are paid for, and the balance is paid for in the following month. 3. Budgeted cash disbursements for salaries and operating expenses for May total $170,000. 4. During May, $25,000 of principal repayment and $4,000 of interest payment are due to the bank. 5. A $20,000 income tax deposit is due to the federal government during May. 6. A new delivery truck will be purchased during May for $7,000 cash and an $8,000 note payable. Depreciation for May will be $525. Prepare a cash budget for Campton Company for the month of May 2019. Campton Company Cash Budget For the Month Ended May 31, 2019 Beginning cash balance $ 89,000 Cash receipts: Cash sales 65,000 Collections on credit sales 505,000 x Cash available $ 0 x Cash disbursements: Payments for merchandise $ 285,000 x Salaries and operating expense payments 0 x Principal and interest payment 0 x Income tax deposit 0 x Payment on truck Total cash disbursements Ending cash balance Check 0 x $ 0 x $ 0 x
Expert Answer:
Answer rating: 100% (QA)
By calculating the total cash received from sales collections and other s... View the full answer
Related Book For
Financial Accounting
ISBN: 978-1337272124
15th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac
Posted Date:
Students also viewed these finance questions
-
(a) Write each displacement in Example 2.5 in terms of the unit vector \(\hat{\imath}\) shown in Figure 2.18. (b) What is the magnitude of each displacement vector in part \(a\) ? (c) Write my final...
-
A big part of leadership is being a mentor as well. This is related to succession planning. My personal experience is that the military does a good job of focusing on mentoring. Leaders set the...
-
Complete the horizontal analysis of the following comparative income statement? Mile Wide Organic Woolens, Inc. Comparative Income Statement For Years Ending December 31, 2012 and 2013 Increase...
-
Does the image of a retail outlet affect the image of the brands it carries? Do the brands carried affect the image of the retail outlet?
-
An ambitious young worker claims that older employees have a better chance of being CEOs than younger employees. To confirm this, he sampled the ages of CEOs for 31 companies. The mean age in the...
-
Reduced temperature of a pure substance is the ratio of its (a) Critical temperature to temperature (b) Critical temperature to saturated temperature (c) Saturated temperature to critical temperature...
-
Colerain Corporation is a merchandising company that is preparing a profit plan for the third quarter of the calendar year. The companys balance sheet as of June 30 is shown below: Colerain...
-
Explore the concept of demand paging in virtual memory systems. What are some common page replacement policies, such as Least Recently Used (LRU) and Clock/Second Chance, and how do they impact...
-
Find the sum of the first 100 natural numbers.
-
In the air duct system shown in the figure, air enters the main duct at A. The recommended Fan velocities in the main duct sections and branches are 10 m/s and 7 m/s, respectively. Using the velocity...
-
Estimate the x- and y-intercepts from the graph. 98-76 x-intercept(s): 8- 7. y-intercept(s): 6- 3 4 35 -6- 17 58 Write each intercept as an ordered pair. Separate your answers using commas, if...
-
(10pts) Given T: R P(R) that is defined by T(a,b,c) = (a+b+c) + (a-b+c)x+ ar Determine if T is invertible and find T-1 if it exist. (Show all row operations when finding the inverse!)
-
K Use the following information to answer the questions below. In the current year, McDowell, Inc., recognized the following long-term gains and losses on sale of assets Asset Office equipment Land...
-
A 10-kilogram object is moving along the spiral parameterized by x(u): = u cos u and y(u) = u sin u in the direction of increasing u. The variable u is not time. When the object is at the origin, its...
-
Describe how Jesus fulfills each of the aspects of the kingdom of God (people, place, and rule/blessing). How does Roberts describe the distinctive emphases of each gospel?
-
Starr Co. had sales revenue of $540,000 in 2014. Other items recorded during the year were: Cost of goods sold ..................................................... $330,000 Salaries and wages...
-
True or False. For an undamped system, the velocity leads the acceleration by \(\pi / 2\).
-
True or False. The motion diminishes to zero in both underdamped and overdamped cases.
-
True or False. The loss coefficient denotes the energy dissipated per radian per unit strain energy.
Study smarter with the SolutionInn App