Question

In: Finance

The purchase price is $2,000,000 There are 30 units and the market rent is $850/month Market...

The purchase price is $2,000,000

There are 30 units and the market rent is $850/month

Market rents are expected to increase 4% per year

Vacancy and collection loss is 10%

Real Estate Taxes are expected to be $20,000 in year 1 and increase 5% per year

Insurance is expected to be $10,000 in year 1 and increase 7% per year

Utilities are expected to be 9% of EGI each year

Repairs and Maintenance costs are expected to be 7% of EGI each year

Grounds and Security costs are expected to by 6% of EGI each year

The market value of the investment is expected to increase 6% each year

Selling expenses will be 5%

The holding period is 5 years

80% of the purchase price can be borrowed on a 30-year, monthly payment mortgage

The annual interest rate on the loan will be 8%.

Loan origination fees will be 1% of the loan amount (paid in the year the loan is taken out - Year 0)

There are no prepayment penalties if you pay the loan early.

Tenant Improvements are expected to be $3,000/year

Leasing Commissions are expected to be $1,000/year

A roof repair totaling $15,000 will be completed in year 3

The required rate of return for the investor is 12%.  

Assume taxes are 30% of BTCF.

Assignment:

Fill out the income statement.

PGI (Potential Gross Income)
-VC (Vacancy/Collection Loss)
EGI (Effective Gross Income)
　 OE (Ope. Expenses)
　 Real Estate Tax
　 Insurance
　 Utilities
　 Repair & Maint
　 Grounds & Security
-OE (Total Ope. Expenses)
NOI (Net Operating Income)
　 DS (Debt Service)
　 Interest Payments
　 Principal Payments
-DS (Total Debt Service)
　 CAPX (Capital Exp.)
　 Tenant Improvements
　 Leasing Commissions
　 Roof Repair
-CAPX (Total Cap Exp.)
BTCF (Before Tax Cash Flow)
-TAX
ATCF (After Tax Cash Flow)

Calculate the monthly mortgage payment to find debt service.

What is the IRR and NPV of the property? (CF0 = equity investment + loan origination fees)

Calculate the ratios for one or five years as indicated on the worksheet

To find the mortgage balance, principal and interest payments:

Enter key strokes to find payment on the loan

Solutions

Expert Solution

jeff jeffy answered 7 months ago
Next > < Previous

Related Solutions

1. Graph the market for apartment units that has a binding price ceiling (rent control) and...
1. Graph the market for apartment units that has a binding price ceiling (rent control) and a consumer subsidy. 2. Graph the market for tobacco that has both a consumer tax, and a producer subsidy. For each, always indicate any surplus or shortage, and under- or over-allocation.
Price Market Quantity Demanded Social Quantity Demanded ($) (units per month) (units per month) 20 10...
Price Market Quantity Demanded Social Quantity Demanded ($) (units per month) (units per month) 20 10 20 18 20 30 16 30 40 14 40 50 12 50 60 10 60 70 b. Does this product have external benefits or external costs? External benefits c. How large ($) is that externality? ? per unit
Your firm currently sells 2000 units a month at a price of $30 a unit. You...
Your firm currently sells 2000 units a month at a price of $30 a unit. You think you can increase your sales by an additional 20 units if you switch to a net 30 credit policy. The monthly interest rate is 0.5 percent and your variable cost per unit is $18. What is the net present value of the proposed credit policy switch? What is the necessary increase in unit sales to breakeven?
You can afford a $850 per month mortgage payment. You've found a 30 year loan at...
You can afford a $850 per month mortgage payment. You've found a 30 year loan at 7% interest. a) How big of a loan can you afford? $ b) How much total money will you pay the loan company? $ c) How much of that money is interest? $
The following information for Dorado Corporation relates to the three-month period ending September 30. Units Price...
The following information for Dorado Corporation relates to the three-month period ending September 30. Units Price per Unit Sales 520,000 $ 55 Beginning inventory 54,000 37 Purchases 495,000 43 Ending inventory 29,000 ? Dorado expects to purchase 245,000 units of inventory in the fourth quarter of the current calendar year at a cost of $44 per unit, and to have on hand 83,000 units of inventory at year-end. Dorado uses the last-in, first-out (LIFO) method to account for inventory costs....
The following information for Dorado Corporation relates to the three-month period ending September 30. Units Price...
The following information for Dorado Corporation relates to the three-month period ending September 30. Units Price per Unit Sales 455,000 $ 42 Beginning inventory 41,000 24 Purchases 430,000 30 Ending inventory 16,000 ? Dorado expects to purchase 180,000 units of inventory in the fourth quarter of the current calendar year at a cost of $31 per unit, and to have on hand 57,000 units of inventory at year-end. Dorado uses the last-in, first-out (LIFO) method to account for inventory costs....
The market price is $850 for a 15-year bond ($1,000 face value)with a 6% annual...
The market price is $850 for a 15-year bond ($1,000 face value) with a 6% annual coupon rate. What is the bond's expected rate of return?
The market price is $850 for a 10​-year bond ($1,000 par​ value) that pays 9 percent...
The market price is $850 for a 10​-year bond ($1,000 par​ value) that pays 9 percent annual​ interest but makes interest payments on a semiannual basis (4.5 percent​ semiannually). What is the​ bond's yield to​ maturity? The​ bond's yield to maturity is ____​ (Round to two decimal​ places.) 2. (Bond valuation)​Fingen's 16​-year, $1,000 par value bonds pay 14 percent interest annually. The market price of the bonds is $870 and the​ market's required yield to maturity on a​ comparable-risk bond...
Beg Inventory 50 units at $5 each Purchase 10 units at $6 each Sale 30 units...
Beg Inventory 50 units at $5 each Purchase 10 units at $6 each Sale 30 units at $15 each Purchase 10 units at $7 each Sale 25 unites at $15 each a .)Find Cost of Goods Sold and Ending Inventory using the FIFO method B.)Find Cost of Goods Sold and Ending Inventory using the LIFO - Perpetual
Loanstar had 50 units in beginning inventory before starting 1,000 units and completing 850 units. The...
Loanstar had 50 units in beginning inventory before starting 1,000 units and completing 850 units. The beginning work in process inventory consisted of $3,000 in materials and $5,000 in conversion costs before $8,550 of materials and $12,670 of conversion costs were added during the month. The ending WIP inventory was 100% complete with regard to materials and 40% complete with regard to conversion costs. Use the above information to complete a production cost report. Enter all amount as positive values....
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT