You are an employee of a consulting company which offers advisory services in mergers and acquisitions....

  

Transcribed Image Text:

You are an employee of a consulting company which offers advisory services in mergers and acquisitions. Your team is responsible for an initial valuation of the ABS company. In the attached Excel are presented main assumptions related to future performance and past ratios of ABS. Based on the assumption, please: Prepare forecasted financial statement (P&L, CF, BS) Fixed and intangible assets Current Assets Inventories Receivables Cash and Cash Equivalents Total Assets Common stock capital Capital surplus Accruals and provisions IBD (Debt) Account payables Total Equity and Liabilities Historical analysis / Forecasting Sales Other operational costs excl. Depreciation Marginal tax rate COGS Variable cost / Sales Receivable Turnover Ratio (in days) Inventories Turnover Ratio (in days) Account Payables Turnover Ratio (in days) Receivables Inventories Account payables Accruals and provisions Depreciation Investements in Fixed and Intengible Assets net 2020 111 601 17 400 2021 123 401 18 801 89 836 77 451 69,40% 72,80% 79,2 73,3 7,4 8,6 54 55 24 216 2 254 16 513 11 835 8 202 12 301 24 773 2 920 18 587 11 372 9 202 8 104 2022 79 197 27 283 2 248 22 833 2 202 106 479 2022 45 000 16 810 7 966 22 000 14 704 106 479 2022 113 801 22 002 7,2 47,2 22 833 2 248 14 704 2023 F 118 500 22 002 20% 7 966 9 302 10 201 2023 F 123 600 22 222 20% 85 578 88 283 90 228 98 651 103 317 98 690 75,20% 74,50% 73,00% 72,50% 72,30% 71,00% 73,2 73,2 73,2 73,2 73,2 73,2 7,2 7,2 7,2 7,2 47,2 47,2 47,2 47,2 28 658 27 876 23 765 2410 27 289 2768 17 596 2 906 7 966 7 902 5 501 15 324 7 966 9 201 13 020 2024 F 136 070 22 666 20% 7,2 47,2 24 788 2514 15 983 7 966 8 302 4 000 2025 F 142 900 23 120 20% 2026 F 139 000 23 582 20% 18 479 7 966 6 901 9 000 2 827 17 975 7 966 7 701 7 701 You are an employee of a consulting company which offers advisory services in mergers and acquisitions. Your team is responsible for an initial valuation of the ABS company. In the attached Excel are presented main assumptions related to future performance and past ratios of ABS. Based on the assumption, please: Prepare forecasted financial statement (P&L, CF, BS) Fixed and intangible assets Current Assets Inventories Receivables Cash and Cash Equivalents Total Assets Common stock capital Capital surplus Accruals and provisions IBD (Debt) Account payables Total Equity and Liabilities Historical analysis / Forecasting Sales Other operational costs excl. Depreciation Marginal tax rate COGS Variable cost / Sales Receivable Turnover Ratio (in days) Inventories Turnover Ratio (in days) Account Payables Turnover Ratio (in days) Receivables Inventories Account payables Accruals and provisions Depreciation Investements in Fixed and Intengible Assets net 2020 111 601 17 400 2021 123 401 18 801 89 836 77 451 69,40% 72,80% 79,2 73,3 7,4 8,6 54 55 24 216 2 254 16 513 11 835 8 202 12 301 24 773 2 920 18 587 11 372 9 202 8 104 2022 79 197 27 283 2 248 22 833 2 202 106 479 2022 45 000 16 810 7 966 22 000 14 704 106 479 2022 113 801 22 002 7,2 47,2 22 833 2 248 14 704 2023 F 118 500 22 002 20% 7 966 9 302 10 201 2023 F 123 600 22 222 20% 85 578 88 283 90 228 98 651 103 317 98 690 75,20% 74,50% 73,00% 72,50% 72,30% 71,00% 73,2 73,2 73,2 73,2 73,2 73,2 7,2 7,2 7,2 7,2 47,2 47,2 47,2 47,2 28 658 27 876 23 765 2410 27 289 2768 17 596 2 906 7 966 7 902 5 501 15 324 7 966 9 201 13 020 2024 F 136 070 22 666 20% 7,2 47,2 24 788 2514 15 983 7 966 8 302 4 000 2025 F 142 900 23 120 20% 2026 F 139 000 23 582 20% 18 479 7 966 6 901 9 000 2 827 17 975 7 966 7 701 7 701

Answer rating: 100% (QA)

Forecasted Financial Statements for ABS Company Assumptions Historical analysis and forecasting data provided in the Excel file Marginal tax rate of 2... View the full answer