Question: I NEED HELP TO IMPLEMENT THIS PROBLEM IN EXCEL AND USE THE SOLVER. Q: You have the opportunity to acquire a company in the ICT

I NEED HELP TO IMPLEMENT THIS PROBLEM IN EXCEL AND USE THE SOLVER.

Q: You have the opportunity to acquire a company in the ICT sector with the following forecast for the earnings before interest, tax, depreciation and amortization (EBITDA): End of year 2020 2021 2022 2023 2024 2025 2026 EBITDA (million USD) 13 13 13 13 14 14 14 The acquisition value of this company will be discussed below. For tax purposes, the acquisition costs will be depreciated with 20 % annually according to the declining balance method. Net income is subject to taxation with a tax rate of 30 %. It is expected that the ICT company will be sold in the end of 2026. Assume that the sales value corresponds to the book value. The acquisition of the firm today (beginning of 2020) will be equity-financed with at least 50 %. The required return on equity is assumed to be 14%. Furthermore, your bank offers you to use any combination of the following loans: . Constant amortization mortgage (CAM): interest rate of 6 %, maturity 15 years, maximum USD 30 million, Constant payment mortgage (CPM): interest rate of 6 %, maturity 15 years, maximum USD 30 million, Credit line: interest rate of 8 %, maximum USD 5 million. Excessive cash flow will be deposited on a savings account with an interest rate of 2.5%. (a) Assume acquisition costs of USD 55 million. Optimize financing and determine your future wealth in the end of 2026. Should you proceed with the acquisition? (b) What is the highest price that you will pay for the firm if you assume the financial structure obtained in (a)? (c) What is the highest price that you will pay if financing is simultaneously optimized at this highest price? (d) Assume that the company can be sold for USD 20 million in the end of 2026. Again, optimize financing and find out if the acquisition at USD 55 million will be favorable or not Please help me implement this in excel and use the solver

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

You have the opportunity to acquire a company in the ICT sector with the following forecast for the earnings before interest, tax, depreciation and amortization (EBITDA): End of year 2020 2021 2022...

Cars-to-Dealers Logistics Inc. is the exclusive logistics provider for the Summit Motor Co. and has responsibility for transporting cars from Summit's 3 manufacturing plants in Toledo, OH; Charlotte,...

Inventories are stocks or items used to support production (raw materials and work-in-process items), supporting activities (maintenance, repair, and operating supplies) and customer service...

Can you solve this in excel? Q: You have the opportunity to acquire a corrVany in the ICT sector With the following forecast for the before interest, tax, depreciation and amortization (EBITDA): End...

Please work on the review taking into account the guidelines and the rubrics attached. Complete the template. Don?t forget the general remarks on the bottom of the page (around 1/2 page) 2 CHINESE...

A report consisting of 700 words Make a short introduction, where you explain (in your own words) what balanced management is as well as how balanced management is used by Norwegian municipalities....

Part3: Need help with the below-mentioned question: Use excel and show the formulas and steps.?? 3) At what level of initial sales forecast will the firm achieve NPV breakeven? You should use the...

What Is the PAEI Model? P roducer, A dministrator, E ntrepreneur, I ntegrator. The person in the producer role is ultimately responsible for the product or service that you're offering. They are in...

1. In 2013, several data server companies took a dramatic decision to begin using energy surcharges to recapture rising energy costs. However, customers are critical of how the energy surcharges are...

Through the use of strategic alternatives, companies may compete in a marketplace, achieve its vision, or if no vision has been articulated, decide where it might go and what it might achieve....

The calculations in PERT allow you to determine the probability that as project will be completed. Suppose you calculate that the probability a project will be completed by a target deadline is only...

The beginning cash balance of a store is P120,000. The top management applies the control limit model to manage its stores cash balance. Its lower limit, optimal return point and upper limit are...

The internal rate of return ( IRR ) is the discount rate that makes the NPV of an investment zoro. True False

Integer valueIn is read from input. Write a while loop that iterates until valueIn is negative. In each iteration: Update integer finalNum as follows: If valueIn is divisible by 4 , output "miss" and...