Prepare a cash budget for the months of July, August, and September. (Negative balances and Loan...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare a cash budget for the months of July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Enter your final answers in whole dollars.) Budgeted sales Budgeted cash payments for Direct materials Direct labor Overhead July August September $ 63,500 $ 79,500 $ 48,500 16,260 13,540 13,860 4,140 20,300 3,460 16,900 3,540 17,300 Sales to customers are 25% cash and 75% on credit. Sales in June were $57,000. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $17,000 in cash and $5,100 in loans payable. A minimum cash balance of $17,000 is required. Loans are obtained at the end of any month when the preliminary cash balance is below $17,000. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. Any preliminary cash balance above $17,000 is used to repay loans at month-end. Expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($4,100 per month), and rent ($6,600 per month). Beginning cash balance Total cash available Less: Cash payments for Total cash payments Preliminary cash balance Loan activity Additional loan Repayment of loan to bank Ending cash balance BUILT-TIGHT Cash Budget July August September 0 0 0 0 0 0 Loan balance - Beginning of month Additional loan (loan repayment) Loan balance - End of month Loan balance July August September Prepare a cash budget for the months of July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Enter your final answers in whole dollars.) Budgeted sales Budgeted cash payments for Direct materials Direct labor Overhead July August September $ 63,500 $ 79,500 $ 48,500 16,260 13,540 13,860 4,140 20,300 3,460 16,900 3,540 17,300 Sales to customers are 25% cash and 75% on credit. Sales in June were $57,000. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $17,000 in cash and $5,100 in loans payable. A minimum cash balance of $17,000 is required. Loans are obtained at the end of any month when the preliminary cash balance is below $17,000. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. Any preliminary cash balance above $17,000 is used to repay loans at month-end. Expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($4,100 per month), and rent ($6,600 per month). Beginning cash balance Total cash available Less: Cash payments for Total cash payments Preliminary cash balance Loan activity Additional loan Repayment of loan to bank Ending cash balance BUILT-TIGHT Cash Budget July August September 0 0 0 0 0 0 Loan balance - Beginning of month Additional loan (loan repayment) Loan balance - End of month Loan balance July August September
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
You want to launch a business internationally, and you need to choose 3 countries1 in the Middle East, 1 in Asia, and 1 in Latin America. What are some of the components of these cultures that you...
-
Use the data in anthrop.dat for this problem. a. Construct a population from the 3000 observations in anthrop.dat in which the 1000 individuals with the highest value of y have been removed. Now take...
-
Influencer marketing on social platforms is integral to marketing campaigns of many brands. For FYiDoctors, it is also vital for the brand. FYIDoctors currently haven't hired any influencers, but it...
-
The diff-amp in Figure 11.3 of the text has parameters \(V^{+}=+5 \mathrm{~V}\), \(V^{-}=-5 \mathrm{~V}, R_{C}=8 \mathrm{k} \Omega\), and \(I_{Q}=0.5 \mathrm{~mA}\). The transistor parameters are...
-
Stockholders equity accounts and other related accounts of Gonzales Company as of January 1, 20--, the beginning of its fiscal year, are shown below. Preferred stock subscriptions...
-
Sarnia Ltd . is a manufacturing company that produces a single product. The company keeps meticulous records of manufacturing activities from which the following information has been extracted: March...
-
What is the main objective of reverse logistics in supply chain management? a ) ) Maximizing profits b ) ) Returning defective products to suppliers c ) ) Reducing transportation costs d ) ) Ensuring...
-
A mechanical wave travels the length of a 2 7 m long string stretched to a tension of 7 6 N in 0 . 2 4 s . Find the mass of the string ( in g ) .
-
if a 1 2 5 0 N force acts on a 7 0 kg box in a Northerly direction and a 8 3 0 N force acts on the box at an angle of 1 2 0 what is the resultant force on the box? b . What is the net acceleration of...
-
108. Given below are two statements: one is labelled as Assertion (A) and the other is labelled as Reason (R). Assertion (A): Mendel's law of independent assortment does not hold good for the genes...
-
A planet has an equatorial radius of 6 . 9 3 \ times 1 0 7 m and a mass of 4 . 5 2 x 1 0 2 6 kg . ( a ) Compute the acceleration of gravity at the equator of this planet. ( b ) What is the ratio of a...
-
A mass is bouncing on a spring and its motion is well represented by the fit function y = 0 . 0 5 5 sin ( 4 . 6 t + 1 . 8 ) + . 2 3 . What is the velocity of this mass at t = 1 . 4 1 ? ( You will...
-
Research three current articles on manufacturing corporations; focus on specific product purchasing strategies. Determine how these strategies can support the highest levels of strategic planning....
-
Use the graphs of f and g to graph h(x) = (f + g) (x). To print an enlarged copy of the graph, go to MathGraphs.com. 1. 2. y 24 8. 2. -2 -2 4 6
-
True or False. For a bar element of length \(l\) with two nodes, the shape function corresponding to node 2 is given by \(x / l\).
-
Derive the stiffness matrix of the tapered bar element (which deforms in the axial direction) shown in Fig. 12.13. The diameter of the bar decreases from \(D\) to \(d\) over its length. P. E D X d...
-
What is the basic idea behind the finite element method?
Study smarter with the SolutionInn App