In: Finance
You are considering opening a drive-in movie theater and running it for ten years. You have spent after-tax $10,000 researching the land that will be used for theater, but if you take the project you expect to incur another immediate after-tax expense of $20,000 as you work with a consulting firm to decide how to most efficiently run the business.
The project entails an immediate $100,000 capital expenditure, which can be depreciated over 10 years. You expect to sell this capital investment for $25,000 at the end of the ten year project. Working capital expenses for the project are $50,000 immediately, $40,000 incurred two years from today, both of which are fully recovered in ten years (at the end of the project).
The project’s operating costs are expected to be $100,000 for each of the first five years and then (starting between t=5 and t=6) grow at -5% per year through the end of the project (i.e., through t=10). You expect the project’s revenues to start at $100,000 starting one year from today and remain constant for the life of the project.
Can you add as much details as you can, Thank you!
Present Value(PV) of Cash Flow: | |||||||||||||
(Cash Flow)/((1+i)^N) | |||||||||||||
i=discount rate =10%=0.1 | |||||||||||||
N=Year of Cash Flow | |||||||||||||
Amount of $10000 already spent is sunk cost and not relevant | |||||||||||||
CASH FLOW ANALYSIS OF THE PROJECT | |||||||||||||
N | Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
a | Cash Flow for fixed asset investment | -$100,000 | |||||||||||
b | Immediate after tax cash expense | -$20,000 | |||||||||||
c | Initial cash flow for working capital | -$50,000 | |||||||||||
D=a+b+c | Total initial cash flow | -$170,000 | |||||||||||
e | Annual Revenues | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | ||
f | Annual Operating Costs | -$100,000 | -$100,000 | -$100,000 | -$100,000 | -$100,000 | -$95,000 | -$90,250 | -$85,738 | -$81,451 | -$77,378 | ||
g | Annual Depreciation expense (100000-25000)/10 | -$7,500 | -$7,500 | -$7,500 | -$7,500 | -$7,500 | -$7,500 | -$7,500 | -$7,500 | -$7,500 | -$7,500 | ||
h=e+f+g | Before tax operating profit | -$7,500 | -$7,500 | -$7,500 | -$7,500 | -$7,500 | -$2,500 | $2,250 | $6,763 | $11,049 | $15,122 | ||
i=-h*25% | Tax (Expenses)/Savings | $1,875 | $1,875 | $1,875 | $1,875 | $1,875 | $625 | -$563 | -$1,691 | -$2,762 | -$3,780 | ||
j=h+i | After tax operating profit | -$5,625 | -$5,625 | -$5,625 | -$5,625 | -$5,625 | -$1,875 | $1,688 | $5,072 | $8,287 | $11,341 | ||
k | Add depreciation expenses(non cash) | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | ||
L=j+k | Annual Operating Cash Flow | $1,875 | $1,875 | $1,875 | $1,875 | $1,875 | $5,625 | $9,188 | $12,572 | $15,787 | $18,841 | ||
M | After tax salvage value | $25,000 | |||||||||||
P | Working capital Cash Flow | -$40,000 | $90,000 | ||||||||||
CF=D+L+M+P | Net Cash Flow | ($170,000) | $1,875 | ($38,125) | $1,875 | $1,875 | $1,875 | $5,625 | $9,188 | $12,572 | $15,787 | $133,841 | SUM |
PV=CF/(1.1^N) | Present Value of Net Cash Flow | ($170,000) | $1,705 | ($31,508) | $1,409 | $1,281 | $1,164 | $3,175 | $4,715 | $5,865 | $6,695 | $51,602 | ($123,899) |
NPV=Sum of PV | Net Present Value(NPV) | ($123,899) | |||||||||||
If Salvage Value is $75000 instead of $25000 | |||||||||||||
Difference in Salvage Value=(75000-25000) | $50,000 | ||||||||||||
Present Value of the difference=50000/(1.1^10)= | $19,277 | ||||||||||||
NPV is increased by $19277 | |||||||||||||
Still the NPV will be negative |
Related SolutionsYou are considering opening a drive-in movie theater and running it for ten years. You have...You are considering opening a drive-in movie theater and
running it for ten years. You have spent after-tax $10,000
researching the land that will be used for theater, but if you take
the project you expect to incur another immediate after-tax expense
of $20,000 as you work with a consulting firm to decide how to most
efficiently run the business.
The project entails an immediate $100,000 capital
expenditure, which can be depreciated over 10 years. You expect to
sell this...
You are considering opening a drive-in movie theater and running it for ten years. You have...You are considering opening a drive-in movie theater and
running it for ten years. You have spent after-tax $10,000
researching the land that will be used for theater, but if you take
the project you expect to incur another immediate after-tax expense
of $20,000 as you work with a consulting firm to decide how to most
efficiently run the business.
The project entails an immediate $100,000 capital
expenditure, which can be depreciated over 10 years. You expect to
sell this...
Think about the last movie you saw in a movie theater. What aspects of the movie...Think about the last movie you saw in a movie theater. What
aspects of the movie had international components in it? Are there
more international elements included than compared to your favorite
movie from 10 years ago?
At the movies: A movie theater is considering a showing of Puppet Master for a 80's...At the movies: A movie theater is considering a
showing of Puppet Master for a 80's thowback night. In order to
ensure the success of the evening, they've asked a random sample of
53 patrons whether they would come to the showing or not. Of the 53
patrons, 30 said that they would come to see the film. Construct a
95% confidence interval to determine the true proportion of all
patrons who would be interested in attending the showing.
a)...
The managers at Melody’s Movie theater are considering whether to upgrade their film projector. The upgraded...The managers at Melody’s Movie theater are considering whether
to upgrade their film projector. The upgraded projector costs
$120,000 and will last for an estimated 6 years. It will be
depreciated using the 3-year MACRS schedule. The upgraded projector
will have an estimated $5,000 salvage value in year 7.
The upgraded projector will replace the theater’s existing
projector. The existing projector was purchased 5 years ago, for
$45,000. The old projector was also depreciated using the 3-year
MACRS schedule. If...
Customers arrive at a movie theater at the advertised movie time only to find that they have to sit through several previews and pre-preview ads before the movie starts.
Customers arrive at a movie theater at the advertised movie time only to find that they have to sit through several previews and pre-preview ads before the movie starts. Many complain that the time devoted to previews is too long.† A preliminary sample conducted by The Wall Street Journal showed that the standard deviation of the amount of time devoted to previews was 6 minutes. Use that as a planning value for the standard deviation in answering the following...
You’ve been assigned to set the price at the local movie theater. You know that market...You’ve been assigned to set the price at the local movie
theater. You know that market demand can be broken into two groups,
students and non-students. Those functions are: Students: p = 12 −
1/4q Non-Students: p = 22 − q (if you aggregated those functions,
you would obtain p = 22 − q if p > 12 and p = 14 −1/5q if p ≤
12). You’ve also been given the total cost and marginal cost for
the theater....
You are considering making a movie. The movie is expected to cost $ 10.5million upfront and...You are considering making a movie. The movie is expected to
cost $ 10.5million upfront and take a year to produce. After that,
it is expected to make $ 4.5 million in the year it is released and
$ 1.9 million for the following four years. What is the payback
period of this investment? If you require a payback period of two
years, will you make the movie? Does the movie have positive NPV
if the cost of capital is...
5. You want to retire in ten years and you currently have no wealth to your...5. You want to retire in ten years and you currently
have no wealth to your name. You estimate that you’ll will need
$1.8M at your retirement date in order to live out the remainder of
your life comfortably. You plan to make 10 equal annual payments
into an account at the end of each year from now until your retire.
If you can earn 8%/year, compounded annually, how much must you
invest at the end of each year for...
You are considering making a movie. The movie is expected to cost $ 10.4 million up...You are considering making a movie. The movie is expected to
cost $ 10.4 million up front and take a year to produce. After
that, it is expected to make $ 4.6 million in the year it is
released and $ 1.6 million for the following four years.
What is the payback period of this investment?
If you require a payback period of two years, will you make
the movie?
Does the movie have positive NPV if the cost of...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|