Someone already answered 1-3 so I just need someone to help me out with 4

Now That all of the above 3 are answered I need help on the requirements part of this project (below)

Requirements: (See sheet tabs at bottom. Use each sheet for the following requirements.) Use Excel Skillsin completing these requirements, You must use formulas and functions, cell references, and professional formatting 1. Prepare the Panama Pajama Company multi-step income statement for the year ended December 31, 2018. 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.) Prepare the Panama Pajama Company balance sheet for December 31, 2018. 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.) Prepare the Panama Pajama Company statement ofcash flows for the year ended December 31, 2018. Use the indirect method. 2. 3. 4. Complete the analysis of the financial statements as directed on the Analysis sheet The Panama Pajama Company began operations on January 1, 2015, and is now in its third year of operations. The adjusted trial balance as of December 31, 2018 appears below, along with prior year balance sheet data and some additional transaction data for 2018 THE PANAMA PAIAMA COMPANY Adjusted Trial Balanoe 12/31/18 2018 2017 Account Title Adjusted Trial Balance Debit Balance Sheet Info Debit Cash Accounts Receivable S138,000 12,000 S35,600 11,000 Office Equipment Machinery & Tools Accumulated Depreciation-Plant Assets Accounts Payable Note Payable- Short Term Note Payable-Long Term Common Stock, $10 par Retained Earnings 26,000 59,000 20,000 21,000 8,600 12,200 10,000 33,000 9,800 50,000 11,900 11,900 Sales Revenue Cost of Goods Sold Rent Expense Advertising Expense Depreciation Expense 31,700 11,600 800 2,600 $257,400 257,400 Transaction Data for 2018 (Note, these transactions were included in the trial balance numbers above.) Cash paid for purchase of office equipment Cash paid for purchase of tools Acquisition of Machinery with Notes Payable-Long-term Cash payment of dividends Cash receipt from issuance of 10,000 shares of common stock 33,000 100,000 The Panama Pajama Company Multi Step Income Statement For the Year Ended 2018 1 Vertical Analysis Sales Revenue Less Cost of Goods Sold Gross Profit Less Expenses Rent Expense Advertising Expense Depreciation Expense Total Expenses Net Income 100.0% 36.6% 34 31700 11600 20100 63.4% 2000 800 2600 6.3% 2.5% 8.2% 10 5400 17.0% 14700 46.4% 14 15 16 Net Income (A) Number of Equity Shares (B) EPS (A/B) 14700 15000 (150000/10) 0.98 49 50 51 52 53 54 The Panama Pajama Company Balance Sheet Vertical Analysis 59.8% 5.2% 1.9% 11.3% 25.6% 3.7% 100.0% Assets Cash Accounts Receivable Inventory Office Equipment Machinery & Tools Accumulated Depreciation Plant Assets Total Assets 138000 12000 56 57 58 59 26000 59000 8600 230800 61 62 63 64 65 Liabilities &Owners Equity Accounts Payable Notes Payable - Short Term Notes Payable - Long Term Total Liabilities Common Stock Retained Earnings (11900+14700-1000) Total Liabilities & Owner's Equity 5.3% 4.3% 14.3% 23.9% 65.0% 10000 33000 55200 25600 67 230800 100.0% 68 69 The Panama Pajama Company Cash Flow Statement Cash flows from operating Activities Net Income Add Adjustments to reconcile net income to net cash provided by operating activities Depreciation Changes in Operating Assets & Liabilities Increase in Accounts receivable Decrease in Inventory Increase in Accounts Payable Decrease in Notes Payable - Short ternm Net Cash provided by Operating Activities 72 73 74 75 76 14700 2,600 1,000) 1,200 2,400 (5,500) 79 300 81 82 83 84 85 86 87 14,400 Cash Flows from Investing Activities Purchase of Tools Purchase of Office Equipment Net cash used by Investing Activities (5,000) (6,000) (11,000) Cash Flows from Financing Activities Issue of common stock Payment of Dividend Net cash Provided by Financing Activities Net Decrease in Cash & its equivalents 100,000 1,000) 89 91 9,000 102,400 92 Using the information provided in the instructions and the financial statements you have created in the previous requirements, perform the following analysis (5 Requirements): Debt-to- Requirement 1. Compute these ratios: Round ratios to two decimal places or format as percentages or currency as appropriate. CurrentWorking Ratio Capia Cash Ratio Debt Ratio Equity Ratio Inventory Days Sales in Gross Profit Receivable Days Sales in Percentage Turnover ge Turnover Receivables 2017 Total Assets- Rate of Return on Total Assets Rate of Return on TurnoverStockholders' Earnings Per Asset Ratio Share 2017 SHE Price/ EarningsDividend Dividend Current Stock Price is $5.00 per share Ratio Yield Payout Dividend per share- Requirement 2. Based on the ratios computed above analyze the company's ability to pay its debts (both current and longterm). 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. Requirement S: Based on the ratios computed above, analyze the company's utilization of assets and evaluate whether this company's stock is likely to be attractive to investors. Refer to at least 3 specific ratios in your analysis. Assume the industry average rate of return on assets is 6% and asset turnover is 1.50