Francis and Company has planned a cash budget for the third quarter of 2004. The cash...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Francis and Company has planned a cash budget for the third quarter of 2004. The cash balance on July 1, 2004 is expected to be an overdraft of $82,000. Extracts from the sales and purchases budgets are as follows: Budgeted Sales Budgeted Purchases Month May $800,000 $900,000 $750,000 $650,000 $800,000 $600,000 $550,000 $450,000 $500,000 June July August September i) All sales are on credit and an analysis of the records shows that debtors settle according to the following pattern, in accordance with the credit terms 5/30, n90: 50% in the month of sale 30% in the month following sale 20% the following month All purchases are on credit and past experience shows that 80% are settled in the month of purchase in order to take advantage of a 10% prompt settlement discount. The balance will be disbursed in the month after purchase. The credit terms of the suppliers - 10/30, n60. ii) Wages and salaries are expected to be $1,800,000 per annum and are paid monthly. ii) Fixed operating expenses, which accrue evenly throughout the year, are estimated to be $2,400,000 per annum, (including depreciation on fixed assets of $60,000 per month) and is settled monthly. iv) v) Taxation of $80,000 has to be settled in August. The company is expected to receive settlement on an insurance claim of $50,000 in September. vi) vii) Interest on investment in other companies of $25,000 is expected in July 2004. viii) A short-term investment in JMMB Ltd. of $80,000 will be liquidated in September 2004. ix) The business has made arrangements with their bankers for a loan of $250,000. The loan will be disbursed in two tranches: July 1, 2004 November 1, 2004 $150,000 $100,000 Required: Prepare a schedule of expected cash collections for sales for each of the months July to September. Prepare a schedule of expected cash disbursements for purchases for the quarter to September 30, 2004. Prepare a cash budget, with a total column, for the quarter ending September 30, 2004, showing the expected receipts and payments for each month. (a) (b) (c) Francis and Company has planned a cash budget for the third quarter of 2004. The cash balance on July 1, 2004 is expected to be an overdraft of $82,000. Extracts from the sales and purchases budgets are as follows: Budgeted Sales Budgeted Purchases Month May $800,000 $900,000 $750,000 $650,000 $800,000 $600,000 $550,000 $450,000 $500,000 June July August September i) All sales are on credit and an analysis of the records shows that debtors settle according to the following pattern, in accordance with the credit terms 5/30, n90: 50% in the month of sale 30% in the month following sale 20% the following month All purchases are on credit and past experience shows that 80% are settled in the month of purchase in order to take advantage of a 10% prompt settlement discount. The balance will be disbursed in the month after purchase. The credit terms of the suppliers - 10/30, n60. ii) Wages and salaries are expected to be $1,800,000 per annum and are paid monthly. ii) Fixed operating expenses, which accrue evenly throughout the year, are estimated to be $2,400,000 per annum, (including depreciation on fixed assets of $60,000 per month) and is settled monthly. iv) v) Taxation of $80,000 has to be settled in August. The company is expected to receive settlement on an insurance claim of $50,000 in September. vi) vii) Interest on investment in other companies of $25,000 is expected in July 2004. viii) A short-term investment in JMMB Ltd. of $80,000 will be liquidated in September 2004. ix) The business has made arrangements with their bankers for a loan of $250,000. The loan will be disbursed in two tranches: July 1, 2004 November 1, 2004 $150,000 $100,000 Required: Prepare a schedule of expected cash collections for sales for each of the months July to September. Prepare a schedule of expected cash disbursements for purchases for the quarter to September 30, 2004. Prepare a cash budget, with a total column, for the quarter ending September 30, 2004, showing the expected receipts and payments for each month. (a) (b) (c)
Expert Answer:
Answer rating: 100% (QA)
Schedule of Expected Cash Sales colleefions fan sales for Fuly fo Septem ben ononike Poon ticulen... View the full answer
Related Book For
Cost Accounting Foundations and Evolutions
ISBN: 978-1111971724
9th edition
Authors: Michael R. Kinney, Cecily A. Raiborn
Posted Date:
Students also viewed these accounting questions
-
For the third quarter of the year, Johnson Company, 415 Circle Avenue, Chicago, Illinois 60652, received Form 941 from the Internal Revenue Service. The identification number of Johnson Company is...
-
For the third quarter of the year, Barney Construction, 715 Red Rock Boulevard, San Francisco, California 94121, received Form 941 from the District Office of the Internal Revenue Service. The...
-
The following cash budget is for the third quarter of 2014. Solve for the missing numbers on the cash budget, assuming that the accountant has requested a minimum cash balance of $ 7,000 at the start...
-
For this final discussion board, please reflect back on your accounting courses and answer the following questions: 1. Which course in the accounting program did you find to be the most difficult? 2....
-
Rihanna Company is considering purchasing new equipment for $450,000. It is expected that the equipment will produce net annual cash flows of $60,000 over its 10-year useful life. Annual depreciation...
-
In each of these cases, find the percentage rate of change of the function f(t) with respect to t at the given value of t. a. f(t) = t 2 (3 2t) 3 at t = 1 b. f(t) || 1 - t + 1 at t = 0
-
An incompressible fluid oscillates harmonically \(\left(V=V_{0} ight.\) \(\sin \omega t\), where \(V\) is the velocity) with a frequency of \(10 \mathrm{rad} / \mathrm{s}\) in a 4-in.-diameter pipe....
-
Day, Corp., is considering the use of activity-based costing. The following information is provided for the production of two product lines: Day plans to produce 400 units of Product A and 375 units...
-
1-Define electric fields and how it helps us understand electricity. 2-Electric fields are represented as a physical effect of a configuration of charges that is created by the attraction of electric...
-
Problem #12: Planning and Control Don't-Cha-Wanna-a-Coffee, a large-scale coffee company that has a chain of 125 retail coffee stores throughout New England, was embroiled in an ethics scandal 3...
-
2) A 78.650 (kg) women is setting inside an airplane that moves 3160 (km) above the sea-level, Determine the weight of the women at this height?
-
Why have behavioural public policy-makers not progressed far in applying some of the microeconomic behavioural principles explored so far in this book to the design of behavioural macroeconomic and...
-
Describe branding. What are the guidelines for developing an effective brand name? Why is brand loyalty such an important concept for sports marketers to understand?
-
What impact has access to the internet on smartphones had on the price elasticity of demand for items from Best Buy or Barnes and Noble? What are some strategies these companies could take to combat...
-
Provide examples of individual athletes, teams, and sports (leagues) that have had to develop repositioning strategies.
-
Provide some examples of goods or services that you purchase that have relatively inelastic demand. How would you respond to a 10% increase in price? Are there any goods that you would consider...
-
In the 'Future Of Real-Time Information' slide presentation, 11 trends are identified. In your opinion, which of those are short-term, or already realized in developed countries, and which of those...
-
What is your assessment of the negotiations process, given what you have studied? What are your recommendations for Mr. Reed? You must justify your conclusions
-
Assume that Pedraza Corp. in Exercise 24 had 7,200 EUP for direct material in Octobers beginning WIP Inventory, 8,000 EUP for direct labor, and 7,920 EUP for overhead. What was the October FIFO cost...
-
Montana Metal Works has two departments: Fabrication and Finishing. Three workers oversee the 25 machines in Fabrication. Finishing uses 35 crafters to hand-polish output, which is then run through...
-
You are a managing partner for a 50-person CPA firm. What important detail items would you want to review in making a budget and year-end analysis in each of the following areas? a. Human resources...
-
Birth weights in the United States are normally distributed with a mean (in grams) of 3420 g and a standard deviation of 495 g. If you graph this normal distribution, the area to the right of 4000 g...
-
Is the distribution of those digits a normal distribution? Why or why not?
-
Many states have lotteries that involve the random selection of digits 0, 1, 2, ,
Study smarter with the SolutionInn App