please note there is 7 photos to this one problem

here is the last photo in 2 parts

B. Prepare Financial Statements Now that all of Lidia's transactions have been recorded, she needs you to prepare an Income Statement, Statement of Owner's Equity, and Balance Sheet. She will need to submit these financial statements to the bank to determine if she can secure more funding for a second location. Be sure to include proper headers, sections, and totals. Please note that all statements should be inclusive of all transactions that have occurred since the start of June. Use the provided templates to complete your work. C. Bank Reconciliation Lidia has the following information from her books and her August bank statement. She is hoping that you can reconcile her bank account for her. Then prepare a tabular analysis for any adjustments required to reach the adjusted cash balance per books. Be sure to include dates and explanations for any revenues or expenses. Use the provided templates to complete your work. Book Balance Bank Balance Deposits in transit Outstanding checks Bank charges Interest earned Health insurance auto-draft $28,600 $32,545 $3,400 $5,000, $1,800 and $975 $35 $55 $450 D. Long-Term Assets If Lidia is able to obtain the new loan, she is looking to purchase a company cargo van to help haul the merchandise inventory, as well as purchase her own container machine (a machine that makes containers so she can save on her own purchase cost). She has found the cargo van she wants to purchase, as well as the machine she'd like to buy, but wants to look ahead at which depreciation methods she should use that will help maximize the use of each, as well as increase the income after depreciation. Utilizing the information below, calculate the depreciation expense for the first two years using all three main depreciation methods (Straight-Line, Units of Production, and Double-Declining-Balance) for both the cargo van and the machine. Be sure to show your calculations. Round all dollar amounts to the nearest cent. Cargo Van Price Salvage value Useful life Total miles Yr 1 miles Yr 2 miles $26,000 $2,000 10 years 90,000 12,100 9,400 Machine Price Salvage value Useful life Total hours Yr 1 hours Yr 2 hours $48,000 $3,000 8 years 13,000 1,250 1,460 BONUS (worth 30 points - optional) E. Calculate Inventory It's been half a year and Lidia's business has really taken off. She secured her loan and has started accepting more clients, which in turn means more sales. To help with organization, she's started selling a lot more containers and baskets. Lidia has a large inventory of baskets that are all different sizes, but each unit is very similar in nature. She'd like to determine a better way to cost her basket inventory because her current method is causing too much loss and she cannot afford to continue down this path. She has provided you with the information below and would like for you to calculate the cost of goods sold and ending inventory using all three cost allocation methods (FIFO, LIFO, and Weighted Average). Use the periodic method and be sure to show all of your work to ensure Lidia can make the best decision. Beginning Inventory Purchased in Sept. Purchase in Oct. Purchase in Nov. Totals (goods avail) Ending Inventory Number of units 500 600 650 700 2450 550 Cost per unit $40 45 40 35 Total $20,000 27,000 26,000 24,500 97,500 Tabular Summary MNR 09 * 'E) | 2.500 fool 2001 NET 1230 Lise Tatuar Sumary for June, July and August Asus Cwrity Account Notes Imerest Uneamed Retained Owners Explain Revenue or calculation Dute Cash Receivable Supplies tory Equipment Payable Payable Payable Raven Capital Earrings Neues - Expenses. Drawings Expense recorded 110.000 0.000 2-Jun (230) 1.2001 Rent Expense - 12.2001 1.00 - 503 - 20.000 20,000 20 1200 Awing pente 4700 4.700 12 1250) 15-Jun 12.500) 2.500 17 11850 LARS 2-un entry 25- 3.300 3.300 29 2200 1,200 30- 200 12001 Uties Expense olun 2.15 terve 4700 30 (250) 2507 Supplies Expense 650-400 - 1001 rest Expense 20000/ 1200 1.2001 Hent Expo Bul 1435) 250 250 Avertise 6- 2.56 Service Revue 7.1 12900 (200 S. 1200) (1200 10-1 1300 1100 Sales Revenue 300 Cost of God Sold II- 1200 L200 Sales Revenue 700 Cost of Goods Sold (250 ISM 14.000 4.000 15-2001) 10 weeks 2 4250 4.250 M 1.200 1.200 Service Revente 24 1.200 1.00 Sales Revenue 11.30 1.200 Cosef Good Sold 14501 1150 20-4 (2,150 2.15 Service Revenue 4700-2350 2M 241 Secvenue 3300 30- 11.2009 1.2001 Sales Expense M 200 12001 Expense Service Revue 43500 21- 15501 Supplies Expense 125-925-07 300 14.00 nege 2000 TV 1-dug 10000 Sales Returns and Allgemees 300 Cost of Goods Sold 11.2001 3 Aug 11.900 1.500 - 250 1250 Uties Expense 6.AR 4100 4.800 Service Rover 7. 1200 (200 9.aug 5.000 5.000 10- 4200 4.200 3.700 Cost of Goods Sold 1000 14,800 1) 1250) 250 14- 2.200 Santeste- S202 weeks 16- 21. 395 Seni Rue 1300-1425 15.00 13 Sales Revue 300 3001 Cost of Goods Sold 21- 150 Service U42020 27-Aug 15.000 (5.000 24 2.200 Svet IL 700 L 2007 Cost of Goods Sold 27.Aug 1975) 1975) 20-0) (1.000 States Expense=15920 3 weeks 314 200 (2001 Utilities Expense 2.550 Service revenue 1250-450-100 (1.225 11,225 Supplies Expenses 1500 21- 300 100 Inter Experte 200000/12 Totals 1200 3.900 5,150 200 20,00 MOO 30.01. (2275) 11.425 lol = looch lot 009 09 . 05806 Tabular Summary 13-Jun 1250 Lidia Tabular Summary for lune, July and August Assets Liabilties Owners Equity Accounts Accounts Notes Interest Uneared. Retained Owners Explain Revenue or calculation Date Cash Receivable Supplies Inventory Equipment Payable Payable Payable Revenue - Capital Earnings Revenues. Experies Drawings Expense Recorded 1-Jun 10,000 10,000+ 2.Jun 11.2001 (1.2001 Rent Expense 3-Jun (3,300) 3,300 -un (650) 650 4-Jun 20,000 20,000 5-Jun 250 (250) Advertising Expense 7-Jun 4,700 4.700 (250) 15-Jun 12.500) 2.500 17-Jun 11,850) 1.650 22. Jun No Entry 25-Jun 3,300 3.100 2-un 1200 1200 30-Jun 200 (200) Utilities Expense 30 jun (2,350) 2,350 Service Revenue 4700 50% 30-un (250) (250) Supplies Expense 650-400 30-un 100 (100) Interest Expense 200006% 1/12 2 Jul (1.2001 (1.2001 Rent Expense -ul (475) 5-ul 250 (250) Advertising Expense 6-Jul 2.500 2.500 Service Revenue 7-Jul (200) (200) 9. Jul 11.2001 (1.2009 10- 1,300 1.300 Sales Revenue (800) (800) Cost of Goods Sold 11 1.200 L200 Sales Revenue 17001 (700) Cost of Goods Sold 11 (2501 12501 15-1 14.000 4.000 15- 11.2001 11.2001 Salaries Expense was us$202 weeks 2 2014 4.250 4.250 24u 1.200 1.200 Service Revenue MU 1,700 1.700 Sales Revenue (1200) 11.2001 Cost of Goods Sold 475 25-1 (6501 12.350) (2.475) 2,350 2.4) (650) 20-Jul 20. Jul 30- 11.2001 31-Jul 31-Jul 31-01 31-Jul 1.Aug (600) 200 (1.2001 (2001 1850 850 (550) Service Revenue 4700-2350 Service Revenue 3300*738 Salaries Expense #15 hrs 5202 weeks '2 Utilities Expense Service Revenue 4250 20% Supplies Expense 325-650+250-475 interest Expense 20000*6%*1/12 Sales Returns and Allowances Cost of Goods Sold Rent Expense 100 (550) (100) (600) 100 100 11.2001 1.500 250 (2501 2-Aug (1.2001 3.Aug (1.5001 5-Aug 6-Aug ) (200) 9. Aug 10- Aug 4,200 4,800 Utilities Expense Service Revenue 7. (200) 5.000 5.000 4200 4,200 (3.700) (3,7001 Sales Revenue Cost of Goods Sold 14.800 (250) 10-Aug 4,800 1-A (250) 14-Aug (1.2001 16-Aug 19-Aug 1.300 (825) . (1.2001 825 1.300 Salaries Expense 15hrs $20*2 weeks 2 Service Revenue 3300-2475 Sales Revenue Cost of Goods Sold Service Revenue 4250 20% (800) (800) (850) . 850 21 Aug 23-Aug (5,000) 24-Aug 2.200 15.000) 2.200 Sales Revenue Cost of Goods Sold (1.700) (1.700 1975) 200 27-A (975) 29-Aug (1.100) 31 Aug 31 Aug 31 Aug 31 Aug Totals 28,600 (2.550) (L.300) (200) 2.550 (1.225) (100) 30,850 (20,275) Salaries Expense 15 hrs $2003 weeks 2 Utilities Expense Service Revenue 4250-850-850 Supplies Expense 600-125-1500 Interest Expense 20000*6% 1/12 11,225) 100 300 1,200 600 3,900 5,150 - 200 20,000 . 10,000 (1.625) B. Prepare Financial Statements Now that all of Lidia's transactions have been recorded, she needs you to prepare an Income Statement, Statement of Owner's Equity, and Balance Sheet. She will need to submit these financial statements to the bank to determine if she can secure more funding for a second location. Be sure to include proper headers, sections, and totals. Please note that all statements should be inclusive of all transactions that have occurred since the start of June. Use the provided templates to complete your work. C. Bank Reconciliation Lidia has the following information from her books and her August bank statement. She is hoping that you can reconcile her bank account for her. Then prepare a tabular analysis for any adjustments required to reach the adjusted cash balance per books. Be sure to include dates and explanations for any revenues or expenses. Use the provided templates to complete your work. Book Balance Bank Balance Deposits in transit Outstanding checks Bank charges Interest earned Health insurance auto-draft $28,600 $32,545 $3,400 $5,000, $1,800 and $975 $35 $55 $450 D. Long-Term Assets If Lidia is able to obtain the new loan, she is looking to purchase a company cargo van to help haul the merchandise inventory, as well as purchase her own container machine (a machine that makes containers so she can save on her own purchase cost). She has found the cargo van she wants to purchase, as well as the machine she'd like to buy, but wants to look ahead at which depreciation methods she should use that will help maximize the use of each, as well as increase the income after depreciation. Utilizing the information below, calculate the depreciation expense for the first two years using all three main depreciation methods (Straight-Line, Units of Production, and Double-Declining-Balance) for both the cargo van and the machine. Be sure to show your calculations. Round all dollar amounts to the nearest cent. Cargo Van Price Salvage value Useful life Total miles Yr 1 miles Yr 2 miles $26,000 $2,000 10 years 90,000 12,100 9,400 Machine Price Salvage value Useful life Total hours Yr 1 hours Yr 2 hours $48,000 $3,000 8 years 13,000 1,250 1,460 BONUS (worth 30 points - optional) E. Calculate Inventory It's been half a year and Lidia's business has really taken off. She secured her loan and has started accepting more clients, which in turn means more sales. To help with organization, she's started selling a lot more containers and baskets. Lidia has a large inventory of baskets that are all different sizes, but each unit is very similar in nature. She'd like to determine a better way to cost her basket inventory because her current method is causing too much loss and she cannot afford to continue down this path. She has provided you with the information below and would like for you to calculate the cost of goods sold and ending inventory using all three cost allocation methods (FIFO, LIFO, and Weighted Average). Use the periodic method and be sure to show all of your work to ensure Lidia can make the best decision. Beginning Inventory Purchased in Sept. Purchase in Oct. Purchase in Nov. Totals (goods avail) Ending Inventory Number of units 500 600 650 700 2450 550 Cost per unit $40 45 40 35 Total $20,000 27,000 26,000 24,500 97,500 Tabular Summary MNR 09 * 'E) | 2.500 fool 2001 NET 1230 Lise Tatuar Sumary for June, July and August Asus Cwrity Account Notes Imerest Uneamed Retained Owners Explain Revenue or calculation Dute Cash Receivable Supplies tory Equipment Payable Payable Payable Raven Capital Earrings Neues - Expenses. Drawings Expense recorded 110.000 0.000 2-Jun (230) 1.2001 Rent Expense - 12.2001 1.00 - 503 - 20.000 20,000 20 1200 Awing pente 4700 4.700 12 1250) 15-Jun 12.500) 2.500 17 11850 LARS 2-un entry 25- 3.300 3.300 29 2200 1,200 30- 200 12001 Uties Expense olun 2.15 terve 4700 30 (250) 2507 Supplies Expense 650-400 - 1001 rest Expense 20000/ 1200 1.2001 Hent Expo Bul 1435) 250 250 Avertise 6- 2.56 Service Revue 7.1 12900 (200 S. 1200) (1200 10-1 1300 1100 Sales Revenue 300 Cost of God Sold II- 1200 L200 Sales Revenue 700 Cost of Goods Sold (250 ISM 14.000 4.000 15-2001) 10 weeks 2 4250 4.250 M 1.200 1.200 Service Revente 24 1.200 1.00 Sales Revenue 11.30 1.200 Cosef Good Sold 14501 1150 20-4 (2,150 2.15 Service Revenue 4700-2350 2M 241 Secvenue 3300 30- 11.2009 1.2001 Sales Expense M 200 12001 Expense Service Revue 43500 21- 15501 Supplies Expense 125-925-07 300 14.00 nege 2000 TV 1-dug 10000 Sales Returns and Allgemees 300 Cost of Goods Sold 11.2001 3 Aug 11.900 1.500 - 250 1250 Uties Expense 6.AR 4100 4.800 Service Rover 7. 1200 (200 9.aug 5.000 5.000 10- 4200 4.200 3.700 Cost of Goods Sold 1000 14,800 1) 1250) 250 14- 2.200 Santeste- S202 weeks 16- 21. 395 Seni Rue 1300-1425 15.00 13 Sales Revue 300 3001 Cost of Goods Sold 21- 150 Service U42020 27-Aug 15.000 (5.000 24 2.200 Svet IL 700 L 2007 Cost of Goods Sold 27.Aug 1975) 1975) 20-0) (1.000 States Expense=15920 3 weeks 314 200 (2001 Utilities Expense 2.550 Service revenue 1250-450-100 (1.225 11,225 Supplies Expenses 1500 21- 300 100 Inter Experte 200000/12 Totals 1200 3.900 5,150 200 20,00 MOO 30.01. (2275) 11.425 lol = looch lot 009 09 . 05806 Tabular Summary 13-Jun 1250 Lidia Tabular Summary for lune, July and August Assets Liabilties Owners Equity Accounts Accounts Notes Interest Uneared. Retained Owners Explain Revenue or calculation Date Cash Receivable Supplies Inventory Equipment Payable Payable Payable Revenue - Capital Earnings Revenues. Experies Drawings Expense Recorded 1-Jun 10,000 10,000+ 2.Jun 11.2001 (1.2001 Rent Expense 3-Jun (3,300) 3,300 -un (650) 650 4-Jun 20,000 20,000 5-Jun 250 (250) Advertising Expense 7-Jun 4,700 4.700 (250) 15-Jun 12.500) 2.500 17-Jun 11,850) 1.650 22. Jun No Entry 25-Jun 3,300 3.100 2-un 1200 1200 30-Jun 200 (200) Utilities Expense 30 jun (2,350) 2,350 Service Revenue 4700 50% 30-un (250) (250) Supplies Expense 650-400 30-un 100 (100) Interest Expense 200006% 1/12 2 Jul (1.2001 (1.2001 Rent Expense -ul (475) 5-ul 250 (250) Advertising Expense 6-Jul 2.500 2.500 Service Revenue 7-Jul (200) (200) 9. Jul 11.2001 (1.2009 10- 1,300 1.300 Sales Revenue (800) (800) Cost of Goods Sold 11 1.200 L200 Sales Revenue 17001 (700) Cost of Goods Sold 11 (2501 12501 15-1 14.000 4.000 15- 11.2001 11.2001 Salaries Expense was us$202 weeks 2 2014 4.250 4.250 24u 1.200 1.200 Service Revenue MU 1,700 1.700 Sales Revenue (1200) 11.2001 Cost of Goods Sold 475 25-1 (6501 12.350) (2.475) 2,350 2.4) (650) 20-Jul 20. Jul 30- 11.2001 31-Jul 31-Jul 31-01 31-Jul 1.Aug (600) 200 (1.2001 (2001 1850 850 (550) Service Revenue 4700-2350 Service Revenue 3300*738 Salaries Expense #15 hrs 5202 weeks '2 Utilities Expense Service Revenue 4250 20% Supplies Expense 325-650+250-475 interest Expense 20000*6%*1/12 Sales Returns and Allowances Cost of Goods Sold Rent Expense 100 (550) (100) (600) 100 100 11.2001 1.500 250 (2501 2-Aug (1.2001 3.Aug (1.5001 5-Aug 6-Aug ) (200) 9. Aug 10- Aug 4,200 4,800 Utilities Expense Service Revenue 7. (200) 5.000 5.000 4200 4,200 (3.700) (3,7001 Sales Revenue Cost of Goods Sold 14.800 (250) 10-Aug 4,800 1-A (250) 14-Aug (1.2001 16-Aug 19-Aug 1.300 (825) . (1.2001 825 1.300 Salaries Expense 15hrs $20*2 weeks 2 Service Revenue 3300-2475 Sales Revenue Cost of Goods Sold Service Revenue 4250 20% (800) (800) (850) . 850 21 Aug 23-Aug (5,000) 24-Aug 2.200 15.000) 2.200 Sales Revenue Cost of Goods Sold (1.700) (1.700 1975) 200 27-A (975) 29-Aug (1.100) 31 Aug 31 Aug 31 Aug 31 Aug Totals 28,600 (2.550) (L.300) (200) 2.550 (1.225) (100) 30,850 (20,275) Salaries Expense 15 hrs $2003 weeks 2 Utilities Expense Service Revenue 4250-850-850 Supplies Expense 600-125-1500 Interest Expense 20000*6% 1/12 11,225) 100 300 1,200 600 3,900 5,150 - 200 20,000 . 10,000 (1.625)