Question
In: Accounting
The Fab Five are planning on launching a new Netflix series. But which one? Antoni could...
The Fab Five are planning on launching a new Netflix series. But which one? Antoni could lead a sizzling cooking show which would cost $450,000 to shoot, but is guaranteed to earn $200,000 for the first year, then $100,000 for 3 more years, and finally $50,000 in its fifth year. Jonathan could just sit in front of the camera and be great for $100,000 to shoot, but he’d only earn cash flows of $25,000 for the next 7 years. There is the potential for Bobby to create a home makeover show which would cost $600,000 to make, but he’d earn them $300,000 the first year then $250,000 the next two years. Lastly, Tan and Karamo could produce a show about cultural influences on fashion. It would cost $200,000 to shoot and earn $50,000 for the first 2 years, then $100,000 for the next 2 years. Interest rates are currently 12%.
Which project is expected to be most profitable? If funding wasn’t an object, which show(s) should they create?
(Use Excell and use your knowledge about NPV, IRR, and scenario analysis method)
Solutions
Expert Solution
| CALCULATION OF NPV | ||||||
| ANTONY | ||||||
| YEAR |
AMOUNT (A) |
INTEREST RATE 12% (DISCOUNTING
RATE) (B) |
PRESENT VALUE (A*B) |
|||
| 1 | 200000 | 0.893 | 178571.43 | |||
| 2 | 100000 | 0.797 | 79719.39 | |||
| 3 | 100000 | 0.712 | 71178.02 | |||
| 4 | 100000 | 0.636 | 63551.81 | |||
| 5 | 50000 | 0.567 | 28371.34 | |||
| TOTAL | 421391.99 | |||||
| Net present value (NPV) | Present value of all cash flow - Initial Investment | |||||
| 421391.9917 - 450000 | ||||||
| -28608.01 | ||||||
| JONATHAN | ||||||
| Initial investnment | 1,00,000.00 | |||||
| A | cashflows | 25,000.00 | ||||
| B | Year | 7 | ||||
| C | PVIAF | 4.564 | ||||
| (Present value of annuity factor for 7 years @ 12%) | ||||||
| D | Present value of cashflow | A*C | ||||
| 25000*4.564 | ||||||
| 1,14,093.91 | ||||||
| NPV | Present value of all cash flow - Initial Investment | |||||
| 114093.91-100000 | ||||||
| 14,093.91 | ||||||
| BOBBY | ||||||
| YEAR |
AMOUNT (A) |
INTEREST RATE 12% (DISCOUNTING
RATE) (B) |
PRESENT VALUE (A*B) |
|||
| 1 | 3,00,000 | 0.893 | 2,67,857.14 | |||
| 2 | 2,50,000 | 0.797 | 1,99,298.47 | |||
| 3 | 2,50,000 | 0.712 | 1,77,945.06 | |||
| TOTAL | 6,45,100.67 | |||||
| NPV | Present value of all cash flow - Initial Investment | |||||
| 645100.67-600000 | ||||||
| 45,100.67 | ||||||
| Tan & Karamo | ||||||
| YEAR |
AMOUNT (A) |
INTEREST RATE 12% (DISCOUNTING
RATE) (B) |
PRESENT VALUE (A*B) |
|||
| 1 | 50,000 | 0.893 | 44,642.86 | |||
| 2 | 50,000 | 0.797 | 39,859.69 | |||
| 3 | 1,00,000 | 0.712 | 71,178.02 | |||
| 4 | 1,00,000 | 0.636 |
 ekkarill92 answered 2 years agoRelated SolutionsThe following five men are in a room discussing evolution, which one most likely could not...The following five men are in a room discussing
evolution, which one most likely could not agree with the other
four on most concepts associated with evolution? Can you also give
a short explanation of why you chose that answer.
A. Charles Darwin
B. Alfred Wallace
C. Charles Lyell
D. A modern day biologist
E. Georges Cuvier
Businesses are created in one of several organizational structures, or forms. Before launching any new business,...Businesses are created in one of several organizational
structures, or forms. Before launching any new business, an
essential step is to decide which business structure (sometimes
called business form) is most favorable for the business and its
owners. Jo, Maddy, and Taylor recognize the significance and
implications for choosing an appropriate business structure for
PI.
A priority goal for all the owners is to minimize legal risks
and liabilities, as well as tax liabilities, for the owners and the
business. ...
ABC, Inc is considering launching a new product which incurred $2.5 million in Research and Development...ABC, Inc is considering launching a new product which incurred
$2.5 million in Research and Development expenses over the last
year. The company will spend $1.8 million to acquire the equipment
necessary for the manufacture of the new product. The equipment
will last for 15 years and have a salvage value of $35,000. It will
be depreciated to zero over 10 years using straight line
depreciation. The company will also have an increase of $250,000 in
accounts receivable and a...
One of the key benefits identified early on was that a financial planning practice could: a.Attract...One of the key benefits identified early on was that a financial
planning practice could:
a.Attract clients otherwise not engaged in the purchase of
insurance, stocks or bonds
b.Develop a business that would have value that could be sold at
some point, such as retirement of the planner.
c.Consolidate sales of insurance and stock under one roof
d.Incorporate psychology into the financial services industry in
order to get consumers to buy more financial products.
Select one of the five COSO internal control components, Develop one control process that could be...Select one of the five COSO internal control components, Develop
one control process that could be associated with the COSO control
component you selected., Write 2 control activities related to the
control process you developed., Describe how each of
these two control activities could be tested.
Choose the statement which best describes the “Time Series Momentum”. Select one: a. In Time Series...Choose the statement which best describes the “Time Series
Momentum”.
Select one:
a.
In Time Series Momentum, we form a portfolio of all assets in
our universe. First, we use the volatility-scaled returns and then
invest appropriately
b.
Time Series Momentum examines each asset individually. If its
recent performance has been bad, then we go short, otherwise we go
long. Finally, our portfolio will include all assets
c.
Time Series Momentum is a special case of Cross-Sectional
Momentum where we...
Consider the series of elements below. Which series contains ONLY elements with one lone pair of...
Consider the series of elements below. Which series contains ONLY
elements with one lone pair of electrons in their Lewis symbol.
A. N,O,F
B. N,P, As
C. F,Cl,Br
D. Li, Na, K
E. None of the above
Please explain why the answer is B and why it can’t be C or D.
Thank you
Two baseball teams play a best-of-seven series, in which the series ends as soon as one...Two baseball teams play a best-of-seven series, in which the
series ends as soon as one team wins four games. The first two
games are to be played on A’s field, the next three games on B’s
field, and the last two on A’s field. The probability that A wins a
game is 0:7 at home and 0:5 away. Assume that the results of the
games are independent. Find the probability that:
(a) A wins the series in 4 games;...
One of the big Coffee chain is planning to open a new store in New York...One of the big Coffee chain is planning to open a new store in
New York
Opening a new store - Whether to go ahead or not. Below are some
details
Cost of Capital = 6.15%
Current Stores - 27000
Set up Costs: The cost of setting up a new
store is $5 million right now, and this cost is expected to grow at
the inflation rate in future years. The cost is depreciable,
straight line, over 10 years down...
The J. Mehta Company’s production manager is planning a series of one-month production periods for stainless...The J. Mehta Company’s production
manager is planning a series of one-month production periods for
stainless steel sinks. The forecasted demand for the next four
months is as follows:
Month
Demand for Stainless Steel Sinks
1
120
2
160
3
240
4
100
The Mehta firm can normally produce 100
stainless steel sinks in a month. This is done during regular
production hours at a cost of $100 per sink. If demand in any one
month cannot be satisfied by...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|