MTDC Calculation Table.xlsx

This file is a Modified Total Direct Costs (MTDC) calculation worksheet for XYZ Organization's federal grant budget. The organization's total direct costs equal $830,000, comprised of personnel ($100,000), fringe benefits ($50,000), travel ($55,000), equipment ($15,000), supplies ($6,000), contractual subawards ($509,000 across four awards), and other direct costs ($95,000 including venue and childcare). Total exemptions of $408,000 are applied, including equipment ($15,000), participant support costs ($73,000), and portions of subawards exceeding $50,000 ($320,000), resulting in a Modified Total Direct Costs figure of $422,000. Based on this MTDC, the indirect cost calculation using a NICRA or 15 percent de minimis rate yields $63,300 in allowable indirect costs.

This budget worksheet corresponds to the Department of State Bureau of Democracy, Human Rights and Labor's competitive grant opportunity for an Independent Journalism Consortium in Europe under Assistance Listing 19.345 (International Programs to Support Democracy, Human Rights and Labor). The funding mechanism is a cooperative agreement supporting fact-based independent journalism focused on public policy issues affecting European sovereignty, civilizational values, and democracy. Applicants must comply with 2 CFR Subpart F audit requirements, maintain records for seven years, and refer to the solicitation on grants.gov for specific eligibility criteria, deadlines, and additional application requirements.