Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
The final will need you to create a spreadsheet /proforma of the cash flows from a property. All you have to do is input the cash flow on a monthly basis tenant by tenant and expense by expense.
This assignment is to create an analysis for determining a price for purchasing a property, by projecting rents, expense pass throughs, expenses, capital over a holding period through the sale. Below are is all the information that you need to do the calculations and determine the metrics behind the investment.
Market rent TBD Growth rate 2.5% for everything Rent Roll Tenant SF Rent/yr /sf Stop Start Month Term Steps Tenant A 25,000 26 $9.40 1 10 3% per year Tenant B 30,000 25.5 $8.50 1 8 32 in yr 5 Tenant C 35,000 20 Net 1 12 N/A Tenant D 10,000 market 10 market 10 36 in month 67 Total The tenant will pay for expenses that have risen to a level above their expense stop. Net leases have a stop of zero, so they pay all reimbursable expense. Tenants A and B are base year while tenant C is Net. Comparable leases have recently been signed as follows Tenant SF Rent/yr /sf Stop free rent Term Steps X 12,000 29.50 by 3 10 $0.60 Y 9,000 30.25 by 3 10 2% Z 5,000 32 by 2 5 3% Aa 35,000 25 by 6 10.5 1.5% Vacancy credit loss 10% Expense Category Expense per foot Taxes 5 R&M 1 Insurance 0.25 Utilities 2 Payroll 0.85 Security 0.5 G&A 0.4 Total Reimbursable 10 Non Reimbursable Management 3% of EGI Assume zero rollover possibility. Downtime (vacancy at end of lease) 6 months Total Capital at rollover 25/sf growing at inflation From the above information, you should be able to create a proforma. Reversion 0.075 Discount Rate 9.5% Term 5 years Amortization 30 Rate 0.04 LTV 70 Looking for you to provide underwriting metrics including but not limited to the following: Cash flow after debt Service Cash on Cash Return Debt service coverage Debt yield Cap rate Equity multiple (total cash return divided by investment) Break even ratio.
Suppose Fox Wood Corp. (FWC) has perpetual earnings before interest and taxes (EBIT) of $10 million per year. Fox Wood's unlevered cost of equity is 12%. FWC is subject to a corporate tax rate of 40%. It has $50 million in permanent debt in its capit..
The discount rate that makes the net present value of an investment exactly equal to zero is called the:
Justify the circumstances which are best suited for the dividend discount model versus the free cash flow model to value a firm.
Nigel received a Land Rover from his mother as a gift. Mom had purchased the Land Rover two years earlier for $65,000, but its fair market value at the date of the gift was only $50,000. No gift tax was paid by Mom at time of the gift.
What is the net interest income earned in dollars on this one-year transaction if the spot rate of U.S. dollars for Australian dollars
What is the value of a building that is expected to generate fixed annual cash flows of 115,800 dollars every year for a certain amount of time.
The E! Network just paid a dividend of $1.90 on each share of its stock. Calculate the Current Stock Price. Calculate the Stock Price in 3 Years
Starbucks orders fresh raw milk from a local farm every day. They buy each 1-gallon bottle of milk for $2 and sell it at their store for $4. If they are unable to sell the bottles by the end of the afternoon they sell the remainder to a nearby baker ..
A firm should set its growth target equal to its sustainable growth rate. The sustainable growth concept can highlight tensions associated with "competing" objectives within the firm. Generating a higher profit margin provides fuel for a higher susta..
If Tabor reduces its average collection period to 19 days, what will be its new level of accounts receivable?
Estimate? AMR's equity cost of capital. Estimate? AMR's share price.
The report should be well structured and include but is not limited to two key headings in relation to documentation compliance and customer/banker relationship
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd