Great Adventures Company, Inc., specializes in supplies, gears and equipment for sports and outdoor adventures. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Great Adventures Company, Inc., specializes in supplies, gears and equipment for sports and outdoor adventures. The products it sells range from tennis balls, gloves to skiing gears, and off-road motorcycles. The company purchases its products from manufactures worldwide and sells them to a large network of independent retail shops and dealers in North America. Business is booming as the population becomes more health-conscious and more people participate in sports and outdoor adventures. In addition to its main business, the company is planning to diversify its business into running ski resorts and out-door parks. The company's stock is actively traded on the New York Stock Exchange. At the end of the first quarter of the year 2022, the company's CFO is in the process of preparing financial statements for filing with the SEC and reporting to shareholders at the coming stockholder's conference late April. The CFO has obtained summarized information on the company's business activities from the controller's office. The CFO asks for your assistance to analyze the information and come up with a draft of quarterly financial statements with a brief analysis. Summary of Business Activities in the First Quarter 2022 All dollar amounts are in thousands (000) except the per-share values. 1. To finance business expansion, the company signed an agreement with a national bank in December 2021 to obtain a $30,000 three-year loan. The amount was deposited into the company's bank account on January 1, 2022. The interest on the loan is due semiannually and carries a 12% annual interest rate. 2. On January 20, Great Adventures reached an agreement to purchase a large plot of land in a mountainous area in Vermont as the site for the future ski resort. In this share-based transaction, the company agreed to issue 500,000 shares of its common stock as a way of payment. The common stock has a $1 par value per share. The transaction was closed on March 1 when stocks were trading at $23 per share. 3. On February 1, the company issued five million shares of its common stock through an investment banker on Wall Street and received $95,760 in cash proceeds. 4. In January, the company received $45,000 in cash from customers who bought merchandizes last year. The remaining $30,000 was received in February. 5. On January 28, the company paid its suppliers for a total of $29,630 in cash through its bank for the purchases made last year. 6. On February 1, the company signed an agreement with a national TV station to run the company's infomercial between 11:00 am - 12:00 pm each day for three months and paid a total cost of $1,660. 7. On February 15, the company closed a deal to purchase a new warehouse building in a suburban area outside Boston for $8,800 in cash. The warehouse was placed in use immediately. 8. On February 28, the company closed a deal to sell an office building for $4,580 in cash at a significant gain of $2,115. The building was temporarily rented to another company before it was sold. The building was purchase in 1980 for a total cost of $5,675. 9. On February 28, the company paid its suppliers for the remaining unpaid purchases made last year. 10. On March 1, the company paid the employer's portion of health insurance premium to the insurance provider. The total amount paid was $12,435 which would cover a period of 12 months. The remainder of the premium was paid by the employees through salaries withholding, according to the employment contract. 11. On March 1, the company purchased 300,000 shares of its own common stock at $24 per share. These shares were needed to issue to top executives for their employee stock option plan. 12. On March 30, the company declared and paid a quarterly cash dividend of $0.20 for shares outstanding on March 28. 13. Company's total sales for the quarter are listed below. All sales were credit sales. Total Net Sales Revenue $ 148,000 168,000 199,000 $ 515,000 The amount was net of sales return and sales discount. January February March Total 14. The collection for sales was as follows: January sales were received in full by the end of March. The total amount received for February and March sales was $138,000 and $106,000, respectively. 15. Company's total salary and other operating expenses each month were as follows: Other Operating Expenses $ 5,630 January February March (First 3 weeks) Total Salary & Payroll Tax Expenses $ 26,410 January February 28,230 21.620 $ 76,260 Salaries were paid in the form of direct deposits to employees' bank accounts biweekly; the employees' portion of health insurance premium was withheld from salaries and paid to the insurance provider at the same time when salaries were paid; the estimated personal income taxes were withheld and paid to the government agencies before the end of each month. Employer's payroll taxes which included the unemployment tax and social security tax were remitted to the government agencies immediately as they were recorded. Other operating expenses which included utility, property taxes, freight-out, and other miscellaneous expenses were all paid in cash via online banking. 16. Company's merchandize purchases were as follows: Total Merchandise Purchase Costs March Total 6,430 4,460 $ 16,520 $ 106,000 108,000 121.000 $ 335,000 The company's purchase agreement specifies that the suppliers ship merchandizes and send invoices, and the company inspects merchandizes after receiving them and pay the invoices after inspection. The purchase amount listed included purchase price, tax, tariff, shipping, and insurance, net of purchase returns and discounts. 17. Payment for purchases were as follows: January purchases were fully paid by the end of March. The amount paid for February and March purchases was $99,000 and $87,000, respectively. The remaining unpaid purchases would be paid in the future months in April and May. 18. Company paid in cash for the interest on the 2-year commercial note for the current quarter as well as the amount owed from last year. The note is not due until June 30, 2023. 19. The CFO also identified the following areas that need to be adjusted: A. Employee salary for the 4th week in March totaled $6,500 and will be paid biweekly on April 5 through direct deposit. B. Goods ordered by customers in the past year but not delivered were all delivered on time in January. However, the delivery of goods to some customers in the northeast region of the U.S. for sales made in March was delayed because of an unexpected snowstorm. As a result, sales totaled $57,000 were not delivered and the merchandize remained in the company's warehouse. C. The depreciation for equipment and buildings totaled $6,800 for the quarter. D. The cost for the three-month informercial paid on February 1 requires a proper adjustment. E. Health insurance premium for January and February, totaled $2,300, was prepaid last year. The health insurance premium paid on March 1 covers a period of 12 months. Proper adjustments are required. F. Interest expense on the new 3-year 12% loan borrowed in January needs to be recognized although not yet paid. G. Company's inventory system shows the total costs of inventory on hand at the end of the quarter, based on LIFO, totaled $145,000. The number has been confirmed by a companywide inventory count completed at the end of March. H. Company's income tax rate is 28%. Current assets: Cash Balance Sheet for Great Adventures at 12/31/2021 Great Adventures, Inc. Assets Accounts Receivable - Net Merchandise Inventory Prepayments Total current assets Total assets Long-term assets: Land Buildings Equipment Accumulated Depreciation. Total Long-term asset Balance Sheet (In USD 1,000) December 31, 2021 $138,800 $75,000 $111,836 $2,300 $327.936 $34,290 $85,000 $56,650 ($25,225) $150.715 $478,651 Liabilities Current liabilities: Accounts payable Interest payable Unearned Revenues Income tax payable Total current liabilities Notes payable (2 year, 9%) Total Long-term Liabilities Stockholders' Equity Common stock ($1 Par) Additional Paid-in Capital Retained earnings Total stockholders' equity Liabilities & stockholders' equity $39,630 $1,750 $38,846 $48,680 $128.906 $25,000 $25,000 $20,000 $157,965 $146,780 $324.745 $478,651 Required: With the CFO's help, you developed the following work plan for the project: Set up T-accounts with proper account titles and beginning balances. Analyze each of the summary transitions 1-18, determine the proper journal entries and record the journal entries in the general journal. Post journal entries to T-accounts. 1. 2. 3. 4. 5. Analyze adjustments in item 19 and determine proper adjusting entries. Record the adjusting entries in the general journal. Post adjusting entries to T-accounts and prepare an adjusted trial balance. Correct mistakes before continuing to the next step if your accounts are out of balance. 7. Prepare classified Income Statement and then classified Balance Sheet. Prepare the Statement of Stockholder's Equity. Pay attention to proper titles, dates, and formats. Prepare Statement of Cash Flows using direct and indirect methods. Significant non-cash transactions must be disclosed in the footnote. 9. 10. Prepare an unadjusted trial balance. Correct mistakes before continuing to the next step if your accounts are out of balance. Prepare and post the closing entries to T-accounts. Compute EPS, ROA, ROE, Average Collection Period, Inventory Turnover, PE ratio, and Free-Cash Flow. Give comments on these ratios. 11. Submit a report with your name and UID. Please include the following in your reports: a. Balance Sheet, Income Statement, Statement of Owner's Equity, and Statement of Cash Flows. b. Financial ratios you computed in requirement 10 with your analysis. c. General Journal with all journal entries including the adjusting entries. d. Adjusted and unadjusted trial balances. Hints: 1. Do not keep decimals, round all number to thousand. 2. Record salary, payroll taxes, insurance, infomercial, and other expense as Operating Expenses. Keep Depreciation Expenses and Interest Expenses in separate accounts. This helps reducing the number of T-accounts. 3. Assume the tax rate is also 28% for the gains on sale of long-term assets. Great Adventures Company, Inc., specializes in supplies, gears and equipment for sports and outdoor adventures. The products it sells range from tennis balls, gloves to skiing gears, and off-road motorcycles. The company purchases its products from manufactures worldwide and sells them to a large network of independent retail shops and dealers in North America. Business is booming as the population becomes more health-conscious and more people participate in sports and outdoor adventures. In addition to its main business, the company is planning to diversify its business into running ski resorts and out-door parks. The company's stock is actively traded on the New York Stock Exchange. At the end of the first quarter of the year 2022, the company's CFO is in the process of preparing financial statements for filing with the SEC and reporting to shareholders at the coming stockholder's conference late April. The CFO has obtained summarized information on the company's business activities from the controller's office. The CFO asks for your assistance to analyze the information and come up with a draft of quarterly financial statements with a brief analysis. Summary of Business Activities in the First Quarter 2022 All dollar amounts are in thousands (000) except the per-share values. 1. To finance business expansion, the company signed an agreement with a national bank in December 2021 to obtain a $30,000 three-year loan. The amount was deposited into the company's bank account on January 1, 2022. The interest on the loan is due semiannually and carries a 12% annual interest rate. 2. On January 20, Great Adventures reached an agreement to purchase a large plot of land in a mountainous area in Vermont as the site for the future ski resort. In this share-based transaction, the company agreed to issue 500,000 shares of its common stock as a way of payment. The common stock has a $1 par value per share. The transaction was closed on March 1 when stocks were trading at $23 per share. 3. On February 1, the company issued five million shares of its common stock through an investment banker on Wall Street and received $95,760 in cash proceeds. 4. In January, the company received $45,000 in cash from customers who bought merchandizes last year. The remaining $30,000 was received in February. 5. On January 28, the company paid its suppliers for a total of $29,630 in cash through its bank for the purchases made last year. 6. On February 1, the company signed an agreement with a national TV station to run the company's infomercial between 11:00 am - 12:00 pm each day for three months and paid a total cost of $1,660. 7. On February 15, the company closed a deal to purchase a new warehouse building in a suburban area outside Boston for $8,800 in cash. The warehouse was placed in use immediately. 8. On February 28, the company closed a deal to sell an office building for $4,580 in cash at a significant gain of $2,115. The building was temporarily rented to another company before it was sold. The building was purchase in 1980 for a total cost of $5,675. 9. On February 28, the company paid its suppliers for the remaining unpaid purchases made last year. 10. On March 1, the company paid the employer's portion of health insurance premium to the insurance provider. The total amount paid was $12,435 which would cover a period of 12 months. The remainder of the premium was paid by the employees through salaries withholding, according to the employment contract. 11. On March 1, the company purchased 300,000 shares of its own common stock at $24 per share. These shares were needed to issue to top executives for their employee stock option plan. 12. On March 30, the company declared and paid a quarterly cash dividend of $0.20 for shares outstanding on March 28. 13. Company's total sales for the quarter are listed below. All sales were credit sales. Total Net Sales Revenue $ 148,000 168,000 199,000 $ 515,000 The amount was net of sales return and sales discount. January February March Total 14. The collection for sales was as follows: January sales were received in full by the end of March. The total amount received for February and March sales was $138,000 and $106,000, respectively. 15. Company's total salary and other operating expenses each month were as follows: Other Operating Expenses $ 5,630 January February March (First 3 weeks) Total Salary & Payroll Tax Expenses $ 26,410 January February 28,230 21.620 $ 76,260 Salaries were paid in the form of direct deposits to employees' bank accounts biweekly; the employees' portion of health insurance premium was withheld from salaries and paid to the insurance provider at the same time when salaries were paid; the estimated personal income taxes were withheld and paid to the government agencies before the end of each month. Employer's payroll taxes which included the unemployment tax and social security tax were remitted to the government agencies immediately as they were recorded. Other operating expenses which included utility, property taxes, freight-out, and other miscellaneous expenses were all paid in cash via online banking. 16. Company's merchandize purchases were as follows: Total Merchandise Purchase Costs March Total 6,430 4,460 $ 16,520 $ 106,000 108,000 121.000 $ 335,000 The company's purchase agreement specifies that the suppliers ship merchandizes and send invoices, and the company inspects merchandizes after receiving them and pay the invoices after inspection. The purchase amount listed included purchase price, tax, tariff, shipping, and insurance, net of purchase returns and discounts. 17. Payment for purchases were as follows: January purchases were fully paid by the end of March. The amount paid for February and March purchases was $99,000 and $87,000, respectively. The remaining unpaid purchases would be paid in the future months in April and May. 18. Company paid in cash for the interest on the 2-year commercial note for the current quarter as well as the amount owed from last year. The note is not due until June 30, 2023. 19. The CFO also identified the following areas that need to be adjusted: A. Employee salary for the 4th week in March totaled $6,500 and will be paid biweekly on April 5 through direct deposit. B. Goods ordered by customers in the past year but not delivered were all delivered on time in January. However, the delivery of goods to some customers in the northeast region of the U.S. for sales made in March was delayed because of an unexpected snowstorm. As a result, sales totaled $57,000 were not delivered and the merchandize remained in the company's warehouse. C. The depreciation for equipment and buildings totaled $6,800 for the quarter. D. The cost for the three-month informercial paid on February 1 requires a proper adjustment. E. Health insurance premium for January and February, totaled $2,300, was prepaid last year. The health insurance premium paid on March 1 covers a period of 12 months. Proper adjustments are required. F. Interest expense on the new 3-year 12% loan borrowed in January needs to be recognized although not yet paid. G. Company's inventory system shows the total costs of inventory on hand at the end of the quarter, based on LIFO, totaled $145,000. The number has been confirmed by a companywide inventory count completed at the end of March. H. Company's income tax rate is 28%. Current assets: Cash Balance Sheet for Great Adventures at 12/31/2021 Great Adventures, Inc. Assets Accounts Receivable - Net Merchandise Inventory Prepayments Total current assets Total assets Long-term assets: Land Buildings Equipment Accumulated Depreciation. Total Long-term asset Balance Sheet (In USD 1,000) December 31, 2021 $138,800 $75,000 $111,836 $2,300 $327.936 $34,290 $85,000 $56,650 ($25,225) $150.715 $478,651 Liabilities Current liabilities: Accounts payable Interest payable Unearned Revenues Income tax payable Total current liabilities Notes payable (2 year, 9%) Total Long-term Liabilities Stockholders' Equity Common stock ($1 Par) Additional Paid-in Capital Retained earnings Total stockholders' equity Liabilities & stockholders' equity $39,630 $1,750 $38,846 $48,680 $128.906 $25,000 $25,000 $20,000 $157,965 $146,780 $324.745 $478,651 Required: With the CFO's help, you developed the following work plan for the project: Set up T-accounts with proper account titles and beginning balances. Analyze each of the summary transitions 1-18, determine the proper journal entries and record the journal entries in the general journal. Post journal entries to T-accounts. 1. 2. 3. 4. 5. Analyze adjustments in item 19 and determine proper adjusting entries. Record the adjusting entries in the general journal. Post adjusting entries to T-accounts and prepare an adjusted trial balance. Correct mistakes before continuing to the next step if your accounts are out of balance. 7. Prepare classified Income Statement and then classified Balance Sheet. Prepare the Statement of Stockholder's Equity. Pay attention to proper titles, dates, and formats. Prepare Statement of Cash Flows using direct and indirect methods. Significant non-cash transactions must be disclosed in the footnote. 9. 10. Prepare an unadjusted trial balance. Correct mistakes before continuing to the next step if your accounts are out of balance. Prepare and post the closing entries to T-accounts. Compute EPS, ROA, ROE, Average Collection Period, Inventory Turnover, PE ratio, and Free-Cash Flow. Give comments on these ratios. 11. Submit a report with your name and UID. Please include the following in your reports: a. Balance Sheet, Income Statement, Statement of Owner's Equity, and Statement of Cash Flows. b. Financial ratios you computed in requirement 10 with your analysis. c. General Journal with all journal entries including the adjusting entries. d. Adjusted and unadjusted trial balances. Hints: 1. Do not keep decimals, round all number to thousand. 2. Record salary, payroll taxes, insurance, infomercial, and other expense as Operating Expenses. Keep Depreciation Expenses and Interest Expenses in separate accounts. This helps reducing the number of T-accounts. 3. Assume the tax rate is also 28% for the gains on sale of long-term assets.
Expert Answer:
Answer rating: 100% (QA)
Great Adventures Inc General Journal in USD 1000 March 31 2022 Date Description Debit Credit 1 01012022 Cash 30000 Bank Loan Payable 30000 2 20012022 Land 11500 Common stock 500 Stock premium 11000 3 ... View the full answer
Related Book For
Financial and Managerial Accounting Using Excel for Success
ISBN: 978-1111993979
1st edition
Authors: James Reeve, Carl S. Warren, Jonathan Duchac
Posted Date:
Students also viewed these accounting questions
-
At the end of the first quarter of Year 2, McKinney & Co. reevaluates its receivables. McKinney & Co.s management decides that $8,500 due from Mangold Corporation will not be collectible. This amount...
-
At the end of its first quarter in the 2018 fiscal year, Brandon Corporation had an undrawn line of credit facility that allowed the company to borrow up to $16 million and pay it down whenever it...
-
At the end of the first quarter of 201X, you are asked to determine the FUTA tax liability for Carter Company. The FUTA tax rate is 0.8% on the first $7,000 each employee earns during the year...
-
The following table includes transactions carried out by Ram Horn Corporation, as well as columns for each of the three categories found in the statement of cash flows: operating, financing, and...
-
A monopolist operates in an industry where the demand curve is given by Q = 1000 - 20P. The monopolist's constant marginal cost is $8. What is the monopolist's profit-maximizing price?
-
Marida Products, Inc., produces plastic cases used for video cameras. The product passes through three departments. For April, the following equivalent units schedule was prepared for the first...
-
Use stepwise regression with \(F_{\mathrm{IN}}=F_{\text {OUT }}=4.0\) to find the "best" set of regressor variables for the Belle Ayr liquefaction data in Table B.5. Repeat the analysis with...
-
Here is a CPM network with activity times in weeks: a. Determine the critical path. b. How many weeks will the project take to complete? c. Suppose F could be shortened by two weeks and B by one...
-
ABC limited. has a 6% coupon bonds that has maturity in 11 years. The bond pays interest semi-annually. What is the market price of a $1,000 face value bond if the yield to maturity is 12.9%?
-
Mr. Urgent is the Chief Executive Officer (CEO) of one of the stable companies. He is very passionate about corporate valuation and growth. As a mean to enhance the value of the firm he advised to...
-
Resource: https://revcycleintelligence.com/news/congress-to-halve-medicare-payment-cuts-via-year-end-spending-package Read the article Medicare Payment Cuts (article link above) and respond to the...
-
Tesco is a leading global retail operation and is Britains leading food retail group. Tesco has a substantial European and international network of retailer operations and has recently begun selling...
-
Summarise the role of strategy tools and models in formulating a companys strategic approach to the Internet.
-
Explain the significance of the diffusionadoption concept to the adoption of new technologies to: a consumers purchasing using technological innovations; b businesses deploying technological...
-
What does a company need in order to be able to state clearly in the mission statement its strategic position relative to the Internet?
-
Suggest approaches to managing the rapid change of technological innovation.
-
use the venn diagram Image transcription text Learning Task 4: Compare and contrast financial instrument, financial institution and financial market. Financial Instrument Financial Market Financial...
-
Suppose that you could invest in the following projects but have only $30,000 to invest. How would you make your decision and which projects would you invest in? Project Cost $ 8,000 11,000 9,000...
-
Crane Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows: a....
-
Several items are omitted from each of the following income statement and cost of goods manufactured statement data for the month of December 2012: 1. Determine the amounts of the missing items,...
-
The manufacturing costs of Greenburg Enterprises for the first three months of the year are provided below. Using the high-low method, determine (a) The variable cost per unit (b) The total fixed...
-
Verify that the log-likelihood of model (7.7) is \(\sum_{i=1}^{k}\left[n_{i} \lambda-\exp (\lambda) ight]\). (a) Compute MLE of \(\lambda\). (b) Compute the Pearson chi-square statistic and compare...
-
Think about the general concept of a relationship, not necessarily in a business setting, but just relationships in general between any two parties. What aspects of relationships are inherently...
-
What is value? In what ways does a relationship selling approach add value to your customers, to you the salesperson, and to your sales organization?
Study smarter with the SolutionInn App