please show all steps

$ A company is looking for a retail property to buy its market analysis shows that based on current market supply and demand, trends in rents and per square foot operating and other expenses, the estimated net operation income amounts will be as follows. For the first two years it estimates $800,000 for the annual net operating income. During the following three years, market rents are expected to be higher increasing the estimated net operating income by $70,000 each year. It is further expected that after that all the way through year 7, the net operation income will reflect a stable, balanced market and should grow at 6 percent per year. The company also considered past trends in real estate prices and believes that the building value will be appreciating by 5 percent per year up to and . real . In the calculations below for dollar amounts don't use the "sign and round to whole dollar. For any percentages. put, for example, 1.23 if you got "1.23 percent". 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 better say, 6 or even higher In the table below, fill out the estimated annual amounts of net operating income for the company's planned holding period Year Year 4 Years Year 6 5 $ Year 2 The estimated Reversion value equals The estimated current value of the real property equals (Type a number, no decimals. 18. type 10 if your answer is Year (Type a number, no decimals. Eg.type 10 if your answer is (Type a number that corresponds to your answer from the options in The estimated going in caprate equals percent, and the cap rate formula uses the net operating income from year 10") The estimated going out cap rate equals percent, and the cap rate formula uses the net operating income from year "Year 10 For this investment, the shorter the holding period, the the reversion value, the _ the current value, and the _ the poing in rate.plek the table below...type 1 if you pick the first row.) Ngher, higher, ither 2 Ngher, higher, lower Ngher, lower,her lower, lower, cher Slower, lower lower Glower, the lower $ A company is looking for a retail property to buy its market analysis shows that based on current market supply and demand, trends in rents and per square foot operating and other expenses, the estimated net operation income amounts will be as follows. For the first two years it estimates $800,000 for the annual net operating income. During the following three years, market rents are expected to be higher increasing the estimated net operating income by $70,000 each year. It is further expected that after that all the way through year 7, the net operation income will reflect a stable, balanced market and should grow at 6 percent per year. The company also considered past trends in real estate prices and believes that the building value will be appreciating by 5 percent per year up to and . real . In the calculations below for dollar amounts don't use the "sign and round to whole dollar. For any percentages. put, for example, 1.23 if you got "1.23 percent". 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 better say, 6 or even higher In the table below, fill out the estimated annual amounts of net operating income for the company's planned holding period Year Year 4 Years Year 6 5 $ Year 2 The estimated Reversion value equals The estimated current value of the real property equals (Type a number, no decimals. 18. type 10 if your answer is Year (Type a number, no decimals. Eg.type 10 if your answer is (Type a number that corresponds to your answer from the options in The estimated going in caprate equals percent, and the cap rate formula uses the net operating income from year 10") The estimated going out cap rate equals percent, and the cap rate formula uses the net operating income from year "Year 10 For this investment, the shorter the holding period, the the reversion value, the _ the current value, and the _ the poing in rate.plek the table below...type 1 if you pick the first row.) Ngher, higher, ither 2 Ngher, higher, lower Ngher, lower,her lower, lower, cher Slower, lower lower Glower, the lower $ A company is looking for a retail property to buy its market analysis shows that based on current market supply and demand, trends in rents and per square foot operating and other expenses, the estimated net operation income amounts will be as follows. For the first two years it estimates $800,000 for the annual net operating income. During the following three years, market rents are expected to be higher increasing the estimated net operating income by $70,000 each year. It is further expected that after that all the way through year 7, the net operation income will reflect a stable, balanced market and should grow at 6 percent per year. The company also considered past trends in real estate prices and believes that the building value will be appreciating by 5 percent per year up to and . real . In the calculations below for dollar amounts don't use the "sign and round to whole dollar. For any percentages. put, for example, 1.23 if you got "1.23 percent". 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 better say, 6 or even higher In the table below, fill out the estimated annual amounts of net operating income for the company's planned holding period Year Year 4 Years Year 6 5 $ Year 2 The estimated Reversion value equals The estimated current value of the real property equals (Type a number, no decimals. 18. type 10 if your answer is Year (Type a number, no decimals. Eg.type 10 if your answer is (Type a number that corresponds to your answer from the options in The estimated going in caprate equals percent, and the cap rate formula uses the net operating income from year 10") The estimated going out cap rate equals percent, and the cap rate formula uses the net operating income from year "Year 10 For this investment, the shorter the holding period, the the reversion value, the _ the current value, and the _ the poing in rate.plek the table below...type 1 if you pick the first row.) Ngher, higher, ither 2 Ngher, higher, lower Ngher, lower,her lower, lower, cher Slower, lower lower Glower, the lower $ A company is looking for a retail property to buy its market analysis shows that based on current market supply and demand, trends in rents and per square foot operating and other expenses, the estimated net operation income amounts will be as follows. For the first two years it estimates $800,000 for the annual net operating income. During the following three years, market rents are expected to be higher increasing the estimated net operating income by $70,000 each year. It is further expected that after that all the way through year 7, the net operation income will reflect a stable, balanced market and should grow at 6 percent per year. The company also considered past trends in real estate prices and believes that the building value will be appreciating by 5 percent per year up to and . real . In the calculations below for dollar amounts don't use the "sign and round to whole dollar. For any percentages. put, for example, 1.23 if you got "1.23 percent". 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 better say, 6 or even higher In the table below, fill out the estimated annual amounts of net operating income for the company's planned holding period Year Year 4 Years Year 6 5 $ Year 2 The estimated Reversion value equals The estimated current value of the real property equals (Type a number, no decimals. 18. type 10 if your answer is Year (Type a number, no decimals. Eg.type 10 if your answer is (Type a number that corresponds to your answer from the options in The estimated going in caprate equals percent, and the cap rate formula uses the net operating income from year 10") The estimated going out cap rate equals percent, and the cap rate formula uses the net operating income from year "Year 10 For this investment, the shorter the holding period, the the reversion value, the _ the current value, and the _ the poing in rate.plek the table below...type 1 if you pick the first row.) Ngher, higher, ither 2 Ngher, higher, lower Ngher, lower,her lower, lower, cher Slower, lower lower Glower, the lower