Apartment Project You have been asked to develop a spreadsheet that will allow a builder to analyze what types of apartment buildings to build. Specifically, the builder needs to compare the income that comes in from the rent of apartments to the cost of building and running the apartments The apartment buildings being considered will cach have either all one-bedroom, all two-bedroom or all three- bedroom apartments. For each type, the builder will enter the following values: a) number of rooms in the apartment b) square footage of the apartment c) number of units of that type that will be in each building In the example below, the three possible apartment buildings will have either 25 one-bedroom apartments, 20 two-bedroom apartments or 12 three-bedroom apartments d) whether the building has an exercise room For your spreadsheet, use the following data. Remember that your spreadsheet should work for any data that is entered. Feel free to have as many columns as you like. of Nuncher of Number parte 1975 TO 25 Teached Dww.bodo Throefoe No Income-there are 3 sources of income. Apartment rent State rebate - Fees from the Exercise Room usage 1) Rent - The monthly rent for each apartment is computed by the following formula: rent = (per-room-fee* number of rooms) + (square-foot- fee square footage) where the per-room-fee and the square-foot-fee is set by the builder. The 2 fees are the same for all 3 of the apartment types. For your spreadsheet, use a per-room-fee of S10 and square-foot-fee of S4. Remember that your spreadsheet should work for any data that is entered 2) State rebate - this monthly rebate is based upon the total number of rooms and the total size, in square feet (sq. ft.). of all apartments in each building. If the total size is greater than 16,000 sq. ft. or the total size is greater than 12,000 ft and the number of rooms is greater than 55, then the rebate is $50 per apartment; otherwise it is 560 per apartment apartment 3) Exercise room - Buildings that have an exercise room charge $100 per unit (apartment) per month Costs - there are 3 costs the builder will incur monthly loan to pay for construction faxes - maintenance 1) The cost of construction will be paid with a loan that will be paid off monthly in 20 years at an interest rate of 7.5% The cost to build each apartment in the building is a function of the following table: quartas putne pas fece b00 SOLO To 100 5.200 Remember that the loan is calculated on the total construction cost of each building 2) Taxes -- the formula for the monthly real estate tax for cach building is based on the total monthly rent for that apartment building. The tax rate is 5% for the first $65.000 of rent and 5.75% for any rent over $65,000 3) Maintenance - if the total square footage of the building exceeds 15,000 sq. ft. and the total income is greater than $68,000 per month, the maintenance cost incurred by the builder is S2 per square foot of space. If not, the maintenance cost is $2.25 per square foot of space. The minimum cost of maintenance is $35,000 per month. That is the smallest amount paid per month for maintenance is $35,000 Be sure to display the following values for cach building type: Monthly Rent 2. Monthly State Rebate Monthly Exercise Room Fees Monthly Income Monthly Loan Payment to pay for Construction Monthly Taxes Monthly Maintenance Monthly Cost Display the word BUILD if income exceeds cost or DO-NOT-BUILD if income does not exceed cost. Additional values to compute are: Largest Monthly Profit 1 Average Monthly Profit Notes The analysis should produce monthly numbers. All event interest rate chand he disalu construction cost of each building 2) Taxes - the formula for the monthly real estate tax for cach building is based on the total monthly rent for that apartment building. The tax rate is 5% for the first $65,000 of rent and 5.75% for any rent over $65.000 3) Maintenance - if the total square footage of the building exceeds 15,000 sq. ft. and the total income is greater than $68,000 per month, the maintenance cost incurred by the builder is S2 per square foot of space. If not, the maintenance cost is $2.25 per square foot of space. The minimum cost of maintenance is $35,000 per month. That is, the smallest amount paid per month for maintenance is $35.000 Be sure to display the following values for cach building type: Monthly Rent 2. Monthly State Rebate Monthly Exercise Room Fees 4. Monthly Income Monthly Loan Payment to pay for Construction Monthly Takes Monthly Maintenance Monthly Cost Display the word BUILD if income exceeds cost or DO-NOT-BUILD if income does not exceed cost. Additional values to compute are: Largest Monthly Profit 1. Average Monthly Profit Notes. - The analysis should produce monthly numbers All values, except interest rate, should be displayed with zero decimal places. The interest rate should be displayed as a percentage to 2 decimal places. Be sure to have an assumptions constants section Use absolute addresses where appropriate. Make sure the spreadsheet is laid out in an organized. logical manner. Use text wrapping for column headings that are too wide Include a one row title at the top of the spreadsheet that says "Apartment Project" and that is 18 point Times New Roman font, with red letters on a yellow background. The title should be centered across all the columns that have values. You have been asked to develop a spreadsheet that will allow a builder to analyze what types of apartment buildings to build. Specifically, the builder needs to compare the income that comes in from the rent of apartments to the cost of building and running the apartments. The apartment buildings being considered will each have either all one-bedroom, all two-bedroom or all three- bedroom apartments. For each type, the builder will enter the following values: a) number of rooms in the apartment b) square footage of the apartment c) number of units of that type that will be in each building. In the example below, the three possible apartment buildings will have either 25 one-bedroom apartments, 20 two-bedroom apartments or 12 three-bedroom apartments. d) whether the building has an exercise room. For your spreadsheet, use the following data. Remember that your spreadsheet should work for any data that is entered. Feel free to have as many columns as you like. Type of Number of Apartment rooms One-bedroom Two-bedroom Three-bedroom Apartment Number of Units Exercise Room square footage 25 Ne 1000 20 hes 1300 Yes 575 Income -- there are 3 sources of income: Apartment rent State rebate Fees from the Exercise Room usage 1) Rent - The monthly rent for each apartment is computed by the following formula: rent = ((per-room-fee* number of rooms) + (square-foot- fee * square footage)) where the per-room-fee and the square-foot-fee is set by the builder. The 2 fees are the same for all 3 of the apartment types. For your spreadsheet, use a per-room-fee of $10 and square-foot-fee of $4. Remember that your spreadsheet should work for any data that is entered. Be sure to display the following values for each building type: 1. Monthly Rent 2. Monthly State Rebate 3. Monthly Exercise Room Fees 4. Monthly Income 5. Monthly Loan Payment to pay for Construction 6. Monthly Taxes 7. Monthly Maintenance 8. Monthly Cost 9. Display the word BUILD if income exceeds cost or DO-NOT-BUILD if income does not exceed cost. Additional values to compute are: 10. Largest Monthly Profit 11. Average Monthly Profit Notes. a) The analysis should produce monthly numbers. b) All values, except interest rate, should be displayed with zero decimal places. The interest rate should be displayed as a percentage to 2 decimal places. c) Be sure to have an assumptions/constants section. ) Use absolute addresses where appropriate. c) Make sure the spreadsheet is laid out in an organized, logical manner. 1) Use text wrapping for column headings that are too wide. g) Include a one row title at the top of the spreadsheet that says "Apartment Project" and that is 18 point Times New Roman font, with red letters on a yellow background. The title should be centered across all the columns that have values. Be sure to display the following values for each building type: 1. Monthly Rent 2. Monthly State Rebate 3. Monthly Exercise Room Fees 4. Monthly Income 5. Monthly Loan Payment to pay for Construction 6. Monthly Taxes 7. Monthly Maintenance 8. Monthly Cost 9. Display the word BUILD if income exceeds cost or DO-NOT-BUILD if income does not exceed cost. Additional values to compute are: 10. Largest Monthly Profit 11. Average Monthly Profit Notes. a) The analysis should produce monthly numbers. b) All values, except interest rate, should be displayed with zero decimal places. The interest rate should be displayed as a percentage to 2 decimal places. c) Be sure to have an assumptions/constants section. d) Use absolute addresses where appropriate. c) Make sure the spreadsheet is laid out in an organized, logical manner. 1) Use text wrapping for column headings that are too wide. g) Include a one row title at the top of the spreadsheet that says "Apartment Project" and that is 18 point Times New Roman font, with red letters on a yellow background. The title should be centered across all the columns that have values. Apartment Project You have been asked to develop a spreadsheet that will allow a builder to analyze what types of apartment buildings to build. Specifically, the builder needs to compare the income that comes in from the rent of apartments to the cost of building and running the apartments The apartment buildings being considered will cach have either all one-bedroom, all two-bedroom or all three- bedroom apartments. For each type, the builder will enter the following values: a) number of rooms in the apartment b) square footage of the apartment c) number of units of that type that will be in each building In the example below, the three possible apartment buildings will have either 25 one-bedroom apartments, 20 two-bedroom apartments or 12 three-bedroom apartments d) whether the building has an exercise room For your spreadsheet, use the following data. Remember that your spreadsheet should work for any data that is entered. Feel free to have as many columns as you like. of Nuncher of Number parte 1975 TO 25 Teached Dww.bodo Throefoe No Income-there are 3 sources of income. Apartment rent State rebate - Fees from the Exercise Room usage 1) Rent - The monthly rent for each apartment is computed by the following formula: rent = (per-room-fee* number of rooms) + (square-foot- fee square footage) where the per-room-fee and the square-foot-fee is set by the builder. The 2 fees are the same for all 3 of the apartment types. For your spreadsheet, use a per-room-fee of S10 and square-foot-fee of S4. Remember that your spreadsheet should work for any data that is entered 2) State rebate - this monthly rebate is based upon the total number of rooms and the total size, in square feet (sq. ft.). of all apartments in each building. If the total size is greater than 16,000 sq. ft. or the total size is greater than 12,000 ft and the number of rooms is greater than 55, then the rebate is $50 per apartment; otherwise it is 560 per apartment apartment 3) Exercise room - Buildings that have an exercise room charge $100 per unit (apartment) per month Costs - there are 3 costs the builder will incur monthly loan to pay for construction faxes - maintenance 1) The cost of construction will be paid with a loan that will be paid off monthly in 20 years at an interest rate of 7.5% The cost to build each apartment in the building is a function of the following table: quartas putne pas fece b00 SOLO To 100 5.200 Remember that the loan is calculated on the total construction cost of each building 2) Taxes -- the formula for the monthly real estate tax for cach building is based on the total monthly rent for that apartment building. The tax rate is 5% for the first $65.000 of rent and 5.75% for any rent over $65,000 3) Maintenance - if the total square footage of the building exceeds 15,000 sq. ft. and the total income is greater than $68,000 per month, the maintenance cost incurred by the builder is S2 per square foot of space. If not, the maintenance cost is $2.25 per square foot of space. The minimum cost of maintenance is $35,000 per month. That is the smallest amount paid per month for maintenance is $35,000 Be sure to display the following values for cach building type: Monthly Rent 2. Monthly State Rebate Monthly Exercise Room Fees Monthly Income Monthly Loan Payment to pay for Construction Monthly Taxes Monthly Maintenance Monthly Cost Display the word BUILD if income exceeds cost or DO-NOT-BUILD if income does not exceed cost. Additional values to compute are: Largest Monthly Profit 1 Average Monthly Profit Notes The analysis should produce monthly numbers. All event interest rate chand he disalu construction cost of each building 2) Taxes - the formula for the monthly real estate tax for cach building is based on the total monthly rent for that apartment building. The tax rate is 5% for the first $65,000 of rent and 5.75% for any rent over $65.000 3) Maintenance - if the total square footage of the building exceeds 15,000 sq. ft. and the total income is greater than $68,000 per month, the maintenance cost incurred by the builder is S2 per square foot of space. If not, the maintenance cost is $2.25 per square foot of space. The minimum cost of maintenance is $35,000 per month. That is, the smallest amount paid per month for maintenance is $35.000 Be sure to display the following values for cach building type: Monthly Rent 2. Monthly State Rebate Monthly Exercise Room Fees 4. Monthly Income Monthly Loan Payment to pay for Construction Monthly Takes Monthly Maintenance Monthly Cost Display the word BUILD if income exceeds cost or DO-NOT-BUILD if income does not exceed cost. Additional values to compute are: Largest Monthly Profit 1. Average Monthly Profit Notes. - The analysis should produce monthly numbers All values, except interest rate, should be displayed with zero decimal places. The interest rate should be displayed as a percentage to 2 decimal places. Be sure to have an assumptions constants section Use absolute addresses where appropriate. Make sure the spreadsheet is laid out in an organized. logical manner. Use text wrapping for column headings that are too wide Include a one row title at the top of the spreadsheet that says "Apartment Project" and that is 18 point Times New Roman font, with red letters on a yellow background. The title should be centered across all the columns that have values. You have been asked to develop a spreadsheet that will allow a builder to analyze what types of apartment buildings to build. Specifically, the builder needs to compare the income that comes in from the rent of apartments to the cost of building and running the apartments. The apartment buildings being considered will each have either all one-bedroom, all two-bedroom or all three- bedroom apartments. For each type, the builder will enter the following values: a) number of rooms in the apartment b) square footage of the apartment c) number of units of that type that will be in each building. In the example below, the three possible apartment buildings will have either 25 one-bedroom apartments, 20 two-bedroom apartments or 12 three-bedroom apartments. d) whether the building has an exercise room. For your spreadsheet, use the following data. Remember that your spreadsheet should work for any data that is entered. Feel free to have as many columns as you like. Type of Number of Apartment rooms One-bedroom Two-bedroom Three-bedroom Apartment Number of Units Exercise Room square footage 25 Ne 1000 20 hes 1300 Yes 575 Income -- there are 3 sources of income: Apartment rent State rebate Fees from the Exercise Room usage 1) Rent - The monthly rent for each apartment is computed by the following formula: rent = ((per-room-fee* number of rooms) + (square-foot- fee * square footage)) where the per-room-fee and the square-foot-fee is set by the builder. The 2 fees are the same for all 3 of the apartment types. For your spreadsheet, use a per-room-fee of $10 and square-foot-fee of $4. Remember that your spreadsheet should work for any data that is entered. Be sure to display the following values for each building type: 1. Monthly Rent 2. Monthly State Rebate 3. Monthly Exercise Room Fees 4. Monthly Income 5. Monthly Loan Payment to pay for Construction 6. Monthly Taxes 7. Monthly Maintenance 8. Monthly Cost 9. Display the word BUILD if income exceeds cost or DO-NOT-BUILD if income does not exceed cost. Additional values to compute are: 10. Largest Monthly Profit 11. Average Monthly Profit Notes. a) The analysis should produce monthly numbers. b) All values, except interest rate, should be displayed with zero decimal places. The interest rate should be displayed as a percentage to 2 decimal places. c) Be sure to have an assumptions/constants section. ) Use absolute addresses where appropriate. c) Make sure the spreadsheet is laid out in an organized, logical manner. 1) Use text wrapping for column headings that are too wide. g) Include a one row title at the top of the spreadsheet that says "Apartment Project" and that is 18 point Times New Roman font, with red letters on a yellow background. The title should be centered across all the columns that have values. Be sure to display the following values for each building type: 1. Monthly Rent 2. Monthly State Rebate 3. Monthly Exercise Room Fees 4. Monthly Income 5. Monthly Loan Payment to pay for Construction 6. Monthly Taxes 7. Monthly Maintenance 8. Monthly Cost 9. Display the word BUILD if income exceeds cost or DO-NOT-BUILD if income does not exceed cost. Additional values to compute are: 10. Largest Monthly Profit 11. Average Monthly Profit Notes. a) The analysis should produce monthly numbers. b) All values, except interest rate, should be displayed with zero decimal places. The interest rate should be displayed as a percentage to 2 decimal places. c) Be sure to have an assumptions/constants section. d) Use absolute addresses where appropriate. c) Make sure the spreadsheet is laid out in an organized, logical manner. 1) Use text wrapping for column headings that are too wide. g) Include a one row title at the top of the spreadsheet that says "Apartment Project" and that is 18 point Times New Roman font, with red letters on a yellow background. The title should be centered across all the columns that have values