Appendix B - Budget Workbook - Development 02112026.xlsx

This is a Budget Workbook Appendix for a development project in the City of Sun Prairie, Wisconsin, focused on the development of affordable owner-occupied homes. The document provides a template for applicants to submit comprehensive financial information across three fiscal years (2025 Actual, 2026 Budget, and 2027 Proposed). The workbook is structured to capture agency operating expenses including personnel costs with salary and benefits, operating expenses, space costs for rent/utilities/maintenance and mortgage/depreciation/taxes, and special costs such as subcontracts and debt service. The Agency Overview section requires applicants to document total revenue from multiple sources including direct public grants, direct and indirect public support, miscellaneous revenue, restricted funds, and program income, with calculations of net income across the three-year period.

The Capital Budget section requires applicants to detail all proposed project funding sources, including permanent loans, subordinate loans, tax-exempt bonds, city AHF loans, historic tax credits, equity contributions, deferred developer fees, and owner investment. The document also captures construction financing sources such as construction loans and bridge loans, with associated terms, rates, and annual debt service calculations. The Project Expenses section requests itemization of acquisition costs including land, existing buildings/improvements, and construction/rehabilitation costs. Applicants are required to provide estimated pricing on the sale of federal and state tax credits if applicable and include remarks concerning project funding sources. The workbook serves as the primary financial documentation tool for evaluating the feasibility and funding structure of affordable housing development proposals submitted to the City of Sun Prairie.