Question

In: Finance

I am not sure where to post this complain. My situation is that I keep paying...

I am not sure where to post this complain. My situation is that I keep paying for help but having incorrect answers. This will be the 3rd time Ill be paying for these problems and keep have incorrect answers. Please help me with it.

7)

You are deciding between two mutually exclusive investment opportunities. Both require the same initial investment of $10.3 million. Investment A will generate $1.95 million per year? (starting at the end of the first? year) in perpetuity. Investment B will generate $1.47

million at the end of the first? year, and its revenues will grow at 2.2% per year for every year after that.

a. Which investment has the higher? IRR?

b. Which investment has the higher NPV when the cost of capital is 7.8%??

c. In this? case, for what values of the cost of capital does picking the higher IRR give the correct answer as to which investment is the best? opportunity?

a. Which investment has the higher? IRR?

The IRR of investment A is -------?%. (Round to the nearest? integer.)

9)

Facebook is considering two proposals to overhaul its network infrastructure. They have received two bids. The first bid from Huawei will require a $17 million upfront investment and will generate $20 million in savings for Facebook each year for the next 3 years. The second bid from Cisco requires a $82 million upfront investment and will generate $60 million in savings each year for the next 3 years. a. What is the IRR for Facebook associated with each bid? b. If the cost of capital for each investment is 12%, what is the net present value (NPV) for Facebook of each bid? Suppose Cisco modifies its bid by offering a lease contract instead. Under the terms of the lease, Facebook will pay $24 million upfront, and $35 million per year for the next 3 years. Facebook's savings will be the same as with Cisco's original bid. c. Including its savings, what are Facebook's net cash flow under the lease contract? What is the IRR of the Cisco bid now? d. Is this new bid a better deal for Facebook than Cisco's original bid? Explain. a. What is the IRR for AOL associated with each bid? The IRR associated with the first bid from Huawei is --------%.(Round to one decimal place.)

10)

Pisa Pizza, a seller of frozen pizza, is considering introducing a healthier version of its pizza that will be low in cholesterol and contain no trans fats. The firm expects that sales of the new pizza will be $21 million per year. While many of these sales will be to new customers, Pisa Pizza estimates that 45% will come from customers who switch to the new, healthier pizza instead of buying the original version.?? a. Assume customers will spend the same amount on either version. What level of incremental sales is associated with introducing the new pizza? b. Suppose that 44% of the customers who will switch from Pisa Pizza's original pizza to its healthier pizza will switch to another brand if Pisa Pizza does not introduce a healthier pizza. What level of incremental sales is associated with introducing the new pizza in this case? a. Assume customers will spend the same amount on either version. What level of incremental sales is associated with introducing the new pizza? The incremental sales are $ -------- million. (Round to two decimal places.)

11) Cellular Access Inc., is a cellular telephone service provider that reported net operating profit after tax (NOPAT) of $241 million for the most recent fiscal year. The firm had depreciation expenses of $102 million, capital expenditures of $220 million, and no interest expenses. Working capital increased by $13 million. Calculate the free cash flow for Cellular Access for the most recent fiscal year. The free cash flow is $ --- million. (Round to the nearest integer.)

12) A bicycle manufacturer currently produces 255,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $2.10 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct in-house production costs are estimated to be only $1.50 per chain. The necessary machinery would cost $253,000 and would be obsolete after ten years. This investment could be depreciated to zero for tax purposes using a ten-year straight-line depreciation schedule. The plant manager estimates that the operation would require $27,000 of inventory and other working capital upfront (year 0), but argues that this sum can be ignored since it is recoverable at the end of the ten years. Expected proceeds from scrapping the machinery after ten years are $18,975. If the company pays tax at a rate of 35% and the opportunity cost of capital is 15%, what is the net present value of the decision to produce the chains in-house instead of purchasing them from the supplier? Project the annual free cash flows (FCF) of buying the chains. The annual free cash flows for years 1 to 10 of buying the chains is $ ------. (Round to the nearest dollar. Enter a free cash outflow as a negative number.)

