"""Fictional investment/debt case. Amounts: million rubles; Python 3.9."""
import argparse
import json
from decimal import Decimal
from pathlib import Path

def number(value, name, positive=False):
    result = Decimal(str(value))
    if not result.is_finite() or result < 0 or (positive and result == 0):
        raise ValueError("Invalid nonnegative finite value: " + name)
    return result

def evaluate(data):
    opening = number(data["opening_cash"], "opening_cash")
    debt = number(data["existing_debt"], "existing_debt")
    ebitda = number(data["ebitda"], "ebitda", positive=True)
    limit = number(data["debt_limit"], "debt_limit")
    reserve = number(data["reserve"], "reserve")
    delay = number(data["stress_delay"], "stress_delay")
    rate = number(data["discount_rate"], "discount_rate")
    rows = []
    identifiers = set()
    for project in data["projects"]:
        identifier = project["id"]
        if identifier in identifiers:
            raise ValueError("Duplicate project")
        identifiers.add(identifier)
        investment = number(project["investment"], "investment")
        loan = number(project["loan"], "loan")
        equity = number(project.get("equity", "0"), "equity")
        flows = [number(v, "cash_flow") for v in project["cash_flows"]]
        if len(flows) != 3:
            raise ValueError("Exactly three annual end-period flows required")
        npv = sum((flow / (1 + rate) ** year for year, flow in enumerate(flows, 1)), Decimal(0)) - investment
        total_debt = debt + loan
        ratio = total_debt / ebitda
        cash = opening + loan + equity - investment
        stressed = cash - delay
        rows.append({"id": identifier, "npv": str(npv), "total_debt": str(total_debt),
                     "debt_ratio": str(ratio), "closing_cash": str(cash), "stressed_cash": str(stressed),
                     "debt_pass": ratio <= limit, "reserve_pass": stressed >= reserve,
                     "both_pass": ratio <= limit and stressed >= reserve})
    return rows

def main():
    parser = argparse.ArgumentParser(description=__doc__)
    parser.add_argument("input", nargs="?", default=str(Path(__file__).with_name("projects.json")))
    args = parser.parse_args()
    data = json.loads(Path(args.input).read_text(encoding="utf-8"))
    print(json.dumps(evaluate(data), ensure_ascii=False, indent=2))

if __name__ == "__main__":
    main()
