Question
In: Finance
A movie is expected to produce cash flows of 26,600 dollars per month with the first...
A movie is expected to produce cash flows of 26,600 dollars per month with the first monthly cash flow expected later today and the last monthly cash flow expected in 5 months from today. The cost of capital for the movie is 22.44 percent per year. What is the value of the movie?
Holly just borrowed 137,598 dollars from the bank. She plans to repay this loan by making equal quarterly payments for 10 years. If the interest rate on the loan is 7.8 percent per year and she makes her first quarterly payment in 3 months from today, then how much must Holly pay to the bank each quarter?
Kaka just borrowed $4,630 from the bank. He plans to repay this loan by making equal semi-annual payments for 24 half years. If the interest rate on the loan is 5.46 percent per year and he makes his first semi-annual payment later today, then how much must Kaka pay to the bank each half year?
Yu-Na must borrow $657 from the bank to pay her phone bill. She plans to repay this loan by making monthly payments to the bank of $31 per month. If the annual interest rate on the loan is 10.68 percent and she makes her first $31 payment in 1 month from today, then how many payments must Yu-Na make? Round your answer to 2 decimal places (for example, 2.89, 14.70, or 6.00).
Solutions
Expert Solution
| Pmt | Cash Flow per month | $26,600 | |||||||||
| Nper | Number of periodic cash flows | 6 | |||||||||
| Rate | Monthly interest =(22.44/12)% | 0.0187 | |||||||||
| Type | Payments At Beginning of month | 1 | |||||||||
| PV | Present Value(PV) of cash flows | $152,452.48 | (Using PV function ofv excel with Rate=0.0187,Nper=6, Pmt=-26600,Type=1) | ||||||||
| ALTERNATIVE METHOD: | |||||||||||
| N | CF | PV=CF/(1.0187^N) | |||||||||
| Month | Cash flow | PV of cash flow | |||||||||
| 0 | $26,600 | $26,600.00 | |||||||||
| 1 | $26,600 | $26,111.71 | |||||||||
| 2 | $26,600 | $25,632.39 | |||||||||
| 3 | $26,600 | $25,161.86 | |||||||||
| 4 | $26,600 | $24,699.97 | |||||||||
| 5 | $26,600 | $24,246.56 | |||||||||
| $152,452.48 | |||||||||||
| VALUE OF MOVIE | $152,452.48 | ||||||||||
| Pv | Amount Borrowed | $137,598 | |||||||||
| Nper | Number of quarterly payments | 40 | (10*4) | ||||||||
| Rate | Quarterly interest rate=(7.8/4)% | (7.8/4)% | |||||||||
| PMT | Payment tobe made each quarter | $4,986.00 | (Using PMT function ofv excelwith Rate=(7.8/4)%,Nper=40, Pv=-137598) | ||||||||
| Pv | Amount Borrowed | $4,630 | |||||||||
| Nper | Number of Semi annual payments | 48 | (24*2) | 2.73 | |||||||
| Rate | Semi annual interest rate=(5.46/2)% | 2.73% | |||||||||
| Type | Payments At Beginning of month | 1 | |||||||||
| PMT | Payment tobe made each quarter | $169.59 | (Using PMT function ofv excelwith Rate=2.73%,Nper=48, Pv=-4630, Type=1) | ||||||||
| Pv | Amount Borrowed | $657 | |||||||||
| Pmt | Amount of Monthly payments | $31 | |||||||||
| Rate | Monthlyl interest rate=(10.68/12)% | 0.89% | |||||||||
| NPER | Number of months of payment | 23.59 | (Using NPER function ofv excelwith Rate=0.89%,Pmt=31, Pv=-657, ) | ||||||||
| Number of payments | 24 | (Last payment less than $31) | |||||||||
jeff jeffy answered 1 year agoRelated Solutions
A laundromat is expected to produce regular annual cash flows of 36,011 dollars with the first...
A laundromat is expected to produce regular annual cash flows of
36,011 dollars with the first regular cash flow expected later
today and the last regular cash flow expected in 7 years from
today. In addition to the regular cash flows of 36,011 dollars, the
laundromat is also expected to produce an extra cash flow of 38,159
dollars in 7 years from today. The cost of capital for the
laundromat is 15.01 percent. What is the value of the
laundromat?
Project P costs $10,400 and is expected to produce cash flows of $3,650 per year for...
Project P costs $10,400 and is expected to produce cash flows of
$3,650 per year for five years.
Project Q costs $30,000 and is expected to produce cash flows of
$9,250 per year for five years.
a. Calculate the NPV, IRR, MIRR, and traditional payback period
for each project, assuming a required rate of return of 8
percent.
b. If the projects are independent, which project(s) should be
selected? If they are mutually exclusive, which project should be
selected?
Machine A costs $850,000 and would produce cash flows of $220,000 per year for the first...
Machine A costs $850,000 and would produce cash flows of
$220,000 per year for the first two years, $350,000 per year for
the next two years, and $150,000 in the final year. Machine B costs
$650,000 and would produce cash flows of $250,000 per year for the
first two years, $200,000 the following year, $150,000 in its
fourth year, and $140,000 in its final year. Your required return
is 11%. What is the IRR of buying machine B?
Project P costs $15,000 and is expected to produce benefits (cash flows) of $4,500 per year...
Project P costs $15,000 and is expected to produce benefits
(cash flows) of $4,500 per year for five years. Project Q costs
$37,500 and is expected to produce cash flows of $11,100 per year
for five years. Calculate each project’s (a) net present value
(NPV), (b) internal rate of return (IRR), and (c) modified internal
rate of return (MIRR). The firm’s required rate of return is 14
percent. If the projects are independent, which project (s) should
be selected? If...
Project P costs $15,000 and is expected to produce benefits (cash flows) of $4,500 per year...
Project P costs $15,000 and is expected to produce benefits
(cash flows) of $4,500 per year for five years. Project Q costs
$37,500 and is expected to produce cash flows of $11,100 per year
for five years. Calculate each project’s (a) net present value
(NPV), (b) internal rate of return (IRR), and (c) mod- ified
internal rate of return (MIRR). The firm’s required rate of return
is 14 percent. Compute the (a) NPV, (b) IRR, (c) MIRR,
and (d) discounted payback...
An investment is expected to produce cash flows of $1,000 at the end of each of...
An investment is expected to produce cash flows of $1,000 at the
end of each of the next 6 years, then an additional lump sum
payment of $1,500 at the end of Year 6. What is the maximum price
you are willing to pay for this investment now if your expected
rate of return is 4%?
Select one:
a. $5,324.89
b. $5,974.77
c. $5,568.13
d. $6,427.61
e. $4,854.13
You are evaluating a project that will cost $497,000, but is expected to produce cash flows...
You are evaluating a project that will cost
$497,000,
but is expected to produce cash flows of
$123,000
per year for
10
years, with the first cash flow in one year. Your cost of
capital is
11.2%
and your company's preferred payback period is three years or
less.
a. What is the payback period of this project?
b. Should you take the project if you want to increase the value
of the company?
a. What is the payback period of...
Silky Smooth Studio (SMS) is considering investing in a movie project. The expected cash flows of...
Silky Smooth Studio (SMS) is considering investing in a movie
project. The expected cash flows of the project are given in the
table below.
Year
0
1
2
3
Cash Flow
-$100,000
$45,000
$45,000
$45,000
The required return of the project is 12 percent.
Using Net Present Value as the decision criterion, should SMS
invest in this movie? Explain carefully.
What is the discounted payback period of this project?
8. Project R has a cost of $ 10,000 and in expected to produce cash flows...
8. Project R has a cost of $ 10,000 and in expected to produce
cash flows per year of $ 4,000 for 3 years. Project S has a cost of
$20,000 and in expected to produce cash flows of $ 7,000 per year
for 4 years. Calculate the 2 projects' NPVs, IRRs, MIRRs, and PIs,
assuming a cost of capital of 11%. Which project should be selected
?
You are evaluating a project that is expected to produce cash flows of $5,000 each year...
You are evaluating a project that is expected to produce cash
flows of $5,000 each year for the next 3 years and $7,000 each year
for the following 3 years. The IRR of this 6-year project is 12%.
If the firm’s WACC is 10%, what is the project’s NPV?
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- PUT IN JAVA PROGRAMMING The StockB class: Design a class named StockB that contains the following...
- Draw a DFA for the following ( ∑ = {0,1}): Set of all strings with.
- In the article from Forbes notes that the goal of a leader is not to clone...
- Many people keep time using a 24 hour clock (11 is 11am and 23 is 11pm,...
- UNIX ONLY -- DIFFICULT LAB ASSIGNMENT This is an extremely difficult subject for me. Could you...
- Do you know why your credit card can be refused even though you are profitable?
- The Following Java expression: S/10 * 10 + 10 – S = C Show that this...
ADVERTISEMENT