? Apollo Shoes Fluctuation Review: Using the Apollo Shoes Fluctuation spreadsheet and the Apollo Shoes Ratios, please
Fantastic news! We've Found the answer you've been seeking!
Transcribed Image Text:
Apollo Shoes Fluctuation Review: Using the Apollo Shoes Fluctuation spreadsheet and the Apollo Shoes Ratios, please prepare a one-page summary. (1/4 of a page): Facts: My audit supervisor assigned me to perform a fluctuation and ration review of Apollo Shoes financial statement accounts. Issues: Based on our class discussion, I identified and give business reasons for the following: ● Significant Account: Ratio Fluctuation: Recommendations: I recommend that based on the information presented above be used in the audit planning process for Apollo Shoes. Needed information: 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Account ID Account Description 10100 Cash on Hand 10200 Regular Checking Account 10300 Payroll Checking Account 10400 Savings Account 11000 Accounts Receivable 11400 Other Receivables 11500 12000 Inventory - Spotlight 12300 Reserve for Inventory Obsolescence 14100 Prepaid Insurance 14200 Prepaid Rent 14300 Office Supplies 14400 Notes Receivable-Current 14700 Other Current Assets 15000 Land 15100 Buildings and Land Improvements 15200 Machinery, Equipment, Office Furniture 17000 Accum. Depreciation 19000 Investments Allowance for Doubtful Accounts 19900 Other Noncurrent Assets 20000 Accounts Payable 23100 Sales Tax Payable 23200 Wages Payable 23300 FICA Employee Withholding 23350 Medicare Withholding 23400 Federal Payroll Taxes Payable 23500 FUTA Tax Payable 23600 State Payroll Taxes Payable 23700 SUTA Tax Payable 23800 FICA Employer Withholding 23900 Medicare Employer Withholding 24100 Line of Credit 24200 Current Portion Long-Term Debt 24700 Other Current Liabilities 27000 Notes Payable-Noncurrent 39003 Common Stock 39004 Paid-in Capital C 2016 Debit $1,987.28 $198,116.52 $0.00 $3,044,958.13 $16,410,902.71 $0.00 $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 D 2016 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 E 2017 Debit Amt $2,275.23 $557,125.92 0 $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 F 2017 Credit Amt S 1,239,009.75 S $ 846,000.00 $609,500.00 $1,922,095.91 $8,439.65 $11,414.99 $118,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 G $ Change Debit Amt $287.95 $359,009.40 $0.00 $600,641.02 $35,104,357.27 $1,250,000.00 $48,899,322.26 $0.00 $0.00 -23810.13 #DIV/0! $2,680,899.40 ($200,000.00) $1,133.18 $0.00 $0.00 $0.00 $50,408.00 $2,495,880.03 $0.00 $1,426,089.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 H $ Change Credit Amt $0.00 $0.00 $0.00 $0.00 $0.00 0 0 14% #DIV/0! 181% #DIV/0! 0 O #DIV/0! #DIV/0! 20% #DIV/0! 0 214% #DIV/0! O #DIV/0! #DIV/0! 0 -2166000 %Change %Change Debit Amt Credit Amt 0 #DIV/0! -72% 361% #DIV/0! 0 -100% #DIV/0! 0 15% #DIV/0! O #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 0 0% #DIV/0! 0 0 0 260% #DIV/0! -2% 8% #DIV/0! 0 576% #DIV/0! 446000 #DIV/0! 273% 249% #DIV/0! 0% #DIV/0! -2711022.18 #DIV/0! O #DIV/0! -29470.32 #DIV/0! 7120.96 #DIV/0! 10831 #DIV/0! 112053.11 #DIV/0! O #DIV/0! 52291.39 #DIV/0! o #DIV/0! 7120.96 #DIV/0! 10831 #DIV/0! 34403000 #DIV/0! 12000000 #DIV/0! O #DIV/0! 0 #DIV/0! -59% #DIV/0! -100% 540% 1855% 1857% #DIV/0! 1857% #DIV/0! 540% 1855% 344% 0 #DIV/0! #DIV/0! O #DIV/0! #DIV/0! #DIV/0! 0% 0% 1 2 40 1 2 3 4 45 46 7 48 49 41 42 43 44 47 50 Sy 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 A Account ID B Account Description 39005 Retained Earnings 40000 Sales 41000 Sales Returns 42000 Warranty Expense 45000 Income from Investments Interest Income 46000 47000 50010 Cost of Goods Sold 57500 Freight 60000 Miscellaneous Income Advertising Expense 61000 Auto Expenses 62000 Research and Development 64000 Depreciation Expense 64500 Warehouse Salaries 65000 Property Tax Expense 66000 Legal and Professional Expense 67000 Bad Debt Expense 68000 Insurance Expense 70000 Maintenance Expense 70100 Utilities 70110 Phone 70120 Postal 71000 Miscellaneous Office Expense 72000 Payroll Tax Exp 73000 Pension/Profit-Sharing Plan Ex 74000 Rent or Lease Expense 77500 Administrative Wages Expense 78000 Interest Expense 78500 Income Tax Expense - Federal 78510 Income Tax Expense - State 80000 Loss on Legal Settlement C 2016 Debit $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 D 2016 Credit $2,219,620.65 $246,172,918.44 $0.00 $204,302.81 $283 238 404 03 E 2017 Debit Amt $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 $0.00 $329,788,915 21 F 2017 Credit Amt $6,590,983.64 $242,713,452.88 $1,426,089.31 $131,881.46 $2,166,000.00 $329 788 915 21 G $ Change Debit Amt $0.00 $0.00 $6,602,637.69 $57,846.99 $0.00 $0.00 $0.00 ($11,372,576.35) ($62,688.37) $139,714.00 $1,528.41 ($30,683,463.73) $313,000.00 $87,331.74 $18,837.13 $1,308,090.49 ($1,622,425.99) ($817,835.73) ($25,633.17) $1,689.19 H $ Change Credit Amt 4371362.99 #DIV/0! -3459465.56 #DIV/0! 147% #DIV/0! 5% #DIV/0! 1426089.31 #DIV/0! #DIV/0! -72421.35 #DIV/0! -35% 2166000 #DIV/0! #DIV/0! -8% #DIV/0! ($23,774.76) ($50,229.60) $7,868.55 $26,822.79 $300,000.00 ($1,396,911.87) ($678,080.55) $1,716,736.50 $6,535,000.00 $2,671,000.00 ($19,172,000.00) #VALUE! 0 0 0 %Change %Change Debit Amt Credit Amt 197% -1% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1% #DIV/0! 16% #DIV/0! 1% #DIV/0! -98% #DIV/0! 235% #DIV/0! 2% #DIV/0! 23% #DIV/0! 36% #DIV/0! -100% #DIV/0! -96% #DIV/0! -42% #DIV/0! 1% #DIV/0! -31% #DIV/0! -39% #DIV/0! 46% #DIV/0! 2% #DIV/0! T 10% #DIV/0! -54% #DIV/0! -4% #DIV/0! 6% #DIV/0! 6% #DIV/0! 623% #DIV/0! -100% #VALUE! Apollo Shoes, Inc. Selected Ratios 12/31/17 Ratios Current Ratio Debt Ratio Debt-Equity Ratio Asset Turnover Liability Turnover Days Sales in Inventory Days Sales in AR Audited 12/31/16 2.40 0.40 0.66 6.54 16.39 48.54 24.90 Apollo Shoes Ratios 20,481,828.95 Unaudited 12/31/17 2.71 0.45 0.81 1.76 3.94 189.86 81.59 79,504,533.64 Percentage Change 13.05% 11.86% 21.41% -73.14% -75.98% 291.14% 227.69% 288.17% Apollo Shoes Fluctuation Review: Using the Apollo Shoes Fluctuation spreadsheet and the Apollo Shoes Ratios, please prepare a one-page summary. (1/4 of a page): Facts: My audit supervisor assigned me to perform a fluctuation and ration review of Apollo Shoes financial statement accounts. Issues: Based on our class discussion, I identified and give business reasons for the following: ● Significant Account: Ratio Fluctuation: Recommendations: I recommend that based on the information presented above be used in the audit planning process for Apollo Shoes. Needed information: 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Account ID Account Description 10100 Cash on Hand 10200 Regular Checking Account 10300 Payroll Checking Account 10400 Savings Account 11000 Accounts Receivable 11400 Other Receivables 11500 12000 Inventory - Spotlight 12300 Reserve for Inventory Obsolescence 14100 Prepaid Insurance 14200 Prepaid Rent 14300 Office Supplies 14400 Notes Receivable-Current 14700 Other Current Assets 15000 Land 15100 Buildings and Land Improvements 15200 Machinery, Equipment, Office Furniture 17000 Accum. Depreciation 19000 Investments Allowance for Doubtful Accounts 19900 Other Noncurrent Assets 20000 Accounts Payable 23100 Sales Tax Payable 23200 Wages Payable 23300 FICA Employee Withholding 23350 Medicare Withholding 23400 Federal Payroll Taxes Payable 23500 FUTA Tax Payable 23600 State Payroll Taxes Payable 23700 SUTA Tax Payable 23800 FICA Employer Withholding 23900 Medicare Employer Withholding 24100 Line of Credit 24200 Current Portion Long-Term Debt 24700 Other Current Liabilities 27000 Notes Payable-Noncurrent 39003 Common Stock 39004 Paid-in Capital C 2016 Debit $1,987.28 $198,116.52 $0.00 $3,044,958.13 $16,410,902.71 $0.00 $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 D 2016 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 E 2017 Debit Amt $2,275.23 $557,125.92 0 $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 F 2017 Credit Amt S 1,239,009.75 S $ 846,000.00 $609,500.00 $1,922,095.91 $8,439.65 $11,414.99 $118,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 G $ Change Debit Amt $287.95 $359,009.40 $0.00 $600,641.02 $35,104,357.27 $1,250,000.00 $48,899,322.26 $0.00 $0.00 -23810.13 #DIV/0! $2,680,899.40 ($200,000.00) $1,133.18 $0.00 $0.00 $0.00 $50,408.00 $2,495,880.03 $0.00 $1,426,089.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 H $ Change Credit Amt $0.00 $0.00 $0.00 $0.00 $0.00 0 0 14% #DIV/0! 181% #DIV/0! 0 O #DIV/0! #DIV/0! 20% #DIV/0! 0 214% #DIV/0! O #DIV/0! #DIV/0! 0 -2166000 %Change %Change Debit Amt Credit Amt 0 #DIV/0! -72% 361% #DIV/0! 0 -100% #DIV/0! 0 15% #DIV/0! O #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! 0 0% #DIV/0! 0 0 0 260% #DIV/0! -2% 8% #DIV/0! 0 576% #DIV/0! 446000 #DIV/0! 273% 249% #DIV/0! 0% #DIV/0! -2711022.18 #DIV/0! O #DIV/0! -29470.32 #DIV/0! 7120.96 #DIV/0! 10831 #DIV/0! 112053.11 #DIV/0! O #DIV/0! 52291.39 #DIV/0! o #DIV/0! 7120.96 #DIV/0! 10831 #DIV/0! 34403000 #DIV/0! 12000000 #DIV/0! O #DIV/0! 0 #DIV/0! -59% #DIV/0! -100% 540% 1855% 1857% #DIV/0! 1857% #DIV/0! 540% 1855% 344% 0 #DIV/0! #DIV/0! O #DIV/0! #DIV/0! #DIV/0! 0% 0% 1 2 40 1 2 3 4 45 46 7 48 49 41 42 43 44 47 50 Sy 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 A Account ID B Account Description 39005 Retained Earnings 40000 Sales 41000 Sales Returns 42000 Warranty Expense 45000 Income from Investments Interest Income 46000 47000 50010 Cost of Goods Sold 57500 Freight 60000 Miscellaneous Income Advertising Expense 61000 Auto Expenses 62000 Research and Development 64000 Depreciation Expense 64500 Warehouse Salaries 65000 Property Tax Expense 66000 Legal and Professional Expense 67000 Bad Debt Expense 68000 Insurance Expense 70000 Maintenance Expense 70100 Utilities 70110 Phone 70120 Postal 71000 Miscellaneous Office Expense 72000 Payroll Tax Exp 73000 Pension/Profit-Sharing Plan Ex 74000 Rent or Lease Expense 77500 Administrative Wages Expense 78000 Interest Expense 78500 Income Tax Expense - Federal 78510 Income Tax Expense - State 80000 Loss on Legal Settlement C 2016 Debit $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 D 2016 Credit $2,219,620.65 $246,172,918.44 $0.00 $204,302.81 $283 238 404 03 E 2017 Debit Amt $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 $0.00 $329,788,915 21 F 2017 Credit Amt $6,590,983.64 $242,713,452.88 $1,426,089.31 $131,881.46 $2,166,000.00 $329 788 915 21 G $ Change Debit Amt $0.00 $0.00 $6,602,637.69 $57,846.99 $0.00 $0.00 $0.00 ($11,372,576.35) ($62,688.37) $139,714.00 $1,528.41 ($30,683,463.73) $313,000.00 $87,331.74 $18,837.13 $1,308,090.49 ($1,622,425.99) ($817,835.73) ($25,633.17) $1,689.19 H $ Change Credit Amt 4371362.99 #DIV/0! -3459465.56 #DIV/0! 147% #DIV/0! 5% #DIV/0! 1426089.31 #DIV/0! #DIV/0! -72421.35 #DIV/0! -35% 2166000 #DIV/0! #DIV/0! -8% #DIV/0! ($23,774.76) ($50,229.60) $7,868.55 $26,822.79 $300,000.00 ($1,396,911.87) ($678,080.55) $1,716,736.50 $6,535,000.00 $2,671,000.00 ($19,172,000.00) #VALUE! 0 0 0 %Change %Change Debit Amt Credit Amt 197% -1% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1% #DIV/0! 16% #DIV/0! 1% #DIV/0! -98% #DIV/0! 235% #DIV/0! 2% #DIV/0! 23% #DIV/0! 36% #DIV/0! -100% #DIV/0! -96% #DIV/0! -42% #DIV/0! 1% #DIV/0! -31% #DIV/0! -39% #DIV/0! 46% #DIV/0! 2% #DIV/0! T 10% #DIV/0! -54% #DIV/0! -4% #DIV/0! 6% #DIV/0! 6% #DIV/0! 623% #DIV/0! -100% #VALUE! Apollo Shoes, Inc. Selected Ratios 12/31/17 Ratios Current Ratio Debt Ratio Debt-Equity Ratio Asset Turnover Liability Turnover Days Sales in Inventory Days Sales in AR Audited 12/31/16 2.40 0.40 0.66 6.54 16.39 48.54 24.90 Apollo Shoes Ratios 20,481,828.95 Unaudited 12/31/17 2.71 0.45 0.81 1.76 3.94 189.86 81.59 79,504,533.64 Percentage Change 13.05% 11.86% 21.41% -73.14% -75.98% 291.14% 227.69% 288.17%
Expert Answer:
Answer rating: 100% (QA)
Common Size Income Statement Account Account 12312016 12312017 Change Significant Title Audited Unaudited X Revenue 40000 Sales 24617291844 102 24271345290 105 345946554 3 41000 Sales Return 449758320 ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Using correct business memo format, prepare a one page persuasive memo to management in favor of a four day work week. Assume you are a department manager at a company of approximately 400 employees....
-
The deputy county manager asks you to create a simple table showing the total cost allocation to each department using the three models you have developed. Prepare a one-page memo to the deputy...
-
View the article about Cable/DSL/Fiber Optics. Prepare a one page summary of the information that you were exposed to. Do you think fiber will support all the information needs we will have in the...
-
The Depression Anxiety Stress Scales (DASS) is a tool to measure the depression, anxiety and stress levels of individuals. For measuring the stress level, the DASS score ranges from 0 to 42 and a...
-
A part produced from a 4320 steel has a hardness of HRC 35 at a critical location after quenching. Determine (a) The cooling rate at that location, and (b) The microstructure and hardness that would...
-
Blood plasma proteins of patients with malignant breast tumors differ from proteins of healthy people in their solubility in the presence of various polymers. When the polymers dextran and...
-
Verify that both the pressure and the vorticity field satisfy the Laplace equation for Stokes flow. Verify that the velocity field satisfies the biharmonic equation \[\begin{equation*}abla^{4}...
-
Glenn Grimes is the founder and president of Heartland Construction, a real estate development venture. The business transactions during February while the company was being organized are listed...
-
Write a Java record (Class) Car with the following features (Instance variables): Make, Model, Color, and Year. Declare an array Cars to store 10 cars. Define an instance method setCars() to populate...
-
Garnett Jackson, the founder and CEO of Tech Tune-Ups, stared out the window as he finished his customary peanut butter and jelly sandwich, contemplating the dilemma currently facing his firm. Tech...
-
You have been recently hired by the Azad Inc., a manufacturing company to work as a cost analyst in the accounting department. The head of the department has asked you to examine the income statement...
-
From the article : MOTIVATING HOTEL EMPLOYEES IN POLAND. By: Wszendybyl-Skulska, Ewa. Answer the following: What is/are the hypothesis(es) of the writer(s) What key findings did they discover? What...
-
Analyse Inventory Management Policy of any organisation including Levels of Stock Lead time Service Level Stock Outs safety stock Economic Order Quantity 2. What are cash discounts, quantity...
-
Read first: ABC Enterprises is a newly established car dealership in town. The company has several sales representatives whose weekly compensations are commission-based. That is, sale...
-
City Manager executive summaries from each of the three budgets from the City of Seattle, WA and Address what you believe to be the message communicated with each of those three executive summaries....
-
Tyler Smithson owns Joe on the Run, a small chain of three coffee shops, all of which are facing a challenge that is common to most service businesses: They must deal with highly variable demand,...
-
Creat a reflection essay on Hubert Joly's approach to turning Best Buy around. The following questions can serve as a guide: Why do you think he took this approach, considering it is not what a...
-
Refrigerant-134a enters an adiabatic compressor as saturated vapor at 120 kPa at a rate of 0.3 m3/min and exits at 1-MPa pressure. If the isentropic efficiency of the compressor is 80 percent,...
-
Explain why an audit team cannot use the same combination of audit procedures for every audit.
-
When gaining an understanding of a client, an auditor will be interested in an entity's relationships with both its suppliers and customers. What aspects of these relationships will the auditor be...
-
Each of the professional accounting bodies has its own rules of professional conduct, which may also vary from province to province. Required (a) Go to the website of the Certified General...
-
Which ratio measures the ability of a company to collect its receivables? a. Current ratio b. Quick ratio c. Days sales in receivables d. Return on assets
-
In vertical analysis, the base used for comparison on the income statement is a. total expenses. b. total assets. c. net sales. d. gross profit.
-
A statement that lists the assets, liabilities, and stockholders equity of a company in percentages only with no dollar amounts is a a. common-size income statement. b. benchmarking analysis. c....
Study smarter with the SolutionInn App