The Caldwell Company is a retail company that began operations on October 1st, 2018.

The last screenshot is the format I would need the answer in.

Comp13-1 (similar to) Ques The Caldwell Company is a retail company that began operations on October 1, 2018, when it incorporated in the state of North Carolina. The Caldwell Company is authorized to issue 300,000 shares of $1 par value common stock and 45,000 shares of 6%, $60 par value preferred stock. The company sells a product that includes a one-year warranty and records estimated warranty payable each month. Customers are charged a 7% state sales tax. The company uses a perpetual inventory system. There are three employees that are paid a monthly salary on the last day of the month. Following is the chart of accounts for The Caldwell Company. As a new business, all beginning balances are $0. E: (Click the icon to view the chart of accounts.) The Caldwell Company completed the following transactions during the last quarter of 2018, its first year of operations: 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 Expense Total Payment Ending Balance Beginning Principal Balance Payment 10/01/2018 11/1/2018 0 12/1/2018 01/01/2019 CCC | C C Data Table The Tusquittee Company Chart of Accounts Cash Dividends PayableCommon Merchandise Inventory Notes Payable Land Mortgages Payable Building Common Stock-$1 Par Value Store Fixtures Paid-in Capital in Excess of ParCommon Accumulated Depreciation Paid-in Capital from Treasury Stock Transactions Accounts Payable Retained Earnings Employee Income Taxes Payable Treasury Stock-Common FICAOASDI Taxes Payable Cash Dividends FICAMedicare Taxes Payable Sales Revenue Employee Health Insurance Payable Cost of Goods Sold Federal Unemployment Taxes Payable Salaries Expense State Unemployment Taxes Payable Payroll Tax Expense Income Tax Payable Utilities Expense Print Done Oct. 1 Issued 24,000 shares of $1 par value common stock for cash of $5 per share. 1 Issued a $230,000, 10-year, 11% mortgage payable for land with an existing store building Mortgage payments of $2,875 are due on the first day of each month, beginning November 1. The assets had the following market values: Land, $190,000; Building, $40,000. 1 Issued a one-year, 6% note payable for $15,200 for store fixtures. The principal and interest are due October 1, 2019. 3 Purchased merchandise inventory on account from Paramount for $134,000, terms n/30. 15 Paid $120 for utilities. 31 Recorded cash sales for the month of $140,000 plus sales tax of 7%. The cost of the goods sold was $84,000 and estimated warranty payable was 6%. 31 Recorded October payroll and paid employees. 31 Accrued employer payroll taxes for October. Nov. 1 Paid the first mortgage payment. 3 Paid Paramount for the merchandise inventory purchased on October 3. 10 Purchased merchandise inventory on account from Paramount for $170,000, terms n/30 12 Purchased 800 shares of treasury stock for $20 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 $325 for utilities. 16 Paid $3,000 to satisfy warranty claims. 17 Declared cash dividends of $1 per outstanding share of common stock. 18 Paid $325 for utilities. 27 Paid the cash dividends. 30 Recorded cash sales for the month of $130,000 plus sales tax of 7%. The cost of the goods sold was $78,000 and estimated warranty payable was 6%. 30 Recorded November payroll and paid employees. 30 Accrued employer payroll taxes for November. Dec 1 Paid the second mortgage payment. 10 Paid Paramount for the merchandise inventory purchased on November 10. 12 Paid $7,200 to satisfy warranty claims. 15 Sold 250 shares of treasury stock for $25 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 $260 for utilities 19 Purchased merchandise inventory on account from Paramount for $100,000, terms n/30. 31 Recorded cash sales for the month of $200,000 plus sales tax of 7%. The cost of the goods sold was $120,000 and estimated warranty payable was 6%. 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 P C 10/01/2018 11/1/2018 12/1/2018 01/01/2019