I need a detailed excel sheet on how to make this

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 cach 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 Apartment Number of rooms Number of Units Exercise Room One-bedroom Two-bedroom Three bedroom 2 3 5 Apartment square footage 575 1000 1300 25 20 12 No Yes Yes Income-there are 3 sources of income: Apartment rent State rebate Fees from the Exercise Room usage 1) Rent - The monthly rent for cach 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 54. 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 sq.ft and the number of rooms is greater than 55 then the rebate is $50 per apartment otherwise it is $60 per 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 maintenance . . taxes 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 75% PMT. Principal 1)xlokup 2 step 2 The cost to build each apartment in the building is a function of the following table: Step 1 Square foot of the apartment 0 - 500 501 - 700 701 - 999 1000- Cost per square foot $300 $265 $240 $200 Remember that the loun is calculated on the total construction cost of each building, 2) Taxes the formula for the monthly real estate tax for each 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. If statement: 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 $2 per sciare 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 68k,sq ft>15, *saft! . . Be sure to display the following values for each building type: Monthly Rent Monthly State Rebate Monthly Exercise Room Fees Monthly Income Monthly Loan Payment to pay for Construction Monthly Taxes Monthly Maintenance Monthly Cost 1 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 max Average Monthly Profit-avg 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 appropriats. 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 cach 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 Apartment Number of rooms Number of Units Exercise Room One-bedroom Two-bedroom Three bedroom 2 3 5 Apartment square footage 575 1000 1300 25 20 12 No Yes Yes Income-there are 3 sources of income: Apartment rent State rebate Fees from the Exercise Room usage 1) Rent - The monthly rent for cach 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 54. 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 sq.ft and the number of rooms is greater than 55 then the rebate is $50 per apartment otherwise it is $60 per 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 maintenance . . taxes 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 75% PMT. Principal 1)xlokup 2 step 2 The cost to build each apartment in the building is a function of the following table: Step 1 Square foot of the apartment 0 - 500 501 - 700 701 - 999 1000- Cost per square foot $300 $265 $240 $200 Remember that the loun is calculated on the total construction cost of each building, 2) Taxes the formula for the monthly real estate tax for each 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. If statement: 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 $2 per sciare 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 68k,sq ft>15, *saft! . . Be sure to display the following values for each building type: Monthly Rent Monthly State Rebate Monthly Exercise Room Fees Monthly Income Monthly Loan Payment to pay for Construction Monthly Taxes Monthly Maintenance Monthly Cost 1 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 max Average Monthly Profit-avg 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 appropriats. 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