Solutions

Expert Solution

.Answer for a,

Incase of InvestmentA, In perpetuity, Return = (Annual Cash flow / Initial investment)X 100, Here in case of Investment A,

IRR is the return = ($1.95 million / $10.3million) X 100 = 18.9320388349515?%, rounded to 2 integer = 18.93%, rounded integer = 19%

In case of Investment B, this is growth model, the formula will be like Formula for Cost of Equity when dividents is growing,

Formula for Ke = (Divident / Market Price) X 100 + growth rate

here the concept is same and the formula will be (Cashflow / Initial Investment) X 100 + Growth rate =

It is given that growth at 2.2% per year for every year,

Cash flow in year 1 is $1.47million Initial investment will be same as Investment A = $10.3million, when we are applying value in Formula, it will be ($1.47million / $10.3million) X 100 ) + 2.2% = 14.2718446601942% + 2.2% = 16.4718446601942% rounded to 2 ineger = 16.47%, rounded nearest integer = 16%

Here Investment A has higher IRR which is 18.9320388349515?%, rounded to 2 integer = 18.93%, rounded integer = 19%

Answer to Question b.

Which investment has the higher NPV when the cost of capital is 7.8%??

NPV = Present value of inflow - Initial outlay,

In case of Investment A, is a perpetuity, in such situations we can find out Present value by deviding the Cash inflow by Cost of Capital, formula will be

Present value = Annual cash inflow / Cost of Capital = $1.95 million ? / 7.8% = 25,

NPV? of Investment A will be= $25 million - $10.3million = $14.7 million,

In case of Investment B, growth model, in such situation, We can find out Present value in one growth and applyConcept for computing Equity share price when having growth in divident under divident discount model    (formula of D1 / (Ke - Growth rate) and discount it using the discount factor before the year in which the growth rate will be stable) here only one stage growth and so it is very simple. Present value = Annual cash flow X PV factor or discount factor.

PV factor or discount factor? = 1/(1+i)n, here n = 1, i= 7.8% or 0.078, = 1/1.078 or 0.927643784786642

The present value of cashflows after year1 = (year1 cashflow X (1+growth rate )) / (Cost of Capital - Growth Rate)X year1 Discount factor =($1.47million X 1.022) / 0.078 -0.022 X(1/1.078) =

So PV = $24.8863636363636 millions?, NPV= $24.8863636363636 millions? - $10.3Millions, = $14.5863636363636 millions.

Investment A has higher NPV of $14.7millions.

Answer to c, Based on IRR and NPV methods, Investment of A will be the Best Investment opportunity.

Answer to Question 9, a. What is the IRR for Facebook associated with each bid?

for computing IRR first, we have to identify Lowest Discount rate at which getting positive NPV and we have to identify Highest Discount rate at which getting negative NPV. then find out the values of terms in formula andapply values

IRR = LR +(NPV @ LR /(NPV@ LR - NPV @ HR))X (HR-LR)?, LR = Lowest Discount rate?, 100%

HR = Highest Discount rate, 110%

IRR of bid from Huawei, a $17 million upfront investment, annual cost savings $20 million

Annual Cash flow Present Value of cash
year in $million Discount Factor @110% Inflow in$ million
1 20 0.4761904761904760        9.52380952380952
2 20 0.2267573696145120        4.53514739229025
3 20 0.1079796998164350        2.15959399632869
Total Present Value      16.21855091242850
Initial outlay    17.00
NPV @HR -0.781449087571538
Annual Cash flow Present Value of cash
year in $million Discount Factor @100% Inflow in$ million
1 20 0.5000000000000000      10.00000000000000
2 20 0.2500000000000000        5.00000000000000
3 20 0.1250000000000000        2.50000000000000
Total Present Value      17.50000000000000
Initial outlay 17.00
NPV @ LR 0.50

