Mahendra Toys is a wholesale distributor of gifts and accessories. The following data relates to their...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Mahendra Toys is a wholesale distributor of gifts and accessories. The following data relates to their balance sheet as of 31 December 2019. Current Assets Cash Accounts Receivable Inventory Building and equipment, Net* Total Assets Current Liabilities Accounts Payable Common Shares $ 8,000 $ 42,000 $ 10,200 $136,000 $196,200 $ 30,200 $120,000 Retained Earnings Total Liabilities & Owner's Equity a. The gross margin for the company is 40% of sales. b. Actual and budgeted sales data are as follows- December (Actual) January February March April $80,000 $58,000 $88,000 $63,000 $70,000 $ 46,000 $196,200 c. Sales are 30% in cash and 70% in credit. Credit sales are collected in the month following the sale. d. Each month's ending inventory should be 25% of the following month's budgeted cost of goods sold. e. 30% of the month's inventory purchases are paid for in the month of purchase; the remaining 70% is paid for in the following month. f. Monthly expenses are as follows: salaries, $10,000; rent, $6,000; advertisements, $2,000; other expenses (excluding depreciation), 12% of sales. Depreciation is $3,200 for the quarter and includes depreciation on new assets acquired during the quarter. g. Equipment will be acquired for cash: $4,000 in January and $6,000 in March. h. Management would like to maintain a minimum cash balance of $6,000 at the end of each month. Assume the company can borrow at 0% interest and they do not pay any income tax. All borrowing occurs at the beginning of a month. The company will, as far as it is able, repay outstanding loans at the end of each month Question 1: Prepare the following budgets for each of the first three months of 2020. [20 Marks] Schedule of Expected Cash Collection Merchandise Purchase Budget Schedule of Cash Disbursement for Purchase Schedule of Cash Disbursement for S & A expenses Cash Budget Question 2: Prepare a budgeted income statement for the first three months of 2020 and a budgeted balance sheet as of March 31, 2020 [ 10 Marks] Mahendra Toys is a wholesale distributor of gifts and accessories. The following data relates to their balance sheet as of 31 December 2019. Current Assets Cash Accounts Receivable Inventory Building and equipment, Net* Total Assets Current Liabilities Accounts Payable Common Shares $ 8,000 $ 42,000 $ 10,200 $136,000 $196,200 $ 30,200 $120,000 Retained Earnings Total Liabilities & Owner's Equity a. The gross margin for the company is 40% of sales. b. Actual and budgeted sales data are as follows- December (Actual) January February March April $80,000 $58,000 $88,000 $63,000 $70,000 $ 46,000 $196,200 c. Sales are 30% in cash and 70% in credit. Credit sales are collected in the month following the sale. d. Each month's ending inventory should be 25% of the following month's budgeted cost of goods sold. e. 30% of the month's inventory purchases are paid for in the month of purchase; the remaining 70% is paid for in the following month. f. Monthly expenses are as follows: salaries, $10,000; rent, $6,000; advertisements, $2,000; other expenses (excluding depreciation), 12% of sales. Depreciation is $3,200 for the quarter and includes depreciation on new assets acquired during the quarter. g. Equipment will be acquired for cash: $4,000 in January and $6,000 in March. h. Management would like to maintain a minimum cash balance of $6,000 at the end of each month. Assume the company can borrow at 0% interest and they do not pay any income tax. All borrowing occurs at the beginning of a month. The company will, as far as it is able, repay outstanding loans at the end of each month Question 1: Prepare the following budgets for each of the first three months of 2020. [20 Marks] Schedule of Expected Cash Collection Merchandise Purchase Budget Schedule of Cash Disbursement for Purchase Schedule of Cash Disbursement for S & A expenses Cash Budget Question 2: Prepare a budgeted income statement for the first three months of 2020 and a budgeted balance sheet as of March 31, 2020 [ 10 Marks]
Expert Answer:
Related Book For
Financial Accounting
ISBN: 978-0078025549
3rd edition
Authors: J. David Spiceland, Wayne Thomas, Don Herrmann
Posted Date:
Students also viewed these accounting questions
-
Historical overview of financial markets and their implications for personal investment and references
-
CP.02.02_Step 7_Entries_SJ 7. Journalize the closing entries. After you have completed this step, print out the problem and your answer to use in the next step. Although you will complete the actual...
-
Assume that adults have IQ scores that are normally distributed with a mean of 102.6 and a standard deviation of 17.8. Find the probability that a randomly selected adult has an IQ greater than...
-
An analysis of spending by a sample of credit card bank cardholders shows that spending by cardholders in January (Jan) is related to their spending in December ( Dec): The assumptions and conditions...
-
Insurance agents are intermediaries who help other members of the channel by providing information and handling the selling function. Does it make sense for an insurance agent to specialize and work...
-
(a) Where is the limbic system located? (b) Which structures make up this system? (c) How is the limbic system important in behavior?
-
One of the first U.S. major industries to be regulated was the railroads. Farmers and manufacturers depended on railroads to get their products to market, and often there was only one railroad...
-
The wedding date for a couple is quickly approaching, and the wedding planner must provide the caterer an estimate of how many people will attend the reception so that the appropriate quantity of...
-
Given h(x) = f(g(x)) At x = 4, the equation of the tangent line of f is -5x + y = = 25. At x = 4, the equation of the tangent line of g is y - 4 = -8(x-4). Determine h' (4) h'(4) =
-
(b) Three forces, A, B, and C are drawn to scale of 1 square = 20 N. Find the magnitude and direction of each. -8 -6 -4 -2 Ly Force A Find the magnitude and direction of A. A = OA= measured from the...
-
What is meant by an intelligent consumer of accounting information?
-
Intermediate feeds should not be introduced into a downcomer. Explain why.
-
Which of the following is not shown on the statement of stockholders' equity? a. Contributed capital b. Retained earnings c. Common stock d. Total liabilities
-
What external objectives does cost accounting serve? What internal objectives?
-
Beer stills are distillation columns that process the raw feed from fermentation. This feed includes cells and cell debris in addition to ethanol and water. Why are sieve plates with...
-
The relationship between a tick feeding on a cat is considered
-
The manager of a local convenience store is expanding his line of small toy items. To price these new items, the manager is looking at the prices being charged by competing retailers in his area. For...
-
What is empowerment?
-
What is organizational politics?
-
____________ is the ability to control anothers behavior because, through the individuals efforts, the person accepts the desirability of an offered goal and a reasonable way of achieving it. (a)...
Study smarter with the SolutionInn App