YEARLY cash flows (100), 25, 40, 50, 60. 17. Find the NPV for the above yearly...

YEARLY cash flows (100), 25, 40, 50, 60.

17. Find the NPV for the above yearly cash flows assuming a 14 % cost of capital.

17A. What is the profitability index for the cash flows above?

Expert Solution

jeff jeffy answered 2 years ago

Data set: 0, 3, 7, 8, 11, 17, 25, 42, 50, 60, 100 1)Using Excel, compute...

Data set: 0, 3, 7, 8, 11, 17, 25, 42, 50, 60, 100 1)Using Excel, compute the population mean and standard deviation. 2)How many samples of size 3 can you generate out of the population? 3)List all possible samples of size 3 and for each one compute the sample mean. 4)Using the Randbetween function on Excel, select one random sample, and report its mean and standard deviation. 5)For that one sample you have selected, build a 90% confidence interval. Does...

you are to find a business for sale, project the cash flows, and calculate the NPV...

you are to find a business for sale, project the cash flows, and calculate the NPV to determine whether the business is worth buying based on NPV and your overall evaluation. You may wish to visit a business broker website as they list businesses for sale, usually provide latest year cash flow and the price of the business. You need to: 1. Qualitatively assess the business. Why is it viable in the long run? If it’s not then choose another...

Given the data {20, 20, 30, 30, 40, 40, 50, 50, 60, 60}, calculate 1. Gini...

Given the data {20, 20, 30, 30, 40, 40, 50, 50, 60, 60}, calculate 1. Gini coefficient using the quintile distribution. 2. Draw the Lorenz curve with proper labels.

6 You have the following cash flows: FIND the IRR, NPV (using 8 %), and the...

6 You have the following cash flows: FIND the IRR, NPV (using 8 %), and the Profitability Index (Bang for your buck) T0 = -1250 IRR = _______________%_ T1 = 350 NPV = __$______________ T2 = 450 PI = __$______________ T3 = 450 T4 = 550

Find the net present value (NPV) for the following series of future cash flows, assuming the...

Find the net present value (NPV) for the following series of future cash flows, assuming the company’s cost of capital is 6.64 percent. The initial outlay is $339,858. Year 1: 163,676 Year 2: 147,656 Year 3: 123,800 Year 4: 178,407 Year 5: 149,077 Round the answer to two decimal places.

X Y/1 Y/0 Years Exp Successful Unsccessful total 4 17 83 100 8 40 60 100...

X Y/1 Y/0 Years Exp Successful Unsccessful total 4 17 83 100 8 40 60 100 12 50 50 100 16 56 44 100 20 96 4 100 The data in tab #2 pertain to the years of experience of project managers and the numbers of successes and failures they have had on major projects. Use the data set given in tab #2 in the attached Excel workbook and logistic regression to find the following: The probability of success given...

Stephens Stock Company (SSC) expects to generate free cash flows of $50 million, 60 million and...

Stephens Stock Company (SSC) expects to generate free cash flows of $50 million, 60 million and 65 million over the next three years after which SSC expects free cash flows to grow at 3% per year. SSC has a cost of capital of 15%, excess cash of $20 million and debt of $100 million. What is SSC’s enterprise value? If SSC has 20 million shares of stock outstanding, then what is the value of a share of SSC stock?

Given the cash-flows in the table, what is the NPV of project A?

1. Project A Year Cash Flow 0 -$107 1 $69 2 $80 3 $120 WACC = 6.19% Given the cash-flows in the table, what is the NPV of project A? State your answer to the nearest penny. Give just the number with no dollar sign (e.g., 3.26) If the NPV is negative include the - sign (e.g. -4.28) 2. Using the information in the table, what is the IRR for Project A? Cash Flow Year Project A 0 ($175) 1...

Marcal can wait for 1 year and find out whether the cash flows will be $50...

Marcal can wait for 1 year and find out whether the cash flows will be $50 million per year or $90 million per year before deciding to purchase the company. If it waits to purchase, Marcal can no longer sell the company for $450 million 2 years after purchase. Does decision-tree analysis indicate that it makes sense to purchase the electronics company? If so, when? Again, assume that all cash flows are discounted at 15%. (NPV calculation required)

Using the data set below: Score Frequency 20-30 5 30-40 8 40-50 13 50-60 12 60-70...

Using the data set below: Score Frequency 20-30 5 30-40 8 40-50 13 50-60 12 60-70 5 Draw a Histogram Draw a polygon After listening to YouTube “histogram and polygon,” explain how histogram is different and similar to polygon.

Question