You must decide whether to produce Straight Out of New Canaan, a biographical film about four thugs
Question:
You must decide whether to produce "Straight Out of New Canaan”, a biographical film about four thugs who acquire fortune and fame as "gansta” rappers. The budget, or initial investment, to produce the film and the cash flows it is forecast to generate are shown in the table below. Beyond year 5, the film is expected to earn a cash flow of $200,000 perpetually. What is the "Internal Rate of Return" or return that would be earned if the forecast is accurate? This can only be answered by "trial and error". The process can be expedited by using Excel to enter cash flows and test various rates of return. Round the answer to one one-hundredth of a percent - i.e. 1 basis point
Quantitative Methods for Business
ISBN: 978-0324651751
11th Edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam