Business

FinanceQ&A LibraryBill Clinton reportedly was paid $10 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.(Show excel spreadsheet workings)A. What is the NPV of agreeing to write the book (ignoring any royalty payments)? What is the :PV of losing the speaking fees_______NPV of book deal_______B. 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? What is the:PV of perpetuity at year 3_______PV of perpetuity at year 0 _______NPV of book deal______Question

Asked Apr 4, 2019

54 views

Bill Clinton reportedly was paid $10 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.

(Show excel spreadsheet workings)

**A.** What is the NPV of agreeing to write the book (ignoring any royalty payments)? **What is the :**

**PV of losing the speaking fees**_______

**NPV of book deal**_______

** B. **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?

**PV of perpetuity at year 3___**____

**PV of perpetuity at year 0 _______**

**NPV of book deal______**

Step 1

Since you have specifically asked for excel workings, a snpashot of the excel model is attached for your reference. The calculated values appear in the cell ...

Tagged in

Find answers to questions asked by student like you

Show more Q&A

Q: Burke's Corner currently sells blue jeans and T-shirts. Management is considering adding fleece tops...

A: Please see the table below. Please be guided by signs like [+] / [-] used in each row item to help y...

Q: Could you please give me a brief overview of what "cash flow for ROR analysis" is? Thanks.

A: ROR analysis is a short form for Rate of Return Analysis.Under ROR analysis, we need to find that Ra...

Q: Romagnoli Company is considering a 3-year investment project that involves the purchase of a new man...

A: Since we have to handle multiple variables here, we will use Microsoft Excel to get the final answer...

Q: investment QUICK AND SLOW COST $1,000 each, are mutually exclusive, and have the following cash flow...

A: All the financials shown in the solution are in $. Figures in parenthesis mean negative values.The f...

Q: You are creating a portfolio that consists of the following two bonds. Bond A pays an annual 7 perce...

A: We will use the MDURATION function of the excel to calculate the modified duration of bond A.Let's a...

Q: on B (Use the answer from part a to find these answers. Round to the nearest cent as needed.)

A: P = $ 150,000r = 3% = 0.03n = 12 (months in a year)t = 40 years

Q: Multinational companies are exposed to complex management and allocation of their resources. A multi...

A: Question 1:Calculate the change in the dollar value of inventory:

Q: Shown below are the investment weights for the securities held in four different portfolios: three m...

A: a.Formula for calculation of active share (AS):

Q: A project will produce cash inflows of $3,200 a year for 4 years with a final cash inflow of $5,700 ...

A: Calculation of NPV: Excel spread sheet: