Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please note there are 8 photos to this one problem. please fet back to me asap there is 10 Actually ASSETS LIABILITIES OWNER'S EQUITY Retainers

please note there are 8 photos to this one problem. please fet back to me asap
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
there is 10 Actually
image text in transcribed
image text in transcribed
ASSETS LIABILITIES OWNER'S EQUITY Retainers Date Cash Accts Res Interest Par . Epla Supp laven + Equip Catal Acts Pay Ray Rey 18 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 ASSETS LABILITIES OWNERS EQUITY Reidamine Las or to Date ca Atsilec - Se Accti Pay Interest Book ii ) ASSETS LIABILITIES OWNER'S EQUITY Retainers Date Cash Accts Res Interest Par . Epla Supp laven + Equip Catal Acts Pay Ray Rey 18 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 ASSETS LABILITIES OWNERS EQUITY Reidamine Las or to Date ca Atsilec - Se Accti Pay Interest Book ii )

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Cost Accounting

Authors: Edward J. Vanderbeck

12th Edition

0324100949, 978-0324100945

More Books

Students also viewed these Accounting questions

Question

How would you support more positive behaviors and help

Answered: 1 week ago