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

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.
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?
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 =...
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 =...
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 =...
Kitty Company is planning its operations for next year, and the CEO wants you to forecast...
Kitty Company is planning its operations for next year, and the CEO wants you to forecast the firm's additional funds needed (AFN). Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Last year's sales = S0 $200,000 Last year's accounts payable $50,000 Sales growth rate = g 40% Last year's notes payable $15,000 Last year's total assets = A0* $127,500 Last year's accruals $20,000 Last year's profit...
Kitty Company is planning its operations for next year, and the CEO wants you to forecast...
Kitty Company is planning its operations for next year, and the CEO wants you to forecast the firm's additional funds needed (AFN). Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Last year's sales = S0 $200,000 Last year's accounts payable $50,000 Sales growth rate = g 40% Last year's notes payable $15,000 Last year's total assets = A0* $127,500 Last year's accruals $20,000 Last year's profit...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT