)  Calculate the annual compound growth rate

The Hamptons Home of a Famed Socialite Hits the Market

“Before there was Paris Hilton, there was Consuelo Vanderbilt Balsan – a Gilded Age heiress and socialite, renowned for her beauty and wealth. Now Ms. Balsan’s onetime Hamptons home is slated to hit the market priced at \$28 million with Tim Davis of the Corcoran Group.

Located on Ox Pasture Road in Southampton, the shingle-style home was built around 1900 and is known as “Gardenside” or “Cara-Mia”. Ms. Balsan, the great-granddaughter of railroad magnate Cornelius Vanderbilt, owned the house until her death in 1964.

According to public records, the estate is owned by Robert G. Goldstein, executive vice president and president of global gaming operations at Las Vegas Sands Corp, and his wife Sheryl, who purchased the house in 2007 for \$17.4 million.” (The Wall Street Journal, August 1, 2014, M2)

*****************************************************************************

I highly recommend putting these problems into the attached spreadsheet and posting the file.  Hamptons Spreadsheet (find attached)

1)  Calculate the annual compound growth rate of the house price during the period when the house was owned by Robert G. Goldstein (since 2007…article written in 2014). (Round the number of years to the whole number).

2) Assume that the growth rate you calculated in question #1 remained the same until today.  What is the price of the house today?

3) Assume the growth rate that you calculated in #1 prevailed since 1900. Calculate the price of the house in 1900.

4)  Assume the growth rate that you calculated in #1 prevailed since 1900. Which price was paid for the house in 1964?

5) You were using the time value of money concept to answer the question #2. What is Time Point 0 for this problem?

6)  Reflection – the students also should include a paragraph in the initial response in their own words reflecting on specifically what they learned from the assignment and how they think they could apply what they learned in the workplace or in everyday life.

• Disc2-HamptonsTemplateClean.xlsx
• The Hamptons Home of a Famed Socialite Hits the Market
• “Before there was Paris Hilton, there was Consuelo Vanderbilt Balsan – a Gilded Age heiress and socialite, renowned for her beauty and wealth. Now Ms. Balsan’s onetime Hamptons home is slated to hit the market priced at \$28 million with Tim Davis of the Corcoran Group.
• Located on Ox Pasture Road in Southampton, the shingle-style home was built around 1900 and is known as “Gardenside” or “Cara-Mia”. Ms. Balsan, the great-granddaughter of railroad magnate Cornelius Vanderbilt, owned the house until her death in 1964.
• According to public records, the estate is owned by Robert G. Goldstein, executive vice president and president of global gaming operations at Las Vegas Sands Corp, and his wife Sheryl, who purchased the house in 2007 for \$17.4 million.” (The Wall Street Journal, August 1, 2014, M2)
• *****************************************************************************
• I highly recommend putting these problems into the attached spreadsheet and posting the file.  Hamptons Spreadsheet (find attached)
• 1)  Calculate the annual compound growth rate of the house price during the period when the house was owned by Robert G. Goldstein (since 2007…article written in 2014). (Round the number of years to the whole number).
• 2) Assume that the growth rate you calculated in question #1 remained the same until today.  What is the price of the house today?
• 3) Assume the growth rate that you calculated in #1 prevailed since 1900. Calculate the price of the house in 1900.
• 4)  Assume the growth rate that you calculated in #1 prevailed since 1900. Which price was paid for the house in 1964?
• 5) You were using the time value of money concept to answer the question #2. What is Time Point 0 for this problem?
• 6)  Reflection – the students also should include a paragraph in the initial response in their own words reflecting on specifically what they learned from the assignment and how they think they could apply what they learned in the workplace or in everyday life.
• Disc2-HamptonsTemplateClean.xlsx
0 replies