Question

Part (a) It is said (S. Branch Walker) that the Indian who sold Manhattan for $29...

Part (a) It is said (S. Branch Walker) that the Indian who sold Manhattan for $29 was a sharp salesman. If he had put his $29 away at 4% compounded semiannually, it would now be worth over $8 billion, and he could buy most of the now-improved land back! Assume that this seller invested on January 1, 1701, the $29 he received. (Round your answers to the nearest whole dollar amount and not in millions.)

Required: 1. Use Excel to determine the balance of the investment as of December 31, 2018, assuming a 4% interest rate compounded semiannually. (Hint: Use the FV function in Excel.)

2. Use Excel to determine the balance of the investment as of December 31, 2018, assuming an 5% annual interest rate, compounded semiannually. (Hint: Use the FV function in Excel.)

3. What would be the balances for requirements 1 and 2 if interest is compounded quarterly?

4. Assume that the account consisting of this investment had a balance of $8.5 billion as of December 31, 2018. How much would the total amount be on December 31, 2024, if the annual interest rate is 5%, compounded semiannually?

Part (b) In 2000, a star major-league baseball player signed a 10-year, $257 million dollar contract with the Texas Rangers. Assume that equal payments would have been made each year to this individual and that the owner’s cost of capital (discount rate) was 11% at the time the contract was signed. What is the present value cost of the contract to the owners as of January 1, 2000, the date the contract was signed, in each of the following independent situations? (Round your answers to the nearest whole dollar amount and not in millions.)

Required: 1. The baseball player received the first payment on December 31, 2000.

2. The baseball player received the first payment on January 1, 2000, the date the contract was signed.

