Prepare a balance sheet as of June 30. n a. As of March 31 (the end of
Fantastic news! We've Found the answer you've been seeking!
Question:
Prepare a balance sheet as of June 30.
n
Transcribed Image Text:
a. As of March 31 (the end of the prior quarter), the company's balance sheet showed the following account balances: Current quarter to be analyzed is 2nd Quarter (Apr. thru June) $ 6,700 36,900 11,130 120,000 Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable $ 32,880 Common stock 100,000 Retained earnings 41,850 $174,730 $174,730 Actual and budgeted sales are as follows: March (actual) April May $61,500 $79,500 $88,800 $89,400 $58,100 June July c. Sales are 40% for cash and 60% on credit. All payments on credit sales are collected in the month following the sale. The accounts receivable at March 31 are a result of March credit sales. d. The company's gross margin percentage is 30% of sales. (In other words, COGS is 70% of sales.) e. Each month's ending inventory should equal 20% of the following month's budgeted cost of goods sold. f. One-quarter of a month's inventory purchases is paid for in the month of purchase; the other three- quarters are paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. g. Monthly expenses are as follows: commissions, $12,150; rent, $2,650; other expenses (excluding depreciation), 8% of sales. Assume that these expenses are paid monthly. Depreciation is $2,550 for the quarter and includes depreciation on new assets acquired during the quarter. h. Equipment will be acquired for cash: $3,830 in April and $8,100 in May. i. Management would like to maintain a minimum cash balance of $5,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month (if needed to maintain the $5,000 cash balance), The company can borrow up to a total loan balance of $50,000. The interest rate on these loans is 1% per month, and for simplicity, we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. b. a. As of March 31 (the end of the prior quarter), the company's balance sheet showed the following account balances: Current quarter to be analyzed is 2nd Quarter (Apr. thru June) $ 6,700 36,900 11,130 120,000 Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable $ 32,880 Common stock 100,000 Retained earnings 41,850 $174,730 $174,730 Actual and budgeted sales are as follows: March (actual) April May $61,500 $79,500 $88,800 $89,400 $58,100 June July c. Sales are 40% for cash and 60% on credit. All payments on credit sales are collected in the month following the sale. The accounts receivable at March 31 are a result of March credit sales. d. The company's gross margin percentage is 30% of sales. (In other words, COGS is 70% of sales.) e. Each month's ending inventory should equal 20% of the following month's budgeted cost of goods sold. f. One-quarter of a month's inventory purchases is paid for in the month of purchase; the other three- quarters are paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. g. Monthly expenses are as follows: commissions, $12,150; rent, $2,650; other expenses (excluding depreciation), 8% of sales. Assume that these expenses are paid monthly. Depreciation is $2,550 for the quarter and includes depreciation on new assets acquired during the quarter. h. Equipment will be acquired for cash: $3,830 in April and $8,100 in May. i. Management would like to maintain a minimum cash balance of $5,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month (if needed to maintain the $5,000 cash balance), The company can borrow up to a total loan balance of $50,000. The interest rate on these loans is 1% per month, and for simplicity, we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. b.
Expert Answer:
Related Book For
Accounting Texts and Cases
ISBN: 978-1259097126
13th edition
Authors: Robert Anthony, David Hawkins, Kenneth Merchant
Posted Date:
Students also viewed these accounting questions
-
A classified balance sheet showed the following amounts: cash $5,000; short-term investments $2,000; equity investment $3,000; accounts receivable $3,000; prepaid expenses $1,000; and goodwill...
-
The regression model to be analyzed is y = X11 + X22 + , where X1 and X2 have K1 and K2 columns, respectively. The restriction is 2 = 0. a. Using (6-14), prove that the restricted estimator is simply...
-
The regression model to be analyzed is y = X 1 1 + X 2 2 + , where X 1 and X 2 have K 1 and K 2 columns, respectively. The restriction is 2 = 0. a. Using (5-23), prove that the restricted...
-
To the right is the graph of the position of the object versus time: Which of graphs below correctly shows the object's velocity versus time? velocity (m/s) velocity (m/s) 1.5 1 0.5 -0.5 -1 -1.5 15...
-
Foreign aid, if it is to be successful in enhancing economic development, must lead to a more productive economy. Describe some of the problems in achieving such an objective through foreign aid.
-
Use the methods of descriptive statistics to summarize the data in Table 3.11. Discuss your findings. 1. Include a summary for each variable in the data set. Make comments and interpretations based...
-
Robert Shapiro was the owner and CEO of Woodbridge, a supposed investment firm. Woodbridges main business model was to solicit money from individuals to invest in low-risk and conservative...
-
Braun Company produces its product through a single processing department. Direct materials are added at the beginning of the process. Direct labor and overhead are added to the product evenly...
-
Differentiate entity wide controls from transaction controls. Identify at least 3 types of entity wide controls and 3 types of transaction controls. Then, provide an example for each type of control...
-
Futoshiki is a Sudoku-like Japanese logic puzzle that is very simple, but can be quite challenging. You are given an n x n grid, and must place the numbers 1, . . . n in the grid such that every row...
-
Design a 4-bit adder-subtractor circuit using the 4-bit binaryFull adders (74LS83) and any necessary additional logic gates. Thecircuit has a mode input bit, M, that controls its...
-
For each of the following, compute the present value. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Present Value Years Interest Rate Future value...
-
Epstein's creditors are threatening to garnish his bank account. Epstein, who is insolvent, makes a gift of $20,000 to the Jewish Community Federation of Richmond. Within two years, Epstein files for...
-
Describe the features of an asset and give two examples of assets typically recorded in a company's balance sheet.
-
Explore the principles of deadlock detection and avoidance in operating systems, discussing the various deadlock resolution strategies, such as resource preemption, process rollback, and deadlock...
-
Emerald City Stained Glass Company is creating their Selling and Administrative Expense Budget for next year. They know the following information: Budgeted sales are expected to be 10,000 units,...
-
Please answer all parts of the question. It is the second timeposting this question. The following is a partial trial balance for General Lighting Corporation as of December 31, 2021: There were...
-
What is a content filter? Where is it placed in the network to gain the best result for the organization?
-
The Bradley Company has just completed its first year of operations. A condensed income statement follows, showing actual and standard amounts and the variances: Required: The president of Bradley...
-
What are some of the exceptions to the historical cost concept that generally accepted accounting principles require or allow?
-
Mr. and Mrs. Ilyong Kim had purchased the Pinetree Motel in 1998 with their life savings, supplemented by a loan from a close personal friend. The motel consisted of 20 units (i.e., rentable rooms)...
-
Suppose you operate a bank in a country where the central bank is expected to embark on a series of interest rate increases. Based on gap analysis, would this scenario be more likely to hurt or help...
-
Cyber risk has been recognized as a growing source of operational risk for financial institutions. Why might managing this risk at an individual firm level not be adequate?
-
Bank assets equal bank liabilities plus bank capital. a. Bank assets are the uses for bank funds. i. They include reserves, securities, and loans. ii. Over the years, commercial and industrial loans...
Study smarter with the SolutionInn App