Using the below assumptions, calculate and provide excel formula for:

• Net Operating Income,
• Cap Rate, Capitalized Value,
• Time Value of Money, Discounted Cash Flows,
• Net Present Value (NPV),
• Internal Rate of Return (IRR),
• DCF of Uneven Cash Flows,
• Simple Financial Feasibility Analysis (SFFA),
• Construction loan and draw calculations,
• Loan-to-Value (LTV),
• Loan Constant
• Debt Service Coverage Ratio,
• Calculation of levered returns

Development Timeline Gross Building Area (GBA)Bldg. Area (sqft.) Site Purchased 2/1/16 Residential 13,658 Planning Started 2/1/16 Parking 3,000 Construction Financing Arranged9/1/16 Total GBA 16,658 Construction Started10/1/16 Total Auto Parking Spaces 16 Sales/Leasing Started5/1/17 Total Bike Storage Spaces 6 Construction Completed8/31/17 Land Use Plan Acres% of Site Buildings 0.1741% Landscaping/Open Space0.2459% Total 0.41100% Current Residential Information Unit TypeNumber of UnitsSquare FeetVacant UnitsAverage Rents Studio (w/o parking)361511,425 Studio 765011,630 Two Bedroom 693002,200 Three bedroom (historic house)11,68303,200 Total 17 2 Development Cost Information Financing & Value InformationSite Acquisition Cost $ 825,000 Construction Loan Interest Rate3.50%Hard Costs Permanent Loan Interest Rate5.50%Residential Units (gross) 1,950,000 Loan to Value 70%Existing House Rehab 172,500 Amortization (years)30Parking Area 237,000 Loan Term (years) 10Stairwell 52,000 Lender Required DCR (min.)1.20Landscape/Hardscape 76,500 Interest-Only PeriodN/AContractor's Fee 80,000 Market Cap Rate 8.25%Administrative Overhead & Expenses 73,250 Your Required ROE 10.0%Contingency 132,063 Subtotal - Hard Costs 2,773,313 Soft Costs Architecture 48,500 Landscape Architecture 23,650 Structural Engineering 32,000 Civil Engineering 24,675 Planning & Processing Consultants 6,000 MEP Engineering 15,840 Utility Consulting 12,350 Title 24 & Survey 15,000 Legal 16,500 Accounting, Printing & Insurance 11,275 General & Administrative 47,950 Property Taxes (24 months) 14,325 City Fees & Permits 425,000 Contingency 34,653 Construction Loan Interest - Subtotal - Soft Costs 727,718 Total Development Cost $ 4,326,031