Question: please help me with this problem, I need excel tables Bill Clinton reportedly was paid $15 million to write his book My Life. Suppose the

please help me with this problem, I need excel tables

Bill Clinton reportedly was paid $15 million to write his book My Life. Suppose the book took three years to write. In the time he spent writing, Clinton could have been paid to make speeches. Given his popularity, assume that he could earn $8 million per year (paid at the end of the year) speaking instead of writing. Assume his cost of capital is 10% per year. a) What is the NPV of agreeing to write the book (ignoring any royalty payments)? b) How many IRRs are there in part a) ? Does the IRR rule give the right answer in the case? Plot NPV profile using discount rates from 0% to 80% in 5% increments. Explain your reasoning with this NPV profile plot. Use Excel solver to compute exact IRRs. c) Assume that, once the book is finished, it is expected to generate royalties of $5 million in the first year (paid at the end of the year) and these royalties are expected to decrease at a rate of 30% per year in perpetuity. What is the NPV of the book with the royalty payments? d) How many IRRs are there in part c) ? Does the IRR rule work in this case? Plot NPV profile using discount rates from 0% to 80% in 5% increments. Explain your reasoning with this NPV profile plot. Use Excel solver to compute exact IRRs. Bill Clinton reportedly was paid $15 million to write his book My Life. Suppose the book took three years to write. In the time he spent writing, Clinton could have been paid to make speeches. Given his popularity, assume that he could earn $8 million per year (paid at the end of the year) speaking instead of writing. Assume his cost of capital is 10% per year. a) What is the NPV of agreeing to write the book (ignoring any royalty payments)? b) How many IRRs are there in part a) ? Does the IRR rule give the right answer in the case? Plot NPV profile using discount rates from 0% to 80% in 5% increments. Explain your reasoning with this NPV profile plot. Use Excel solver to compute exact IRRs. c) Assume that, once the book is finished, it is expected to generate royalties of $5 million in the first year (paid at the end of the year) and these royalties are expected to decrease at a rate of 30% per year in perpetuity. What is the NPV of the book with the royalty payments? d) How many IRRs are there in part c) ? Does the IRR rule work in this case? Plot NPV profile using discount rates from 0% to 80% in 5% increments. Explain your reasoning with this NPV profile plot. Use Excel solver to compute exact IRRs

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Can someone please help me with a and b? Thank you again! Bill Clinton reportedly was paid $15.0 million to write his book My Life. The book took three years to write. In the time he spent writing,...

Bill Clinton reportedly was paid $15 million to write his book Mfy Life. The book took three years to write. In the time be spent writing, Clinton could have been paid to make speeches. Given his...

only need the NPV profile graph in Q3 3. Bill Clinton reportedly was paid $15 million to write his book My Life. Suppose the book took three years to write. In the time he spent writing, Clinton...

2. Bill Clinton reportedly was paid $15 million to write his book My Life . Suppose the book took three years to write. In the time he spent writing, Clinton could have been paid to make speeches....

Please answer in excel formula format. This is the full question with all the information. Bill Clinton reportedly was paid $15 million to write his book My L . Suppose the book took three years to...

Bill Clinton reportedly was paid $15 million to write his book My Way . The book took three years to write. In the time he spent writing, Clinton could have been paid to make speeches. Given his...

5. Bill Clinton reportedly was paid $15 million to write his book My Life. Suppose the book took three years to write. In the time he spent writing, Clinton could have been paid to make speeches....

3. Bill Clinton reportedly was paid $15 million to write his book My Life. Suppose the book took three years to write. In the time he spent writing, Clinton could have been paid to make speeches....

(a) For two inductors in series as in Fig. 6.81(a), show that the current-division principle is Assuming that the initial conditions are zero (b) For two inductors in parallel as in Fig. 6.81(b),...

Refer to figure. Suppose a tax of $3 per unit is imposed on this market. price 10 9 DE 7 6 4 2 5 10 15 20 25 30 35 40 45 50 55 60 S R What will be the new equilibrium quantity in this market? 8 D B

During the presentation, you must: Explain the contents of the budget Inform the group of the reporting requirements Explain the financial delegations Ask questions to confirm the information has...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...