Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Perform comparitive horizontal analysis in excel clearer images Balance Sheet As of May 31, 2021 TOTAL 003 54894003 ODO 50.00 - ASSETS - Current Act
Perform comparitive horizontal analysis in excel clearer images Balance Sheet As of May 31, 2021 TOTAL 003 54894003 ODO 50.00 - ASSETS - Current Act - Bank Accounts Checking Total Bank Accounts - Accounts Receivable Accounts Receivable (AR) Total Accounts Receivable - Other Current Art - Inventory Asset Phone Case inventory T Shirt inventory Total Inventory Asset Total Other Current Assets Total Current Assets TOTAL ASSETS - LIABILITIES AND EQUITY - Liabilities - Curentabilities 0.00 218500 185.00 S-3185.00 545.755.03 545.755.83 71.500.00 571,500.00 $71,500.00 22812.00 $22.812.00 $94.312.00 - Current abilities - Accounts Payable Accounts Payable (AP) Total Accounts Payable Total Current Liabilities - Long Term Liabilities SBA Loan Total Long-Turm Liabilities Total Liabilities - Equity Dale BP Investor Equity Opening balance Equity Owner's Equity Owier's investment Owners Equity Retained Esming Net Income Total Equity TOTAL LIABILITIES AND EQUITY 40,000.00 0.00 10,000.00 2,500.00 0.00 7.500.00 35.61138 5-10,611.38 $83.700 62 Balance Sheet As of December 31, 2021 Balance Sheet As of December 31, 2021 TOTAL 38 41195 586,418.96 3,250.00 $3,250.00 2.78334 3.785.00 5,968 34 5-5.968.34 583,700.62 583,700.62 ASSETS - Current Assets - Bank Accounts Checking Total Bank Accounts - Accounts Receivable Accounts Receivable (ARI Total Accounts Receivable - Other Current Asset - Inventory Asset Phone Case inventory T Shirt mentory Total Inventory Asset Total Other Current Assets Total Current Assets TOTAL ASSETS LIABLITIES AND EQUITY - abilities - Curabit - Liabilities - Current Liabilities - Accounts Payable Accounts Payable (AP) Total Accounts Payable Total Current abilities - Long Term Liabile SBA Loan Total Long-Term Liabilities Total Liabilities Equity Dale BP Investor Equity Opening Balance Equity Owners Equity Owner's Investment Owners Equity Retained Eige Net Income Total Equity TOTAL LIABILITIES AND EQUITY 73,500.00 $71,500.00 571.500.00 23.916.00 523.916.00 595,416,00 40,000.00 0.00 10,000.00 2.500.00 0.00 7.500.00 -9466097 5-49,660.97 545,755.03 Balance Sheet As of May 31, 2021 TOTAL 48,940.03 $48,940.03 0.00 - ASSETS Current Assets Bank Accounts Checking Total Bank Accounts - Accounts Receivable Accounts Receivable (A/R) Total Accounts Receivable Other Current Assets Inventory Asset Phone Case Inventory T-Shirt Inventory Total Inventory Asset Total Other Current Assets Total Current Assets 50.00 0.00 -3,185.00 -3,185.00 $ -3,185.00 $45,755.03 TOTAL ASSETS $45,755.03 71,500.00 $71,500.00 $71,500.00 - LIABILITIES AND EQUITY - Liabilities Current Liabilities - Liabilities - Current Liabilities Accounts Payable Accounts Payable (A/P) Total Accounts Payable Total Current Liabilities Long Term Liabilities SBA Loan Total Long Term Liabilities Total Liabilities Equity Dale BP Investor Equity Opening Balance Equity Owner's Equity Owner's Investment Owners Equity Retained Earnings Net Income Total Equity TOTAL LIABILITIES AND EQUITY 22,812.00 $22,812.00 $94,312.00 40,000.00 0.00 10,000.00 2,500.00 0.00 -7,500.00 -55,611.38 $-10,611.38 $83,700.62 Balance Sheet As of December 31, 2021 TOTAL 86,418.96 $86,418.96 3,250.00 $3,250.00 ASSETS Current Assets - Bank Accounts Checking Total Bank Accounts - Accounts Receivable Accounts Receivable (A/R) Total Accounts Receivable Other Current Assets Inventory Asset Phone Case Inventory T-Shirt Inventory Total Inventory Asset Total Other Current Assets Total Current Assets TOTAL ASSETS -2,783.34 -3,185.00 -5,968.34 $ -5,968.34 583,700.62 $83,700.62 71,500.00 $71,500.00 $71,500.00 LIABILITIES AND EQUITY - Liabilities Current Liabilities Liabilities - Current Liabilities - Accounts Payable Accounts Payable (A/P) Total Accounts Payable Total Current Liabilities - Long Term Liabilities SBA Loan Total Long-Term Liabilities Total Liabilities Equity Dale BP Investor Equity Opening Balance Equity Owner's Equity Owner's Investment Owners Equity Retained Earnings Net Income Total Equity TOTAL LIABILITIES AND EQUITY 23,916.00 $23,916.00 $95,416.00 40,000.00 0.00 10,000.00 2,500.00 0.00 -7,500.00 -94,660.97 $-49,660.97 $45,755.03
Perform comparitive horizontal analysis in excel
clearer images
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started