You generally require investments to triple in value over a 5 year period. Based on your above
Fantastic news! We've Found the answer you've been seeking!
Question:
You generally require investments to triple in value over a 5 year period. Based on your above analysis discuss why you would, or would not, acquire this company.
Transcribed Image Text:
Scenario Summary Changing Cells: $B$2 $B$6 $B$5 Result Cells: Year 1 Year 2 Year 3 Year 4 Year 5 Year 1 Year 2 Year 3 Year 4 Year 5 Year 1 Year 2 Year 3 Year 4 Year 5 Profit projection for fifth year if you were to sell the firm after five years Current Values: 5% 20% 9 Best scenario 8.00% 7.78% 7.58% 7.40% 7% 20% 10.5 Worst scenario Revenue Revenue Revenue $ 7,400,000.00 $ 7,400,000.00 $ 7,400,000.00 $ 7,770,000.00 $ 7,918,000.00 $ 7,622,000.00 $ 8,158,500.00 $ 8,472,260.00 $ 7,850,660.00 $ 8,566,425.00 $ 9,065,318.20 $ 8,086,179.80 $ 8,994,746.25 $ 9,699,890.47 $ 8,328,765.19 FCFF FCFF FCFF $ 3,236,280.00 $3,189,660.00 $ 3,383,910.00 $ 3,495,280.00 $ 3,552,260.00 $3,539,310.00 $ 3,767,230.00 $ 3,940,242.00 $3,699,372.00 $ 4,052,777.50 $4,355,382.74 $ 3,864,235.86 $ 4,352,602.38 $ 4,799,583.33 $ 4,034,045.64 % Increase % Increase % Increase 11.37% 10.92% 10.54% 10.20% 3% 10% 8.5 4.59% 4.52% 4.46% 4.39% $ 76,272,716.25 $ 96,388,849.98 $ 66,374,504.15 Scenario Summary Changing Cells: $B$2 $B$6 $B$5 Result Cells: Year 1 Year 2 Year 3 Year 4 Year 5 Year 1 Year 2 Year 3 Year 4 Year 5 Year 1 Year 2 Year 3 Year 4 Year 5 Profit projection for fifth year if you were to sell the firm after five years Current Values: 5% 20% 9 Best scenario 8.00% 7.78% 7.58% 7.40% 7% 20% 10.5 Worst scenario Revenue Revenue Revenue $ 7,400,000.00 $ 7,400,000.00 $ 7,400,000.00 $ 7,770,000.00 $ 7,918,000.00 $ 7,622,000.00 $ 8,158,500.00 $ 8,472,260.00 $ 7,850,660.00 $ 8,566,425.00 $ 9,065,318.20 $ 8,086,179.80 $ 8,994,746.25 $ 9,699,890.47 $ 8,328,765.19 FCFF FCFF FCFF $ 3,236,280.00 $3,189,660.00 $ 3,383,910.00 $ 3,495,280.00 $ 3,552,260.00 $3,539,310.00 $ 3,767,230.00 $ 3,940,242.00 $3,699,372.00 $ 4,052,777.50 $4,355,382.74 $ 3,864,235.86 $ 4,352,602.38 $ 4,799,583.33 $ 4,034,045.64 % Increase % Increase % Increase 11.37% 10.92% 10.54% 10.20% 3% 10% 8.5 4.59% 4.52% 4.46% 4.39% $ 76,272,716.25 $ 96,388,849.98 $ 66,374,504.15
Expert Answer:
Answer rating: 100% (QA)
To assess whether to acquire the company we need to analyze its potential for tripling in value over a 5year period based on the provided revenue proj... View the full answer
Related Book For
Fundamentals Of Investments Valuation And Management
ISBN: 9781266824012
10th Edition
Authors: Bradford Jordan, Thomas Miller, Steve Dolvin
Posted Date:
Students also viewed these finance questions
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
Consider a binomial distribution with 10 trials. Look at Table 2 in the Appendix showing binomial probabilities for various values of p, the probability of success on a single trial. (a) For what...
-
As Paradise Properties CEO Ajanee Kallapur began thinking about what aspects of sustainability were most important for Paradise Cove, she realized that success of the hotel was critically linked to...
-
Study the Employee Earnings Record for J.C. Jenkins in Exhibit 11-8, page 665. In addition to the amounts shown in the exhibit, the employer also paid all employee benefits plus (a) An amount equal...
-
Find the Laurent series that converges for 0 0|
-
Defendant Kenneth Blake was married to Charlene Hinton-Blake, who died in 2012. Three of Hinton-Blakes sisters, including Yvonne Hinton, assisted her with day-to-day care during a four-year period of...
-
Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them...
-
A certain substance has a mass per mole of 53 g/mol. When 312 J is added as heat to a 26.0 g sample, the sample's temperature rises from 21.0C to 45.0C. What are the (a) specific heat and (b) molar...
-
Kennedy Prisby, age 33, is single and has no dependents. Her social security number is 111-22-3333. Her address is 101 North Fork Ave., Cedar City, UT 84720. She has no intention of donating to the...
-
Jacks Lock and Key is considering remodeling. It estimates that the remodeling will cost $6,000 and that as a result revenues will rise by $3,000 the first year, $2,500 the second year, $1,500 the...
-
Give a short (5 - 10 minutes) presentation to a partner explaining a communication strategy, protocol or standard of your choice. This could include information related to public relations, crisis...
-
Category 7 - Diversity - Cultural Dimensions Discuss 2 divergent cultural characteristics that can be present in a group. Define these characteristics using textbook citations and provide examples to...
-
List the four (4) different communication strategies you have used while communicating with clients and co-workers?
-
Create a simple blockchain simulation in Python. Your program should be able to create new blocks, validate the integrity of the chain, and display the entire blockchain.
-
1; Journal Prompt: Different Cultures Is it ethical or appropriate for someone from one culture to attempt to change the cultural values of someone from another culture? For example, consider the...
-
Manchester Higher Education (MHE) is a privately owned Business School offering courses in Accounting, Marketing, Management and Hospitality. Students have a chance to choose specializing in one...
-
A routine activity such as pumping gasoline can be related to many of the concepts studied in this text. Suppose that premium unleaded costs $3.75 per gal. Work Exercises in order. Use the...
-
A bond analyst at Omnipotent Bank (OB) notices that the prepayment experience on his holdings of high-coupon GNMA issues has been moving sharply higher. What does this indicate? a. Interest rates are...
-
Which of the following investment strategies or tactics is likely the most relevant in the decision to short sell a particular stock? a. Market timing b. Asset allocation c. Security selection d. Tax...
-
On a particular day, the Common Sense Growth Fund had a net asset value of $13.91. The offering price was $15.20. Is this a load fund? What is the front-end load?
-
Stage-2 receivables are those in which the payment is delayed by: a. Less than 30 days b. More than 30 days but less than 90 days c. More than 60 days d. More than 90 days
-
In July 2023, JFI Islamic Bank booked receivables of USD 5,000 from Paragon Parks Limited which were to be received in five equal instalments. The first payment was due on Dec 15, 2023. By the end of...
-
Which of the following will be used to determine the amount of credit losses? a. The total amount of receivable at risk b. Any change in the credit loss of a receivable due to a decline of credit...
Study smarter with the SolutionInn App