FinanceFree
House Affordability Calculator
Estimate affordable house price from income, debts, mortgage assumptions, and monthly housing costs.
- Income and debt inputs
- DTI affordability check
- Housing cost breakdown
- Payment chart summary
Team Profile
Shahsawar Shahid
Senior Spreadsheet Architect & Data Analyst
Profile Overview
- StatusSpecialist
- FocusFinancial Modeling
- CategoriesFinance, Business
- LocationRemote
Profile
Senior Financial Modeler & Excel Automator (6+ years experience)
Shahsawar works on corporate finance and debt models, the templates where the arithmetic has to stand against how the same calculation is done professionally rather than merely producing a plausible-looking number.
His focus areas are finance and business. On this site that covers the debt payoff, affordability and cash flow planners, together with the automation that keeps them usable: routines that rebuild a schedule when an assumption changes, instead of leaving someone to drag formulas down by hand and hope the last row caught.
A recurring part of the work is reconciliation. Where a web calculator and its downloadable counterpart implement the same model, the two have to agree to the cent, and establishing that is a task in its own right rather than something that can be assumed.
Core Expertise
Financial ModelingVBA AutomationDebt Payoff PlannersCorporate Finance
4
Planners built
2
Focus areas
101
Tools in those areas
4
Specialisms
Focus areas
101 toolsHow Shahsawar works
- Match the professional method
- A number that looks right but was reached by a different route will not survive anyone checking it.
- Automate the repetitive part
- If changing one assumption means dragging formulas down three hundred rows, the model is not finished.
- Reconcile against the web tool
- Two implementations of one model must agree, and the only way to know they do is to check.
"Excel models must align perfectly with web calculators. We translate advanced corporate modeling into direct, offline spreadsheets."
— Shahsawar Shahid, Senior Spreadsheet Architect & Data AnalystSpreadsheet Templates Developed
4 Planners
FinanceFree
Crypto Portfolio Tracker
A connected workbook for logging crypto trades, tracking cost basis and holdings, comparing allocation to targets, estimating FIFO/LIFO tax lots, and stress-testing your portfolio against market scenarios.
- Transaction ledger with cost basis & P/L
- Allocation analysis with rebalancing suggestions
- FIFO/LIFO tax lot estimator
- Scenario & risk lab with 1,800-row OHLCV database
PersonalFree
Personal Cash Flow Tracker
A connected workbook that logs income and bills by the date they actually happen, carries a running balance forward automatically, and projects that balance week by week so low-balance weeks show up before they become overdrafts.
- Weekly balance projection with Surplus / Tight Week / Low Balance alerts
- Cash Flow Log with running balance & timing status
- Dashboard with buffer headroom & Decision Insights
- Monthly rollup & printable cash timing report
BusinessFree
Amazon FBA Profit Calculator
The offline, editable version of the Amazon FBA Profit Calculator: net profit, margin, ROI, break-even price, target-margin and target-ROI pricing, a seller-plan comparison, and a price sensitivity table from one product's inputs.
- Net profit, margin & ROI matching the live calculator's formulas
- Break-even, target-margin & target-ROI pricing side by side
- Professional vs. Individual seller-plan comparison
- Five-point price sensitivity table & Dynamic Insights