Research Projection Reports

Research Projection Reports can be run by using the "Research" menu found on the ASPIRE main menu. From this menu, choose "Projection Report."

Available Reports:

Open Balance

This report shows the remaining and projected spending for all actively funded projects, as well as proposals that have not yet been funded but are expected to be funded. The report also shows projected spending for the next several fiscal years.

ICR Grs Balance

This report shows the gross indirect cost recovery (excludes cost share) for all actively funded projects, as well as proposals that have not yet been funded but are expected to be funded. This report also project the expected amount of gross indirect cost recovery based on the projected spending rates for the next several fiscal years.

MTDC Balance

This report shows the remaining amount of Modified Total Direct Cost (MTDC) for actively funded projects. This amount is then projected for several fiscal years based on the projected spending rates. MTDC is often used as the basis for calculating F&A charges.

ICR Net Balance

This report shows the indirect cost recovery (net of any cost share) for all actively funded projects, as well as proposals not yet funded by a sponsor.

Equipment Balance

This report shows the balance of any actively funded projects that have an equipment purchase budgeted.

Cost Share Balance

This report shows the balance of any cost share on actively funded projects.

Report Sections

There are three main sections to each of the reports listed above.

Awarded - These are sponsored projects that have been awarded and have been entered into Banner by Sponsored Programs Accounting. Projections are based on the current available balance of the project, the remaining life of the project, and monthly weighting factors.
Proposals In Progress - These are projects that have been proposed to sponsors, but have not yet been awarded or declined. Projections are based on prior success rates, proposed start/end dates, and anticipated award amounts.
Anticipated Awards - These are projects that are incrementally funded. The anticipated awards section displays the remaining balance of the incremental funding.

Note -

The projected spending rates are a calculated rate from Sponsored Programs and are re-calculated each fiscal year. The weights used can be found at the top of each report.
Success stats for pending proposals are calculated by Sponsored Programs on a yearly basis and are updated accordingly. These success stats are calculated based on the dollar amount of the proposal requests, and departmental history.
Based on your ASPIRE access you might not have access to all of the Research Projections Reports.