Question: Part (a) It is said (S. Branch Walker) that the Indian who sold Manhattan for $33 was a sharp salesman. If he had put his

Part (a)

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

Required:

Use Excel to determine the balance of the investment as of December 31, 2015, assuming a 5% interest rate compounded semiannually. (Hint: Use the FV function in Excel.)ke

Balance of investment = ?

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

Balance of the investment = ?

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

Balance of the investment at 5% compounded quarterly = ?

Balance of the investment at 6% annual interest rate, compounded quarterly = ?

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

Total amount = ?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Shauna Coleman is single. She is employed as an architectural designer for Streamline Design (SD). Shauna wanted to determine her taxable income for this year. She correctly calculated her AGI....

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...

please help with explanations Part (a) It is said (S. Branch Walker) that the Indian who sold Manhattan for $40 was a sharp salesman. If he had put his $40 away at 5% compounded semiannually, it...

Please help with explanation Part (a) It is said (S. Branch Walker) that the Indian who sold Manhattan for $40 was a sharp salesman. lf he had put his $40 away at 5% compounded semiannually, it would...

Part (a) It is said (S. Branch Walker) that the Indian who sold Manhattan for $40 was a sharp salesman. lf he had put his $40 away at 5% compounded semiannually, it would now be worth over $7...

vious attempt. 2 Aad 138 out of 2.75 points You did not recevfull crede for this question Part (a) It is said (S. Branch Walker) that the Indian who sold Manhattan for $32 was a sharp salesman. If he...

Part (a) It is said (S. Branch Walker) that the Indian who sold Manhattan for $42 was a sharp salesman. If he had put his $42 away at 7% compounded semiannually, it would now be worth over $6...

Expert Q&A Done Part (a) It is said (S. Branch Walker) that the Indian who sold Manhattan for $38 was a sharp salesman. If he had put his $38 away at 6% compounded semiannually, it would now be worth...

Part (a) It is said (S. Branch Walker) that the Indian who sold Manhattan for $24 was a sharp salesman. If he had put his $24 away at 6% compounded semiannually, it would now be worth over $9...

It is said (S. Branch Walker) that the Indian who sold Manhattan for $42 was a sharp salesman. If he had put his $42 away at 7% compounded semiannually, it would now be worth over $6 billion, and he...

Explain why the frequency bar graph and the relative frequency bar graph for a data set have a similar appearance.

What are your favorite brand characters? Do you think they contribute to brand equity in any way? How? Can you relate their effects to the customer-based brand equity model?

Use the gradient to find the directional derivative of the function at P in the direction of v . h ( x , y ) = e - 2 x s i n ( y ) , P ( 1 , 2 ) , v = - i

A large tank holds (400) gallons of brine solution with (50) pounds Q5: of salt. A concentration of (3 lb/gal) is pumped in the tank at the rate of ( 4gal/min) and the concentration is pumped out of...

2. Suppose X is a metric space with metric d. (a) Prove that d(r, y) 1+ d(x, y)' d'(r, y) 2, y e X is also a metric on X. (b) Show that d and d' are topologically equivalent in the sense that a set...

Question 3. Suppose that the random variable X is defined as X 0.6X1 +0.3X2 +0.1X3, where the probability distributions of the independent random variables X1, X2, and X3 are Ix, (=) = (:)0.1-0,9-,...

Calculate the average rate of change for f(x) = 4x2 + 4x from x to x + h.

3) The pKa of barbituric acid is 4.01; the sodium salt of barbituric acid has a small Ksp. At what pH do we find the maximum solubility of barbituric acid? Why is it not useful to use extreme values...

Write two short papers one on contract law and one on tort law. Contract Law Evaluate the potential rights, claims, defenses, obligations, and remedies for each party from the perspective of contract...

15.2 Explain the costs associated with employee turnover.

15.6 Describe how risks from wrongful dismissal lawsuits can be minimized.

15.3 Describe how quits and retirements are aform of voluntary turnover.