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...
-
List one or more trade pacts in which your country is involved. Do these trade pacts affect all residents of your country in the same way? On balance, are these trade pacts good or bad for residents...
-
During 2023, GlenTel Inc. sold its interest in a chain of wholesale outlets. This sale took the company out of the wholesaling business completely. The company still operates its retail outlets....
-
Perform a degrees-of-freedom analysis for the noninteracting exothermic reactor shown in Figure 20.3a. Suggest an appropriate control structure. Carry out the same exercise for the heat-integrated...
-
Tori Amos Corporation began operations on December 1, 2007. The only inventory transaction in 2007 was the purchase of inventory on December 10, 2007, at a cost of $20 per unit. None of this...
-
Explain how the Japanese economy fell into recession in the early 1990s. Briefly analyse the reasons why monetary and fiscal policies ineffective in stimulating GDP growth and hence pulling the...
-
Hill has two options to enter the small business market through a partnership or through direct sales. The costs and pricing differ for each approach. Hill Partnership: Sales price is 35% lower Hill...
-
The initial number of bacteria in the culture is 1000. After 3 hours there are 8000 bacteria in the culture Assuming exponential growth a) Find the formula for the number of bacteria in the culture,...
-
A block holding a ringing tuning fork is attached to a wall by a spring. The block oscillates back and forth on a horizontal, frictionless surface, with amplitude 17 cm. The mass of the tuning fork...
-
QUESTION 7 What is the centripetal accleration of a person standing 4 meters from the center of a merry-go-round if the merry-go-round has a linear velocity of 5 m/s? 6.25 m/s 1.25 m/s2 O 3.2 m/s O...
-
Consider an airplane flying at a steady and level flight with a speed of 144 knots and an altitude of 13,000 ft. At time t = 0 hour, the position of the airplane is directly above an island. (a)...
-
A roller of a motorised mortar mixer rotates for 5 seconds with a uniform angular acceleration and describes 120 radians during this time. It then rotates with constant angular velocity and covers...
-
The speed of a flywheel changes from 10 rad/s to 30 rad/s in 5 seconds time. Determine the angular acceleration of the wheel. How many revolutions the wheel would turn to attain a speed of 600...
-
The height, in feet, of an object s at time t seconds is shown in the graph below. Mark the two points on the graph that are needed to calculate average velocity AV [-5,0] between times t = -5 and t...
-
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...
-
In Fig. 1130, there is no explicit invariant that states that a Transaction cannot be linked to movements that are linked to the same account, because the structure of the model already demands is....
-
Apply the Account/Transaction pattern to the parallel financial transactions of the example shown in Figs. 1131 to 1135. As the bills may be paid forward, it may be necessary to use memo entries....
-
Look at Fig. 1119 and create a new discount strategy that gives a percentage of discount for sales with more than a certain number of products. Order | < > < > +nr: Natural = < > +date: Date...
Study smarter with the SolutionInn App