Question

In: Finance

A project has the following cash flow's what is the payback period in years? A 2.48...

A project has the following cash flow's what is the payback period in years?
A 2.48
B 2.74
C 2.80
D 3.63
E 3.11

Bingo Bowling is considering a project with an initial cost of $161,400 the project will not produce any cash flows for the first 3 years starting in year 4 the project will produce cash inflows of $94,000 a year for the next 5 years the project is risky so the firm has assigned it a discount rate of 13.5% what is the projects IRR?
A 18.8%
B 20.17%
C 21.37%
D 22.53%
E 14.77%

Philly Has a beta of 1.14 and an expected return of 10.6% Brillo has an expected return of 8.3% the risk-free rate is 4.4% what is the beta of Brillo?
A 1.23
B .704
C .717
D .869
E .918



no cahflows needed

Solutions

Expert Solution

As the cashflows are not given for the first question, it cannot be solved. Payback period is the period by which our initial investment is recovered. We do not use discounted cash flows. For example, if our initial investment was $200 and we get cash inflows of 50,50 & 100 in years 1,2,& 3 respectively, then our payback period would be 3 years. The cash flows after the payback period is not taken into any consideration. So, we will just keep adding cash flows from the beginning and stop wherever we get the sum to be equal to initial investment. Generally, we can assume that cashflows are evenly spread throughout the year.

For the second question, we can use excel's =irr function. We can also solve the following equation and take the use of options to feed and check in the equation. IRR is that rate of internal return which makes npv = 0. The initial outlay is -$161400. From year 4 we get $94000 cash inflows for 5 years. We will discount the future cash flows to get its present value.

Thus, -161400 + 94000/(1+irr)^4 + 94000/(1+irr)^5 + 94000/(1+irr)^6 + 94000/(1+irr)^7 + 94000/(1+irr)^8 = 0

In excel =irr(-161400,0,0,94000,94000,94000,94000,94000) = 20.17%

Thus the correct option is B.

Now, the third question says that,

Beta (Philly) = 1.14

Expected return (Philly) = 10.6%

Expected return (Brillo) = 8.3%

Risk free rate, Rf = 4.4%

According to Capital Asset Pricing Model, CAPM, we have, Re = Rf + Beta(Rm-Rf),

Where Re is the expected return on stock Beta is the beta of security and Rm is the return of market, Rf is risk free rate

Putting this equation with values of Philly, we get,

10.6 = 4.4 + 1.14* (Rm-4.4)

Rm = 9.839%

Now, using this same equation for Brillo, we get

8.3 = 4.4+Beta*(9.839-4.4)

Thus, Beta (Brillo) = 0.717

Thus the correct option is C


Related Solutions

What is the payback period for the investment project that has the following cash flows? Year...
What is the payback period for the investment project that has the following cash flows? Year Cash Flows 0 -65,209 1 24,853 2 27,977 3 23,774 4 25,436
What is the discounted payback period for the investment project that has the following cash flows,...
What is the discounted payback period for the investment project that has the following cash flows, if the discount rate is 14 percent? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16)) Year Cash Flows 0 -13779 1 4470 2 5005 3 5877 4 6626
A project has the following cash flows. What is the payback period? Year 0 1 2...
A project has the following cash flows. What is the payback period? Year 0 1 2 3 4 cash flow -$14500 $2200 $4800   $6500 $7500 A project has the following cash flows. What is the internal rate of return? Year 0 1 2 3 Cash flows -$89300 $32900 $64200 $5800 A project has the following cash flows. What is the payback period? Year 0 1 2 3 4 Cash flow -$28000 $11600 $11600 $6500 $6500 And how to solve this...
​(Discounted payback period​) You are considering a project with the following cash​ flows: YEAR   PROJECT CASH...
​(Discounted payback period​) You are considering a project with the following cash​ flows: YEAR   PROJECT CASH FLOW 0   -40,000 1   15,000 2   15,000 3   15,000 4   15,000 If the appropriate discount rate is 12 ​percent, what is the​ project's discounted payback​ period? The​ project's discounted payback period is ___ years.  ​(Round to two decimal​ places.)
Given the following cash flows for a capital project, calculate its payback period and discounted payback...
Given the following cash flows for a capital project, calculate its payback period and discounted payback period. The required rate of return is 8 percent. Year 0 1 2 3 4 5 Cash Flows $-37500 $11250 $11250 $15000 $6000 $6000 The discounted payback period is 0.16 year longer than the payback period. 0.80 year longer than the payback period. 1.27 years longer than the payback period. 1.85 years longer than the payback period.
What is the Payback period of a project with cash flows of -350,000 in year 0,...
What is the Payback period of a project with cash flows of -350,000 in year 0, then 100,000 each in years 1, 2 & 3, then 250,000 in year 4? Assume the cost of capital is 10%. 2.0 years 2.75 years 3.2 years can't tell from information given Consider the project in the previous question, what is its IRR? 5.56% 9.83% 14.1% 17.54%
(Payback period​) What is the payback period for the set of cash flows in the popup​...
(Payback period​) What is the payback period for the set of cash flows in the popup​ window, LOADING... ​? The payback period for the set of cash flows is nothing years. 0 -11,200 1 3,800 2 4,800 3 3,700 4 4,600 5 3,200 ​ (Payback ​period, NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash outlay of ​$75,000 and expected free cash flows of ​$22,000 at the end of each year for 6 years. The...
A. What is the payback period for the following set of cash flows?    Year Cash...
A. What is the payback period for the following set of cash flows?    Year Cash Flow 0 −$ 5,300        1 2,300        2 2,300        3 1,400        4 1,100        B. A project with an initial cost of $22,350 is expected to generate cash flows of $5,200, $7,300, $8,400, $7,300, and $6,000 over each of the next five years, respectively. What is the project's payback period? C. A new project has an initial cost of $133,000. The...
Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment...
Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment of $20,000 with expected after-tax operating cash flows of $125,000 per year for each of the next 3 years. However, in preparation for its termination at the end of year 3, an additional investment of $350,000 must be made at the end of Year 2. Please show all work in excel.
What is the payback period for the following set of cash flows?     Year Cash Flow...
What is the payback period for the following set of cash flows?     Year Cash Flow 0 −$ 4,200        1 2,500        2 2,600        3 2,600        4 1,900       
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT