This model of a real estate investment relies on three categories of investment parameters. Transactions and mortgage parameters are all associated with the initial purchase and loan. Monthly rent and expenses represent all recurring costs and income on a monthly basis, e.g. if annual capital expenditures (Capex) are estimated at 12k, then monthly Capex should be set to 1k. Appreciation and sale are then all parameters associated with final sale.
Investment metrics are calculated from investment parameters. Categories include initial investment metrics representing metrics relevant at the initial purchase, monthly investment metrics representing monthly cash flow calculations, and then final investment metrics that include the total annual return and other metrics determined at the time of sale.