I need help trying to fill out financial statemnts over the transaction records given

1) The company purchases inventory with a cost of $10,000 on account. The terms of the purchase are 2/10 n/30.

2) The company purchases supplies of $5,000 with cash.

3) On January 1st of the year, the company gets a loan of $400,000 from a bank. The loan has an annual rate of interest of 5%. The annual payment on the loan is $75,000.

4) The company purchases a piece of machinery for $100,000. The machine is estimated to produce 40,000 units over its life. The company estimates the salvage value of the machine to be $5,000.

5) The company has sales to customers of $45,000 on account.

6) The inventory sold in transaction 5 is calculated to be worth $5,000.

7) The company estimates that 5% of the sales in transaction 5 won't be collectable.

8) The company pays the amount due on the inventory purchased in transaction 1. The company takes advantage of the reduced sales price for the 2/10 n/30 terms.

9) The company pays salaries to it's employees of $5,000.

10) The company collects $30,000 of cash from customers who paid on account.

11) The compnay collects $10,000 from a customer for an order that will not be completed until the next year.

12) The company writes off $1,000 of accounts receivable.

13) The company purchases inventory with a cost of $5,000 on account. The terms of the purchase are 2/10 n/30.

14) The company has sales to customers of $50,000 in cash.

15) The inventory sold in transaction 14 is calculated to be worth $5,500.

16) The company makes it annual payment of $75,000 on the loan to the bank.

17) The company collects $10,000 of outstanding accounts receivable.

18) On September 1 of the year, the company pays $12,000 for lease on an office. The lease term is one year.

19) The company pays general expenses of $4,500 in cash.

20) The company pays the amount due on the inventory purchases in transaction 13. The company takes advantage of the reduced sales price for the 2/10 n/30 terms.

adj At the end of the year, the company has supplies on hand of $500.

adj At the end of the year, the machine produced 8,000 units. The company uses the units of production method to calculate depreciation.

adj At the end of the year, the company accrues $10,000 of salaries due to employees.

adj At the end of the year, the company recognizes rent expense for the lease executed in transaction 18.

adj At the end of the year, a physical count finds $2,000 of inventory on hand.

0 The 10.000 OLDI O 1000 the who 00.00. The story the The Theo th wie Then the che . BH HIT 1 The 16 f . the th Al ya at is callee 10.000 therefore wa AR Allows for try Machinery And Peppe -> No La Payatile Une CO tad Debt Depreciation Salari Gari DOBIT 17.00 DO A/ wear Me w talar F HOP 1 het RE Doud Dep Tam be 1 2 TIL 11 1 HIN Foundador Spring 2021 NOTE Enterall amounts as positive numbers. The pre-populated formulas will calculate subtotals as required Renard's Book Binding Business Income Statement FYE December 31, Year xx HINT Colors cells need to be the same number 6 7 E Sales Revenue 10 Cost of Goods Sold (COGS 11 Gross Prats 11 Salaries 14 General Expenses 15 Dad Debt 16 Interest 17 Depreciation Instructions In Chapters 1 thru 7 we have explored various components of the Financial statements and the transactions that are included. This project will take a comprehensive look at the material we have covered and evaluate your proficiency with posting the transactions. You will also complete the financial statements based on these transactions. What do you need to do? Download the excel file included with the assignment attachments. Complete the transactions in a manner similar to the comple videos for Chapters 1 thru 7. After completing the transactions, prepare the financial statements for your company. Any applicable beginning balance has already been input onto the financial statements. You do not need to calculate or adjust any beginning balance item. You DO NOT need to complete a Statement of Cash Flows 19 Net Income (Low) 20 21 Nenad Book dinding Business Statement of Changes in Stockholders' Equity FYE December 11 Year XX 24 Beginning Common Stock 26 Common Stocksued 27 Ending Common Stock 29 Beginning Retained aming 29 Net incom/loul 20 Less Dividends 5 Ending retained earning 12 13 Total Stockholders' Equity 14 Orohat you compara mantereses few check Figure you have not calculated the same amounts as these check figures, you likely have an error somewhere. Ending Cash - 5298,800 Net Income $12,050 Total Assets $392.050 Renard ook dinding Business Balance Sheet HY December Year XX 17 19 Aus 40 Cih 41 AR Allowance for Doubtful Account 4) Inventory 44 Machinery 5 Acumulated Depreciation 00 Prepaid Rent 24 DE Benin Common Stock 26 Common Stock mund 27 Ending Common Stock 2 Beginning Retained Earnings 29 Net Income/(Loss) 30 Less Dividends 1 Ending retained earnings 32 33 Total Stockholders' Equity figures. If you have not cakulated the same amounts as these check figures, voukely have an error somewhere Ending Cash-$298.800 Net Income - $12,050 Total Assets $192050 36 Renard's Book Binding Business dolance Sheet PYE December Year xx 39 Assets 40 Cash 41 AR Aliowance for Doubtful Accounts Inventory 4 Machinery 45 Accumulated Depreciation 46 President 47 Supplies 40 Total Assets Sp 51 bites 52 AP 55 Loan Payable 54 Useamed Revue 15 56 Stockholders' Equity 57 Common Stock 58 Retained Earning 59 Total Stocholes Equity 60 01 Totalt and Stockholders TV 2 64 5 The company purchases inventory with a cost of $10,000 on account. The terms of the purchase are 2/10 1/30. The company purchases supplies of $5,000 with cash. On January 1st of the year, the company sets a loan of $400,000 from a bank. The loan has an annual rate of interest of 5%. The annual payment on the loan is $75,000 The company purchases a piece of machinery for $100,000. The machine is estimated to produce 40,000 units over its life. The company estimates the salvage value of the machine to be 55.000 The company has sales to customers of $45,000 on account The inventory sold in transaction 5 is calcylated to be worth $5,000 The company estimates that 5% of the safes in transaction 5 won't be collectable The company pays the amount due on the inventory purchased in transaction 1. The company takes advantage of the reduced sales price for the 2/10/30 terms. The company pays salaries to it's employees of $5,000 The company collects $30,000 of cash from customers who paid on account The compnay collects $10,000 from a customer for an order that will not be completed until the next year. The company writes off $1,000 of accounts receivable The company purchases inventory with a cost of $5,000 on account. The terms of the purchase are 2/10 1/30 The company has sales to customers of $50,000 in cash The Inventory sold in transaction 14 is calculated to be worth $5.500 The company makes it annual payment of $75,000 on the loan to the bank The company collects $10,000 of outstanding accounts receivable On September 1 of the year, the company pays $12,000 for lease on an office. The lease term is one war. The company pays general expenses of $4.500 in cash The company pays the amount due on the inventory purchases in transaction 13. The company takes advantage of the reduced sales price for the 2/201/10 terms At the end of the year, the company has supplies on hand of $500 At the end of the year, the machine produced 8,000 units. The company uses the units of production method to calculate depreciation At the end of the year, the company accrues $10,000 of salaries due to employees At the end of the year, the company recognizes rent expense for the lease executed in transaction 18. At the end of the year, a physical count finds $2,000 of inventory on hand 1) 2 31 4) 5) 71 3) 91 10) 11) 12) 13) 14) 15) 16) 17) 18) The company purchases inventory with a cost of $10,000 on account. The terms of the purchase are 210/30 The company purchases supplies of $5,000 with cash. On January 1st of the year, the company gets a loan of $400.000 from a bank. The loan has an annual rate of interest of 3%. The al payment on the loan is $75,000 The company purchases a piece of machinery for $100,000. The machine is estimated to produce 40,000 units over its life. The company estimates the salvage value of the machine to be 55.000 The company has sales to customers of $45.000 on account The inventory sold in transaction is calculated to be worth 55.000 The company estimates that S. of the sales in transactions won't be collectable The company pays the amount due on the inventory purchased in transaction. The company take advantage of the reduced sales price for the 2/10 w/90 terms The company pays salaries to its employees of 55.000 The company collects 530,000 of cash from customers who paid on account The compnay collects 510.000 from a customer for order that will not be completed until the next year The company wit of 1,000 of counts receive The company purchases nemory with a cost of $5,000 on account. The terms of the purchase nro 2/10w30 The company has sales to or of 50,000 in Cali The inventory wild in transaction 14 is calculated to be worth $5.500 The company makes it annual payment of $75,000 on the loan to the bank The company collects $10,000 of outstanding accounts receivable On September of the year, the company pays $12,000 for lease on an office. The lease term is one year The company pays general expenses of $4,500 in cash The company pay the aut due on the inventory purchases in transaction. The company take advantage of the reduced tale price for the 2/161/30 termis. At the end of the year, the company has supplies can hand of S500 At the end of the year, the machine produced 8,000 units. The company uses the units of production method to calculate depreciation At the end of the year, the company accrues $10,000 of salaries due to employees At the end of the year, the company recognizes rent expense for the lease executed in transaction 18. At the end of the year, a physical count finds $2.000 of inventory on hand. 201 ad adi adi adj adj 0 The 10.000 OLDI O 1000 the who 00.00. The story the The Theo th wie Then the che . BH HIT 1 The 16 f . the th Al ya at is callee 10.000 therefore wa AR Allows for try Machinery And Peppe -> No La Payatile Une CO tad Debt Depreciation Salari Gari DOBIT 17.00 DO A/ wear Me w talar F HOP 1 het RE Doud Dep Tam be 1 2 TIL 11 1 HIN Foundador Spring 2021 NOTE Enterall amounts as positive numbers. The pre-populated formulas will calculate subtotals as required Renard's Book Binding Business Income Statement FYE December 31, Year xx HINT Colors cells need to be the same number 6 7 E Sales Revenue 10 Cost of Goods Sold (COGS 11 Gross Prats 11 Salaries 14 General Expenses 15 Dad Debt 16 Interest 17 Depreciation Instructions In Chapters 1 thru 7 we have explored various components of the Financial statements and the transactions that are included. This project will take a comprehensive look at the material we have covered and evaluate your proficiency with posting the transactions. You will also complete the financial statements based on these transactions. What do you need to do? Download the excel file included with the assignment attachments. Complete the transactions in a manner similar to the comple videos for Chapters 1 thru 7. After completing the transactions, prepare the financial statements for your company. Any applicable beginning balance has already been input onto the financial statements. You do not need to calculate or adjust any beginning balance item. You DO NOT need to complete a Statement of Cash Flows 19 Net Income (Low) 20 21 Nenad Book dinding Business Statement of Changes in Stockholders' Equity FYE December 11 Year XX 24 Beginning Common Stock 26 Common Stocksued 27 Ending Common Stock 29 Beginning Retained aming 29 Net incom/loul 20 Less Dividends 5 Ending retained earning 12 13 Total Stockholders' Equity 14 Orohat you compara mantereses few check Figure you have not calculated the same amounts as these check figures, you likely have an error somewhere. Ending Cash - 5298,800 Net Income $12,050 Total Assets $392.050 Renard ook dinding Business Balance Sheet HY December Year XX 17 19 Aus 40 Cih 41 AR Allowance for Doubtful Account 4) Inventory 44 Machinery 5 Acumulated Depreciation 00 Prepaid Rent 24 DE Benin Common Stock 26 Common Stock mund 27 Ending Common Stock 2 Beginning Retained Earnings 29 Net Income/(Loss) 30 Less Dividends 1 Ending retained earnings 32 33 Total Stockholders' Equity figures. If you have not cakulated the same amounts as these check figures, voukely have an error somewhere Ending Cash-$298.800 Net Income - $12,050 Total Assets $192050 36 Renard's Book Binding Business dolance Sheet PYE December Year xx 39 Assets 40 Cash 41 AR Aliowance for Doubtful Accounts Inventory 4 Machinery 45 Accumulated Depreciation 46 President 47 Supplies 40 Total Assets Sp 51 bites 52 AP 55 Loan Payable 54 Useamed Revue 15 56 Stockholders' Equity 57 Common Stock 58 Retained Earning 59 Total Stocholes Equity 60 01 Totalt and Stockholders TV 2 64 5 The company purchases inventory with a cost of $10,000 on account. The terms of the purchase are 2/10 1/30. The company purchases supplies of $5,000 with cash. On January 1st of the year, the company sets a loan of $400,000 from a bank. The loan has an annual rate of interest of 5%. The annual payment on the loan is $75,000 The company purchases a piece of machinery for $100,000. The machine is estimated to produce 40,000 units over its life. The company estimates the salvage value of the machine to be 55.000 The company has sales to customers of $45,000 on account The inventory sold in transaction 5 is calcylated to be worth $5,000 The company estimates that 5% of the safes in transaction 5 won't be collectable The company pays the amount due on the inventory purchased in transaction 1. The company takes advantage of the reduced sales price for the 2/10/30 terms. The company pays salaries to it's employees of $5,000 The company collects $30,000 of cash from customers who paid on account The compnay collects $10,000 from a customer for an order that will not be completed until the next year. The company writes off $1,000 of accounts receivable The company purchases inventory with a cost of $5,000 on account. The terms of the purchase are 2/10 1/30 The company has sales to customers of $50,000 in cash The Inventory sold in transaction 14 is calculated to be worth $5.500 The company makes it annual payment of $75,000 on the loan to the bank The company collects $10,000 of outstanding accounts receivable On September 1 of the year, the company pays $12,000 for lease on an office. The lease term is one war. The company pays general expenses of $4.500 in cash The company pays the amount due on the inventory purchases in transaction 13. The company takes advantage of the reduced sales price for the 2/201/10 terms At the end of the year, the company has supplies on hand of $500 At the end of the year, the machine produced 8,000 units. The company uses the units of production method to calculate depreciation At the end of the year, the company accrues $10,000 of salaries due to employees At the end of the year, the company recognizes rent expense for the lease executed in transaction 18. At the end of the year, a physical count finds $2,000 of inventory on hand 1) 2 31 4) 5) 71 3) 91 10) 11) 12) 13) 14) 15) 16) 17) 18) The company purchases inventory with a cost of $10,000 on account. The terms of the purchase are 210/30 The company purchases supplies of $5,000 with cash. On January 1st of the year, the company gets a loan of $400.000 from a bank. The loan has an annual rate of interest of 3%. The al payment on the loan is $75,000 The company purchases a piece of machinery for $100,000. The machine is estimated to produce 40,000 units over its life. The company estimates the salvage value of the machine to be 55.000 The company has sales to customers of $45.000 on account The inventory sold in transaction is calculated to be worth 55.000 The company estimates that S. of the sales in transactions won't be collectable The company pays the amount due on the inventory purchased in transaction. The company take advantage of the reduced sales price for the 2/10 w/90 terms The company pays salaries to its employees of 55.000 The company collects 530,000 of cash from customers who paid on account The compnay collects 510.000 from a customer for order that will not be completed until the next year The company wit of 1,000 of counts receive The company purchases nemory with a cost of $5,000 on account. The terms of the purchase nro 2/10w30 The company has sales to or of 50,000 in Cali The inventory wild in transaction 14 is calculated to be worth $5.500 The company makes it annual payment of $75,000 on the loan to the bank The company collects $10,000 of outstanding accounts receivable On September of the year, the company pays $12,000 for lease on an office. The lease term is one year The company pays general expenses of $4,500 in cash The company pay the aut due on the inventory purchases in transaction. The company take advantage of the reduced tale price for the 2/161/30 termis. At the end of the year, the company has supplies can hand of S500 At the end of the year, the machine produced 8,000 units. The company uses the units of production method to calculate depreciation At the end of the year, the company accrues $10,000 of salaries due to employees At the end of the year, the company recognizes rent expense for the lease executed in transaction 18. At the end of the year, a physical count finds $2.000 of inventory on hand. 201 ad adi adi adj adj