Question

In: Finance

Captain America gets an offer for the next movie and wants you to analyze whether it's...

Captain America gets an offer for the next movie and wants you to analyze whether it's a good deal. Captain America will receive $200,000 per year starting on his 35th birthday and ending on his 70th birthday (his last payments will be on his 70th birthday). He then will receive $400,000 every six months starting six months after the last payments of $200,000 and ending on his 89th birthday. He will also receive $16,000,000 on his 90th birthday and another $16,000,000 on his 95th birthday.

Assuming he will be around until the end of the investments and celebrating his 30th birthday today and he has a 10% (semiannual). Use the PV concept. What is his offer?

Please use business calculator, no formulas or charts. (State what N, I, PMT, PV, FV) Please use timeline. Thanks!!

Solutions

Expert Solution

Present value of Captain America’s offer is $ 8,504,906.4 that he would receive in 60 years with a discount rate of 10% semiannual.

Period PMT PV (Discounted cash flows)
1            200,000.0          190,476.2 (200,000)/(1+.1/2)^1
2            200,000.0          181,405.9 (200,000)/(1+.1/2)^2
3            200,000.0          172,767.5
4            200,000.0          164,540.5
5            200,000.0          156,705.2
6            200,000.0          149,243.1
7            200,000.0          142,136.3
8            200,000.0          135,367.9
9            200,000.0          128,921.8
10            200,000.0          122,782.7
11            200,000.0          116,935.9
12            200,000.0          111,367.5
13            200,000.0          106,064.3
14            200,000.0          101,013.6
15            200,000.0             96,203.4
16            200,000.0             91,622.3
17            200,000.0             87,259.3
18            200,000.0             83,104.1
19            200,000.0             79,146.8
20            200,000.0             75,377.9
21            200,000.0             71,788.5
22            200,000.0             68,370.0
23            200,000.0             65,114.3
24            200,000.0             62,013.6
25            200,000.0             59,060.6
26            200,000.0             56,248.1
27            200,000.0             53,569.7
28            200,000.0             51,018.7
29            200,000.0             48,589.3
30            200,000.0             46,275.5
31            200,000.0             44,071.9
32            200,000.0             41,973.2
33            200,000.0             39,974.5
34            200,000.0             38,071.0
35            200,000.0             36,258.1
36            200,000.0             34,531.5
37            800,000.0          263,097.0 800000/(1+.1/2)^37*2
38            800,000.0          250,568.6
39            800,000.0          238,636.7
40            800,000.0          227,273.1
41            800,000.0          216,450.6
42            800,000.0          206,143.4
43            800,000.0          196,327.0
44            800,000.0          186,978.1
45            800,000.0          178,074.4
46            800,000.0          169,594.7
47            800,000.0          161,518.7
48            800,000.0          153,827.4
49            800,000.0          146,502.3
50            800,000.0          139,526.0
51            800,000.0          132,881.9
52            800,000.0          126,554.2
53            800,000.0          120,527.8
54            800,000.0          114,788.4
55            800,000.0          109,322.2
56      16,000,000.0       1,041,164.2 16000000/(1+.1/2)^56
57                            -  
58                            -  
59                            -  
60                            -  
61      16,000,000.0          815,779.4 16000000/(1+.1/2)^61
      8,504,906.4 Sum of all discounted cash flows

Related Solutions

in the movie " A Time to Kill", describe the situation that you analyze and interpret...
in the movie " A Time to Kill", describe the situation that you analyze and interpret the actions of the characters depicting social psychology in the courtroom. Draw conclusion based on social psychological Concepts and theories. you will analyze a 3 to 5 minutes segment of a movie or television episode depicting social psychology in the courtroom. after watching the movie segments create a 3-to-4 page report on your analysis. in your report mentioned the name of the movie, describe...
8. A business wants to know whether two versions of an email offer have the same...
8. A business wants to know whether two versions of an email offer have the same click-through proportion. It sent a random sample of customers an email. It randomly decided which of the two offers went in each email. In the end, it had the following data. 505 out of the 1218 customers that received the first email, clicked on the offer. 468 out of the 1221 customers that received the second email, clicked on the offer. (a) What is...
This week, you will analyze a three- to five-minute segment of a movie or a television...
This week, you will analyze a three- to five-minute segment of a movie or a television episode depicting conformity and obedience. After watching the movie segment, create a report on your analysis. In your report: Mention the name of the movie. Describe the setting and overall storyline of the movie. Describe the main characters in the observed movie section. Describe the situation that you analyzed and interpret the action of the characters depicting conformity and obedience. Draw conclusions based on...
You will analyze a three- to five-minute segment of a movie or a television episode depicting...
You will analyze a three- to five-minute segment of a movie or a television episode depicting cultural diversity and gender issues. After watching the movie segment, create a report on your analysis. In your report: Mention the name of the movie. Describe the setting and overall storyline of the movie. Describe the main characters in the observed movie section. Describe the situation that you analyzed and interpret the action of the characters depicting cultural diversity and gender issues. Draw conclusions...
It's cold--check your tires. When it gets cold, you have to add more air to car...
It's cold--check your tires. When it gets cold, you have to add more air to car tires. If a 1.90×10−2 m3m3  car tire at 299 KK  has an *absolute* pressure of only 213 kPa How many moles of air do you have to add to increase its *absolute* pressure to 271 kPa? The temperature and volume of the tire remain constant.
"Johari Window"- Either analyze a conversation from a TV or movie you have recently seen or...
"Johari Window"- Either analyze a conversation from a TV or movie you have recently seen or ideally, think of a recent conversation at work that was difficult or stressful and then analyze the conversation using the Johari approach (1-2 paragraphs).
If you were Joseph Wierda (BMW), what criteria would you use to decide whether to offer...
If you were Joseph Wierda (BMW), what criteria would you use to decide whether to offer video streaming for the X5 model?
The CFO of Rosecurity, is planning for the company's operations next year, and he wants you...
The CFO of Rosecurity, is planning for the company's operations next year, and he wants you to forecast the firm's additional funds needed (AFN). The firm is operating at full capacity. Data (in millions) for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year (in millions)? Last year's sales = $350, Last year's accounts payable = $40, Sales growth rate = 3%, Last year's notes payable = $50, Last...
To study whether movie ratings and release season influence the box office earnings, you gather data...
To study whether movie ratings and release season influence the box office earnings, you gather data on 70 recent movies. You characterize each movie’s rating (G, PG, PG-13, R, or NC-17) and release season (summer or not summer). Complete the ANOVA table below by filling in the shaded boxes Find the appropriate critical value(s) [?=0.05] Does box office revenue significantly vary with rating, release season, or their interaction? Clearly answer for each SS df MS F Rating 455    Season...
Angel Enterprise was going public in 2018. You were wondering whether the $30 per share offer...
Angel Enterprise was going public in 2018. You were wondering whether the $30 per share offer price is a fair price. You decided to use discounted cash flow approach to value the company’s stock. You gathered the following data: Year FCF Other Data 2019 $600,000 Growth rate of FCF beyond 2023 = 3% 2020 $900,000 Weighted Average Cost of Capital (WACC) = 10% 2021 $1,400,000 The firm has no debt 2022 2023 $1,800,000 $2,500,000 Number of common shares outstanding =...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT