Appendix D - Financial Proposal Summary.xlsx
XLSX spreadsheet 52 KB Posted
- Solicitation number
- 2119068
- Issued by
- Dutchess County, New York
About this file
This is a Financial Proposal Summary spreadsheet template designed to capture detailed financial assumptions and projections for a mixed-use development project. The template includes sections for site-wide assumptions, unit mix calculations, operating expenses, and development timelines for both rental and homeownership components. The spreadsheet allows for input of various unit types including studios, 1-4 bedroom units, and townhomes, with separate tracking for market-rate and affordable housing units.
The financial structure includes construction budgets, sources and uses of funds, loan terms, and return calculations including IRR, MOIC, and yield-on-cost metrics. The template provides for multiple funding sources including HFA mortgages, HCR subsidies, LIHTC (both federal and state), and developer equity. Operating expense categories are comprehensively broken down including utilities, maintenance, insurance, and management fees. The document appears to be blank or partially filled, with many fields showing "$0" or "ERROR" values, suggesting it is meant to be completed by prospective developers or bidders as part of their proposal submission.
View the file
Other files
Show all 17
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
RFP Cover Page
| Site-Wide Assumptions |
| Note: please add additional detail if necessary in every category |
| General | Open Space Assumptions | ||
| Land Close Date | [insert] | GSF of Open Space / Park Space | 0 |
| Site Acreage | 0.0 | Annual Operating Expense | $0 |
| Note: assume the developer/owner will be responsible for open space operating expenses | |||
| # Parking Spaces | 0 | ||
| Site Preparation/Infrastructure Costs | |||
| Unit Count | Environmental Remediation | $0 | |
| # Rental | 0 | Demolition | $0 |
| # Homeownership | 0 | Electrical Infrastructure | $0 |
| # Market-Rate | 0 | Fiber/Telecom Infrastructure | $0 |
| # Affordable | 0 | Sewer/Water Infrastructure | $0 |
| Total Number of Units | 0 | Total | $0 |
Mixed-Income Rental Program Assumptions Affordable Rental Program Assumptions Homeownership Program Assumptions
| Affordable Unit Mix | Rentable SF of Avg. Unit | # Affordable Units | UW Affordable Rent | AMI | 100% Affordable Unit Mix | Affordable Homeownership | ERROR:#DIV/0! | |||||
| Studios | 0 | 0 | $0 | 0% | Income Band 1 | 0.0% AMI | SF of Avg. Unit | # Affordable Units | Affordable Sales Price | Annual CAM | Annual Utilities |
tc={B7C8E7A4-6F74-4FC3-9816-9775C98A77CC}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
https://hcr.ny.gov/system/files/documents/2023/01/ua-2023-memo.pdf Annual Taxes tc={08F9731E-17F1-491B-94D3-DF409AED0B7F}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| https://hcr.ny.gov/system/files/documents/2023/01/ua-2023-memo.pdf | Annual Mortgage Payments | Buyer's Required Income | AMI | |||||||||||||||||||||
| 1BR | 0 | 0 | $0 | 0% | HH Factor | Rentable SF of Avg. Unit | # Units | UW Affordable Rent | Utility Allowance | Net Affordable Rent | 1BR | 0 | 0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#NUM! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||
| 2BR | 0 | 0 | $0 | 0% | 0.70 | Studio | 0 | 0 | $0 | $0 | $0 | 2BR | 0 | 0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#NUM! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| 3BR | 0 | 0 | $0 | 0% | 0.75 | 1BR | 0 | 0 | $0 | $0 | $0 | 3BR | 0 | 0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#NUM! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| 4BR (if applicable) | 0 | 0 | $0 | 0% | 0.90 | 2BR | 0 | 0 | $0 | $0 | $0 | 4BR (if applicable) | 0 | 0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#NUM! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Townhomes (if applicable) | 0 | 0 | $0 | 0% | 1.04 | 3BR | 0 | 0 | $0 | $0 | $0 | Total / Wtd. Avg. | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | |||||||||
| Total / Wtd. Avg. | 0 | 1.20 | 4BR (if applicable) | 0 | 0 | $0 | $0 | $0 | ||||||||||||||||
| ERROR:#DIV/0! | Total / Wtd. Avg. | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | Market-Rate Homeownership | |||||||||||||||||
| SF of Avg. Unit | # Market Units | Market Sales Price | Annual CAM | Annual Utilities | Annual Taxes |
tc={96AC5076-11E2-4532-8612-27DE632E3679}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| https://hcr.ny.gov/system/files/documents/2023/01/ua-2023-memo.pdf | Annual Mortgage Payments | Buyer's Required Income | AMI | |||||||||||||||||||||
| Market-Rate Unit Mix | Rentable SF of Avg. Unit | # Market-Rate Units | UW Market Rent | UW Market Rent | Income Band 2 | 0.0% AMI | 1BR | 0 | 0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#NUM! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||
| Studios | 0 | 0 | $0 | 0% | Rentable SF of Avg. Unit | # Units | UW Affordable Rent | Utility Allowance | Net Affordable Rent | 2BR | 0 | 0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#NUM! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| 1BR | 0 | 0 | $0 | 0% | 0.70 | Studio | 0 | 0 | $0 | $0 | $0 | 3BR | 0 | 0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#NUM! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| 2BR | 0 | 0 | $0 | 0% | 0.75 | 1BR | 0 | 0 | $0 | $0 | $0 | 4BR (if applicable) | 0 | 0 | $0 | ERROR:#DIV/0! | $0 | $0 | ERROR:#NUM! | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| 3BR | 0 | 0 | $0 | 0% | 0.90 | 2BR | 0 | 0 | $0 | $0 | $0 | Total / Wtd. Avg. | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | |||||||||
| 4BR (if applicabe) | 0 | 0 | $0 | 0% | 1.04 | 3BR | 0 | 0 | $0 | $0 | $0 | |||||||||||||
| Townhomes (if applicable) | 0 | 0 | $0 | 0% | 1.20 | 4BR (if applicable) | 0 | 0 | $0 | $0 | $0 | Total # Homeownership Units | 0 | Common Area Charges (Annual) | Returns | |||||||||
| Total / Wtd. Avg. | 0 | Total / Wtd. Avg. | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | Total SSF | 0 | Legal | $0 | Unlevered IRR | 0.0% | |||||||||||
| ERROR:#DIV/0! | Accounting | $0 | Unlevered Profit | $0 | ||||||||||||||||||||
| Income Band 3 | 0.0% AMI | Mortgage Assumptions | Management Fee | $0 | Unlevered MOIC | 0.00x | ||||||||||||||||||
| Total Mixed-Income Units | 0 | Affordable Annual Rent Growth | 0.0% | Rentable SF of Avg. Unit | # Units | UW Affordable Rent | Utility Allowance | Net Affordable Rent | Interest Rate | 0.00% | Insurance | $0 | Untrended Yield-on-Cost | 0.0% | ||||||||||
| Efficiency Ratio (GSF -> RSF) | 0.0% | Stabilized Affordable Vacancy | 0.0% | 0.70 | Studio | 0 | 0 | $0 | $0 | $0 | Amortization (Yrs) | 0 | Maintenance/Repairs | $0 | ||||||||||
| # of Buildings | 0 | Affordable Lease-Up Period (Months) | 0 | 0.75 | 1BR | 0 | 0 | $0 | $0 | $0 | Down Payment (%) | 0.00% | Service Contracts | $0 | Lev. IRR | 0.0% | ||||||||
| 0.90 | 2BR | 0 | 0 | $0 | $0 | $0 | Mortgage Burden (%) | 0.00% | Superintendent | $0 | Lev. Profit | $0 | ||||||||||||
| Other Income ($ / Unit / Month) | $0.00 | Market-Rate Annual Rent Growth | 0.0% | 1.04 | 3BR | 0 | 0 | $0 | $0 | $0 | Total Annual CAM Expense | $0 | Lev. MOIC | 0.00x | ||||||||||
| Parking Income ($ / Unit / Month) | $0.00 | Stabilized Market-Rate Vacancy | 0.0% | 1.20 | 4BR (if applicable) | 0 | 0 | $0 | $0 | $0 | Development Timeline | |||||||||||||
| Mths. Concession in Lease-Up | 0 | Market-Rate Lease-Up Period (Months) | 0 | Total / Wtd. Avg. | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | Pre-Development (Months) | 0 | Retail/Community Facility Assumptions | ||||||||||||
| Sitework (Months) | 0 | # Retail Suites | 0 | |||||||||||||||||||||
| Residential Operating Expenses | $/Unit/Year | Retail/Community Facility Assumptions | Rent Burden | 30.0% | Affordable Annual Rent Growth | 0.0% | Construction (Months) | 0 | Avg. Retail Suite Size | 0 | ||||||||||||||
| Payroll | $0 | # Retail Suites | 0 | Total 100% Affordable Units | 0 | Stabilized Affordable Vacancy | 0.0% | Home Sales Period (Months) | 0 | Avg. Rent (assuming NNN, $ / RSF / Year) | $0.00 | |||||||||||||
| Administrative | $0 | Avg. Retail Suite Size | 0 | Efficiency Ratio (GSF -> RSF) | 0.0% | Affordable Lease-Up Period (Months) | 0 | Last Home Sold Date | ERROR:#VALUE! | |||||||||||||||
| Utilities | $0 | Avg. Rent (assuming NNN, $ / RSF / Year) | $0.00 | # of Buildings | 0 | |||||||||||||||||||
| Marketing | $0 | Sources & Uses | ||||||||||||||||||||||
| Contract Services | $0 | Returns | Other Income ($ / Unit / Month) | $0.00 | Construction Budget/Uses | Construction Sources | % Capital Stack | |||||||||||||||||
| Maintenance | $0 | Unlevered IRR | 0.0% | Parking Income ($ / Unit / Month) | $0.00 | Land Acquisition | $0 | Construction Loan | $0 | ERROR:#DIV/0! | ||||||||||||||
| Management Fee (% of EGI) | 0.00% | Unlevered Profit | $0 | Developer Equity | $0 | ERROR:#DIV/0! | ||||||||||||||||||
| Insurance | $0 | Unlevered MOIC | 0.00x | Residential Operating Expenses | $/Unit/Year | Residential Hard Costs | $0 | Deferred Developer Fee | $0 | ERROR:#DIV/0! | ||||||||||||||
| Replacement Reserves | $0 | Untrended Yield-on-Cost | 0.0% | Utilities | $0 | General Conditions | $0 | |||||||||||||||||
| Real Estate Taxes | $0 | Repairs & Maintenance | $0 | Overhead | $0 | Construction Loan Interest Rate | 0.0% | |||||||||||||||||
| Lev. IRR | 0.0% | Property Management Fee | $0 | GC Profit | $0 | Loan Term (Months) | 0 | |||||||||||||||||
| Annual Expense Growth | 0.00% | Lev. Profit | $0 | Administrative | $0 | Performance Bond | $0 | |||||||||||||||||
| Lev. MOIC | 0.00x | Insurance | $0 | Hard Cost Contingency | $0 | |||||||||||||||||||
| Real Estate Taxes | $0 | Subtotal - Hard Costs | $0 | |||||||||||||||||||||
| Replacement Reserves | $0 | |||||||||||||||||||||||
| Development Timeline | Exit Assumptions | Accounting | $0 | |||||||||||||||||||||
| Pre-Development (Months) | 0 | Exit Cap Rate | 0.00% | Annual Expense Growth | 0.00% | Appraisal | $0 | |||||||||||||||||
| Sitework (Months) | 0 | Sales Costs | 0.00% | Architect | $0 | |||||||||||||||||||
| Construction (Months) | 0 | Hold Period (Years) | 0 | Engineer | $0 | |||||||||||||||||||
| Lease-Up (Months) | 0 | Development Timeline | Permits | $0 | ||||||||||||||||||||
| Hold-Period Post-Stabilization (Months) | 0 | Pre-Development (Months) | 0 | Environmental | $0 | |||||||||||||||||||
| Property Sale Date | ERROR:#VALUE! | Sitework (Months) | 0 | Geotechnical | $0 | |||||||||||||||||||
| Construction (Months) | 0 | Insurance | $0 | |||||||||||||||||||||
| Sources & Uses | Lease-Up (Months) | 0 | Market Study | $0 | ||||||||||||||||||||
| Permanent Loan Conversion | 0 | Legal | $0 | |||||||||||||||||||||
| Construction Budget | Construction Loan | Marketing | $0 | |||||||||||||||||||||
| Land Acquisition Price | $0 | Loan Amount | $0 | Sources & Uses | Survey | $0 | ||||||||||||||||||
| Closing Costs | $0 | % LTC | 0.0% | Construction Budget/Uses | Construction Sources | % Capital Stack | Taxes | $0 | ||||||||||||||||
| Subtotal - Acquisition Costs | $0 | Interest Rate Spread over SOFR | 0.00% | Land Acquisition | $0 | HFA First Mortgage (Long-Term Bonds) | $0 | ERROR:#DIV/0! | Title & Recording | $0 | ||||||||||||||
| Term (Mths) | 0 | HFA Construction Loan (Short-Term Bonds) | $0 | ERROR:#DIV/0! | Soft Cost Contingency | $0 | ||||||||||||||||||
| Residential Hard Costs | $0 | Residential Hard Costs | $0 | HCR Subsidy | $0 | ERROR:#DIV/0! | Subtotal - Soft Costs | $0 | ||||||||||||||||
| General Conditions | $0 | Permanent Loan (if applicable) | General Conditions | $0 | Accrued and Deferred Interest | $0 | ERROR:#DIV/0! | |||||||||||||||||
| Overhead | $0 | Loan Amount | $0 | Overhead | $0 | Federal LIHTC | $0 | ERROR:#DIV/0! | Construction Loan Origination Fee | $0 | ||||||||||||||
| GC Profit | $0 | % LTV | 0.00% | GC Profit | $0 | State LIHTC | $0 | ERROR:#DIV/0! | Interest Reserve: Construction Loan | $0 | ||||||||||||||
| Performance Bond | $0 | Interest Rate | 0.00% | Performance Bond | $0 | Deferred Developer Fee | $0 | ERROR:#DIV/0! | Subtotal - Lender Fees & Interest | $0 | ||||||||||||||
| Hard Cost Contingency | $0 | Financing Fee | 0.00% | Hard Cost Contingency | $0 | |||||||||||||||||||
| Subtotal - Hard Costs | $0 | Origination Month | 0 | Subtotal - Hard Costs | $0 | Construction Loan Interest Rate | 0.0% | Developer Fee | $0 | |||||||||||||||
| Term (Years) | 0 | Capitalized CAM Reserve | $0 | |||||||||||||||||||||
| Open Space / Park Construction & Landscaping Cost | $0 | Amortization Period (Years) | 0 | Accounting | $0 | |||||||||||||||||||
| Parking Structure Construction Cost, if applicable | $0 | Appraisal | $0 | Total Homeownership Program Budget/Uses | $0 | Total Homeownership Program Sources | $0 | |||||||||||||||||
| Subtotal - Non-Building Construction Costs | $0 | Developer Equity | Architect | $0 | Permanent Sources | |||||||||||||||||||
| Equity Amount | $0 | Engineer | $0 | HFA First Mortgage (Long-Term Bonds) | $0 | ERROR:#DIV/0! | ||||||||||||||||||
| Architectural & Engineering | $0 | Equity % of Cost | 0.0% | Permits | $0 | HCR Subsiry | $0 | ERROR:#DIV/0! | ||||||||||||||||
| Other Consultants | $0 | Environmental | $0 | Federal LIHTC | $0 | ERROR:#DIV/0! | ||||||||||||||||||
| Accounting / Printing / Office | $0 | Limited Partner Equity (if applicable) | Geotechnical | $0 | State LIHTC | $0 | ERROR:#DIV/0! | |||||||||||||||||
| Legal | $0 | Equity Amount | $0 | Insurance | $0 | Developer Operating Reserve (3 mos) | $0 | ERROR:#DIV/0! | ||||||||||||||||
| Permit Fees | $0 | Equity % of Cost | 0.0% | Market Study | $0 | Developer Fee | $0 | ERROR:#DIV/0! | ||||||||||||||||
| FF&E / Amenities | $0 | Preferred Return % | 0.0% | Marketing | $0 | |||||||||||||||||||
| Lease-Up Marketing | $0 | Survey | $0 | Permanent Loan Interest Rate | 0.0% | |||||||||||||||||||
| Soft Cost Contingency | $0 | Taxes | $0 | |||||||||||||||||||||
| Subtotal - Soft Costs | $0 | Title & Recording | $0 | |||||||||||||||||||||
| Soft Cost Contingency | $0 | |||||||||||||||||||||||
| Developer Fee | $0 | Subtotal - Soft Costs | $0 |
| Construction Loan Origination Fee | $0 | Interest Reserve: First Mortgage | $0 |
| Loan Closing Costs (Legal/Appraisal/Title) | $0 | Interest Reserve: Construction Loan | $0 |
| Loan Broker (if applicable) | $0 | Lender Line of Credit: Origination, Annual, Draw Fees | $0 |
| Mortgage Recording Tax | $0 | Construction Monitor, Plan & Cost Review | $0 |
| Capitalized Interest | $0 | HFA Closing fee | $0 |
| Capitalized Operating Shortfall | $0 | NYS Bond Issuance Fee | $0 |
| Subtotal - Financing Costs | $0 | Subtotal - Lender Fees & Interest | $0 |
| Total Mixed-Income Rental Program Budget / Uses | $0 | Total Mixed-Income Rental Program Sources | $0 | Borrower Legal | $0 |
| Bank Legal | $0 | ||||
| LIHTC Syndication Fees | $0 | ||||
| Subtotal - Legal Fees & Syndication Costs | $0 |
| Developer Fee | $0 |
| Capitalized Operating Reserve | $0 |
Total Affordable Rental Program Budget / Uses $0 Total Affordable Rental Program Sources $0
File details come from the government source that posted it. Updated .