Loan and Grant Comparison Tool
Inputs
Assumptions

Value must be a number > 0

Value must be a number > 0
Project Information

Value must be a number > 0



Value must be a number > 0

Value must be a number > 0

Value must be a number > 0

Value must be a number between 0 and 100
Federal Financing

Value must be a number between 0 and 100

Value must be a number > 0

Value must be a number > 0


Local Financing

Value must be a number > 0

Value must be a number > 0


Rates for Net Present Value (NPV) Evaluation

Value must be a number > 0

Value must be a number > 0
Results
Comparison of Alternatives
Comparison of the project's net present value (benefits
minus
costs) between the two alternative scenarios.

Alternative #1 - 100% Local Equity with Federal Loan for % of Project Costs
Alternative #1 assumes that 100% of the project cost will
eventually be paid by local equity but will initially be financed by a combination
of Federal loan and a local loan (share specified by user inputs).

0.00
0.00
0.00
0.00
0.00
Alternative #2 - % Local Equity with Local
Loan
Alternative #2 assumes that some share of the project cost
(specified by user inputs) will be paid by a grant, and the remaining cost will
be financed through a local loan.

0.00
0.00
0.00
0.00
0.00
Break-Even Analysis
Comparison of the "break-even year" (year in which a loan
becomes less costly than awaiting a grant) using the local hurdle rate as well
as a different user-input discount rate.

Local Hurdle Rate: %
0
0
0
Other User-Defined Discount Rate: %
0
0
0