Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please let me solve , from instruction e to h. and fill these papers ACC 122 Fall 2020 Comprehensive Project BestValue Corporation's Trial Balance at

image text in transcribed

image text in transcribed

please let me solve , from instruction e to h. and fill these papers

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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 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 478,542 0 53,274 79,632 0 $ 1,122,311 $ 1,122,311 Round all calculations if necessary to-0-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. Best Value 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. (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 Best Value Corporation Balance Sheet 12/31/20XX Assets Liabilities and Stockholders' Equity COMPREHENSIVE PROJECT (Continued) (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 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 COMPREHENSIVE PROJECT (Continued) () 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): COMPREHENSIVE PROJECT (Continued) (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) 12 COMPREHENSIVE PROJECT (Continued) (h) Ratio Analysis, cont.: 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! 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: 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 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 478,542 0 53,274 79,632 0 $ 1,122,311 $ 1,122,311 Round all calculations if necessary to-0-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. Best Value 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. (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 Best Value Corporation Balance Sheet 12/31/20XX Assets Liabilities and Stockholders' Equity COMPREHENSIVE PROJECT (Continued) (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 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 COMPREHENSIVE PROJECT (Continued) () 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): COMPREHENSIVE PROJECT (Continued) (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) 12 COMPREHENSIVE PROJECT (Continued) (h) Ratio Analysis, cont.: 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! 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial & Managerial Accounting For Undergraduates

Authors: Jason Wallace, James Nelson, Karen Christensen, Theodore Hobson, Scott L. Matthews

2nd Edition

161853310X, 9781618533104

More Books

Students also viewed these Accounting questions

Question

Prove that /

Answered: 1 week ago

Question

How can you create a supportive context for your personal growth?

Answered: 1 week ago

Question

How do romantic relationships typically escalate and deteriorate?

Answered: 1 week ago