Question: Please do a 10 year cash flow analysis for a single tenant office building. Assumptions are listed below and a template is provided. Assumptions: 60,000sf

Please do a 10 year cash flow analysis for a single tenant office building. Assumptions are listed below and a template is provided.

Assumptions: 60,000sf building, Rent $10.50psf; RETax $1.65psf; CAM $3psf; Going in cap: 8%; Exit Cap: 8.5%; Cost of Sales: 3%; LTV: 75%; Loan- 6%, 25 yr amort; DSCR: 1.2 Vacancy allowance: 3% (apply only to the proforma, not the 10 year cash flow), Cap Exp Reserve: $.10 psf (apply both to proforma and cash flow); Project Cost: $4.3M; Land: $300K; Use first year Gross Income to do the proforma and then to calculate loan.

Using above and the template, please calculate the: BT Unlevered IRR and the BT Levered IRR.

Please do a 10 year cash flow analysis for a single tenant

Please provide formulas for excel

WICKED TOWER Building st 2015 2016 2017 2019 2020 2021 2022 2024 2014 Year! 2018 Year 3 2023 Year 10 Lease Rate End 1/1/2024 Premises SF 0 SO SO SO SO SU SO SO SO $0 SO SU SO SU SO SU SO SO SO SO SO SU SO Tenant Lease Start Gross Rent Clarke Real Estate 1/1/2014 Effective Gross Rent Less: RE Taxes CAM Cap Expenditure Subtotal RETAX/CAM/ Cap Ex NET OPERATING INCOME Debt Service BT Cash Flow Interest Depreciation Taxable Income Tax AT Cash Flow SO SO SO so so so SO SO so SO so SU #DIV/0! #DIV/0! so so SO $0 #DIV/0! #DIV/0! ! #DIV/0! #DIV/0! SO sa SU #DIV/ #DIV/0! #DIV/0! 0 #DIV/0! so SO #DIV/0! #DIV/0! so SO #DIV/0! #DIV/0! so su #DIV/0! #DIV/0! SO SO #DIVAO! ! #DIV/0! #DIV/0! #DIV/0! SO .. SO SO #VALUE! NVALUE! SO DIV/0! SO NDIV/0! SO NDIV/0! SO ODIV/0! SO NDIVANI SO NDIV/0! SO NDIV/0! so #DIV/0! DIV/0! WDIVAO! 0! DIVADI DIV/0! BT UNLEVERED IRR II'T LEVERED IRR AT UNLEVERED IRR AT LEVERED IRR inflation Inflation 0.02 1.02 SU Assumptions: RETaxes psily CAM psfy PRO FORMA CALCULATION Gross Potenial Income Less Vacancy Allow 0% EGI CAMRETax Cap Expenditure S0.00 #DIV/0! 0.0773 SO SO SO SO SO Cap Rate Lean Race DSCR LTV Amort Vacancy Cap Exp Loan Amt w/LTV Luan Constant Loan Amt w/ DSCR Value NDIV/0! year #DIV/0! Net Operating Income SO psllyear Exit Sale Exit Cup Hale Cost of Sale Land Value Depreciable Life Debt Service #DIV/0! Project Cost 39.5 Cash Flow #DIV/0! Initial Equity Mortgnge Balance End Yr 10 #DIV/0! #DIV/0! WICKED TOWER Building st 2015 2016 2017 2019 2020 2021 2022 2024 2014 Year! 2018 Year 3 2023 Year 10 Lease Rate End 1/1/2024 Premises SF 0 SO SO SO SO SU SO SO SO $0 SO SU SO SU SO SU SO SO SO SO SO SU SO Tenant Lease Start Gross Rent Clarke Real Estate 1/1/2014 Effective Gross Rent Less: RE Taxes CAM Cap Expenditure Subtotal RETAX/CAM/ Cap Ex NET OPERATING INCOME Debt Service BT Cash Flow Interest Depreciation Taxable Income Tax AT Cash Flow SO SO SO so so so SO SO so SO so SU #DIV/0! #DIV/0! so so SO $0 #DIV/0! #DIV/0! ! #DIV/0! #DIV/0! SO sa SU #DIV/ #DIV/0! #DIV/0! 0 #DIV/0! so SO #DIV/0! #DIV/0! so SO #DIV/0! #DIV/0! so su #DIV/0! #DIV/0! SO SO #DIVAO! ! #DIV/0! #DIV/0! #DIV/0! SO .. SO SO #VALUE! NVALUE! SO DIV/0! SO NDIV/0! SO NDIV/0! SO ODIV/0! SO NDIVANI SO NDIV/0! SO NDIV/0! so #DIV/0! DIV/0! WDIVAO! 0! DIVADI DIV/0! BT UNLEVERED IRR II'T LEVERED IRR AT UNLEVERED IRR AT LEVERED IRR inflation Inflation 0.02 1.02 SU Assumptions: RETaxes psily CAM psfy PRO FORMA CALCULATION Gross Potenial Income Less Vacancy Allow 0% EGI CAMRETax Cap Expenditure S0.00 #DIV/0! 0.0773 SO SO SO SO SO Cap Rate Lean Race DSCR LTV Amort Vacancy Cap Exp Loan Amt w/LTV Luan Constant Loan Amt w/ DSCR Value NDIV/0! year #DIV/0! Net Operating Income SO psllyear Exit Sale Exit Cup Hale Cost of Sale Land Value Depreciable Life Debt Service #DIV/0! Project Cost 39.5 Cash Flow #DIV/0! Initial Equity Mortgnge Balance End Yr 10 #DIV/0! #DIV/0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please do a 10 year cash flow analysis for a single tenant office building. Assumptions are listed below and a template is provided. Assumptions: 60,000sf building, Rent $10.50psf; RETax $1.65psf;...

Please do a 10 year cash flow analysis (with a sale at start of Yr 11) for a single tenant office building. Assumptions are listed below and a template is provided. Assumptions: 75,000sf building,...

You are a Capital Markets Associate supporting a team of debt origination professionals at a top Debt Advisory firm based in New York City. A borrower has approached your team with a financing...

Would you be able to put together another monthly cash flow analysis, this time for year 1? INCOME STATEMENT Year 1 269,115.00 48,930.00 20,388.00 338,433.00 $ $ $ $ COGS $ 113,940.00 $ 125,940.00 $...

need it urgently !! please show work excel is needed . need it ASAP This document may be modified for clarification, especially in response to student questions. Instructions Conduct a DCF analysis...

You are a loan officer at a local bank (Bank ABD). The Vice President of the bank asks you to conduct a prelimiary underwriting analysis for a commercial loan. The property is a single tenant retail...

Please include excel sheet on how to answer the following questions: What is the present value of the property, under each scenario, using a discounted cash flow analysis? What is the internal rate...

Using the information provided, evaluate the feasibility of the project under each scenario. What is the present value of the property, under each scenario, using a discounted cash flow analysis?...

The assignment is to reconstruction the proforma for this property to evaluate it with alternative investment assumptions Your Name: Unit Mix Summary Totals Units Type 7 3 10 1 bd/1 ba 2 bd/1 ba...

Create an operating proforma for 6 years, with the sale at the end of year 5. Calculate the offer price. Calculate the loan amount, annual debt service and loan balance end of year 5. Calculate the...

Which of the following are not the 6 key exceptions of supply O Closure of business Agriculture products Competition Rare goods All of the above None of the above

The purchase of new injection molding equipment (MACRS-GDS 3 year property) costs $125,000 and has a planned salvage value of $13,000 after a useful life of 4 years. The tool generates net revenue...

A market is efficient if all securities are priced at their true ( intrinsic ) value II . In efficlent markets, prices only change whon unexpeeted newn is releared III. Most investors, including...

1. Analyze and explain any one work negotiation situation experienced in project management operations for infrastructure projects, having any one or more of these characteristics: Power imbalance:...

Message Strategies: Responding to Rumors and Public Criticism [LO-7] The consumer reviews on Yelp can be a promotional boon to any local businessprovided the reviews are positive, of course. Negative...

Message Strategies: Responding to Rumors [LO-7] Sheila Elliot, a well-known actress, appeared on a national talk show last night and claimed your companys Smoothstone cookware was responsible for her...

I want to make one thing perfectly clear neither of you will be promoted if sales figures dont improve. Review Sections 2.4, 2.5, and 2.6 in the Handbook of Grammar, Mechanics, and Usage, and then...