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)
Answer To determine whether acquiring Pillowscom aligns with your investment criteria of tripling in value over a 5year period we need to assess its p... 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
-
1. Write a program to print out payslip for staff members of Pures College: Expected input: Name of Staff, Date of of Employment, Position, Department, Rate per Hour, Over time hours is calculated as...
-
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...
-
Components have lifetimes in minutes that are independent of each other with a lognormal distribution with parameters = 3.1 and = 0.1. Suppose that a random sample of 200 components is taken. What...
-
Correct 800 Find all x-values where the line tangent to the curve F(x) = (x - 12x+11) is horizontal. Separate multiple answers with a comma. If there are no x-values where the curve has a horizontal...
-
The Artic Company's income statement and comparative balance sheets at December 31 of 2019 and 2018 are shown below: Cash dividends of \(\$ 40,000\) were declared and paid during 2019. Plant assets...
-
Two identical loudspeakers are located at points A and B, 2.00 m apart. The loudspeakers are driven by the same amplifier and produce sound waves with a frequency of 784 Hz. Take the speed of sound...
-
Compute Lead Time Jackson Fabricators Inc. machines metal parts for the automotive industry. Under the traditional manufacturing approach, the parts are machined through two processes: milling and...
-
Solve the structures in Figures P5-16 through P5-18 by using substructuring. Figure P5-16 (Substructure the truss at nodes 3 and 4) Figure P5-17 (Substructure the beam at node 3) Figure P5-18...
-
Suppose g : {0,1}l {0,1}n is such that the number of 1's in is divisible by 3 with probability 2/3. Is it secure? Explain your answer. If you conclude it is insecure suggest a statistical test with...
-
Tender must occur at a reasonable hour and in a reasonable manner. Amazon delivers a shipment of 1 0 0 0 frozen dinners at 2 am to the Warehouse that Fit - for - life addressed for delivery. Upon...
-
Solve the following problem by using MATLAB given th 1-27 2-10 x-30 Find I Add file
-
Think about current political movements or campaigns connected to specific geographies. What kinds of economic discussions might be taking place during the upcoming primary and general elections for...
-
2. (10) In a few sentences, describe what the script below is doing (FYI: GE means greater than or equal). Be as specific as possible. UMULL RO, R1, R2, R3 CMP R1, # 0x01 BGE Elsewhere
-
An all-equity firm is considering the following projects: Project Beta IRR W .80 10.2% .90 1.10 1.35 X Y Z 11.4 12.6 15.1 The T-bill rate is 4 percent, and the expected return on the market is 12...
-
1. Mathew and Henry are in partnership sharing profits and losses in the ratio 1:1. Henry enjoys a salary of sh 5,000 per year. The net profit for the year ended 32 Dec 2010 and 2011 were sh 12,000...
-
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?
-
Are dividends paid to stockholders ever reported in the income statement as an expense? Explain.
-
Assume that you are a developer of business software applications. How might you design an accounting software package that would enable a company to perform its year-end closing process without...
-
The weekly payroll for employees of Ryan Company, who work a five-day week, amounts to \(\$ 20,000\). All employees are paid up-to-date at the close of business each Friday. If December 31 falls on...
Study smarter with the SolutionInn App