Can I get this by tomorrow, ASAP

please use excel

ACCT 2023 PROJECT 1 2 Solar Solutions began operations on January 1, 2015, and is now in its sixth year of operations. It is a retail sales company with a large amount of online sales. 3. The adjusted trial balance as of December 31, 2020 appears below, along with prior year balance sheet data and some additional transaction data for 2020. SOLAR SOLUTIONS Adjusted Trial Balance 12/31/2020 Account Title ###### 35,000 6,000 15,600 47,000 21,000 (16,000) ###### Cash Accounts Receivable Prepaid Insurance Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Salaries Payable Sales Tax Payable Note Payable-Long Term Common Stock, $10 par Retained Earnings Dividends Sales Revenue Cost of Goods Sold Rent Expense Salaries Expense Insurance Expense Advertising Expense Depreciation Expense Interest Expense Income Tax Expense 2020 2019 Adjusted Trial Balance Post-Closing Trial Balance Debit Credit Debit Credit $ 122,200 $ 125,600 55,000 35,000 5,000 6,000 46,000 15,600 63,000 47,000 59,000 21,000 $ 21,000 16,000 11,200 16,800 2,600 2,700 2,000 4,000 31,000 22,100 240,000 160,000 28,600 28,600 10,000 235,000 127,600 20,000 36,000 11,800 6,000 5,000 1,800 3,000 $ 571,400 $ 571,400 $ 250,200 250,200 Page 1 Requirements: (See sheet tabs at bottom. Use each sheet for the following requirements.) Use Excel Skills in completing these requirements. You must use formulas and functions, cell references, and professional formatting. 1. Using examples from your textbook, or online research, prepare the Solar Solutions multi-step income statement for the year ended December 31, 2020. Include the EPS at the bottom. Also include a vertical analysis column at the right and perform a vertical analysis of the income statement. (Use percentage format with 1 decimal place.) 2. Prepare the Solar Solutions balance sheet for December 31, 2020. Include a vertical analysis column at the right and perform a vertical analysis of the balance sheet. (Use the percentage format with 1 decimal place.) 3. Prepare the Solar Solutions statement of cash flows for the year ended December 31, 2020. Use the indirect method. Your textbook has examples of this. 4. Complete the analysis of the financial statements as directed on the Analysis sheet. Use percentage format where appropriate with 2 decimal places. 5. Complete the analyis of the investment options between this company and EBUY (ratios given). Also use the chart from the attached article, and any other source to analyze the impact of using GAAP vs. IFRS> Write short response (15-30 sentences) on your analysis. Vert. Analysis Amount ($) Amount ($) Percent (%) 235000 100 127600 54.2978723 107,400 SOLAR SOLUTIONS Income Statement Year Ended December 31, 2020 Particulars Sales Revenue Less: Cost of Goods Sold Gross Profit Expenses: Rent Expanses Salaries Expenses Insurance Expenses Advertising Expanses Depreciation Expenses Interest Expenses Income Tax Expenses Total Expenses Net Income 20,000 36,000 11,800 6,000 5,000 1,800 3,000 8.5106383 15.3191489 5.0212766 2.55319149 2.12765957 0.76595745 1.27659574 83,600 35.5744681 23,800 10.1276596 A B D SOLAR SOLUTIONS Balance Sheet December 31, 2020 Vert. Analysis Current Assets Cash Accounts Receivable Prepaid Insurance Inentory $122,200 $55,000 $5,000 $46,000 37% 17% 2% 14% $228,200 Fixed Assets Office Equipment Machinery & Tools Accumulated Depreciation $63,000 $59,000 ($21,000) 69% 19% 18% -6% 31% 100% $143,000 $371,200 Total Assets Current Liabilities Accounts Payable Salaries Payable Sales Tax Payable $11,200 $2,600 $2,000 3% 1% 1% 15% $15,800 Long Term Liabilties Note Payable-Long Term Common Stock, $10 per Retained Earnings Less: Dividends Add: Profit for the Year $31,000 $240,000 $28,600 ($10,000) $23,800 9% 73% 9% -3% 7% 95% 100% $313,400 $329,200 Total Using the information provided in the instructions and the financial statements you have created in the previous requirements, perform the following analysis (5 Requirements): Current Ratio Working Capital Debt-to- Debt Ratio Equity Ratio Cash Ratio Requirement 1. Compute these ratios: Round ratios to two decimal places or format as percentages or currency as appropriate. Inventory Days Sales in Turnover Inventory Accounts Days Sales Gross Profit Receivable in Percentage Turnover Receivables 2019 Total Assets = Rate of Rate of Asset Return on Turnover Return on Stockholders Earnings 'Equity Per Share Total Assets Ratio 2019 SHE = *Current Stock Price is $10.00 per share Price/ Earnings Ratio* Dividend Yield Dividend Payout Dividend per share= Requirement 2. Based on the ratios computed above, analyze the company's ability to pay its debts (both current and long term). Refer to at least 3 specific ratios in your analysis. Requirement 3: Based on the ratios computed above, analyze the company's management of inventory. Refer to at least 2 specific ratios in your analysis. Requirement 4: Based on the ratios computed above, analyze the company's management of receivables. Refer to at least 2 specific ratios in your analysis. You have just received a large annual bonus at work, and have decided to invest it in stocks for your retirement. You have been analyzing different stocks and have narrowed your choice to two possibilities. You can either invest in Solar Solutions, or in EBUY. EBUY's ratios are given below. Select 3 ratios you might use to determine which stock to invest in and make a choice. Defend your selection with quality reasoning. The second part of your analysis is to read the article attached to this assignment. On pages 117-120, there is a chart that summarizes some of the differences between GAAP and IFRS. Explain the general similarities and differences, and discuss how interest expense would be presented on the Statement of Cash Flows. Include in your discussion any differences between GAAP and IFRS. Would that impact your investment decision above? Your answer will be graded on analysis, logic, and writing skills. EBUY Ratios: Current Working Ratio Capital 5.00 $ 300,000 Debt-to- Equity Ratio 0.40 Cash Ratio Debt Ratio 4.00 0.35 Days Accounts Sales in Inventory Days Sales Gross Profit Receivable Receiva Turnover in Inventory Percentage Turnover bles 7.25 50.34 48% 7.50 48.67 Rate of Return on Total Assets 8% Rate of Asset Return on Turnover Stockholder Earnings Ratio s' Equity Per Share 1.50 15% 15.40 Price/ Earnings Ratio* 14.50 Dividend Yield 2.00% Dividend Payout 12% 1. Which three ratios would you choose to analyze which company would be a better INVESTMENT for you? Think about which ratios help investors. Investment ratios usually include the P/E ratio, the dividend yield, the EPS and the Dividend payout ratio. All ratios are relevant in that they show how well the company is operating. 2. Based on your selection of ratios above, which company has better ratios for investors? Which company would you invest in? Why? . 1 3. Read the article attached on the assignment in CANVAS. Focus on pages 117-120, and explain the general similarities AND differences between GAAP and IFRS