Question: Help please show calculation in excel :) Value in 2016 : $2.2 million Assume that the average compound growth rate prevailed since John Cleveland Osgood

Help please show calculation in excel :)

Value in 2016 : $2.2 million

Assume that the average compound growth rate prevailed since John Cleveland Osgood built the Castle in 1902 until 2016 was 3.78% per year compounded annually. Calculate the price of the house in 1902. (Round the number of years to the whole number). (TIP: To get the answer correctly you need to use the price of the house in your calculations in dollars with all zeros). Please show your work.

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!

Q:

A castle built for the man who founded the town of Redstone, CO, can now be yours, for $19.75 million. (Sherman, T.) A coal magnate, John Cleveland Osgood , built the castle for his wife near the...

Q:

Please check my answers/Help Below A castle built for the man who founded the town of Redstone, CO, can now be yours, for $19.75 million. (Sherman, T.) A coal magnate, John Cleveland Osgood , built...

Q:

A castle built for the man who founded the town of Redstone, CO, can now be yours, for $19.75 million. (Sherman, T.) A coal magnate, John Cleveland Osgood , built the castle for his wifenear the town...

Q:

Historic Redstone Castle is for sale A castle built for the man who founded the town of Redstone, CO, can now be yours, for $19.75 million. (Sherman, T.) A coal magnate, John Cleveland Osgood , built...

Q:

Historic Redstone Castle is for sale A castle built for the man who founded the town of Redstone, CO, can now be yours, for $19.75 million. (Sherman, T.) A coal magnate, John Cleveland Osgood , built...

Q:

Historic Redstone Castle is for sale A castle built for the man who founded the town of Redstone, CO, can now be yours, for $19.75 million. (Sherman, T.) A coal magnate, John Cleveland Osgood, built...

Q:

A castle built for the man who founded the town of Redstone, CO, can now be yours, for $19.75 million. (Sherman, T.) A coal magnate, John Cleveland Osgood , built the castle for his wife near the...

Q:

Historic Redstone Castle is for sale A castle built for the man who founded the town of Redstone, CO, can now be yours, for $19.75 million. (Sherman, T.) A coal magnate, John Cleveland Osgood , built...

Q:

Historic Redstone Castle is for sale A castle built for the man who founded the town of Redstone, CO, can now be yours, for $19.75 million. (Sherman, T.) A coal magnate, John Cleveland Osgood , built...

Q:

Historic Redstone Castle is for sale A castle built for the man who founded the town of Redstone, CO, can now be yours, for $19.75 million. (Sherman, T.) A coal magnate, John Cleveland Osgood, built...

Q:

A steam power plant for an automotive vehicle is proposed as shown in Fig 5.36. The boiler has a volume of 50 L and initially contains 90% liquid and 10% vapor by volume at 100 kPa. The burner is now...

Q:

For the problem specified in the table, build upon the results of the original problem to obtain a Basic Load Rating for a ball bearing at C with a 95 percent reliability. The shaft rotates at 1200...

Q:

Ahmed needs to find information about gender and income distribution in Ulister County, New York. His company has minimal money to budget for this process. The best source of secondary research Ahmed...

Q:

Firm SCART inc. is expected to pay a dividend of $1 and the dividend is expected to grow at a constant rate of 6%. The required return on its common stock 11%. How much should it be stock price? Keep...

Q:

1. Identify an ecosystem with one or more at-risk species of plants or animals.

Q:

3. Find the best set of ecosystem state values that can be reached by any change in group beliefs. Do this by iterating the following two steps. First, make a small change to qd as given in the...

Q:

2. Repeat Exercise 1 but under the restriction that the belief systems of the president and the rural residents cannot be changed.