Do My Homework / Homework Help Answers / Accounting Information System Homework Help / analyze the financial situation using financial ratios

analyze the financial situation using financial ratios

Need help with this question or any other Accounting Information System assignment help task?

the tasks needed to be answered are all of them. its not a hard task, using the formulas in the excel file it wouldn't be difficult to solve. the questions are similar
Additional Instructions:
Example 1 roe 15% ros 10% ta 20 equity ratio 80% equity: 16 NI 2.4 sales 24 asset turnover 1.2 liabilities 4 debt ratio 0.2 Example 2 2020 2019 liquidity l3 2.3480573261 1.5042602634 l2 1.5931955666 1.0282941733 l1 0.0330071861 0.0229365694 Balance sheet (€) Assets 2020 2019 E+L 2020 2019 Non-current assets 84,103 86,611 Equity 92,901 97,730 Indebtedness 2020 2019 Tangible fixed assets 84,103 86,611 Shareholders equity 75,000 75,000 Self-financing 0.655 0.624 Current assets 57,835 69,912 Capital fonds 100 100 Level of Indebtedness 0.345 0.376 Inventory 18,593 22 121 Profit or loss for the accounting period 17,801 22,630 1 1 Short-term accounts receivable 38,429 46,725 Liabilities 49,037 58,793 Cash 813 1,066 Reserves 5,982 1,829 Short-term liabilities 24,631 46,476 Long-term bank loans 18,424 10,488 2020 2019 Total assets 141,938 156,523 Total E+L 141,938 156,523 Profitability ROE 0.1916 0.2316 horizontal analysis Assets index analysis abs diff E+L index abs diff Non-current assets -2.90% -2,508 Equity -4.94% -4,829 Tangible fixed assets -2.90% -2,508 Shareholders equity 0.00% 0 Current assets -17.27% -12,077 Capital fonds 0.00% 0 Inventory ERROR:#VALUE! ERROR:#VALUE! Profit or loss for the accounting period -21.34% -4,829 Short-term accounts receivable -17.75% -8,296 Liabilities -16.59% -9,756 Cash -23.73% -253 Reserves 227.06% 4,153 ERROR:#DIV/0! 0 Short-term liabilities -47.00% -21,845 ERROR:#DIV/0! 0 Long-term bank loans 75.67% 7,936 Total assets -9.32% -14,585 Total E+L -9.32% -14,585 vertical Assets 2020 2019 E+L 2020 2019 Non-current assets 59.25% 55.33% Equity 65.45% 62.44% Tangible fixed assets 59.25% 55.33% Shareholders equity 52.84% 47.92% Current assets 40.75% 44.67% Capital fonds 0.07% 0.06% Inventory 13.10% ERROR:#VALUE! Profit or loss for the accounting period 12.54% 14.46% Short-term accounts receivable 27.07% 29.85% Liabilities 34.55% 37.56% Cash 0.57% 0.68% Reserves 4.21% 1.17% 0.00% 0.00% Short-term liabilities 17.35% 29.69% 0.00% 0.00% Long-term bank loans 12.98% 6.70% Total assets 100.00% 100.00% Total E+L 100.00% 100.00% Example 3 Assets in € E+L in € Non-current assets 1000000 Equity 2000000 Current assets 3000000 Shareholders equity 500000 Inventory 2000000 Profit or loss for the accounting period 1500000 Accounts receivable 800000 Liabilities 2000000 Cash 200000 Short-term liabilities 2000000 Total Assets 4000000 Total E+L 4000000 sales 10 total assets 4 net income 1.5 inventory 5 ros 15% inventory 2 total liquidity 1.5 debt 8 asset turnover 146 debt ratio 0.5 current assets 12 receivables 29.2 accounts rec 0.8 Example 4 2020 2019 2018 Profit for the accounting period 721,246 620,848 508,616 Income tax 246,299 266,689 178,663 Interest expense (cost) 1,958 4,241 10,428 Depreciation 669,286 622,661 583,415 Solution : v € 2020 2019 2018 EAT (earning after tax) 721,246 620,848 508,616 + income tax 246,299 266,689 178,663 = EBT (earning before tax) 967,545 887,537 687,279 + Interest expense (cost) 1,958 4,241 10,428 = EBIT ( earning b4 interest and tax) 969,503 891,778 697,707 + Depreciation 669,286 622,661 583,415 = EBITDA (earning before tax,interest and depreciation) 1,638,789 1,514,439 1,281,122 Example 3: The company XYZ reported a return on equity of 15% and a return on sales of 10% last year. The volume of total assets was 20 mil. € and an equity ratio of 80%. Last year, XYZ achieved.: · Revenues from sales ............................................... · Asset turnover ..................................................................... · Debt ratio ......................................................... · Debt (liabilities) ............................................................... Example 3: The company XYZ reported a return on equity of 15% and a return on sales of 10% last year. The volume of total assets was 20 mil. € and an equity ratio of 80%. Last year, XYZ achieved.: - Revenues from sales ............................................... - Asset turnover ..................................................................... - Debt ratio ......................................................... - Debt (liabilities) ............................................................... Example 3: The company XYZ reported a return on equity of 15% and a return on sales of 10% last year. The volume of total assets was 20 mil. € and an equity ratio of 80%. Last year, XYZ achieved.: - Revenues from sales ............................................... - Asset turnover ..................................................................... - Debt ratio ......................................................... - Debt (liabilities) ............................................................... Tasks a. Perform a vertical and horizontal analysis of the balance sheet. b. Analyze the financial situation (for 2020 and 2019) using financial ratios (calculate only those where you have input data from the balance sheet): · Liquidity · indebtedness, · profitability. Tasks a. Perform a vertical and horizontal analysis of the balance sheet. b. Analyze the financial situation (for 2020 and 2019) using financial ratios (calculate only those where you have input data from the balance sheet): - Liquidity - indebtedness, - profitability. Tasks a. Perform a vertical and horizontal analysis of the balance sheet. b. Analyze the financial situation (for 2020 and 2019) using financial ratios (calculate only those where you have input data from the balance sheet): - Liquidity - indebtedness, - profitability. Example 5: Fill in the missing data in APPLE 's simplified balance sheet, if you know these indicators/data: total liabilities = 4 mil. €, inventory turnover = 5, return on sales = 15%, total liquidity = 1.5, asset turnover period = 146 days, debt ratio = 0.5 and receivables collection time = 29.2 days. Note: Assume that the company's balance sheet contains only the items listed below or all other items are zero. Example 5: Fill in the missing data in APPLE 's simplified balance sheet, if you know these indicators/data: total liabilities = 4 mil. €, inventory turnover = 5, return on sales = 15%, total liquidity = 1.5, asset turnover period = 146 days, debt ratio = 0.5 and receivables collection time = 29.2 days. Note: Assume that the company's balance sheet contains only the items listed below or all other items are zero. Example 5: Fill in the missing data in APPLE 's simplified balance sheet, if you know these indicators/data: total liabilities = 4 mil. €, inventory turnover = 5, return on sales = 15%, total liquidity = 1.5, asset turnover period = 146 days, debt ratio = 0.5 and receivables collection time = 29.2 days. Note: Assume that the company's balance sheet contains only the items listed below or all other items are zero. Príklad 6: Calculate the different levels of profit, if you have these information from the company's Profit and Loss Statement (in €): Príklad 6: Calculate the different levels of profit, if you have these information from the company's Profit and Loss Statement (in €): Príklad 6: Calculate the different levels of profit, if you have these information from the company's Profit and Loss Statement (in €):
There are no answers to this question.
Login to buy an answer or post yours. You can also vote on other others

Get Help With a similar task to - analyze the financial situation using financial ratios

Popular Services
Tutlance Experts offer help in a wide range of topics. Here are some of our top services: