please show all steps

A Northern California real estate company is considering diversitying its real estate portfolio and buying a 5 year old office building in Upland. It did a thorough study of the market and the leases that are in place. The company estimates that next year's net operating income will be $100,000. Its projections allow it to estimate that after the first year the annual net operating income will be rising by 57.000 each year for 5 years after which is expected to grow by 8 percent per year for a few years in the foreseeable future. It plans to own the property for 3 years and then sell it at a price determined using information on al applicable How many from the list below. That's something you need to figure out comparable properties terminal cap rates. The chosen comps wil all be considered equally important in determining the subject property's expected terminal value. The company requires a 15 return on this investment. Below is the information on several office buildings with similar features and amenities that recently sold in Upland and surrounding area. First, under each recently sold buildings information put YES if it should be treated as a comp, and No otherwise Bid 2 $1,000,000 Bldges $1.200,000 Bldga 51.000.000 51.100.000 Bldg 1 Recent sale price 01.300.000 Arm's length yes transaction 1st year NOI $80.000 Other info 5 years old yes Bldg 23 Bldg 51.200.000 5900.000 yes no $120,000 $100,000 Previously sold three years ago to its second owner 8 years old as a 10 year old buiding yes no $110,000 390,000 13 years old Built in October 2007 $120,000 $110.000 will be a 13 year old Twice as old as the building in a couple weeks subject property Comp? if you can do the math in Excel with correct referencing to cells with intermediate results. This will allow you to avoid rounding errors. Otherwise, increase decimal places the more the bettert Say, 6 or even higher, Calculate the company's estimated future net operating incomes for the entire holding period. Round to whole dollar. Don't use the "S" sign. Year 1 Year 2 Year Year Years Year 6 Year Year NOI Estimated reversion value of the subject property equals 5 Round to whole dollar. Don't put Estimated current value of the subject property is Round to whole dollar. Don't put "s". Estimated going in cap rate for the subject property is assuming it is purchased for no more than what it's worth Round to 2 decimal places. Don't put W. 1.g. for 1.23 put 1.23 1. Round to 2 decimal places. Don't put "W. Eg. For 1.23 put 1.23. Estimated going-out cap rate for the subject property is A Northern California real estate company is considering diversitying its real estate portfolio and buying a 5 year old office building in Upland. It did a thorough study of the market and the leases that are in place. The company estimates that next year's net operating income will be $100,000. Its projections allow it to estimate that after the first year the annual net operating income will be rising by 57.000 each year for 5 years after which is expected to grow by 8 percent per year for a few years in the foreseeable future. It plans to own the property for 3 years and then sell it at a price determined using information on al applicable How many from the list below. That's something you need to figure out comparable properties terminal cap rates. The chosen comps wil all be considered equally important in determining the subject property's expected terminal value. The company requires a 15 return on this investment. Below is the information on several office buildings with similar features and amenities that recently sold in Upland and surrounding area. First, under each recently sold buildings information put YES if it should be treated as a comp, and No otherwise Bid 2 $1,000,000 Bldges $1.200,000 Bldga 51.000.000 51.100.000 Bldg 1 Recent sale price 01.300.000 Arm's length yes transaction 1st year NOI $80.000 Other info 5 years old yes Bldg 23 Bldg 51.200.000 5900.000 yes no $120,000 $100,000 Previously sold three years ago to its second owner 8 years old as a 10 year old buiding yes no $110,000 390,000 13 years old Built in October 2007 $120,000 $110.000 will be a 13 year old Twice as old as the building in a couple weeks subject property Comp? if you can do the math in Excel with correct referencing to cells with intermediate results. This will allow you to avoid rounding errors. Otherwise, increase decimal places the more the bettert Say, 6 or even higher, Calculate the company's estimated future net operating incomes for the entire holding period. Round to whole dollar. Don't use the "S" sign. Year 1 Year 2 Year Year Years Year 6 Year Year NOI Estimated reversion value of the subject property equals 5 Round to whole dollar. Don't put Estimated current value of the subject property is Round to whole dollar. Don't put "s". Estimated going in cap rate for the subject property is assuming it is purchased for no more than what it's worth Round to 2 decimal places. Don't put W. 1.g. for 1.23 put 1.23 1. Round to 2 decimal places. Don't put "W. Eg. For 1.23 put 1.23. Estimated going-out cap rate for the subject property is