Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
please note there is 4 pictures to this problem all the info j was givibg is in the pictures B. Prepare Financial Statements Now that
please note there is 4 pictures to this problem
all the info j was givibg is in the pictures 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 $28,600 Bank Balance $32,545 Deposits in transit $3,400 Outstanding checks $5,000, $1,800 and $975 Bank charges $35 Interest earned $55 Health insurance auto-draft $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 $26,000 Machine Price $48,000 Salvage value $2,000 Salvage value $3,000 Useful life 10 years Useful life 8 years Total miles 90,000 Total hours 13,000 Yr 1 miles 12,100 Yr 1 hours 1,250 Yr 2 miles 9,400 Yr 2 hours 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. Number of units 500 600 650 700 2450 550 Cost per unit $40 45 40 Beginning Inventory Purchased in Sept. Purchase in Oct. Purchase in Nov. Totals (goods avail) Ending Inventory Total $20,000 27,000 26,000 24,500 97,500 35 Tabular Analysis FS Templates Bank Rec ASSETS LIABILITIES Interest Accs Pay Pay Dats Acts Rec Cash OWNER'S EQUITY Retained Earnings Owner Rey Exp Draw Supp Inven Uncam Rey Fruin Capital Explain Revor Exp only + + + ANNES LI MAN Om 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 $28,600 Bank Balance $32,545 Deposits in transit $3,400 Outstanding checks $5,000, $1,800 and $975 Bank charges $35 Interest earned $55 Health insurance auto-draft $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 $26,000 Machine Price $48,000 Salvage value $2,000 Salvage value $3,000 Useful life 10 years Useful life 8 years Total miles 90,000 Total hours 13,000 Yr 1 miles 12,100 Yr 1 hours 1,250 Yr 2 miles 9,400 Yr 2 hours 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. Number of units 500 600 650 700 2450 550 Cost per unit $40 45 40 Beginning Inventory Purchased in Sept. Purchase in Oct. Purchase in Nov. Totals (goods avail) Ending Inventory Total $20,000 27,000 26,000 24,500 97,500 35 Tabular Analysis FS Templates Bank Rec ASSETS LIABILITIES Interest Accs Pay Pay Dats Acts Rec Cash OWNER'S EQUITY Retained Earnings Owner Rey Exp Draw Supp Inven Uncam Rey Fruin Capital Explain Revor Exp only + + + ANNES LI MAN Om
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668edafcd366f_204668edafc7a35c.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668edafdb9684_205668edafd30f13.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668edafe81e4f_206668edafe1268a.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668edaff21a93_206668edafeb41b6.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668edaffc1f23_207668edaff50983.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started