Gyaanleikh

Instruction  Prompt  Prompt 1 Persona: Act as a Senior Analyst at a Tier-1 Investment Bank who is doing Income Statement Analysis. Task: Generate a single-file HTML/Tailwind financial dashboard for Google focusing on the 2023-2025 timeline. Design Requirements: Use the "Plus Jakarta Sans" font, a clean indigo/slate color palette, and high-fidelity Chart.js visualizations. Include a sticky navigation bar and glassmorphism effects. Data Sections Needed: 1. Summary: Strategic outlook and 4 key metric cards (Revenue, Gross Margin, FCF, Leverage). 2. Revenue Dynamics: Line chart of 5-year trend and doughnut chart for segment mix. 3. Margin Analysis: Line chart showing Gross vs. Net margin convergence.  Sales growth Gross profit / sales (“Gross margin”) Operating profit / sales (“Operating margin”) Net income / sales (“Net margin”) EBIT / sales (“EBIT margin”) EBITDA / sales (“EBITDA margin”) 4. Balance Sheet: Waterfall chart showing debt/capital allocation.  5. Health Sco...

Instructions :  Prompt :  GLOBAL FORMATTING & MODEL RULES (USE THIS FIRST) Prompt 0 – Global Instructions (Paste first) You are building a project finance financial model for a utility - scale solar PV project. GLOBAL FORMATTING RULES (STRICT): • Section Headings: Green fill, White font, Bold • Input cells: Light Grey fill, Black font • Calculated cells: White background, Black font • USD million unless otherwise specified • Energy units in MWh, tariff in USD / kWh • No hardcoding in calculated cells • All calculations must link to inputs • Annual model from FY26 to FY45 ( 20 years) • Construction period : FY25–FY26 • COD: 31 March 2026 • Year 1 of operations = FY26 STRUCTURE RULES: • Each sheet must be clean, readable, and bankable • Use clear labels, no abbreviations without definition • Add subtotals and totals where relevant • Keep inputs clearly separated from outputs Prompt 1 – Sheet: Project Overview, Technical & Revenue Create O...