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 the castle for his wife near the town of Redstone, which was founded as a company town for people working in the coal mining industry. Construction began in 1897 and was completed in 1902. (Sherman, T.)

In the early 1900s, John Cleveland Osgood was known as the King of Coal in the West. He was sixth richest of the Robber Barons, a group of elite industrialists. As a social and industrial experiment, Osgood decided he wanted to build a town in the Colorado mountains that would provide better living conditions for the miners working nearby. Instead of the tents and tiny cabins common in mining towns, Osgood built Swiss-style cottages with electricity and running water - along the river. He also built a clubhouse with a theater, school, library, lodge, community garden and stables. (Kesting, A.).

Known as Redstone Castle and as the "Ruby of the Rockies," the 42-room castle has almost 30,000 square feet of interior space. It also has over 150 acres of land, surrounded by beautiful scenery along the Crystal River. (Sherman, T.)

It's not the first time the castle has been up for sale in recent years. Steve and April Carver purchased it at an auction for $2.2 million in 2016. (Oravetz, J.)

The Carvers worked to renovate and restore the castle and have operated it as a hotel since 2018. (Oravetz, J.)

It features nine restored boutique suites, where dignitaries such as Teddy Roosevelt and the Rockefellers once slept. It was also open to the public for guided tours on weekends and was available to host weddings and other private events. (Oravetz, J.)

1- Calculate the annual compound growth rate of the Redstone Castle price since the house was purchased by Steve and April Carver (in 2016) until it was listed for sale in 2020. (The growth rate should be calculated to two decimals in percentage form. Round the number of years to the whole number). Please show your work.

Answer-

g = (19750000/2200000)^(1/4) - 1

g = 73.10%

Therefore, the growth rate is 73.10%

2- Assume that the average compound growth rate prevailed since John Cleveland Osgood built the Castle in 1902 until 2016 was 4.55% 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.

Answer-

Need help figuring the formula to use

3- You were using the time value of money concept to answer question #2. Think about the timeline for that problem. What year is considered as the time point 0 in that problem? Please explain your answer

Answer-

Time point 0 in problem #2= 1902

This is when the house was built and the price is being calculated back to that point in time.

4- Assume that the average compound growth rate you were using in the question #2 now is compounded daily. Calculate the price of the house in 1902. Compare with your answer to the question #2. (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.

Answer-

Need help figuring the formula to use

5- Assume that the house was purchased for the price listed in 2020. A commercial bank loaned the buyer the whole price (zero down payment) for 30 years. The loan must be repaid in equal monthly payments at the end of the month. The annual interest rate on the loan is 2.75% of the unpaid balance. What is the amount of the monthly payments? Please show your work.

Answer-

Monthly payment for 30 year mortgage= $80,627.63

Calculated using PMT function of Excel. Monthly interest rate is Rate, number of months is NPER and the value treated as mortgage (without down payment) is the PV for this.

=PMT(2.75%/12,360,-19750000,0,0)