How to Build a Loan Amortization Schedule in a Spreadsheet
How to build a loan amortization schedule in a spreadsheet: a loan-setup sheet, a month-by-month split of principal and interest, and an extra-payment model.
Real Estate Articles
Rental property analysis, short-term rentals, mortgages, and property investment tracking. Articles covering real estate topics with practical guides, calculators, and spreadsheet templates.
6 articles
How to Analyze a Mortgage in a Spreadsheet
Mortgage analysis in a spreadsheet: build a full amortization schedule, read total interest and total paid, and compare loan scenarios, with a worked example.
How to Analyze a Commercial Property in a Spreadsheet
A commercial property analysis spreadsheet turns a rent roll, NNN reimbursements, and operating costs into NOI, a going-in cap rate, and an implied exit value.
How to Analyze a Rental Property in a Spreadsheet
A rental property analysis spreadsheet turns price, rent, and a loan into NOI, cap rate, DSCR, cash-on-cash, and a ten-year projection with the exit sale.
How to Track Airbnb Income and Expenses in a Spreadsheet
How to track Airbnb income and expenses in a spreadsheet: one bookings ledger, monthly occupancy, ADR, RevPAR, and annual profit, with a worked example.
Rental Property Cash Flow Spreadsheet (Excel, Per-Unit Tabs)
A rental property cash flow spreadsheet tracks income, expenses, and net per unit. Includes Excel template, worked example for a 4-unit portfolio, and Schedule E categories.