please note there are 10 pictures to this problem

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 ASSETS LIABILITIES Date Cash Accts Rec Interest Pay + OWNER'S EQUITY Retained Earnings Owner END Draw Ungarn Rev Expl Sugp - Capital Inven + Equip Accs Pay + Rey On = = ASSETS LALITIES OWNERSEQUAT DateCa Acts Rec Su Accti Pay Interest Logo Book 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 ASSETS LIABILITIES Date Cash Accts Rec Interest Pay + OWNER'S EQUITY Retained Earnings Owner END Draw Ungarn Rev Expl Sugp - Capital Inven + Equip Accs Pay + Rey On = = ASSETS LALITIES OWNERSEQUAT DateCa Acts Rec Su Accti Pay Interest Logo Book