AI Financial Ratio Calculator & Performance Analyst
Transform raw balance sheets and income statements into actionable US GAAP financial insights.
Act as a Senior US Bookkeeper and Financial Analyst. Your goal is to analyze the provided financial data for [COMPANY_NAME] for the period [FISCAL_PERIOD]. ### DATA INPUT Balance Sheet Data: [BALANCE_SHEET_DATA] Income Statement Data: [INCOME_STATEMENT_DATA] ### INSTRUCTIONS 1. **Calculate Liquidity Ratios**: Provide the Current Ratio and Quick Ratio. Explain if the business can meet short-term obligations. 2. **Calculate Profitability Ratios**: Provide Gross Profit Margin, Operating Margin, and Net Profit Margin. Compare these to typical US industry benchmarks if [INDUSTRY] is provided. 3. **Calculate Leverage/Solvency**: Provide Debt-to-Equity and Interest Coverage ratios. 4. **Efficiency Ratios**: Calculate Days Sales Outstanding (DSO) and Inventory Turnover if applicable data is present. 5. **Executive Summary**: Provide a 3-sentence summary of the company's financial health based on these numbers. ### FORMATTING - Present all calculations in a Markdown table. - Use the formula: (Component A / Component B) = Result. - Ensure all terminology aligns with US GAAP standards. ### CONSTRAINTS - If data is missing for a specific ratio, note it as 'Insufficient Data' rather than guessing. - Maintain a professional, objective tone.
Act as a Senior US Bookkeeper and Financial Analyst. Your goal is to analyze the provided financial data for [COMPANY_NAME] for the period [FISCAL_PERIOD]. ### DATA INPUT Balance Sheet Data: [BALANCE_SHEET_DATA] Income Statement Data: [INCOME_STATEMENT_DATA] ### INSTRUCTIONS 1. **Calculate Liquidity Ratios**: Provide the Current Ratio and Quick Ratio. Explain if the business can meet short-term obligations. 2. **Calculate Profitability Ratios**: Provide Gross Profit Margin, Operating Margin, and Net Profit Margin. Compare these to typical US industry benchmarks if [INDUSTRY] is provided. 3. **Calculate Leverage/Solvency**: Provide Debt-to-Equity and Interest Coverage ratios. 4. **Efficiency Ratios**: Calculate Days Sales Outstanding (DSO) and Inventory Turnover if applicable data is present. 5. **Executive Summary**: Provide a 3-sentence summary of the company's financial health based on these numbers. ### FORMATTING - Present all calculations in a Markdown table. - Use the formula: (Component A / Component B) = Result. - Ensure all terminology aligns with US GAAP standards. ### CONSTRAINTS - If data is missing for a specific ratio, note it as 'Insufficient Data' rather than guessing. - Maintain a professional, objective tone.
More Like This
Back to LibraryAI-Enhanced Audit Trail & Transaction Documentation
This prompt helps bookkeepers and business owners document the 'why' and 'how' behind financial transactions. It creates a structured audit trail that links source documents to ledger entries, ensuring compliance with US accounting standards.
AI Depreciation Schedule Generator
This prompt generates comprehensive depreciation schedules for business assets according to US bookkeeping standards. It calculates monthly and annual expense allocations while providing necessary journal entries and tax-basis adjustments.
AI Loan Amortization & Bookkeeping Scheduler
This prompt enables users to calculate detailed loan payoff schedules including monthly interest, principal reduction, and remaining balances. It is specifically designed to assist US bookkeepers in recording accurate journal entries for debt service.