1. Working Trial Balance contains the KCN Working Trial Balance for the year ended December 31,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. "Working Trial Balance" contains the KCN Working Trial Balance for the year ended December 31, 20X5 (unadjusted) and 20X4 (adjusted). 2. "Financial Statements" contains comparative KCN Financial Statements which are the results of the adjusted working trial balance amounts for 20X5 and 20X4. 3. "Ratios" contains the Financial Statement Ratios calculated from KCN Financial Statements, both for 20X5 and for 20X4. Required: a. Recalculate the 12/31/X5 and 12/31/X4 ratios using Excel on the Ratios schedule. b. Identify financial statement accounts that should be investigated because the related ratios are not what one would expect as compared to the prior-year ratios, industry averages, or your knowledge of th company. c. For each account identified in part b., list potential reasons for the unexpected account balances and related ratios. KEYSTONE COMPUTERS & NETWORKS, INC. Analytical Procedures Ratios For the Years Ended December 31, Current ratio Days sales in average accounts receivable Allowance for doubtful accounts / accounts receivable Bad debt expenses/net sales Total liabilities to net worth Return on total assets Return on net worth Return on net sales Gross profit/net sales Selling, operating and admin expense / net sales Times interest earned 20X5 Ref. No. Prepared by Date 20X4 Plan-1 WL 1/10/X6 Industry 1.3 37.0 2.9 9.0% 29.0% 2.3% 24.0% 23.9% 5.5 T KEYSTONE COMPUTERS & NETWORKS, INC. Working Trial Balance For the Year Ended December 31, 20X5 20X4 Acct. No. Account Name Adjusted 1000.10 Cash-First National Bank 1000.20 Cash-Special Account 1000.30 Cash in register 1000.40 Petty Cash 1050.10 Accounts receivable-trade 1050.40 Accounts receivable-officers 1050.90 Allowance for bad debts 1100.10 Inventories 1300.10 Prepaid expenses 2050.10 Furniture & fixtures 2050.30 Equipment 2050.80 Leasehold improvements 2050.90 Accumulated depreciation 2100.00 Software development cost 2200.00 Intangible assets 3050.10 Accounts payable-trade 3100.00 Capital lease oblig.-current 3200.10 Accrued liabilities 3300.30 Unearned service revenue 3400.50 Line of credit 4400.10 Capital lease oblig.-noncurr. 5050.10 Capital stock 5100.10 Paid-in capital 5700.10 Retained earnings 5900.00 Dividends Totals 42,754 9,960 1,200 50 8,534,524 57,643 (96,000) 1,234,589 156,900 300,980 789,654 98,900 (250,987) 1,000,000 (1,349,839) (43,200) (178,900) (6,612,550) (456,700) (200,000) (423,500) (1,626,203) 989,275 20X5 Unadjusted 66,034 10,150 1,200 50 10,235,457 84,670 (104,000) 1,375,835 176,456 344,900 974,676 91,230 (404,560) 178,000 800,000 (1,429,033) (45,675) (203,450) (42,300) (8,632,105) (423,680) (200,000) (423,500) (2,615,478) 415,000 229,877 Ref # Prep'd b Date Adjustments Dr. Cr. WL 1/10/X6 20X5 Adjusted 66,034 10,150 1,200 50 10,235,457 84,670 (104,000) 1,375,835 176,456 344,900 974,676 91,230 (404,560) 178,000 800,000 (1,429,033) (45,675) (203,450) (42,300) (8,632,105) (423,680) (200,000) (423,500) (2,615,478) 415,000 229,877 6000.10 Sales of computers 6010.10 Software licenses 6020.10 Service revenue 6030.10 Consulting revenue 7020.10 Cost of sales-prod. & serv. 7070.10 Salaries-sales 7070.50 Payroll benefits-sales 7075.10 Advertising & promotion 7080.10 Travel & entertainment 7080.30 Miscellaneous exp. -sales 7090.10 Operating salaries 7090.30 Administrative salaries 7090.50 Payroll benefits-admin. 7100.10 Rent 7140.10 Utilities 7200.10 Insurance 7260.30 Legal and accounting 7320.10 Bad debt expense 7410.10 Supplies 7600.10 Depreciation and amort. 7650.10 Software development 7700.10 Miscellaneous exp.-admin. 7800.10 Interest expense 7900.10 Current income taxes 7900.70 Deferred income taxes 9000.00 P&L Summary Total Balance Sheet Total Income Statement Out-of-balance (44,890,788) (248,900) (4,567,888) (46,751,990) 74,122,435 3,167,889 913,456 1,200,786 609,788 334,890 4,878,900 4,234,234 1,812,344 797,800 210,495 356,890 457,577 234,500 556,345 334,565 289,100 234,556 421,344 256,765 45,632 989,275 989,275 (989,275) 0 (42,345,675) (236,700) (4,325,777) (45,677,899) 72,134,566 2,765,677 857,368 1,567,889 445,600 278,656 4,544,860 3,945,670 1,734,565 721,345 234,839 378,677 485,767 256,678 478,900 367,867 345,645 245,456 476,899 80,100 9,150 229,877 (229,877) 0 (42,345,675) (236,700) (4,325,777) (45,677,899) 72,134,566 2,765,677 857,368 1,567,889 445,600 278,656 4,544,860 3,945,670 1,734,565 721,345 234,839 378,677 485,767 256,678 478,900 367,867 345,645 245,456 476,899 80,100 9,150 0 (229,877) 229,877 0 1. "Working Trial Balance" contains the KCN Working Trial Balance for the year ended December 31, 20X5 (unadjusted) and 20X4 (adjusted). 2. "Financial Statements" contains comparative KCN Financial Statements which are the results of the adjusted working trial balance amounts for 20X5 and 20X4. 3. "Ratios" contains the Financial Statement Ratios calculated from KCN Financial Statements, both for 20X5 and for 20X4. Required: a. Recalculate the 12/31/X5 and 12/31/X4 ratios using Excel on the Ratios schedule. b. Identify financial statement accounts that should be investigated because the related ratios are not what one would expect as compared to the prior-year ratios, industry averages, or your knowledge of th company. c. For each account identified in part b., list potential reasons for the unexpected account balances and related ratios. KEYSTONE COMPUTERS & NETWORKS, INC. Analytical Procedures Ratios For the Years Ended December 31, Current ratio Days sales in average accounts receivable Allowance for doubtful accounts / accounts receivable Bad debt expenses/net sales Total liabilities to net worth Return on total assets Return on net worth Return on net sales Gross profit/net sales Selling, operating and admin expense / net sales Times interest earned 20X5 Ref. No. Prepared by Date 20X4 Plan-1 WL 1/10/X6 Industry 1.3 37.0 2.9 9.0% 29.0% 2.3% 24.0% 23.9% 5.5 T KEYSTONE COMPUTERS & NETWORKS, INC. Working Trial Balance For the Year Ended December 31, 20X5 20X4 Acct. No. Account Name Adjusted 1000.10 Cash-First National Bank 1000.20 Cash-Special Account 1000.30 Cash in register 1000.40 Petty Cash 1050.10 Accounts receivable-trade 1050.40 Accounts receivable-officers 1050.90 Allowance for bad debts 1100.10 Inventories 1300.10 Prepaid expenses 2050.10 Furniture & fixtures 2050.30 Equipment 2050.80 Leasehold improvements 2050.90 Accumulated depreciation 2100.00 Software development cost 2200.00 Intangible assets 3050.10 Accounts payable-trade 3100.00 Capital lease oblig.-current 3200.10 Accrued liabilities 3300.30 Unearned service revenue 3400.50 Line of credit 4400.10 Capital lease oblig.-noncurr. 5050.10 Capital stock 5100.10 Paid-in capital 5700.10 Retained earnings 5900.00 Dividends Totals 42,754 9,960 1,200 50 8,534,524 57,643 (96,000) 1,234,589 156,900 300,980 789,654 98,900 (250,987) 1,000,000 (1,349,839) (43,200) (178,900) (6,612,550) (456,700) (200,000) (423,500) (1,626,203) 989,275 20X5 Unadjusted 66,034 10,150 1,200 50 10,235,457 84,670 (104,000) 1,375,835 176,456 344,900 974,676 91,230 (404,560) 178,000 800,000 (1,429,033) (45,675) (203,450) (42,300) (8,632,105) (423,680) (200,000) (423,500) (2,615,478) 415,000 229,877 Ref # Prep'd b Date Adjustments Dr. Cr. WL 1/10/X6 20X5 Adjusted 66,034 10,150 1,200 50 10,235,457 84,670 (104,000) 1,375,835 176,456 344,900 974,676 91,230 (404,560) 178,000 800,000 (1,429,033) (45,675) (203,450) (42,300) (8,632,105) (423,680) (200,000) (423,500) (2,615,478) 415,000 229,877 6000.10 Sales of computers 6010.10 Software licenses 6020.10 Service revenue 6030.10 Consulting revenue 7020.10 Cost of sales-prod. & serv. 7070.10 Salaries-sales 7070.50 Payroll benefits-sales 7075.10 Advertising & promotion 7080.10 Travel & entertainment 7080.30 Miscellaneous exp. -sales 7090.10 Operating salaries 7090.30 Administrative salaries 7090.50 Payroll benefits-admin. 7100.10 Rent 7140.10 Utilities 7200.10 Insurance 7260.30 Legal and accounting 7320.10 Bad debt expense 7410.10 Supplies 7600.10 Depreciation and amort. 7650.10 Software development 7700.10 Miscellaneous exp.-admin. 7800.10 Interest expense 7900.10 Current income taxes 7900.70 Deferred income taxes 9000.00 P&L Summary Total Balance Sheet Total Income Statement Out-of-balance (44,890,788) (248,900) (4,567,888) (46,751,990) 74,122,435 3,167,889 913,456 1,200,786 609,788 334,890 4,878,900 4,234,234 1,812,344 797,800 210,495 356,890 457,577 234,500 556,345 334,565 289,100 234,556 421,344 256,765 45,632 989,275 989,275 (989,275) 0 (42,345,675) (236,700) (4,325,777) (45,677,899) 72,134,566 2,765,677 857,368 1,567,889 445,600 278,656 4,544,860 3,945,670 1,734,565 721,345 234,839 378,677 485,767 256,678 478,900 367,867 345,645 245,456 476,899 80,100 9,150 229,877 (229,877) 0 (42,345,675) (236,700) (4,325,777) (45,677,899) 72,134,566 2,765,677 857,368 1,567,889 445,600 278,656 4,544,860 3,945,670 1,734,565 721,345 234,839 378,677 485,767 256,678 478,900 367,867 345,645 245,456 476,899 80,100 9,150 0 (229,877) 229,877 0
Expert Answer:
Answer rating: 100% (QA)
RATIO Name 20X5 20X4 Days sales in avg acc recev DebtorsSales per day 38 Days 32 Days Total Liabilit... View the full answer
Related Book For
Accounting
ISBN: 978-0324401844
22nd Edition
Authors: Carl S. Warren, James M. Reeve, Jonathan E. Duchac
Posted Date:
Students also viewed these accounting questions
-
The statement of comprehensive income for the years ended December 31, 2006 and 2007, plus selected items from comparative balance sheets of McClain Wholesalers, Inc., are as follows: There were no...
-
The statement of comprehensive income for the years ended December 31, 2008 and 2009, plus selected items from comparative balance sheets of Johnson Wholesalers Inc. are as follows: There were no...
-
The comparative financial statements of Stargel Inc. are as follows. The market price of Stargel common stock was $119.70 on December 31, 2017. Stargel, Inc. Comparative Retained Earnings Statement...
-
What tensions may arise if a shareholder-centric model is imposed on a stakeholder-focused society?
-
Determine the partial fraction expansion for V(s) and compute the inverse Laplace transform. The transfer function V(s) is given by: V(s) = 400 / s2 + 8s + 400
-
Suppose r(t) = (e t cos t)i + (e t sin t)j. Show that the angle between r and a never changes. What is the angle?
-
Question 9 indicated high vibration on the sleeve bearing and bracket in the axial vibration. What damage would this have caused?
-
The unadjusted and adjusted trial balances for Editorial Services Co. on March 31, 2014, are shown below. Journalize the five entries that adjusted the accounts at March 31, 2014. None of the...
-
How does a website like Reddit perform in information sharing? What types of questions are people asking? Are the results relevant? Are they of high quality?
-
Under what circumstances should a systems analyst recommend an agile methodology over structured development or object-oriented analysis?
-
Why might a defined-benefit pension plan become underfunded? Explain.
-
Use the result of Problem 5.20 (b) to calculate the difference, cP - cv, for liquid acetone at 20C and 1 bar. Data can be found in Table 4.4. Repeat for benzene and copper. How do the values you...
-
When the price of corn increases, feedlots will: a. purchase more corn b. purchase less corn c. purchase same corn amount d. cannot tell
-
The optimal combination of inputs depends on: a. land grant university recommendations b. tradition c. resource availability d. relative prices
-
Relative prices are captured in the: a. equilibrium point b. isoquant c. isocost line d. vertical axis
-
Each point on the isoquant shows: a. the same level of output b. the same level of profit c. the same level of inputs d. the same level of expenditures
-
Find the total value of the investment after the time given. 11) $7,300 at 7% compounded semiannually for 3 years 12) $1,030 at 4% compounded semiannually for 2 years
-
Whats the difference between an ordinary annuity and an annuity due? What type of annuity is shown below? How would you change the time line to show the other type of annuity?
-
Rare Earth Clothing is a retail store specializing in women's clothing. The store has established a liberal return policy for the holiday season in order to encourage gift purchases. Any item...
-
Banner Textiles Corporation began January with a budget for 28,000 hours of production in the Weaving Department. The department has a full capacity of 36,000 hours under normal business conditions....
-
A corporation reacquires 8,000 shares of its own $10 par common stock for $120,000, recording it at cost. (a) What effect does this transaction have on revenue or expense of the period? (b) What...
-
Maribel Ortiz is puzzled. Her company had a profit margin of 10% in 2025. She feels that this is an indication that the company is doing well. Gordon Liddy, her accountant, says that more information...
-
At December 31, 2025, the fair value of non-trading securities is 41,300 and the cost is 39,800. At January 1, 2025, there was a credit balance of 900 in the Fair Value Adjustment Non-Trading...
-
On January 1, 2025, Lennon Enterprises acquires 100% of Ono Ltd. for 220,000 in cash. The condensed statements of financial position of the two companies immediately following the acquisition are as...
Study smarter with the SolutionInn App