applying values in formula, 100% + ((0.50/(0.50 - - 0.781449087571538) X (110-100))% = 100%+3.90183273646513% = 103.90183273646513%, rounded to 1 decimal places = 103.9?%,

Evaluation of bid from Cisco requires a $82 million upfront investment and will generate $60 million in savings each year for the next 3 years.

Formula for IRR will be same as above but values will have change

HR = 60%, LR = 50% NPV @ HR = -6.4140625000000, NPV @ LR = 2.44444444444440

Annual Cash flow Present Value of cash
year in $million Discount Factor @60% Inflow in$ million
1 60 0.6250000000000000      37.50000000000000
2 60 0.3906250000000000      23.43750000000000
3 60 0.2441406250000000      14.64843750000000
Total Present Value      75.58593750000000
Initial outlay    82.00
NPV @HR -6.4140625000000
Annual Cash flow Present Value of cash
year in $million Discount Factor @50% Inflow in$ million
1 60 0.6666666666666670      40.00000000000000
2 60 0.4444444444444440      26.66666666666670
3 60 0.2962962962962960      17.77777777777780
Total Present Value      84.44444444444440
Initial outlay    82.00
NPV @ LR    2.44444444444440

Applying values in formula,

50% + ((2.44444444444440? / (2.44444444444440? - - 6.4140625000000?) X (60 - 50)) %,

= 50% +2.75943165115138% = 52.75943165115138%.

Rounded to 1 decimal places =52.8%,

Answer to Question 9,b. If the cost of capital for each investment is 12%, what is the net present value (NPV) for Facebook of each bid?

NPV = Present value of cash inflow - initial outlay,

Present value of cash inflow? = Annual cash flow X Discount factor,

Discount? Factor = (1+i)n , where i = Cost of capital , 12% is given, n is the corresponding year

NPV of bid from Huawei is as follows

Annual Cash flow Present Value of cash
year in $million Discount Factor @12% Inflow in$ million
1 20 0.8928571428571430      17.85714285714290
2 20 0.7971938775510200      15.94387755102040
3 20 0.7117802478134110      14.23560495626820
Total Present Value      48.03662536443150
Initial outlay    17.00
NPV bid from Huawei    31.0366253644315

Rounded to 1 decimal places = $31.0 million,

NPV of bid from Cisco is as follows

Annual Cash flow Present Value of cash
year in $million Discount Factor @12% Inflow in$ million
1 60 0.8928571428571430      53.57142857142860
2 60 0.7971938775510200      47.83163265306120
3 60 0.7117802478134110      42.70681486880460
Total Present Value    144.10987609329400
Initial outlay    82.00
NPV bid from Cisco    62.1098760932944

NPV bid from Cisco? rounded to 1 decimal place = $61.1million

Answer to Question 9c. Including its savings, what are Facebook's net cash flow under the lease contract?

Net annual cash flow = annual cash inflow - annual cash outflow.

Cash out flow in year 0 (now)$24 million

Annual Cash inlfow = $60 million, annual cash outflow = $35 million, annual net cash outflow = 60-35 = $25million.

The question is too large and time is ending, sorry for inconvenience, please rate answer maximum if you understood, please leave any doubts .... sorry for not completing


Related Solutions

The Table in my homework question below is completely wrong. I am not sure where I...
The Table in my homework question below is completely wrong. I am not sure where I went wrong in my calculations but coud you rework this question and answer the parts below?? Here are earnings per share for two companies by quarter from the first quarter of 2009 through the second quarter of 2012. Forecast earnings per share for the rest of 2012 and 2013. Use exponential smoothing to forecast the third period of 2012, and the time series decomposition...
I worked on this my self but I am not sure about it and I feel...
I worked on this my self but I am not sure about it and I feel like I get confuse in explaining some of them, I want to capare and contrast the different types of membrane transport processes.( including differences and similarities) simple diffusion facilitated difusion osmosis primaryactive transport secendary active transport vesicular transport The comparison and similarities should be about each of these topics. 1.direction of transport 2.energy requirement 3.protein requirement 4.types of protein if applicable 5. example of...
Python: I am not sure where to begin with this question, and I hope I can...
Python: I am not sure where to begin with this question, and I hope I can get an input on it. This is in regards to Downey's program, and we are asked to make two changes. Downey prints time as they do in the Army: 17:30:00 hours. We want to print that as 5:30 PM. Downey lets you define the time 25:00:00 - we want to turn over at 23:59:59 to 00:00:00. (I am asked to identify my changes with...
I need to respond to my classmates' discussion post "Hunter's situation is an unfortunate one. I...
I need to respond to my classmates' discussion post "Hunter's situation is an unfortunate one. I believe Hunter's captain is certainly in the wrong by doing this. However, there are multiple ways Hunter may react once the conflict escalates. If Hunter were to use an avoidance style in this conflict he may quit his job or he may seek someone else's help in resolving the conflict remotely. Quitting his job would be the most direct form of avoidance, however, it...
Hi I am not sure how to go about answering this question on my homework. ABC...
Hi I am not sure how to go about answering this question on my homework. ABC corporation adopts a compensatory stock option plan. the plan covers 25 executives and provides each executive 300 otions to purchase stock for $100/share. the options vest in 3 years. the plan starts on 1/1/18 and matures 12/31/20. we assume a 95% retention rate. at 12/31/20 22 executives earn the options. each option is valued at $17/share. record the journal entries for 12/31/18, 12/31/19, and...
I am stuck on this problem and I am not sure what the solution is. In...
I am stuck on this problem and I am not sure what the solution is. In C Write item.h and item.c. In item.h, typedef a struct (of type t_item) which contains the following information: t_item: char name[MAX_ITEM_NAME_STRING]; char description[MAX_ITEM_DESCRIPTION_STRING]; Make sure that MAX_ITEM_NAME_STRING and MAX_ITEM_DESCRIPTION_STRING are defined with suitable sizes in your item.h. Typical values are, 25 and 80, respectively. Add the following interface definition to item.h: int item_load_items(t_item items[], int max_items, char *filename); Returns the number of objects loaded...
I am not sure where, to begin with, this problem... "You have found the following historical...
I am not sure where, to begin with, this problem... "You have found the following historical information for DEF Company:                          Year1       Year 2        Year 3        Year 4 Stock Price        $46.29         $49.74          $54.55          $57.07 EPS                  $2.04 $2.9    $2.81    $3.78 Earnings are expected to grow at 8 percent for the next year. Using the company's historical average PE as a benchmark, what is the target stock price in one year?"
I am working on a project where I have to create my own organization (stem cell...
I am working on a project where I have to create my own organization (stem cell research) I need to go further in depth about the program or organization in terms of describing the program implementation and the project evaluation...
NOTE: I am just checking my own work so if you respond, please make sure I...
NOTE: I am just checking my own work so if you respond, please make sure I can read your handwriting. A loan officer wants to compare the interest rates for 48-month fixed-rate auto loans and 48-month variable-rate auto loans. Two independent, random samples of auto loans are selected. A sample of eight 48-month fixed-rate auto-loans have the following loan rates: 4.29%, 3.75%, 3.50%, 3.99%, 3.75%, 3.99%, 5.40%, 4.00% while a sample of five 48-month variable-rate auto loans have the loan...
My output is incorrect when i put an empty string first_inside_quotes(' "" '). Not sure where...
My output is incorrect when i put an empty string first_inside_quotes(' "" '). Not sure where the issue lies import introcs def first_inside_quotes(s): ''' Returns the first substring of s between two (double) quote characters    Note that the double quotes must be part of the string. So "Hello World" is a precondition violation, since there are no double quotes inside the string.    Example: first_inside_quotes('A "B C" D') returns 'B C' Example: first_inside_quotes('A "B C" D "E F" G')...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT