Please Help! If you can show step by step that'll be great. Thank You.

A financial ratio analysis will spotlight potential issues that a business may not even be aware of. A good counselor follows several steps. The first is listening to the clients story. Make notes. The second step is performing a complete financial analysis. You must understand the ratios, and what they are telling you. There are many financial ratios, but not every ratio is needed in every case. However, there are several ratios that are needed in every instance. These include the liquidity ratios, both current and quick, the solvency ratio, debt to equity ratio, inventory turnover ratio, days receivable, and payables, and net profit ratio.

Other ratios that may be needed, at your discretion on case by case basis, include:

1. Profitability Ratios

A. ROA

B. ROE

C. COGS

D. ROI

2. Efficiency Ratios

A. Accounts receivable ratio

B. Fixed asset turnover

3. Coverage Ratio

A. Times interest earned

B. Debt service ratio

4. Market Ratios

A. Dividend yield

B. P/E Ratio

C. EPS

D. Dividend Payout Ratio

Analyze the company with the ratios you deem important to this case. The client has come to you for assistance. The owner wants to expand to another location in Raleigh. Should the owner continue on this venture?

04 D E F G H L M Balance Sheet 2013 2014 2015 27190 119731 43979 3231 6375 -7973 139597 26200 650 3231 5888 94831 29354 1725 8965 425 55330 34637 200506 196342 184742 667281 -260578 690456 -306209 712332 372395 2 3 4 Current Assets S 6 cash 7 Accounts Receivable 8 Inventory 9 Deposits 10 Prepaid Expenses 11 Loan to employee 12 Loan to stockholder 13 TOTAL CURRENT ASSETS 14 15 FIXED ASSETS 16 Property, Plant, & Equipment 17 Accumulated Depreciation 18 19 Total Fixed Assets 20 21 Other Assets 22 Intangibles e 23 Accumulated Amortization 24 25 Total Other Assets 26 27 Total Assets 28 29 30 Current Liabilites 31 32 Accouts payable Ste 33 Current long term debt 34 Federal tax payable 35 sales tax utice36 Accrued payroll 37 Payroll taxes payable 406703 384247 339937 112207 -64128 112207 -69992 112207 -73129 48079 42225 39078 655288 622814 563757 133818 66919 2848 162961 30609 1326 1025 16707 123159 40877 0 814 24551 7620 18757 Jun 38 197021 224027 212710 ma 39 TOTAL CURRENT LIABILITIES Sheet1 le Editing Ideas Sensitive A D G H L M 0 11 Long term liabilites 12 Notes payable bank) 33 Loans from stockholders N 269139 26500 257911 181748 295639 35 TOTAL LONG TERM LIBILITIES 96 27 Total Liabilities 257911 181748 519666 470621 378769 26325 -183736 293033 26325 -18.3736 309604 26126 -183736 342338 135622 152193 184988 655288 622814 516757 49 Equity 50 Common stock 51 Treasury stock 52 Retained Earning 53 54 TOTAL EQUITY 55 S6 TOTAL LIABILITIES and EQUITY 57 58 59 GO 61 INCOME STATEMENT 62 63 Revenue 64 55 Sales 56 Other income 67 Tatal revenue 68 COGS 69 Purchases 70 Labor 71 Commissions 72 Truck expenses 73 Delivery Equipment maintenance 74 Equipment Rental 75 Frecht 75 Takes - Payroll 77 Utilities 2386446 2463173 129893 2593266 2386446 30575 107844 3165712 1.13.2005 856076 740446 628955 0 0 59455 11666 6191 32498 345136 627020 807 20879 O 10487 24461 0 26910 1995 26004 0 149 18:22 Sheet1 2 tv 1 A W 2386446 2386446 2463373 129893 2593266 3057868 107844 3165712 740446 628955 0 1332005 556076 0 59455 11666 6191 48115 19377 79248 845136 627020 807 20879 0 10487 24461 0 26918 116115 37498 0 19963 26004 0 1469 53414 1593453 1671823 2174719 5 Sales 5 Other income Total revenue 8 COGS 19 Purchases 0 Labor 1 Commissions 2 Truck expenses 3 Delivery Equipment maintenance *4 Equipment Rental 5 Freight 6 Taxes - Payroll 27 Utilities 78 Supplies 79 80 Total COGS 81 82 Gross Profit 83 84 Total operating expenses 85 86 Net income 87 Gain/loss on asset sale 88 EBIT 89 Income taxes 90 Net income/loss 91 92 93 94 95 96 97 98 99 792993 921443 990993 891268 942396 769649 30175 LESS 23344 -2237 21107 3257 17850 41360 25649 + w Sheet1 O A otv 04 D E F G H L M Balance Sheet 2013 2014 2015 27190 119731 43979 3231 6375 -7973 139597 26200 650 3231 5888 94831 29354 1725 8965 425 55330 34637 200506 196342 184742 667281 -260578 690456 -306209 712332 372395 2 3 4 Current Assets S 6 cash 7 Accounts Receivable 8 Inventory 9 Deposits 10 Prepaid Expenses 11 Loan to employee 12 Loan to stockholder 13 TOTAL CURRENT ASSETS 14 15 FIXED ASSETS 16 Property, Plant, & Equipment 17 Accumulated Depreciation 18 19 Total Fixed Assets 20 21 Other Assets 22 Intangibles e 23 Accumulated Amortization 24 25 Total Other Assets 26 27 Total Assets 28 29 30 Current Liabilites 31 32 Accouts payable Ste 33 Current long term debt 34 Federal tax payable 35 sales tax utice36 Accrued payroll 37 Payroll taxes payable 406703 384247 339937 112207 -64128 112207 -69992 112207 -73129 48079 42225 39078 655288 622814 563757 133818 66919 2848 162961 30609 1326 1025 16707 123159 40877 0 814 24551 7620 18757 Jun 38 197021 224027 212710 ma 39 TOTAL CURRENT LIABILITIES Sheet1 le Editing Ideas Sensitive A D G H L M 0 11 Long term liabilites 12 Notes payable bank) 33 Loans from stockholders N 269139 26500 257911 181748 295639 35 TOTAL LONG TERM LIBILITIES 96 27 Total Liabilities 257911 181748 519666 470621 378769 26325 -183736 293033 26325 -18.3736 309604 26126 -183736 342338 135622 152193 184988 655288 622814 516757 49 Equity 50 Common stock 51 Treasury stock 52 Retained Earning 53 54 TOTAL EQUITY 55 S6 TOTAL LIABILITIES and EQUITY 57 58 59 GO 61 INCOME STATEMENT 62 63 Revenue 64 55 Sales 56 Other income 67 Tatal revenue 68 COGS 69 Purchases 70 Labor 71 Commissions 72 Truck expenses 73 Delivery Equipment maintenance 74 Equipment Rental 75 Frecht 75 Takes - Payroll 77 Utilities 2386446 2463173 129893 2593266 2386446 30575 107844 3165712 1.13.2005 856076 740446 628955 0 0 59455 11666 6191 32498 345136 627020 807 20879 O 10487 24461 0 26910 1995 26004 0 149 18:22 Sheet1 2 tv 1 A W 2386446 2386446 2463373 129893 2593266 3057868 107844 3165712 740446 628955 0 1332005 556076 0 59455 11666 6191 48115 19377 79248 845136 627020 807 20879 0 10487 24461 0 26918 116115 37498 0 19963 26004 0 1469 53414 1593453 1671823 2174719 5 Sales 5 Other income Total revenue 8 COGS 19 Purchases 0 Labor 1 Commissions 2 Truck expenses 3 Delivery Equipment maintenance *4 Equipment Rental 5 Freight 6 Taxes - Payroll 27 Utilities 78 Supplies 79 80 Total COGS 81 82 Gross Profit 83 84 Total operating expenses 85 86 Net income 87 Gain/loss on asset sale 88 EBIT 89 Income taxes 90 Net income/loss 91 92 93 94 95 96 97 98 99 792993 921443 990993 891268 942396 769649 30175 LESS 23344 -2237 21107 3257 17850 41360 25649 + w Sheet1 O A otv