Please verify these are correct :)

Problem 11-1 An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,200 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,200 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,200 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management). Management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the base rent to increase at half the increase in the CPI. The CPlis projected to Increase 3 percent per year. Estimated operating expenses for the next year include the following: Property taxes $ 100,500 Insurance 10,500 Utilities 75,500 Janitorial 25,500 Maintenance 40,500 Total $ 252,500 All expenses are projected to increase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after current leases expire and new leases are made, vacancy is estimated to be 10 percent of EG/ for the last two years (ye 4 and Required: a. Calculate the effective gross Income (EG) for the next five years. b. Calculate the expense reimbursements for the next five years. c. Calculate the net operating income (NO) for the next five years. d. How much does the Nor increase (average compound rate) over the five years? e. Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)? Complete this question by entering your answers in the tabs below. Required A Required B Required Required D Required E Calculate the effective gross income (EGI) for the next five years. (Do not round intermediate calculations. Round your final answers to the nearest dollar amount.) Year 2 Year 3 Year 4 Year 5 Year 6 Effective Gross Income $ 832,879 $ 852,545 $ 599,692 $ 833,715 $ 871,7901 Problem 11-1 An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,200 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,200 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,200 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management). Management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the base rent to increase at half the increase in the CPI. The CPL is projected to increase 3 percent per year. Estimated operating expenses for the next year include the following: Property taxes $ 100,500 Insurance 10,500 Utilities 75,500 Janitorial 25,500 Maintenance 40,500 Total $ 252,500 All expenses are projected to increase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after current leases expire and new leases are made, vacancy is estimated to be 10 percent of EGI for the last two years (years 4 and 5). Required: a. Calculate the effective gross income (EG) for the next five years. b. Calculate the expense reimbursements for the next five years. c. Calculate the net operating income (NO) for the next five years. d. How much does the Nor increase (average compound rate) over the five years? e. Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)? Complete this question by entering your answers in the tabs below. Required A Required Required Required Required E Calculate the expense reimbursements for the next five years. (Do not round intermediate calculations. Round your final answers to the nearest dollar amount.) Year 2 Year 3 Year 4 Year 5 Year 6 Expense Reimbursements $ 27.800 S 35.390 $ 42.980 $ 21,584 $ 13.010 Problem 11-1 An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,200 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,200 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,200 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management). Management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the base rent to increase at half the increase in the CPI. The CPL is projected to increase 3 percent per year. Estimated operating expenses for the next year include the following: Property taxes Insurance Utilities Janitorial Maintenance Total $ 100,500 10,500 75,500 25,500 40,500 $ 252,500 All expenses are projected to increase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after current leases expire and new leases are made, vacancy is estimated to be 10 percent of EGI for the last two years (Years 4 and 5). Required: a. Calculate the effective gross income (EG) for the next five years. b. Calculate the expense reimbursements for the next five years. C. Calculate the net operating income (NO) for the next five years. d. How much does the Nor increase (average compound rate) over the five years? e. Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)? Complete this question by entering your answers in the tabs below. Required A Required B Required Required D Required E Calculate the net operating income (Nor) for the next five years. (Do not round intermediate calculations. Round your final answers to the nearest dollar amount.) Year 2 Year 3 Year 4 Year 5 Net Operating Income $ 538,735 s 549,843 $ 301,830 516,116 $ 544,000 lo Year 6 Problem 11-1 An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,200 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,200 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,200 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management) . Management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the base rent to increase at half the increase in the CPI. The CPlis projected to Increase 3 percent per year. Estimated operating expenses for the next year Include the following: Property taxes $ 100,500 Insurance 10,500 Utilities 75,500 Janitorial 25,500 Maintenance 40,500 Total $ 252,500 All expenses are projected to increase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after current leases expire and new leases are made, vacancy is estimated to be 10 percent of EG/ for the last two years (years 4 and 5). Required: a. Calculate the effective gross Income (EG) for the next five years. b. Calculate the expense reimbursements for the next five years. C. Calculate the net operating income (NO) for the next five years. d. How much does the Nor increase (average compound rate) over the five years? e. Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)? Complete this question by entering your answers in the tabs below. Required A Required B Required Required D Required E How much does the NOI increase (average compound rate) over the five years? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Average compound rate 0.19% Problem 11-1 An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,200 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,200 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,200 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management). Management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the base rent to increase at half the increase in the CPI. The CPL is projected to increase 3 percent per year. Estimated operating expenses for the next year include the following: Property taxes $ 100,500 Insurance 10,500 Utilities 75,500 Janitorial 25,500 Maintenance 40,500 Total $ 252,500 All expenses are projected to increase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after current leases expire and new leases are made, vacancy is estimated to be 10 percent of EG/ for the last two years (years 4 and 5). Required: a. Calculate the effective gross income (EG) for the next five years. b. Calculate the expense reimbursements for the next five years. c. Calculate the net operating income (NO) for the next five years. d. How much does the Nor increase (average compound rate) over the five years? e. Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)? Complete this question by entering your answers in the tabs below. Required A Required B Required Required D Required E Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Capitalization rate 10.77% Problem 11-1 An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,200 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,200 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,200 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management). Management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the base rent to increase at half the increase in the CPI. The CPlis projected to Increase 3 percent per year. Estimated operating expenses for the next year include the following: Property taxes $ 100,500 Insurance 10,500 Utilities 75,500 Janitorial 25,500 Maintenance 40,500 Total $ 252,500 All expenses are projected to increase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after current leases expire and new leases are made, vacancy is estimated to be 10 percent of EG/ for the last two years (ye 4 and Required: a. Calculate the effective gross Income (EG) for the next five years. b. Calculate the expense reimbursements for the next five years. c. Calculate the net operating income (NO) for the next five years. d. How much does the Nor increase (average compound rate) over the five years? e. Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)? Complete this question by entering your answers in the tabs below. Required A Required B Required Required D Required E Calculate the effective gross income (EGI) for the next five years. (Do not round intermediate calculations. Round your final answers to the nearest dollar amount.) Year 2 Year 3 Year 4 Year 5 Year 6 Effective Gross Income $ 832,879 $ 852,545 $ 599,692 $ 833,715 $ 871,7901 Problem 11-1 An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,200 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,200 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,200 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management). Management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the base rent to increase at half the increase in the CPI. The CPL is projected to increase 3 percent per year. Estimated operating expenses for the next year include the following: Property taxes $ 100,500 Insurance 10,500 Utilities 75,500 Janitorial 25,500 Maintenance 40,500 Total $ 252,500 All expenses are projected to increase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after current leases expire and new leases are made, vacancy is estimated to be 10 percent of EGI for the last two years (years 4 and 5). Required: a. Calculate the effective gross income (EG) for the next five years. b. Calculate the expense reimbursements for the next five years. c. Calculate the net operating income (NO) for the next five years. d. How much does the Nor increase (average compound rate) over the five years? e. Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)? Complete this question by entering your answers in the tabs below. Required A Required Required Required Required E Calculate the expense reimbursements for the next five years. (Do not round intermediate calculations. Round your final answers to the nearest dollar amount.) Year 2 Year 3 Year 4 Year 5 Year 6 Expense Reimbursements $ 27.800 S 35.390 $ 42.980 $ 21,584 $ 13.010 Problem 11-1 An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,200 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,200 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,200 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management). Management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the base rent to increase at half the increase in the CPI. The CPL is projected to increase 3 percent per year. Estimated operating expenses for the next year include the following: Property taxes Insurance Utilities Janitorial Maintenance Total $ 100,500 10,500 75,500 25,500 40,500 $ 252,500 All expenses are projected to increase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after current leases expire and new leases are made, vacancy is estimated to be 10 percent of EGI for the last two years (Years 4 and 5). Required: a. Calculate the effective gross income (EG) for the next five years. b. Calculate the expense reimbursements for the next five years. C. Calculate the net operating income (NO) for the next five years. d. How much does the Nor increase (average compound rate) over the five years? e. Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)? Complete this question by entering your answers in the tabs below. Required A Required B Required Required D Required E Calculate the net operating income (Nor) for the next five years. (Do not round intermediate calculations. Round your final answers to the nearest dollar amount.) Year 2 Year 3 Year 4 Year 5 Net Operating Income $ 538,735 s 549,843 $ 301,830 516,116 $ 544,000 lo Year 6 Problem 11-1 An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,200 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,200 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,200 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management) . Management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the base rent to increase at half the increase in the CPI. The CPlis projected to Increase 3 percent per year. Estimated operating expenses for the next year Include the following: Property taxes $ 100,500 Insurance 10,500 Utilities 75,500 Janitorial 25,500 Maintenance 40,500 Total $ 252,500 All expenses are projected to increase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after current leases expire and new leases are made, vacancy is estimated to be 10 percent of EG/ for the last two years (years 4 and 5). Required: a. Calculate the effective gross Income (EG) for the next five years. b. Calculate the expense reimbursements for the next five years. C. Calculate the net operating income (NO) for the next five years. d. How much does the Nor increase (average compound rate) over the five years? e. Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)? Complete this question by entering your answers in the tabs below. Required A Required B Required Required D Required E How much does the NOI increase (average compound rate) over the five years? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Average compound rate 0.19% Problem 11-1 An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,200 square feet of rentable space and is currently renting for $15 per square foot. Three years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,200 square feet of rentable space and is leasing for $15.50 per square foot and has four years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,200 square feet of leasable space and a lease just signed for the next five years at a rental rate of $17 per square foot, which is the current market rate. The expense stop is at $5 per square foot, which is what expenses per square foot are estimated to be during the next year (excluding management). Management expenses are expected to be 5 percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the base rent to increase at half the increase in the CPI. The CPL is projected to increase 3 percent per year. Estimated operating expenses for the next year include the following: Property taxes $ 100,500 Insurance 10,500 Utilities 75,500 Janitorial 25,500 Maintenance 40,500 Total $ 252,500 All expenses are projected to increase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after current leases expire and new leases are made, vacancy is estimated to be 10 percent of EG/ for the last two years (years 4 and 5). Required: a. Calculate the effective gross income (EG) for the next five years. b. Calculate the expense reimbursements for the next five years. c. Calculate the net operating income (NO) for the next five years. d. How much does the Nor increase (average compound rate) over the five years? e. Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)? Complete this question by entering your answers in the tabs below. Required A Required B Required Required D Required E Assuming the property is purchased for $5 million, what is the overall capitalization rate (going-in rate)? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Capitalization rate 10.77%