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)

Related 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
ADVERTISEMENT