3. Assuming the owner is in the 43% income tax bracket, calculate your answer for requirement 1.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Please give positive ratings so I can keep answering. If you have any queries please comment. Thanks!
As per Chegg policy I have solved first four questions. Thanks!
We know FV=P*(1+i)^n
Where FV= Future Value
P= Principle
i= interest rate
n=number of compounding for the period
Answer to part a_1
Here P= $29
Rate of interest 4%
i= 4%/2= .02 as it is compounded semiannually.
Number of years from 1701 to 2018= 318
n=                                    636.00 as it is compounded semiannually so 318*2
FV=P*(1+i)^n
FV=29*(1+.02)^636
FV=                        8,552,779.00
The balance of the investment as of December 31, 2018 is $ 8,552,779.
Answer to part a_2
Here P= $29
Rate of interest 5%
i= 5%/2= .025 as it is compounded semiannually.
Number of years from 1701 to 2018= 318
n=                                    636.00 as it is compounded semiannually so 318*2
FV=P*(1+i)^n
FV=29*(1+.025)^636
FV=                    191,768,110.00
The balance of the investment as of December 31, 2018 is $ 191,768,110.
Answer to part a_3
Here P= $29 Here P= $29
Rate of interest 4% Rate of interest 5%
i= 4%/4= .01 as it is compounded quarterly. i= 5%/4= .0125 as it is compounded quarterly.
Number of years from 1701 to 2018= 318 Number of years from 1701 to 2018= 318
n=                                 1,272.00 as it is compounded quarterly so 318*4 n=                1,272.00 as it is compounded quarterly so 318*4
FV=P*(1+i)^n FV=P*(1+i)^n
FV=29*(1+.01)^1272 FV=29*(1+.0125)^1272
FV=                        9,103,019.00 FV= 211,289,813.00
The balance of the investment as of December 31, 2018 is $ 9,103,019. The balance of the investment as of December 31, 2018 is $ 211,289,813.
Answer to part a_4
Here P= $8,500,000,000
Rate of interest 5%
i= 5%/2= .025 as it is compounded semiannually.
Number of years from 2018 to 2024= 6
n=                                      12.00 as it is compounded semiannually so 6*2
FV=P*(1+i)^n
FV=8500000000*(1+.025)^12
FV=              11,431,555,006.00
The balance of the investment as of December 31, 2024 is $ 11,431,555,006.
Add a comment
Know the answer?
Add Answer to:
Part (a) It is said (S. Branch Walker) that the Indian who sold Manhattan for $29...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Part (a): It is said that the Indian who sold Manhattan for $37 was a sharp...

    Part (a): It is said that the Indian who sold Manhattan for $37 was a sharp salesman. If he had put his $37 away at 8% compounded semiannually, it would now be worth more than $4 billion, and he could buy most of the now-improved land back! Assume that this seller invested on January 1, 1701, the $37 he received. (Enter amounts in whole dollars, not in billions. Round final answers to nearest whole dollar amount.) Required: 1. Use Excel...

  • Check my work Part (a): It is said that the Indian who sold Manhattan for $40...

    Check my work Part (a): It is said that the Indian who sold Manhattan for $40 was a sharp salesman. If he had put his $40 away at 5% compounded semiannually, it would now be worth more than $7 billion, and he could buy most of the now-improved land back! Assume that this seller invested on January 1, 1701, the $40 he received. (Enter amounts in whole dollars, not in billions. Round final answers to nearest whole dollar amount.) 0.25...

  • It is said that the Indian who sold Manhattan for $26 was a sharp salesman. If he had put his $26 away at 5% compounded...

    It is said that the Indian who sold Manhattan for $26 was a sharp salesman. If he had put his $26 away at 5% compounded semiannually, it would now be worth more than $8 billion, and he could buy most of the now-improved land back! Assume that this seller invested on January 1, 1701, the $26 he received. (Enter amounts in whole dollars, not in billions. Round final answers to nearest whole dollar amount.) Required: 1. Use Excel to determine...

  • Determine the effective annual yield for each investment. Then select the better investment. Assume 360 days...

    Determine the effective annual yield for each investment. Then select the better investment. Assume 360 days in a year. 11% compounded monthly: 11.25% compounded annually %. The effective annual yield for a 11% compounded monthly investment is (Round to two decimal places as needed.) Determine the effective annual yield for each investment. Then select the better investment. Assume 360 days in a year. 3% compounded semiannually; 2.9% compounded daily %. The effective annual yield for a 3% compounded semiannually investment...

  • A professional baseball player signs a contract for $164 million to play with a team for 7 years. He and his team agree...

    A professional baseball player signs a contract for $164 million to play with a team for 7 years. He and his team agree that the contract will be spread out so that the player is paid beyond the 7 years. The payment plan for the contract is as follows: $17 million each year for years 1 through 7. $3.1 million each year for the next 9 years. $1.4 million each year for the next 7 years. You should assume that...

  • 10. On January 1, 2018, Wright Transport sold four school buses to the Elmira School District....

    10. On January 1, 2018, Wright Transport sold four school buses to the Elmira School District. In exchange for the buses, Wright received a note requiring payment of $524,000 by Elmira on December 31, 2020. The effective interest rate is 9%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.): Required: 1. How much sales revenue would Wright recognize on January 1, 2018,...

  • On January 1, 2018, Wright Transport sold four school buses toElmira School District. In exchange...

    On January 1, 2018, Wright Transport sold four school buses to Elmira School District. In exchange for the buses, Wright received a note requiring payment of $518,000 by Elmira on December 31, 2020. The effective interest rate is 9%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1, and PVAD of $1) (Use the appropriate factor(s) from the tables):Required:1. How much sales revenue would Wright recognize on January 1, 2018, for this transaction?2. Prepare...

  • Only requirement 4 and 5 Fuzzy Monkey Technologies, Inc., purchased as a longterm investment $60 million...

    Only requirement 4 and 5 Fuzzy Monkey Technologies, Inc., purchased as a longterm investment $60 million of 6% bonds. dated January 1 on January 1. 2018. Management has the positive intent and ability to hold the bond until maturity. For bonds of similar risk and maturity the market yield was 8%. The price paid for the bonds was $46 million. Interest is received semiannually on June 30 and December 31. Due to changing market conditions, the fair value of the...

  • Fuzzy Monkey Technologies, Inc., purchased as a long-term investment $90 million of 6% bonds, dated January...

    Fuzzy Monkey Technologies, Inc., purchased as a long-term investment $90 million of 6% bonds, dated January 1, on January 1, 2018. Management has the positive intent and ability to hold the bonds until maturity. For bonds of similar risk and maturity the market yield was 8%. The price paid for the bonds was $73 million. Interest is received semiannually on June 30 and December 31. Due to changing market conditions, the fair value of the bonds at December 31, 2018,...

  • Fuzzy Monkey Technologies, Inc., purchased as a long-term investment $ 220 million of 8% bonds, dated...

    Fuzzy Monkey Technologies, Inc., purchased as a long-term investment $ 220 million of 8% bonds, dated January 1, on January 1, 2018. Management intends to have the investment available for sale when circumstances warrant. For bonds of similar risk and maturity the market yield was 10%. The price paid for the bonds was $201 million. Interest is received semiannually on June 30 and December 31. Due to changing market conditions, the fair value of the bonds at December 31, 2018,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT