Question
In: Accounting
1) tesla is planning to produce an all-electric family car and expects the following cash flows(in$million)...
1)
tesla is planning to produce an all-electric family car and expects
the following cash flows(in$million) at the end of each year:
year 0
cash flow-180;year 1 cash flow10; year2 cash flow20; year 3
cash flow 40; year5 cash flow 110.
the required return for the project is 11%.
a. create an excel spreadsheet with the present value of each
cash flow. what is the projects Nvp?
b.there is an easier way: what is the NVp using excels Nvp
function? note that excels Nvp function all the cash flows in the
range, even the first one
2)you've estimated the following cash flows(in$) for a
project: A. B.
year. cash flow
0 -5,600
1 1,325
2 2,148
3 3,472
required return for project is 8%
What is the IRR for the project?
3)you've estimated the following cash flows (in$) for two
mutually exclusive projects
year. projectA projectB
0 -5,700 -8,550
1 1,325 1,325
2 2,148 2,148
3 4,429 8,245
the required return for both projects is 8%
What is the IRR for project B?
What is NVP for project A?
What is NVP for project B?
Solutions
Expert Solution
The following is the answer for the above questions, i will include the cell reference of formulas used also in the end for the question 1 and for one IRR calculation.
Screen Shots of Formulas Used:
ekkarill92 answered 2 years agoRelated Solutions
A diamond mine is expected to produce regular annual cash flows of $1 million for 8...
A diamond mine is expected to produce regular annual cash flows
of $1 million for 8 years with the first regular cash flow expected
in 1 year from today. In addition to the regular cash flows of
$1,000,000, the diamond mine is also expected to produce an extra
cash flow of $3,000,000 in 8 years from today. The cost of capital
for the mine is 12 percent. What is the value of the mine?
Bob has an investment worth $300,000....
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?
The firm Lando expects cash flows in one year’s time of $90 million if the economy...
The firm Lando expects cash flows in one year’s time of $90
million if the economy is in a good state or $40 million if it is
in a bad state. Both states are equally likely. The firm also has
debt with face value $65 million due in one year.
Lando is considering a new project that would require an
investment of $30 million today and would result in a cash flow in
one year’s time of $47 million in...
The firm Lando expects cash flows in one year’s time of $90 million if the economy...
The firm Lando expects cash flows in one year’s time of $90
million if the economy is in a good state or $40 million if it is
in a bad state. Both states are equally likely. The firm also has
debt with face value $65 million due in one year.
Lando is considering a new project that would require an
investment of $30 million today and would result in a cash flow in
one year’s time of $47 million in...
The firm Lando expects cash flows in one year’s time of $90 million if the economy...
The firm Lando expects cash flows in one year’s time of $90
million if the economy is in a good state or $40 million if it is
in a bad state. Both states are equally likely.
The firm also has debt with face value $65 million due in one
year.
Lando is considering a new project that would require an
investment of $30 million today and would result in a cash flow in
one year’s time of $47 million in...
The firm Lando expects cash flows in one year’s time of $90 million if the economy...
The firm Lando expects cash flows in one year’s time of $90
million if the economy is in a good state or $40 million if it is
in a bad state. Both states are equally likely. The firm also has
debt with face value $65 million due in one year. Lando is
considering a new project that would require an investment of $30
million today and would result in a cash flow in one year’s time of
$47 million in...
The firm Tehbye expects cash flows in one year’s time of $90 million if the economy...
The firm Tehbye expects cash flows in one year’s time of $90
million if the economy is in a good state or $40 million if it is
in a bad state. Both states are equally likely. The firm also has
debt with face value $65 million due in one year.
Tehbye is considering a new project that would require an
investment of $30 million today and would result in a cash flow in
one year’s time of $47 million...
The firm Lando expects cash flows in one year’s time of $90 million if the economy...
The firm Lando expects cash flows in one year’s time of $90
million if the economy is in a good state or $40 million if it is
in a bad state. Both states are equally likely. The firm also has
debt with face value $65 million due in one year. Lando is
considering a new project that would require an investment of $30
million today and would result in a cash flow in one year’s time of
$47 million in...
The firm Lando expects cash flows in one year’s time of $90 million if the economy...
The firm Lando expects cash flows in one year’s time of $90
million if the economy is in a good state or $40 million if it is
in a bad state. Both states are equally likely. The firm also has
debt with face value $65 million due in one year.
Lando is considering a new project that would require an
investment of $30 million today and would result in a cash flow in
one year’s time of $47 million in...
The firm Lando expects cash flows in one year’s time of $90 million if the economy...
The firm Lando expects cash flows in one year’s time of $90
million if the economy is in a good state or $40 million if it is
in a bad state. Both states are equally likely. The firm also has
debt with face value $65 million due in one year.
Lando is considering a new project that would require an
investment of $30 million today and would result in a cash flow in
one year’s time of $47 million in...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- C++ C++ Write a definition for a structure type for records for CDs. The record contains...
- Research Question: Does the spatial ability differ by biological sex? (Use Data A) Null Hypothesis: Spatial...
- Write a method speedingTicket() that decides whether a driver should be given a ticket from a...
- Beasley Ball Bearings paid a $4 dividend last year. The dividend is expected to grow at...
- 7. In order to improve the network performance and security, ACLs is recommended. Please explain what...
- Noting that there has been an increasing interest in organic foodstuffs with increasing affluence, Mr Tommy...
- 1. the physical sites at which crossing over occurs are the.... A. chiasmata B. Centrioles C....
ADVERTISEMENT