Goya Direct Music Limited operates a mail order business offering classical music CDs to the general...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Goya Direct Music Limited operates a mail order business offering classical music CDs to the general public. The balance sheet is as follows: Current assets Cash Accounts receivable Inventory Total current assets Property, plant, and equipment Furniture and fixtures Less: Accumulated depreciation Motor vehicles Less: Accumulated depreciation Total property, plant, and equipment Total assets Current liabilities Accounts payable Accrued overhead Goya Direct Music Limited Balance Sheet As at May 31, 2010 (in $ thousands) Long-term liabilities Debentures (10%, 2015) Total liabilities Shareholders' equity Common shares Retained earnings Total shareholders' equity Total liabilities and shareholders' equity June July August September October November Sales (5) 130,000 140,000 150,000 110,000 90,000 105,000 72 (24) 46 (28) Purchases ($) 102,000 118,000 115,000 88,000 67,000 110,000 27 107 80 48 18 93 17 10 100 214 66 280 110 60 170 The following forecast information for the six months ended November 30, 2010, is available: 1. Sales and purchases for the six months ended November 30, 2010, are estimated as follows: 110 280 2. The gross profit margin on goods sold is 40%. 3. Customers are allowed one month's credit. Suppliers are paid one month after the month of purchase. 4. Salaries and wages are expected to be $30,000 each month. In addition, an annual staff bonus of $12,000 is due for payment in October 2010. All salaries and wages are paid in the month incurred. 5. Selling and administration expenses are expected to be $20,000 per month, and are payable one month after incurred. This figure includes a charge of $3,000 per month of depreciation of property, plant, and equipment. In addition to these expenses, the business is committed to a large advertising campaign. This is not due to commence until December 2010, although advance pay- ments of $60,000 must be made to newspapers and magazines in November 2010. 6. The only financing expense incurred by the business is debenture interest that is not payable until the year end. 7. $10,000 of the debenture loan will be repaid in August 2010. The business has arranged with the bank an overdraft limit of $100,000 to cover the next 12 months, which both parties agreed should not be exceeded. Ignore taxation. Required: (a) Prepare a cash budget for each of the six months to November 30, 2010. (b) Prepare a pro forma income statement for the six months ended November 30, 2010. (A monthly breakdown is not required.) (c) Discuss the problems, if any, the business is likely to face in the next six months and how these might be resolved. Goya Direct Music Limited operates a mail order business offering classical music CDs to the general public. The balance sheet is as follows: Current assets Cash Accounts receivable Inventory Total current assets Property, plant, and equipment Furniture and fixtures Less: Accumulated depreciation Motor vehicles Less: Accumulated depreciation Total property, plant, and equipment Total assets Current liabilities Accounts payable Accrued overhead Goya Direct Music Limited Balance Sheet As at May 31, 2010 (in $ thousands) Long-term liabilities Debentures (10%, 2015) Total liabilities Shareholders' equity Common shares Retained earnings Total shareholders' equity Total liabilities and shareholders' equity June July August September October November Sales (5) 130,000 140,000 150,000 110,000 90,000 105,000 72 (24) 46 (28) Purchases ($) 102,000 118,000 115,000 88,000 67,000 110,000 27 107 80 48 18 93 17 10 100 214 66 280 110 60 170 The following forecast information for the six months ended November 30, 2010, is available: 1. Sales and purchases for the six months ended November 30, 2010, are estimated as follows: 110 280 2. The gross profit margin on goods sold is 40%. 3. Customers are allowed one month's credit. Suppliers are paid one month after the month of purchase. 4. Salaries and wages are expected to be $30,000 each month. In addition, an annual staff bonus of $12,000 is due for payment in October 2010. All salaries and wages are paid in the month incurred. 5. Selling and administration expenses are expected to be $20,000 per month, and are payable one month after incurred. This figure includes a charge of $3,000 per month of depreciation of property, plant, and equipment. In addition to these expenses, the business is committed to a large advertising campaign. This is not due to commence until December 2010, although advance pay- ments of $60,000 must be made to newspapers and magazines in November 2010. 6. The only financing expense incurred by the business is debenture interest that is not payable until the year end. 7. $10,000 of the debenture loan will be repaid in August 2010. The business has arranged with the bank an overdraft limit of $100,000 to cover the next 12 months, which both parties agreed should not be exceeded. Ignore taxation. Required: (a) Prepare a cash budget for each of the six months to November 30, 2010. (b) Prepare a pro forma income statement for the six months ended November 30, 2010. (A monthly breakdown is not required.) (c) Discuss the problems, if any, the business is likely to face in the next six months and how these might be resolved.
Expert Answer:
Related Book For
Financial Management for Decision Makers
ISBN: 978-0138011604
2nd Canadian edition
Authors: Peter Atrill, Paul Hurley
Posted Date:
Students also viewed these accounting questions
-
The financial statements of Helena Beauty Products Ltd. are presented below. Required: Using six ratios, comment on the profitability (three ratios) and efficiency (three ratios) of the business as...
-
Choice Designs Ltd. operates a small group of wholesale/retail carpet stores in Alberta and British Columbia. The balance sheet is below: As a result of falling profits, the directors of the business...
-
Kwaysar Limited sells television satellite dishes Doth to retail outlets and directly to the public. The balance sheet is as follows: In the second half of the financial year ended May 31, 2010, the...
-
Based on the following definitions, which statement is NOT true? int[] 1DArray={1,2,3}; int[][] 2DArray=new int[2][]; 2DArray[0]={4,5}; 2DArray[1]={6,7,8}; public void method1(int[] 1DArray){...}...
-
Which of the other three D aldopentoses gives the same aldaric acid as D-lyxose?
-
Plot the curves of the given polar equations in polar coordinates. 3r 2r sin = 6 (ellipse)
-
Using the result of Problem 12.9, find the assembled stiffness matrix of the truss and formulate the equilibrium equations if the vertical downward load applied at node 4 is \(5 \mathrm{kN}\). Data...
-
The three accounts shown below appear in the general ledger of Cesar Corp. during 2010. InstructionsFrom the postings in the accounts, indicate how the information is reported on a statement of cash...
-
In the figure below, q = 92 = -27.0 C, and the charges are separated by d = 10.0 cm. If q is located at x = 0.00 cm, find the electric potential at the midpoint between the two charges (x = 5.00 cm)....
-
1. Alcoa was listed in Table 13-2 as a company that has a relatively high beta (a measure of stock price volatility). Alcoa produces aluminum and aluminum products. Go to its website at...
-
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the...
-
How does the new nursing shortage impact the nursing shortage? Will it help in solving the issue of nursing shortage or add to it?
-
How do cognitive biases and perceptual distortions influence the resolution of intricate disputes, and what strategies can be implemented to mitigate their impact ?
-
How can the judicious application of mediation and arbitration principles foster harmonious resolutions amidst intricate intergroup conflicts ?
-
"Share a situation (personal or business) where you had to decide on a capital budgeting matter, like buying a house or a car or an appliance. Explain how you evaluated the matter and what...
-
2. Assume that Portugal and England are each able to produce wine and wheat under the following conditions: Portugal England 1 barrel wine 20 labor hrs 1 ton wheat 30 labor hrs 40 labor hrs 30 labor...
-
Let R and S be commutative rings, and o: R S a ring homo- morphism. Let : R[X] S[X] be given by a) Show that b) Show that c) Show that n Caixi i=0 = 2 (). i=0 is a ring homomorphism. is injective...
-
Select a mass spectrometric technique with the highest mass resolution for identifying an unknown compound being eluted from a liquid chromatography column
-
Valley Forms Ltd. is considering introducing a system of EVA and wants its managers to focus on the longer term rather than simply on the year-to-year EVA results. The business is seeking your advice...
-
Cole Harbour Silver Ltd. (CHS) was formed by a hockey player to sell engraved silver teacups. CHS is capitalized by $4 million in shares and $1 million in bonds. It will use all that money to buy...
-
Why are depreciation expenses excluded from net income when preparing the cash budget?
-
True or False. The phase angle of the response depends on the system parameters \(m, c, k\), and \(\omega\).
-
True or False. The phase angle of the response depends on the amplitude of the forcing function.
-
True or False. The \(Q\)-factor can be used to estimate the damping in a system.
Study smarter with the SolutionInn App