Please submit the exam in Microsoft Word. Other formats are not acceptable.

ACTIVITY: CAPITAL BUDGETING PRACTICEComplete the following and submit it in a Word document. Be sure to show your process and calculations:Assume you have just retired as the CEO of a successful company. A major publisher has offered you a book deal. The publisher will pay you $1 million up front if you agree to write a book about your experiences. You estimate that it will take three years to write the book. The time you spend writing will cause you to give up speaking engagements amounting to $500,000 per year. You estimate your opportunity cost to be 10%.Should you accept this deal? Plot a diagram that measures NPV (on the y-axis) vs. discount rate (on the x-axis) to solve this problem. (Hint: Have your scale on the x-axis go to 50% (discount rate)).Determine the IRR for this deal. (Hint: IRR is the point at which NPV = 0)Suppose you inform the publisher that it needs to sweeten the deal before you will accept it. The publisher offers $550,000 advance and $1,000,000 in four years when the book is published.Should you accept or reject the new offer? Again, plot a diagram that measures NVP (on the y-axis) vs. discount rate (on the x-axis) to solve this problem. (Hint: Have your scale on the x-axis go to 50% (discount rate)).Determine the IRRs for this deal (Hint: There are two IRRs for this problem).Discuss if the IRR rule for making budgetary decisions can be used in this case.Finally, you are able to get the publisher to increase your advance to $750,000, in addition to the $1 million when the book is published in four years.Should you accept or reject this new offer? Again, plot a diagram that measures NVP (on the y-axis) vs. discount rate (on the x-axis) to solve this problem. (Hint: Have your scale on the x-axis go to 50% (discount rate)).Determine the IRR for this deal.State three conclusions regarding the use of IRR vs. NPV that you can make from questions 2–4. Which is the stronger method to use (IRR or NPV), and why?By submitting this paper, you agree: (1) that you are submitting your paper to be used and stored as part of the SafeAssign™ services in accordance with the Blackboard Privacy Policy; (2) that your institution may use your paper in accordance with your institution's policies; and (3) that your use of SafeAssign will be without recourse against Blackboard Inc. and its affiliates.

Please see the files bellow to see the details (Only Question 4) Data Mining onlyyOnly do Question 4 the Data Mining and Cluster Analysis with the Red color discard 1,2,3 I can't write the description here, the prof might search on Google then he will find someone get answers from hereit's all about statistics, analytics, and excel,data mining