Question
Using the assumptions below, create an Excel spreadsheet that includes a 10-year cash flow proforma, a Sources and Uses table, and calculates the Outputs listed
Using the assumptions below, create an Excel spreadsheet that includes a 10-year cash flow proforma, a Sources and Uses table, and calculates the Outputs listed below. Property Size Building Net Rentable Square Feet 100,000 sf Purchase Assumptions Asking Price $14,000,000 Acquisition Closing Costs 3.0% of purchase price Sale Assumptions Terminal (Exit) Cap Rate 9.5% Sale Closing Costs 2.25% of sale price Revenue and Expense Assumptions In-place Gross Rents $20.00/sf Annual Rent Escalations 3.0% Vacancy Loss Factor (annual) 5.0% Operating Expenses $5.50/sf Insurance $0.25/sf Property Taxes $2.25/sf Annual Expense Escalations 3.0% Financing Loan Amount 75.0% of purchase price Interest Rate 6.0% Term - 10 years Amortization - 25 years Payment - Monthly Assignment: create an Excel spreadsheet that includes a 10-year cash flow proforma, a Sources and Uses table, and calculates the Outputs listed below
Outputs Needed 1) Year 1 Cap Rate (NOI/Purchase Price) 2) Year 1 Cash-on-Cash Yield (After Debt Cash Flow / Equity) 3) 10-year Leveraged IRR (include debt) 4) 10-year Unleveraged IRR (exclude debt) 5) Year 1 Debt Service Coverage Ratio
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started