Mortgage Dashboard (PHP + HTML + JS) =================================== Files ----- - index.php Main page - styles.css Styling - app.js Calculator logic, dashboard rendering, scenario save/load - api.php PHP persistence API - data/ Folder that stores the JSON file What this app does ------------------ This rebuilds the Excel worksheet as a browser-based dashboard and adds: - cleaner input layout - live monthly mortgage payment calculation - bridge-loan estimate - purchase + sale summaries - saved scenarios that persist on the server - amortization chart preview How to install -------------- 1. Upload the entire folder to your PHP-enabled server. 2. Make sure the server can write to the /data folder. 3. Browse to index.php. Important server permissions ---------------------------- The PHP process must be able to create and edit: - data/mortgage_data.json If saved scenarios do not work: - check folder permissions on /data - confirm your host allows file writes from PHP Suggested permissions --------------------- Typical Linux hosting: - folders: 775 - files: 664 How persistence works --------------------- Saved scenarios are stored in: - data/mortgage_data.json No database is required. Notes about the calculation model --------------------------------- This version is more complete than the workbook: - monthly mortgage payment uses principal + interest - tax, insurance, HOA, and optional PMI are included - bridge-loan interest can be estimated for a short term - saved scenarios can be recalled or deleted Security note ------------- This version is intentionally simple for public hosting. If the site is public-facing and many users will access it, add: - login protection - CSRF protection - validation / rate limiting - backup strategy for the JSON file