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.
hint: insert the pv function.
loan amount $1,100,000.00
no. periods 360
monthly rate 0.40%
monthly payment $5,738.12
total interest paid $965,723.45