In cell C9, enter a database function to calculate the total value of monthly rent lost for the apartments that need to be remodeled based on the…
In cell I4 insert a financial function to calculate the present value of the total monthly rent you will collect for the 8 units for 30 years. Use the number of periods and monthly rate in the Summary Calculations section and the cell references in the What If section. The result should be a positive value.