Caldwell Company

NEED ANSWER IN THE FORMAT OF THE BLANK WITHHOLDINGS EARNINGS BOX PLEASE

The Caldwell Company is a retail company that began operations on October 1, 2018, when it Following is the chart of accounts for The Caldwell Company. As a new business, all incorporated in the state of North Carolina. The Caldwell Company is authorized to issue beginning balances are $0. 250,000 shares of $1 par value common stock and 85,000 shares of 4%, $40 par value (Click the icon to view the chart of accounts.) preferred stock. The company sells a product that includes a one-year warranty and records estimated warranty payable each month. Customers are charged a 5% state sales tax. The The Caldwell Company completed the following transactions during the last quarter of 2018, its first year of operations: company uses a perpetual inventory system. There are three employees that are paid a monthly salary on the last day of the month. (Click the icon to view the transactions.) Read the requirements. Requirement 1a. In preparation for recording the transactions, prepare: An amortization schedule for the first 3 months of the mortgage payable issued on October 1. Round interest calculations to the nearest dollar. Interest Beginning Balance Principal Payment Total Payment Ending Balance Expense 10/01/2018 11/1/2018 12/1/2018 01/01/2019 Data Table Cash Merchandise Inventory Land Building Store Fixtures Accumulated Depreciation Accounts Payable Employee Income Taxes Payable FICAOASDI Taxes Payable FICAMedicare Taxes Payable The Tusquittee Company Chart of Accounts Dividends PayableCommon Notes Payable Mortgages Payable Common StockS1 Par Value Paid-in Capital in Excess of Par-Common Paid-in Capital from Treasury Stock Transactions Retained Earnings Treasury Stock-Common Cash Dividends Sales Revenue RICCUITulateu DepreciaLIOTT TGIO-IT Capital TTUMI Treasury SUCK TTansa CLIOTTS Accounts Payable Employee Income Taxes Payable FICAOASDI Taxes Payable FICAMedicare Taxes Payable Employee Health Insurance Payable Federal Unemployment Taxes Payable State Unemployment Taxes Payable Income Tax Payable Sales Tax Payable Estimated Warranty Payable Interest Payable Retained Earnings Treasury Stock-Common Cash Dividends Sales Revenue Cost of Goods Sold Salaries Expense Payroll Tax Expense Utilities Expense Depreciation Expense Warranty Expense Income Tax Expense Interest Expense Oct. 1 Issued 26,000 shares of $1 par value common stock for cash of $16 per share. 1 Issued a $300,000, 10-year, 7% mortgage payable for land with an existing store building. Mortgage payments of $3,750 are due on the first day of each month, beginning November 1. The assets had the following market values: Land, $60,000; Building, $240,000 1 Issued a one-year, 11% note payable for $13,200 for store fixtures. The principal and interest are due October 1, 2019. 3 Purchased merchandise inventory on account from Blue Chip for $130,000, terms n/30. 15 Paid $180 for utilities. 31 Recorded cash sales for the month of $160,000 plus sales tax of 5%. The cost of the goods sold was $96,000 and estimated warranty payable was 10%. 31 Recorded October payroll and paid employees. 31 Accrued employer payroll taxes for October. Nov. 1 Paid the first mortgage payment. 3 Paid Blue Chip for the merchandise inventory purchased on October 3. 10 Purchased merchandise inventory on account from Blue Chip for $200,000, terms n/30. rogor more 12 Purchased 600 shares of treasury stock for $14 per share 15 Paid all liabilities associated with the October 31 payroll. 15 Remitted (paid) sales tax from October sales to the state of North Carolina. 16 Paid $3,000 to satisfy warranty claims. 17 Declared cash dividends of $1 per outstanding share of common stock. 18 Paid $145 for utilities. 27 Paid the cash dividends. 30 Recorded cash sales for the month of $190,000 plus sales tax of 5%. The cost of the goods sold was $114,000 and estimated warranty payable was 10%. 30 Recorded November payroll and paid employees. 30 Accrued employer payroll taxes for November. Dec 1 Paid the second mortgage payment. 10 Paid Blue Chip for the merchandise inventory purchased on November 10. 12 Paid $7,100 to satisfy warranty claims. 15 Sold 550 shares of treasury stock for $19 per share. 15 Paid all liabilities associated with the November 30 navroll Dec. 1 Paid the second mortgage payment. 10 Paid Blue Chip for the merchandise inventory purchased on November 10 12 Paid $7,100 to satisfy warranty claims. 15 Sold 550 shares of treasury stock for $19 per share. 15 Paid all liabilities associated with the November 30 payroll. 15 Remitted (paid) sales tax from November sales to the state of North Carolina. 18 Paid $240 for utilities. 19 Purchased merchandise inventory on account from Blue Chip for $115,000, terms n/30. 31 Recorded cash sales for the month of $220.000 plus sales tax of 5%. The cost of the goods sold was $132,000 and estimated warranty payable was 10%. 31 Recorded December payroll and paid employees. 31 Accrued employer payroll taxes for December. Requirement 1a. In preparation for recording the transactions, prepare: An amortization schedule for the first 3 months of the mortgage payable issued on October 1. Round interest calculations to the nearest dollar. Beginning Balance Principal Payment Interest Expense Total Payment Ending Balance 10/01/2018 11/1/2018 12/1/2018 01/01/2019 Requirement 1a. In preparation for recording the transactions, prepare: An amortization schedule for the first 3 months of the mortgage payable issued on October 1. Round interest calculations to the nearest dollar. Interest Beginning Balance Principal Payment Expense 10/01/2018 Total Payment $ 3,750 $ 3,750 3.750 Ending Balance 300,000 298,000 295,988 293.965 11/1/2018 $ 300,000 $ $ 298,000 12/1/2018 01/01/2019 2,000 2,012 2.023 1,750 $ 1,738 1.727 295.988 Requirement 1b. In preparation for recording the transactions, prepare: Payroll registers for October, November, and December. All employees worked October 1 through December 31 and are subject to the following FICA taxes: OASDI: 6.2% on first $118,500 earned; Medicare: 1.45% up to $200,000, 2.35% on earnings above $200,000 Begin by preparing the payroll register for October. (Round all amounts to the nearest cent. Complete all answer boxes. Enter a "0" for any zero balances. Abbreviations used: Beg. = Beginning; Cum. = Cumulative; Earn. = Earnings; Med. = Medicare; Ins. = Insurance; With. = Withholdings.) Withholdings Beg. Earnings Current Period Ending Cum. Cum. Income Tax Health Ins. Total With. Net Pay Earn. Earnings Earn. | OASDI Med. Employee Johnson Spark Morgan b. Payroll registers for October, November, and December. All employees worked October 1 through December 31 and are subject to the following FICA taxes: OASDI: 6.2% on first $118,500 earned; Medicare: 1.45% up to $200,000, 2.35% on earnings above $200,000 Additional payroll information includes: Monthly Federal Health Employee Salary Income Tax Insurance Kathy Johnson $ 5,800 $ 1,740 $ Mandy Spark 4,900 980 400 Shannon Morgan 3,300 495 400 C. Calculations for employer payroll taxes liabilities for October, November, and December: OASDI: 6.2% on first $118,500 earned; Medicare: 1.45%; SUTA: 5.4% on first $7,000 earned, FUTA: 0.6% on first $7,000 earned. 2. Record the transactions in the general journal. Omit explanations. 3. Post to the general ledger. 4. Record adjusting entries for the three month period ended December 31, 2018: 4. Record adjusting entries for the three month period ended December 31, 2018: a. Depreciation on the Building, straight-line, 40 years, no residual value. b. Depreciation on Store Fixtures, straight-line, 20 years, no residual value. c. Accrued interest expense on the note payable for the store fixtures. d. Accrued interest expense on the mortgage payable. e. Accrued income tax expense of $31,000. 5. Post adjusting entries and prepare an adjusted trial balance 6. Prepare a multi-step income statement and statement of retained earnings for the quarter ended December 31, 2018. Prepare a classified balance sheet as of December 31, 2018. Assume that $25,074 of the mortgage payable is due within the next year. 7. Evaluate the company's success for the first quarter of operations by calculating the following ratios. The market price of the common stock is $35 on December 31, 2018. Round to two decimal places. a. Times interest earned b. Debt to equity c. Earnings per share d. Pricelearnings ratio e. Rate of return on common stock 8. The Caldwell Company wants to expand and is considering options for raising additional cash. The company estimates net income before the expansion of $280,000 in 2019 and that the expansion will provide additional operating income of $60,000 in 2019. The company intends to sell the shares of treasury stock, so use issued shares for the analysis rather than current shares outstanding. Compare these options, assuming a 20% income tax rate: Plan 1: Issue 5,000 additional shares of common stock for $32 per share Plan 2: Issue $240,000 in 10-year, 18% bonds payable. Which option will contribute more net income in 2019? Which option provides the highest EPS? The Caldwell Company is a retail company that began operations on October 1, 2018, when it Following is the chart of accounts for The Caldwell Company. As a new business, all incorporated in the state of North Carolina. The Caldwell Company is authorized to issue beginning balances are $0. 250,000 shares of $1 par value common stock and 85,000 shares of 4%, $40 par value (Click the icon to view the chart of accounts.) preferred stock. The company sells a product that includes a one-year warranty and records estimated warranty payable each month. Customers are charged a 5% state sales tax. The The Caldwell Company completed the following transactions during the last quarter of 2018, its first year of operations: company uses a perpetual inventory system. There are three employees that are paid a monthly salary on the last day of the month. (Click the icon to view the transactions.) Read the requirements. Requirement 1a. In preparation for recording the transactions, prepare: An amortization schedule for the first 3 months of the mortgage payable issued on October 1. Round interest calculations to the nearest dollar. Interest Beginning Balance Principal Payment Total Payment Ending Balance Expense 10/01/2018 11/1/2018 12/1/2018 01/01/2019 Data Table Cash Merchandise Inventory Land Building Store Fixtures Accumulated Depreciation Accounts Payable Employee Income Taxes Payable FICAOASDI Taxes Payable FICAMedicare Taxes Payable The Tusquittee Company Chart of Accounts Dividends PayableCommon Notes Payable Mortgages Payable Common StockS1 Par Value Paid-in Capital in Excess of Par-Common Paid-in Capital from Treasury Stock Transactions Retained Earnings Treasury Stock-Common Cash Dividends Sales Revenue RICCUITulateu DepreciaLIOTT TGIO-IT Capital TTUMI Treasury SUCK TTansa CLIOTTS Accounts Payable Employee Income Taxes Payable FICAOASDI Taxes Payable FICAMedicare Taxes Payable Employee Health Insurance Payable Federal Unemployment Taxes Payable State Unemployment Taxes Payable Income Tax Payable Sales Tax Payable Estimated Warranty Payable Interest Payable Retained Earnings Treasury Stock-Common Cash Dividends Sales Revenue Cost of Goods Sold Salaries Expense Payroll Tax Expense Utilities Expense Depreciation Expense Warranty Expense Income Tax Expense Interest Expense Oct. 1 Issued 26,000 shares of $1 par value common stock for cash of $16 per share. 1 Issued a $300,000, 10-year, 7% mortgage payable for land with an existing store building. Mortgage payments of $3,750 are due on the first day of each month, beginning November 1. The assets had the following market values: Land, $60,000; Building, $240,000 1 Issued a one-year, 11% note payable for $13,200 for store fixtures. The principal and interest are due October 1, 2019. 3 Purchased merchandise inventory on account from Blue Chip for $130,000, terms n/30. 15 Paid $180 for utilities. 31 Recorded cash sales for the month of $160,000 plus sales tax of 5%. The cost of the goods sold was $96,000 and estimated warranty payable was 10%. 31 Recorded October payroll and paid employees. 31 Accrued employer payroll taxes for October. Nov. 1 Paid the first mortgage payment. 3 Paid Blue Chip for the merchandise inventory purchased on October 3. 10 Purchased merchandise inventory on account from Blue Chip for $200,000, terms n/30. rogor more 12 Purchased 600 shares of treasury stock for $14 per share 15 Paid all liabilities associated with the October 31 payroll. 15 Remitted (paid) sales tax from October sales to the state of North Carolina. 16 Paid $3,000 to satisfy warranty claims. 17 Declared cash dividends of $1 per outstanding share of common stock. 18 Paid $145 for utilities. 27 Paid the cash dividends. 30 Recorded cash sales for the month of $190,000 plus sales tax of 5%. The cost of the goods sold was $114,000 and estimated warranty payable was 10%. 30 Recorded November payroll and paid employees. 30 Accrued employer payroll taxes for November. Dec 1 Paid the second mortgage payment. 10 Paid Blue Chip for the merchandise inventory purchased on November 10. 12 Paid $7,100 to satisfy warranty claims. 15 Sold 550 shares of treasury stock for $19 per share. 15 Paid all liabilities associated with the November 30 navroll Dec. 1 Paid the second mortgage payment. 10 Paid Blue Chip for the merchandise inventory purchased on November 10 12 Paid $7,100 to satisfy warranty claims. 15 Sold 550 shares of treasury stock for $19 per share. 15 Paid all liabilities associated with the November 30 payroll. 15 Remitted (paid) sales tax from November sales to the state of North Carolina. 18 Paid $240 for utilities. 19 Purchased merchandise inventory on account from Blue Chip for $115,000, terms n/30. 31 Recorded cash sales for the month of $220.000 plus sales tax of 5%. The cost of the goods sold was $132,000 and estimated warranty payable was 10%. 31 Recorded December payroll and paid employees. 31 Accrued employer payroll taxes for December. Requirement 1a. In preparation for recording the transactions, prepare: An amortization schedule for the first 3 months of the mortgage payable issued on October 1. Round interest calculations to the nearest dollar. Beginning Balance Principal Payment Interest Expense Total Payment Ending Balance 10/01/2018 11/1/2018 12/1/2018 01/01/2019 Requirement 1a. In preparation for recording the transactions, prepare: An amortization schedule for the first 3 months of the mortgage payable issued on October 1. Round interest calculations to the nearest dollar. Interest Beginning Balance Principal Payment Expense 10/01/2018 Total Payment $ 3,750 $ 3,750 3.750 Ending Balance 300,000 298,000 295,988 293.965 11/1/2018 $ 300,000 $ $ 298,000 12/1/2018 01/01/2019 2,000 2,012 2.023 1,750 $ 1,738 1.727 295.988 Requirement 1b. In preparation for recording the transactions, prepare: Payroll registers for October, November, and December. All employees worked October 1 through December 31 and are subject to the following FICA taxes: OASDI: 6.2% on first $118,500 earned; Medicare: 1.45% up to $200,000, 2.35% on earnings above $200,000 Begin by preparing the payroll register for October. (Round all amounts to the nearest cent. Complete all answer boxes. Enter a "0" for any zero balances. Abbreviations used: Beg. = Beginning; Cum. = Cumulative; Earn. = Earnings; Med. = Medicare; Ins. = Insurance; With. = Withholdings.) Withholdings Beg. Earnings Current Period Ending Cum. Cum. Income Tax Health Ins. Total With. Net Pay Earn. Earnings Earn. | OASDI Med. Employee Johnson Spark Morgan b. Payroll registers for October, November, and December. All employees worked October 1 through December 31 and are subject to the following FICA taxes: OASDI: 6.2% on first $118,500 earned; Medicare: 1.45% up to $200,000, 2.35% on earnings above $200,000 Additional payroll information includes: Monthly Federal Health Employee Salary Income Tax Insurance Kathy Johnson $ 5,800 $ 1,740 $ Mandy Spark 4,900 980 400 Shannon Morgan 3,300 495 400 C. Calculations for employer payroll taxes liabilities for October, November, and December: OASDI: 6.2% on first $118,500 earned; Medicare: 1.45%; SUTA: 5.4% on first $7,000 earned, FUTA: 0.6% on first $7,000 earned. 2. Record the transactions in the general journal. Omit explanations. 3. Post to the general ledger. 4. Record adjusting entries for the three month period ended December 31, 2018: 4. Record adjusting entries for the three month period ended December 31, 2018: a. Depreciation on the Building, straight-line, 40 years, no residual value. b. Depreciation on Store Fixtures, straight-line, 20 years, no residual value. c. Accrued interest expense on the note payable for the store fixtures. d. Accrued interest expense on the mortgage payable. e. Accrued income tax expense of $31,000. 5. Post adjusting entries and prepare an adjusted trial balance 6. Prepare a multi-step income statement and statement of retained earnings for the quarter ended December 31, 2018. Prepare a classified balance sheet as of December 31, 2018. Assume that $25,074 of the mortgage payable is due within the next year. 7. Evaluate the company's success for the first quarter of operations by calculating the following ratios. The market price of the common stock is $35 on December 31, 2018. Round to two decimal places. a. Times interest earned b. Debt to equity c. Earnings per share d. Pricelearnings ratio e. Rate of return on common stock 8. The Caldwell Company wants to expand and is considering options for raising additional cash. The company estimates net income before the expansion of $280,000 in 2019 and that the expansion will provide additional operating income of $60,000 in 2019. The company intends to sell the shares of treasury stock, so use issued shares for the analysis rather than current shares outstanding. Compare these options, assuming a 20% income tax rate: Plan 1: Issue 5,000 additional shares of common stock for $32 per share Plan 2: Issue $240,000 in 10-year, 18% bonds payable. Which option will contribute more net income in 2019? Which option provides the highest EPS