Residential Investment Return Modeling

I need a robust yet intuitive financial model that forecasts the full life-cycle returns of a residential property deal. My raw rental income data is ready, and I want it transformed into clear projections—IRR, NPV, cash-on-cash, equity multiples, and break-even timelines—so I can decide whether to move forward or renegotiate the purchase terms. Scope of work • Build a dynamic Excel or Google Sheets model anchored on my rental income figures, with flexible assumptions for vacancies, rent growth, financing terms, operating expenses, and an eventual sale. • Automate monthly and annual cash-flow statements that roll into a concise summary dashboard. • Layer in sensitivity and scenario analysis (best, base, worst) so I can instantly see how tweaks to rent, interest rates, or holding period affect returns. • Include clear, color-coded input cells and transparent formulas—no hidden macros or hard-coded numbers. • Provide a brief walkthrough or loom video so I can edit assumptions confidently. Acceptance criteria The file is considered complete once: 1. Changing any assumption automatically updates all return metrics without errors. 2. IRR, NPV, and equity multiple calculations reconcile to the cash-flow statements. 3. Sensitivity tables populate correctly for at least three user-defined variables. 4. The workbook stays under 5 MB and opens with no add-ins required. Send over a short note on your relevant residential modeling experience and any example dashboards you can share.

Project ID: 40464390