1. Perform preliminary analytical procedures on the financial statements. a. Perform horizontal (year-to-year changes) and vertical...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Perform preliminary analytical procedures on the financial statements. a. Perform horizontal (year-to-year changes) and vertical (common size financial statements) analyses using the provided trial balances. b. Calculate appropriate financial ratios. Assume the market value of the common stock is $24 million in both the current and prior years. (10 points) 2. Write a memo (labeled GA-4) highlighting what you believe are potential problem areas. In other words, are there any significant changes from year-to-year that we might need to investigate further, or does anything jump out at you? Include printouts of your calculations from 1. above as support and label them GA-4-1, GA-4-2, etc. (You're using GA-4 because other auditors have included other documents in the working paper file already-GA-1, -2, and -3.) (15 points) Account ID Account Description Cash on Hand Regular Checking Account Payroll Checking Account Savings Account 10100 10200 10300 10400 11000 Accounts Receivable 11500 12000 12300 14100 14200 14300 23200 23300 23350 23400 23500 23600 14400 14700 Other Current Assets 15000 Land 15100 15200 17000 19000 19900 20000 23100 23700 23800 23900 24100 24200 24300 24700 27000 39003 39004 39005 40000 41000 Allowance for Doubtful Accounts Inventory Reserve for Inventory Obsolescence Prepaid Insurance Prepaid Rent Office Supplies Notes Receivable-Current Buildings and Land Improvements Machinery, Equipment, Office Furniture Accum. Depreciation Investments Other Noncurrent Assets Accounts Payable Sales Tax Payable Wages Payable FICA Employee Withholding Medicare Withholding Federal Payroll Taxes Payable FUTA Tax Payable State Payroll Taxes Payable SUTA Tax Payable Employer FICA Payable Employer Medicare Payable Line of Credit Current Portion Long-Term Debt Oxford Manufacturing, Inc. Pre-closing Trial Balance (Audited) December 31, 2018 Notes Payable-Current Other Current Liabilities Notes Payable-Noncurrent Common Stock Paid-in Capital Retained Earnings Sales Sales Returns Debit $ 1,987.28 198,116.52 3,044,958.13 16,410,902.71 18,825,205.24 743,314.38 200,000.00 7,406.82 117,000.00 623,905.92 433,217.10 572,691.08 53,840.59 4,497,583.20 Credit $ 1,262,819.88 3,012,000.00 163,500.00 4,633,118.09 0.00 29,470.32 1,318.69 583.99 6,033.01 2,815.47 1,318.69 583.99 10,000,000.00 8,105,000.00 7,423,000.00 2,219,620.65 246,172,918.44 41000 Sales Returns 42000 Warranty Expense 45000 Income from Investments 46000 Interest Income 50010 Cost of Goods Sold 57500 Freight 60000 Advertising Expense Auto Expenses 61000 62000 64000 64500 Research and Development Depreciation Expense Warehouse Salaries 65000 66000 67000 68000 70000 70100 Utilities 70110 Phone Property Tax Expense Legal and Professional Expense Bad Debt Expense Insurance Expense Maintenance Expense 77500 78000 78500 78510 80000 70120 Postal 71000 Miscellaneous Office Expense Payroll Tax Exp 72000 73000 Pension/Profit-Sharing Plan Ex Rent or Lease Expense 74000 Administrative Wages Expense Interest Expense Income Tax Expense - Federal Income Tax Expense - State Loss on Legal Settlement 4,497,583.20 1,100,281.48 141,569,221.61 4,302,951.46 897,140.01 208,974.39 31,212,334.17 133,000.00 4,633,383.82 80,495.32 3,605,133.96 1,622,425.99 853,942.65 61,136.04 135,642.99 76,373.78 128,033.21 17,023.27 1,550,989.06 3,000,000.00 2,603,485.87 16,875,305.98 875,000.00 2,365,000.00 429,000.00 19,172,000.00 $ 283,238,404.03 0.00 204,302.81 $ 283,238,404.03 Account ID 10100 10200 10300 10400 11000 11400 11500 12000 12300 14100 14200 14300 14400 14700 15000 15100 15200 17000 19000 19900 20000 23100 23200 23300 23350 23400 23500 23600 23700 23800 23900 24100 24200 24300 24700 27000 39003 39004 39005 40000 Cash on Hand Regular Checking Account Payroll Checking Account Savings Account Accounts Receivable Prepaid Insurance Prepaid Rent Account Description Other Receivables Allowance for Doubtful Accounts Inventory Reserve for Inventory Obsolescence Office Supplies Notes Receivable-Current Other Current Assets Land Buildings and Land Improvements Machinery, Equipment, Office Furniture Accum. Depreciation Investments Other Noncurrent Assets Accounts Payable Sales Tax Payable Wages Payable FICA Employee Withholding Oxford Manufacturing, Inc. Pre-closing Trial Balance (Unaudited) December 31, 2019 Medicare Withholding Federal Payroll Taxes Payable FUTA Tax Payable State Payroll Taxes Payable SUTA Tax Payable Employer FICA Payable Employer Medicare Payable Line of Credit Common Stock Paid-in Capital Retained Earnings Sales - Spotlight Current Portion Long-Term Debt Notes Payable-Current Other Current Liabilities Notes Payable-Noncurrent $ Debit 2,275.23 557,125.92 3,645,599.15 51,515,259.98 1,250,000.00 67,724,527.50 3,424,213.78 8,540.00 117,000.00 674,313.92 2,929,097.13 1,998,780.39 53,840.59 Credit $ 1,239,009.75 846,000.00 609,500.00 1,933,095.91 8,439.65 11,414.99 107,086.12 55,106.86 8,439.65 11,414.99 44,403,000.00 12,000,000.00 8,105,000.00 7,423,000.00 6,590,983.64 242,713,452.88 40000 41000 42000 45000 46000 47000 50010 57500 60000 61000 62000 64000 64500 65000 66000 67000 68000 70000 70100 70110 70120 71000 72000 73000 74000 77500 78000 78500 78510 Sales - Spotlight Sales Returns Warranty Expense Income from Investments Interest Income Miscellaneous Income Cost of Goods Sold Freight Advertising Expense Auto Expenses Research and Development Depreciation Expense Warehouse Salaries Property Tax Expense Legal and Professional Expense Bad Debt Expense Insurance Expense Maintenance Expense Utilities Phone Postal Miscellaneous Office Expense Payroll Tax Exp Pension/Profit-Sharing Plan Ex Rent or Lease Expense Administrative Wages Expense Interest Expense Income Tax Expense - Federal Income Tax Expense - State 11,100,220.89 1,158,128.47 130,196,645.26 4,240,263.09 1,036,854.01 210,502.80 528,870.44 446,000.00 4,720,715.56 99,332.45 4,913,224.45 36,106.92 35,502.87 137,332.18 52,599.02 77,803.61 24,891.82 1,577,811.85 3,300,000.00 1,206,574.00 16,197,225.43 2,591,736.50 8,900,000.00 3,100,000.00 $ 329,788,915.21 242,713,452.88 1,426,089.31 131,881.46 2,166,000.00 $ 329,788,915.21 1. Perform preliminary analytical procedures on the financial statements. a. Perform horizontal (year-to-year changes) and vertical (common size financial statements) analyses using the provided trial balances. b. Calculate appropriate financial ratios. Assume the market value of the common stock is $24 million in both the current and prior years. (10 points) 2. Write a memo (labeled GA-4) highlighting what you believe are potential problem areas. In other words, are there any significant changes from year-to-year that we might need to investigate further, or does anything jump out at you? Include printouts of your calculations from 1. above as support and label them GA-4-1, GA-4-2, etc. (You're using GA-4 because other auditors have included other documents in the working paper file already-GA-1, -2, and -3.) (15 points) Account ID Account Description Cash on Hand Regular Checking Account Payroll Checking Account Savings Account 10100 10200 10300 10400 11000 Accounts Receivable 11500 12000 12300 14100 14200 14300 23200 23300 23350 23400 23500 23600 14400 14700 Other Current Assets 15000 Land 15100 15200 17000 19000 19900 20000 23100 23700 23800 23900 24100 24200 24300 24700 27000 39003 39004 39005 40000 41000 Allowance for Doubtful Accounts Inventory Reserve for Inventory Obsolescence Prepaid Insurance Prepaid Rent Office Supplies Notes Receivable-Current Buildings and Land Improvements Machinery, Equipment, Office Furniture Accum. Depreciation Investments Other Noncurrent Assets Accounts Payable Sales Tax Payable Wages Payable FICA Employee Withholding Medicare Withholding Federal Payroll Taxes Payable FUTA Tax Payable State Payroll Taxes Payable SUTA Tax Payable Employer FICA Payable Employer Medicare Payable Line of Credit Current Portion Long-Term Debt Oxford Manufacturing, Inc. Pre-closing Trial Balance (Audited) December 31, 2018 Notes Payable-Current Other Current Liabilities Notes Payable-Noncurrent Common Stock Paid-in Capital Retained Earnings Sales Sales Returns Debit $ 1,987.28 198,116.52 3,044,958.13 16,410,902.71 18,825,205.24 743,314.38 200,000.00 7,406.82 117,000.00 623,905.92 433,217.10 572,691.08 53,840.59 4,497,583.20 Credit $ 1,262,819.88 3,012,000.00 163,500.00 4,633,118.09 0.00 29,470.32 1,318.69 583.99 6,033.01 2,815.47 1,318.69 583.99 10,000,000.00 8,105,000.00 7,423,000.00 2,219,620.65 246,172,918.44 41000 Sales Returns 42000 Warranty Expense 45000 Income from Investments 46000 Interest Income 50010 Cost of Goods Sold 57500 Freight 60000 Advertising Expense Auto Expenses 61000 62000 64000 64500 Research and Development Depreciation Expense Warehouse Salaries 65000 66000 67000 68000 70000 70100 Utilities 70110 Phone Property Tax Expense Legal and Professional Expense Bad Debt Expense Insurance Expense Maintenance Expense 77500 78000 78500 78510 80000 70120 Postal 71000 Miscellaneous Office Expense Payroll Tax Exp 72000 73000 Pension/Profit-Sharing Plan Ex Rent or Lease Expense 74000 Administrative Wages Expense Interest Expense Income Tax Expense - Federal Income Tax Expense - State Loss on Legal Settlement 4,497,583.20 1,100,281.48 141,569,221.61 4,302,951.46 897,140.01 208,974.39 31,212,334.17 133,000.00 4,633,383.82 80,495.32 3,605,133.96 1,622,425.99 853,942.65 61,136.04 135,642.99 76,373.78 128,033.21 17,023.27 1,550,989.06 3,000,000.00 2,603,485.87 16,875,305.98 875,000.00 2,365,000.00 429,000.00 19,172,000.00 $ 283,238,404.03 0.00 204,302.81 $ 283,238,404.03 Account ID 10100 10200 10300 10400 11000 11400 11500 12000 12300 14100 14200 14300 14400 14700 15000 15100 15200 17000 19000 19900 20000 23100 23200 23300 23350 23400 23500 23600 23700 23800 23900 24100 24200 24300 24700 27000 39003 39004 39005 40000 Cash on Hand Regular Checking Account Payroll Checking Account Savings Account Accounts Receivable Prepaid Insurance Prepaid Rent Account Description Other Receivables Allowance for Doubtful Accounts Inventory Reserve for Inventory Obsolescence Office Supplies Notes Receivable-Current Other Current Assets Land Buildings and Land Improvements Machinery, Equipment, Office Furniture Accum. Depreciation Investments Other Noncurrent Assets Accounts Payable Sales Tax Payable Wages Payable FICA Employee Withholding Oxford Manufacturing, Inc. Pre-closing Trial Balance (Unaudited) December 31, 2019 Medicare Withholding Federal Payroll Taxes Payable FUTA Tax Payable State Payroll Taxes Payable SUTA Tax Payable Employer FICA Payable Employer Medicare Payable Line of Credit Common Stock Paid-in Capital Retained Earnings Sales - Spotlight Current Portion Long-Term Debt Notes Payable-Current Other Current Liabilities Notes Payable-Noncurrent $ Debit 2,275.23 557,125.92 3,645,599.15 51,515,259.98 1,250,000.00 67,724,527.50 3,424,213.78 8,540.00 117,000.00 674,313.92 2,929,097.13 1,998,780.39 53,840.59 Credit $ 1,239,009.75 846,000.00 609,500.00 1,933,095.91 8,439.65 11,414.99 107,086.12 55,106.86 8,439.65 11,414.99 44,403,000.00 12,000,000.00 8,105,000.00 7,423,000.00 6,590,983.64 242,713,452.88 40000 41000 42000 45000 46000 47000 50010 57500 60000 61000 62000 64000 64500 65000 66000 67000 68000 70000 70100 70110 70120 71000 72000 73000 74000 77500 78000 78500 78510 Sales - Spotlight Sales Returns Warranty Expense Income from Investments Interest Income Miscellaneous Income Cost of Goods Sold Freight Advertising Expense Auto Expenses Research and Development Depreciation Expense Warehouse Salaries Property Tax Expense Legal and Professional Expense Bad Debt Expense Insurance Expense Maintenance Expense Utilities Phone Postal Miscellaneous Office Expense Payroll Tax Exp Pension/Profit-Sharing Plan Ex Rent or Lease Expense Administrative Wages Expense Interest Expense Income Tax Expense - Federal Income Tax Expense - State 11,100,220.89 1,158,128.47 130,196,645.26 4,240,263.09 1,036,854.01 210,502.80 528,870.44 446,000.00 4,720,715.56 99,332.45 4,913,224.45 36,106.92 35,502.87 137,332.18 52,599.02 77,803.61 24,891.82 1,577,811.85 3,300,000.00 1,206,574.00 16,197,225.43 2,591,736.50 8,900,000.00 3,100,000.00 $ 329,788,915.21 242,713,452.88 1,426,089.31 131,881.46 2,166,000.00 $ 329,788,915.21
Expert Answer:
Answer rating: 100% (QA)
A Horizontal Analysis Trading and Profit and Loss Account Oxford Manufacturing Inc Trading and Profit and Loss Account Description Dec 31 2018 Dec 31 2019 Increase Decrease Amount Sales 24617291844 24... View the full answer
Related Book For
Financial Accounting an introduction to concepts, methods and uses
ISBN: 978-0324789003
13th Edition
Authors: Clyde P. Stickney, Roman L. Weil, Katherine Schipper, Jennifer Francis
Posted Date:
Students also viewed these accounting questions
-
The norm of a linear transformation TA: Rn Rn can be defined by where the maximum is taken over all nonzero x in Rn. (The subscript indicates that the norm of the linear transformation on the left is...
-
Suppose that f: Rn R and g: Rn Rn are differentiable on Rn and that there exist r > 0 and a Rn such that Dg(x) is the identity matrix, I, for all x Br(a). Prove that there is a function h: Br(a) {a}...
-
Let 5: Rn Rn and T: Rn Rn be linear transformations with matrices A and B respectively. [Theorem 3.] (a) Show that B2 = B if and only if T2 = 7 (where T2 means T o T). (b) Show that B2 = 1 if and...
-
Refer to the bolt strength problem 17.47. Assume = 6,050 and 5 100. Use the following 24 individual bolt strength observations to answer the questions posed. (a) Prepare a histogram and/or normal...
-
Using the information given in Activity 10.2 in respect of Bayer's value added statement identify possible conclusions that could be drawn in respect of Bayer's performance for the year and any...
-
For which of the following does IFRS for SMEs not provide a simplification of full IFRS? a. Goodwill b. Borrowing costs c. Development costs d. Inventory
-
You should have found that the confidence interval when utilizing the paired structure of the data was narrower than the confidence interval ignoring this structure (this will generally be the case,...
-
Prepare journal entries to record the following. (a) Perez Company retires its delivery equipment, which cost $44,000. Accumulated depreciation is also $44,000 on this delivery equipment. No salvage...
-
What will be a great strategic recommendation to overcome Buyer Power for T-Mobile. The strategic recommendation needs to be something that has not been proposed before. Any suggestions will help.
-
What is a futures contract?
-
Harvard case study on Ricardo Semler, A revolutionary model of Leadership What are the personal and organizational reasons that led Ricardo to change his leadership style so markedly?
-
Enlist physical properties of engineering materials.
-
Define jurisdiction in both of its basic meanings.
-
Define ferrous and non-ferrous materials with their properties and suitable application.
-
What is ferrous metal? Write a note on stainless steel. Write down its application.
-
Describe the kinds of information that should be gathered in preparation for the drafting of a premarital agreement.
-
The base type for two sets is even numbers from 1 to 50 If setA has the following elements: (4, 48, 32, 12, 40, 22, 18, 36, 6, 34, 14, 26, 16) If setB has the following elements: (20, 4, 38, 48, 30,...
-
You have accepted the engagement of auditing the financial statements of the C. Reis Company, a small manufacturing firm that has been your auditee for several years. Because you were busy writing...
-
Relations between financial statements The following selected information is based on the 2007 financial statements of Beyond Petroleum (BP). BP applies IFRS, and reports its results in millions of...
-
Stock option valuation models indicate that the value of a stock option increases with the volatility of the stock, increases with the time between the grant date and the expected exercise date, and...
-
Reconstructing transactions involving shareholders' equity. Shea Company began business on January 1. Its balance sheet on December 31 contained the shareholders' equity section shown in Exhibit...
-
What stimulates the heart to beat?
-
Oxygen moves from the alveoli in the lungs into the bloodstream through the process of (a) active transport. (b) endocytosis. (c) diffusion. (d) exocytosis.
-
The cells that carry oxygen to body tissues are (a) red blood cells. (b) white blood cells. (c) platelets. (d) hemoglobin.
Study smarter with the SolutionInn App