finance

Automate real estate financial modeling with GAAP and USALI standards.

Updated Mar 10, 2026
One-click install
npx skills add https://github.com/ricardocidale/hbg-screens --skill finance-ricardocidale
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: finance
Source: https://github.com/ricardocidale/hbg-screens/tree/main/.claude/skills/finance
Command: npx skills add https://github.com/ricardocidale/hbg-screens --skill finance-ricardocidale

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and scripts (resource) components.

What problem does it solve?

This Skill provides a comprehensive financial calculation engine for real estate investments, automating complex tasks like income statement generation, cash flow analysis, balance sheet balancing, and investment return calculations (IRR, NPV, DCF).

Core Features & Use Cases

  • GAAP-Compliant Financial Statements: Generate accurate Income Statements, Cash Flow Statements, and Balance Sheets based on USALI and GAAP standards.
  • Investment Analysis: Perform Discounted Cash Flow (DCF) analysis, calculate Internal Rate of Return (IRR), Net Present Value (NPV), Debt Service Coverage Ratio (DSCR), and Debt Yield.
  • Use Case: Analyze the financial viability of a new hotel acquisition by projecting its income, cash flow, and key investment returns over a 10-year period, considering financing, operating expenses, and exit strategy.

Quick Start

Generate a 10-year pro forma income statement for a hotel property.

Frequently Asked Questions about finance

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a pro forma income statement for a hotel acquisition?

This Skill automates income statement generation for real estate investments, producing GAAP-compliant financial statements by processing your property's projected revenues and operating expenses.

What is the best way to calculate IRR and DCF for real estate investments?

The best way to calculate IRR and DCF for real estate investments is to use a deterministic calculation engine that integrates discounted cash flow analysis with your projected income statements. This Skill performs DCF analysis and calculates IRR, NPV, DSCR, and Debt Yield by automating deterministic calculations based on your projected property cash flows.

Can I use this financial modeling tool to project cash flow over a 10-year period?

Yes, you can use this financial modeling tool to project cash flow over a 10-year period by inputting your property's expected financing, operating expenses, and exit strategy. It automates multi-year cash flow analysis and investment return projections for real estate assets over specified holding periods.

Does this real estate finance engine support GAAP and USALI standards?

Yes, this real estate finance engine supports GAAP and USALI standards to ensure accurate and compliant financial reporting. It generates Income Statements, Cash Flow Statements, and Balance Sheets that adhere to these specific accounting frameworks for hospitality and real estate properties.

How does cash flow analysis handle financing and exit strategies?

Cash flow analysis handles financing and exit strategies by incorporating debt service coverage ratios and exit valuations into the projected cash flows. The tool calculates DSCR, Debt Yield, and terminal value to accurately model investment returns and financial viability across the holding period.

What do I need to perform DCF analysis on a new hotel acquisition?

To perform DCF analysis on a new hotel acquisition, you need projected income data, operating expenses, financing terms, and an estimated exit strategy. The Skill uses these inputs to automate balance sheet balancing, cash flow analysis, and investment return calculations for your property.