Your assignment is prepare a Cash Budget for April, May, and June!!! FINANCIAL DATA Assets Equipment Purchases
Fantastic news! We've Found the answer you've been seeking!
Question:
Your assignment is prepare a Cash Budget for April, May, and June!!!
Transcribed Image Text:
FINANCIAL DATA Assets Equipment Purchases Cash 9,000 April $ 19,750 $ 48,000 $ 12,600 $ 200,000 Account Receivable May Inventory June Plant and Equipment (net) Budgeted Sales $ 269,000 $ 60,000 $ 70,000 $ 85,000 $ 90,000 $ 50,000 Total Assets March April Liabilities and Equity May Interest Payable June Note Payable July Accounts Payable 18,300 Share Capital $ 180,000 Minimum Cash Balance $ 8,000 Retained Earning 71,300 Sales Mix Total Liabilities and Equity $ 269,600 Cash Sales 20% Credit Sales 80% Budgeted Expenses (monthly) (Collected next month) Wages and Salaries 7,500 Freight Out (% of sales) 6% Gross Margin 40% Advertising 6,000 Amortization 2,000 Loan Interest Rate 12% Other expenses (% of sales) 4% (monthly payment) (Borrow at beginning period Repayment at end period) Inventory Paid 50% month of 50% month after Minimum Inventory Policy Dividend Paid (% of next months COGS) 30% April May June $ 4,000 Prepare a cash budget for April to June の ゅの ゆの %24 のの FINANCIAL DATA Assets Equipment Purchases Cash 9,000 April $ 19,750 $ 48,000 $ 12,600 $ 200,000 Account Receivable May Inventory June Plant and Equipment (net) Budgeted Sales $ 269,000 $ 60,000 $ 70,000 $ 85,000 $ 90,000 $ 50,000 Total Assets March April Liabilities and Equity May Interest Payable June Note Payable July Accounts Payable 18,300 Share Capital $ 180,000 Minimum Cash Balance $ 8,000 Retained Earning 71,300 Sales Mix Total Liabilities and Equity $ 269,600 Cash Sales 20% Credit Sales 80% Budgeted Expenses (monthly) (Collected next month) Wages and Salaries 7,500 Freight Out (% of sales) 6% Gross Margin 40% Advertising 6,000 Amortization 2,000 Loan Interest Rate 12% Other expenses (% of sales) 4% (monthly payment) (Borrow at beginning period Repayment at end period) Inventory Paid 50% month of 50% month after Minimum Inventory Policy Dividend Paid (% of next months COGS) 30% April May June $ 4,000 Prepare a cash budget for April to June の ゅの ゆの %24 のの
Expert Answer:
Answer rating: 100% (QA)
Given Inventory paid 50 month and 50 month after The Term is not clear henc... View the full answer
Related Book For
Fundamentals of Financial Management
ISBN: 9780273713630
13th Revised edition
Authors: James van Horne, John Wachowicz
Posted Date:
Students also viewed these accounting questions
-
Assume the following data for Animal Transport Company REFERENCE REVENUE BUDGET Requirement Prepare a cash budget for April for Animal Transport. Begin the cash budget by calculating the cash...
-
Skulas, Inc., manufactures and sells snowboards. Skulas manufactures a single model, the Pipex. In late 2017, Skulass management accountant gathered the following data to prepare budgets for January...
-
Suppose we have a new population and we are interested in two features named X1, which can take any non-negative integer value, and X2, which takes the values A, B, or C for 30%, 30%, and 40% of the...
-
Dare2Dream Donuts Inc. (D2DD) is a CCPC owned by Alec & Isla Smook. As their tax advisor, you are currently completing D2DD's corporate tax return, and have calculated taxable income as follows: $...
-
Lucy won a large sum in the lottery. She invested part of her winnings into a fund earning 6% compounded monthly. She has arranged a systematic withdrawal plan that provides for 120 monthly payments...
-
After computing the correlation coefficient r from 50 pairs of data, you find that r = 0. Does it follow that there is no relationship between the two variables? Why or why not?
-
The Tsai-Wu interaction parameter \(F_{12}\) is determined from biaxial failure stress data. One way to generate a biaxial state of stress is by using a uniaxial \(45^{\circ}\) off-axis tension test....
-
Rockford Management Services began business on January 1, 2010, with a capital investment of $120,000.The company manages condominiums for owners (Service Revenue) and rents space in its own office...
-
If you calculated the present value (PV) of $500 to be received at the end of 6 years using a required return (discount rate, interest rate) of 10% per year, compounded semiannually. you would get...
-
Consolidation related simulation example: Millennium Capital Management, Inc., (MCM) acquired a 90% interest in NextGen, Inc. MCM's Financial Manager, Matthew Steven, has prepared a draft memo to the...
-
George Walls, president of the Bradley School, is concerned about declining enrollment.Bradley School is a technical college that specializes in training computer programmers and operators.Over the...
-
Was channel stuffing the only scheme perpetrated by Bristol Myers? If the answer is no, name one other scheme.
-
Kinnunen Company wishes to give its customers three options on payments for office equipment when the initial purchase price is over a certain amount. For example, the following three payment plans...
-
What was the total amount of fines and penalties levied against Bristol Myers?
-
Which of the following is not considered a benefit of strong interviewing and interrogation skills? 1. Reduced investigation time 2. Indirect evidence of the culpability of the guilty party 3. The...
-
Which of the following is not found in a prokaryotic cell? a. Plasma membrane b. Ribosome c. Cell nucleus d. Cytoplasm
-
A student lifts a 1.44-kg book from her desk to a bookshelf. If the gravitational potential energy of the bookEarth system increases by 8.92 J, how high is the bookshelf above the desk?
-
If a and b are positive numbers, find the maximum value of f ( x ) = x a (9 x ) b on the interval 0 x 9.
-
Selena Maranjian invests the following sums of money in common stocks having expected returns as follows: a. What is the expected return (percentage) on her portfolio? b. What would be her expected...
-
If a security is undervalued in terms of the capital-asset pricing model, what will happen if investors come to recognize this undervaluation?
-
Discuss the benefits that can be derived by the firm from cash budgeting.
-
What is the relation between degrees Fahrenheit and degrees Rankine? And the relation between degrees Celsius and Kelvin?
-
State Newton's second law as you would apply it to a control mass.
-
Explain the significance of \(g_{c}\) in Newton's second law. What are the magnitude and units of \(g_{c}\) in the English Engineering system? In the SI system?
Study smarter with the SolutionInn App