please help me calculate and analyze the following ratios , according the information provided

Due ACC 122 Fall 2020 Comprehensive Project BestValue Corporation's Trial Balance at December 31, 20XX is presented below. All 20xx transactions have been recorded except for the items described on the next page. Credit $ Debit 109,890 28,789 25,540 o 55,674 215,850 75,120 $ 1,027 63,306 16,048 35,278 0 48,900 0 0 0 Cash Accounts Receivable Inventory Debt Investments Land Buildings Equipment Allowance for Doubtful Accounts Accumulated Depreciation-Buildings Accumulated Depreciation-Equipment Accounts Payable Interest Payable Unearned Rent Revenue Dividends Payable Income Tax Payable Bonds Payable Discount on Bonds Payable Common Stock ($2 par) Paid in Capital in Excess of Par-Common Stock Preferred Stock ($60 par) Paid in Capital in Excess of Par-Preferred Stock Retained Earnings Treasury Stock Cash Dividends Sales Revenue Rent Revenue Gain on Sale of Land Bad Debt Expense Interest Expense Cost of Goods Sold Depreciation Expense Other Operating Expenses Salaries and Wages Expense Income Tax Expense Total 29,200 44,580 0 0 107,904 0 0 776,068 0 0 0 0 478,542 0 53,274 79,632 0 $ 1,122,311 $ 1,122,311 CONTINUED ON NEXT PAGE 2. Round all calculations if necessary to -o-decimals (to the nearest dollar, do not show cents). 1. On January 1, 20XX, BestValue issued 520 shares of $60 par, 5% preferred stock for $75,810. 2. On January 1, 20XX, BestValue also issued 5,800 shares of common stock for $42,050. 3. On January 1, 20XX, BestValue issued $325,000, 5.5%, 9 year bonds when the market rate was 6%. Interest is to be paid annually on each January 1, beginning 1 year from date of issue. 4. BestValue reacquired 3,600 shares of its common stock on January 12, 20xx for $8.50 per share. 5. On December 31, 20XX, Best Value declared the annual preferred dividend plus a $2.75 per share dividend on the outstanding common stock, all payable in cash on January 31 of next year. 6. On December 31, 20XX, BestValue estimates that the total amount of accounts receivable that is uncollectible at year end is $1,850. 7. The building is being depreciated using the straight line method over 25 years. The salvage value is $100,000. 8. The equipment is being depreciated using the straight line method over 5 years. The salvage value is $15,000. 9. Sold the Land for $60,000 cash. 10. Bought Debt Investments worth $200,000 for cash. 11. The unearned rent was collected on December 1, 20XX. It was receipt of 3 months' rent in advance (December 1, 20XX through February 28 of next year). 12. The first cash interest payment on the 5.5% bonds is due January 1 of next year. The annual interest on the bonds for 20XX has not yet been recorded. Use the effective interest method. 13. The BestValue Corporation must make an adjusting entry to accrue income tax expense on Income Before Income Tax at a rate of 36%. The taxes will not be paid until March of next year. Instructions: a) Prepare journal entries for the transactions listed above. (b) Prepare an updated December 31, 20XX trial balance. (C) Prepare a multiple-step income statement for the year ending December 31, 20XX. Id) Prepare a retained earnings statement for the year ending December 31, 20XX. (e) Prepare a classified balance sheet as of December 31, 20xx. (f) Prepare a Statement of Cash Flows as of December 31, 20xx. (e) and (h) Calculate and analyze the following ratios, clearly presenting your work and answers: 1. Working Capital 2. Current Ratio 3. Return on Stockholders' Equity (use ending Common Stockholders' Equity) 4. EPS (all shares are already weighted) 5. Payout Ratio 6. Debt to Assets Ratio 7. Times Interest Earned 8. Free Cash Flow 3 3 5. Payout Ratio: 6. Debt to Assets Ratio: 7. Times Interest Earned: 8. Free Cash Flow (after dividends would have been paid): ACC 122 Fall 2020 Comprehensive Project BestValue Corporation's Trial Balance at December 31, 20XX is presented below. All 20XX transactions have been recorded except for the items described on the next page. Debit Credit $ 109,890 28,789 25,540 0 55,674 215,850 75,120 $ 1,027 63,306 16,048 35,278 0 48,900 0 0 0 0 Cash Accounts Receivable Inventory Debt Investments Land Buildings Equipment Allowance for Doubtful Accounts Accumulated Depreciation-Buildings Accumulated Depreciation-Equipment Accounts Payable Interest Payable Unearned Rent Revenue Dividends Payable Income Tax Payable Bonds Payable Discount on Bonds Payable Common Stock ($2 par) Paid in Capital in Excess of Par-Common Stock Preferred Stock ($60 par) Paid in Capital in Excess of Par-Preferred Stock Retained Earnings Treasury Stock Cash Dividends Sales Revenue Rent Revenue Gain on Sale of Land Bad Debt Expense Interest Expense Cost of Goods Sold Depreciation Expense Other Operating Expenses Salaries and Wages Expense Income Tax Expense Total 29,200 44,580 0 0 107,904 0 0 776,068 0 0 0 0 478,542 0 53,274 79,632 0 1,122,311 $ 1,122,311 CONTINUED ON NEXT PAGE Round all calculations if necessary to -O-decimals (to the nearest dollar, do not show cents). 1. On January 1, 20XX, BestValue Issued 520 shares of $60 par, 5% preferred stock for $75,810. 2. On January 1, 20XX, Best Value also issued 5,800 shares of common stock for $42,050. 3. On January 1, 20XX, Best Value issued $325,000,5.5%, 9 year bonds when the market rate was 6%. Interest is to be paid annually on each January 1, beginning 1 year from date of issue. 4. BestValue reacquired 3,600 shares of its common stock on January 12, 20XX for $8.50 per share. 5. On December 31, 20XX, BestValue declared the annual preferred dividend plus a $2.75 per share dividend on the outstanding common stock, all payable in cash on January 31 of next year. 6. On December 31, 20XX, Best Value estimates that the total amount of accounts receivable that is uncollectible at year end is $1,850. 7. The building is being depreciated using the straight line method over 25 years. The salvage value is $100,000. 8. The equipment is being depreciated using the straight line method over 5 years. The salvage value is $15,000 9. Sold the Land for $60,000 cash. 10. Bought Debt Investments worth $200,000 for cash. 11. The unearned rent was collected on December 1, 20XX. It was receipt of 3 months' rent in advance (December 1, 20XX through February 28 of next year). 12. The first cash interest payment on the 5.5% bonds is due January 1 of next year. The annual interest on the bonds for 20XX has not yet been recorded. Use the effective interest method. 13. The Best Value Corporation must make an adjusting entry to accrue income tax expense on Income Before Income Tax at a rate of 36%. The taxes will not be paid until March of next year. Instructions: (a) Prepare journal entries for the transactions listed above. (b) Prepare an updated December 31, 20XX trial balance. c) Prepare a multiple-step income statement for the year ending December 31, 20XX. la Prepare a retained earnings statement for the year ending December 31, 20xx. (e) Prepare a classified balance sheet as of December 31, 20xx. (f) Prepare a Statement of Cash Flows as of December 31, 20XX. (g) and (h) Calculate and analyze the following ratios, clearly presenting your work and answers: 1. Working Capital 2. Current Ratio 3. Return on Stockholders' Equity (use ending Common Stockholders' Equity) 4. EPS (all shares are already weighted) 5. Payout Ratio 6. Debt to Assets Ratio 7. Times Interest Earned 8. Free Cash Flow 3 BestValue Corporation General Journal Credit Date 1. Debit $ 75, 810 Account Titles Cash Preferred stock Paid in Capital in Excess of Par-Preferred stock L 200 44,610 2 42,050 Cash common Stock Paid in capital in excess of par commun Stock IL 500 20. SO | Cash Discount on Bonds Payable Bonds Payable 297, 917 27,083 325,000 4 Stock 30, 600 Treasury Cash 30 600 5. S7660 Cosh Dividonds Dividends Payable 57, 660 1.850 6. Bab Debt expense Allowance for doubtful accounts 1,850 4,634 7 4634 Deprecation expense Acumulated Depreciation - Buildings 12,024 8 12.024 Depreciation Expense Accumulated Depreciation- Equipment 9 Cash 60,000 Land Gain on sale of land 55,674 41326 CONTINUED 4 10. CR Debt investments cash DR 200 000 200 OOO 11. Unearned Rent Rent Revenue 16,300 16,300 12. 17,875 Interest Expense Interest payable 17,875 13 Income Tax Expense Income tax payable 53,591 53,591 CR 2.877 67,940 28,072 35,272 17.875 32.600 S7: 660 53 591 325.000 (b) BestValue Corporation Updated Trial Balance 12/31/20XX DR Cash 355,0 67 Accounts Receivable 28, 789 Inventory 25, 540 Debt Investments 200,000 Land 33 674 Buildings 215, 850 Equipment 75,120 Allowance for Doubtful Accounts Accumulated Depreciation - Buildings Accumulated Depreciation - Equipment Accounts Payable Interest Payable Dividends Payable Uneamed Rent Revenue Income Tax Payable Bonds Payable Discount on Bonds Payable 27,083 Common Stock ($2 par) Paid-in Capital in Excess of Par - Common Stock Preferred Stock ($60 par) Paid-in Capital in Excess of Par - Preferred Stock Retained Earnings Treasury Stock 30,600 Cash Dividends 57, 660 Sales Revenue Rent Revenue Gain on Sale of Land Bad Debts Expense Interest Expense 17, 875 Cost of Goods Sold 478 542 Depreciation Expense 16,658 Other Operating Expenses 53,274 Salaries and Wages Expense 79,632 Income Tax Expense 53, 591 1717131 Totals 40,800 75,030 31,200 44,610 107, 904 776,068 16 300 4.326 1,850 1717, 131 BestValue Corporation Income Statement For the Year Ended December 31, 20XX Sales Revenue : Rent Revenue (16300) cost of Goods sold 413,592 Gioss Poft 716.06? 46 2242 312826 850 17 875 16,658 53, 274 79,632 Expenses: Bad Debts Expense Interest Expense Depreciation Expense Other Operating expense Solaries and woges Expense Total Operating Expenses operating profit : Goin on sale of Land Net Income before taxes income taxes Net income 169, 229 144,537 4,326 148.263 (53,591) 95,272 (d) BestValue Corporation Retained Earnings Statement For the Year Ended December 31, 20XX Adjusted Balance Net Income for the year Cash Dividends Ending balance 107 904 95, 272 (57, 660 145 516 e) BestValue Corporation Balance Sheet 12/31/20XX Assets 1/25031/4444705 Liabilities and Stockholders' Equity 8 11 (f) Statement of Cash Flows: BESTVALUE CORPORATION Comparative Balance Sheets December 31 of the previous year $ Cash Accounts Receivable (net of AFDA) Inventory Land Buildings Equipment Accumulated Depreciation-Buildings Accumulated Depreciation Equipment Accounts Payable Interest Payable Unearned Rent Revenue Dividends Payable Income Tax Payable 115,982 11,208 15,790 55,674 215,850 75,120 63,306 16,048 47,598 0 0 0 Instructions: Use the Balance Sheet for December 31, 20XX and the above ending balances for last year's Balance Sheet accounts to prepare the "Net cash provided by operating activities" section of the Cash Flow Statement below using the indirect method. BESTVALUE CORPORATION Statement of Cash Flows December 31, 20XX Cash flows from operating activities Net income Adjustments to reconcile net income to net cash provided by operating activities Add: Depreciation expense Add: Bad debt expense Less: Gain on sale of land Increase in accounts receivable Increase in inventory Decrease in accounts payable Increase in unearned rent revenue Increase in interest payable Increase in dividends payable Increase in income taxes payable Net cash provided by operating activities $ (8) Calculating Ratios: Instructions: Using the ratios as found in our textbook, calculate the following for the BestValue Corp. using the numbers you've arrived at in the project. Note: Round answers to 2 decimal places, as needed. All work must be presented! 1. Working Capital: 2. Current Ratio: 3. Return on Stockholders' Equity: (use ending Common Stockholders' Equity, not average. Common Stockholders' Equity does not include par value of preferred stock.) 4. EPS: (assume all shares are already weighted) 5. Payout Ratio: 6. Debt to Assets Ratio: 7. Times Interest Earned: 8. Free Cash Flow (after dividends would have been paid): (h) Ratio Analysis: Instructions: For each of the ratios below, analyze and describe how BestValue's ratio compares to its nearest competitor, Apple, Inc. See Appendix A in the back of your textbook for Apple's annual financial statements. Use the most current year, 2015, for your calculations. Note: Be sure to show the calculation of Apple's ratios below! 1. Working Capital: 2. Current Ratio: 3. Return on Stockholders' Equity: (use ending Common Stockholders' Equity, not average. Common Stockholders' Equity does not include par value of preferred stock.) 4. EPS: (already calculated in Apple's Income Statement) 5. Payout Ratio: 6. Debt to Assets ratio: 7. Times Interest Earned: (Note: Apple's 2015 10-K shows $733 (in millions) in Interest Expense) 8. Free Cash Flow