You are an employee of a consulting company which offers advisory services in mergers and acquisitions....
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Posted Date:
Students also viewed these finance questions
-
Question: \\\\table[[Laptlat aDseld,ivo, vuv,],[Cash,90,500,],[Charges for sales and services,,555,000],[Cost of sales and services,497,000,],[Depreciation expense,47,000,],[Due from General...
-
= Assume that the price S of a risky asset follows a binomial model with S(0) = $100, u = 10% and d -10%. The asset pays a dividend of $5 on the odd times, i.e., 1, 3, 5.... In this market, the...
-
You are an employee of a U.S. firm that produces personal computers in Thailand and then exports them to the United States and other countries for sale. The personal computers were originally...
-
A steel spur pinion has 16 teeth cut on the 20 full-depth system with a module of 8 mm and a face width of 90 mm. The pinion rotates at 150 rev/min and transmits 6 kW to the mating steel gear. What...
-
A company faces two kinds of risk. A firm-specific risk is that a competitor might enter its market and take some of its customers. A market risk is that the economy might enter a recession, reducing...
-
Boswell's Beanery is a locally owned specialty food product company in Northeast Ohio that has been in existence for over 30 years. Its products include flavored coffees and teas, dips, dressings,...
-
Convertibles are great because they offer a lower return than straight debt and we just dish out shares rather than have to find cash to redeem the bonds executive at Myopic plc. Comment on this...
-
On June 1, 2016, Ashley Jackson opened the Leadership Talent Agency. He plans to use the chart of accounts given below. INSTRUCTIONS 1. Journalize the transactions. Be sure to number the journal...
-
MONTGOMERY INCORPORATED Comparative Balance Sheets At December 31 Current Year Prior Year Assets Cash $ 78,500 $ 78,600 Accounts receivable, net 16,700 20,400 Inventory 149,700 117,900 Total current...
-
Suppose a firm runs a tournament compensation scheme for two workers where each worker gets base pay a and the worker who produces more output gets a prize S . Output for each worker i is Q i =dE i +...
-
Discuss why do people celebrate national history? Give detailed answer with examples.
-
Consider the maximum-likelihood estimator $\tilde{\sigma}^{2}$ of $\sigma^{2}$ in the simple linear regression model. We know that $\tilde{\sigma}^{2}$ is a biased estimator for $\sigma^{2}$. a. Show...
-
Consider the simple linear regression model $y=\beta_{0}+\beta_{1} x+\varepsilon$, with $E(\varepsilon)=0$, $\operatorname{Var}(\varepsilon)=\sigma^{2}$, and $\varepsilon$ uncorrelated. a. Show that...
-
Project managers have many resources that are not directly under their control, such as the designer and the owner. Provide some bulleted points describing how project managers can manage (influence)...
-
In this zone, we critically examine the concept of health and well-being and evaluate whether organisations are doing enough to promote the welfare of their most valuable assets. Work is an innate...
-
Consider the least-squares residuals $e_{i}=y_{i}-\hat{y}_{i}, i=1,2, \ldots, n$, from the simple linear regression model. Find the variance of the residuals $\operatorname{Var}\left(e_{i} ight)$. Is...
-
Our CEO, Georgia Alaska, read in the newspaper that an inverted yield curve is a signal for recession. She believes the best thing to hold during a recession is gold! She wants to protect our...
-
SCHEDULE OF COST OF GOODS MANUFACTURED The following information is supplied for Sanchez Welding and Manufacturing Company. Prepare a schedule of cost of goods manufactured for the year ended...
-
Indicate who should be on this important cross-functional team and why.
-
You are the top manager of a start-up company that will produce innovative new flatscreen displays for PC makers like Apple and HP. The flatscreen display market is highly competitive, so there is...
-
What kind of controls would you expect to find most used in (a) a hospital, (b) the Navy, (c) a city police force? Why?
-
Decision scope categorizes decisions into three broad areas of managerial decision making. These three areas are operational control, management control, and strategic planning. In your own words,...
-
Write a two-page report explaining the two basic strategies that S&S, Inc. can pursue and the three different strategic positions that it can adopt. Include in your report a discussion and examples...
-
Information technology is continually changing the nature of accounting and the role of accountants. Write a two-page report describing what you think the nature of the accounting function in a large...
Study smarter with the SolutionInn App