Question

In: Finance

An investment opportunity having a market price of $1,000,000 is available. Your expectation includes these: first-year...

An investment opportunity having a market price of $1,000,000 is available. Your expectation includes these: first-year gross potential income of $300,000; vacancy and collection losses equal to 15 percent of gross potential income; operating expenses equal to 45 percent of effective gross income; and capital expenditures equal to 10 percent of effective gross income. You could obtain a $800,000, 30-year mortgage loan requiring equal monthly payments with interest at 7.5 percent. For the first year only, determine the: a. Net operating income (2.25 pts) b. Effective gross income multiplier (3.25 pts) c. Operating expense ratio (including CAPX) (3.25 pts) d. Monthly and annual payment (3.25 pts) e. Debt coverage ratio (3.25 pts) f. Debt yield ratio (3.25 pts) g. Overall capitalization rate (3.25 pts) h. Equity dividend rate (3.25 pts)

Solutions

Expert Solution

(a) Net operating income

Gross potential income for 1st year = $ 300000

Vacancy and collection losses = 15% of Gross potential income

                                                = 15% ($ 300000)

                                                = $ 45000

Effective gross income = Gross potential income – Vacancy and collection losses

                                    = $ 300000 - $ 45000

                                    = $ 255000

Operating expenses = 45% of effective gross income

                                    = 45% ($ 255000)

                                    = $ 114750

Net operating income = Effective gross income (Gross potential income – Vacancy and collection losses) – Operating expenses

                                    = $ 255000 - $ 114750

                                    = $ 140250

(b) Effective gross income multiplier

Effective gross income multiplier        = Sale price / Effective gross income

                                                            = $ 800000 / $ 255000

                                                            = 3.137254

(c) Operating expense ratio (including CAPX)

Operating expenses ratio       = Operating expenses (including CAPX) / Gross operating income

                                                = ($ 114750 + $ 25500) / $ 300000

                                                = 0.4675

(d) Monthly and annual payment

Loan amount = $ 800000

Interest rate = 7.5%

Monthly rate = 7.5/12 = 0.625% per month

Tenure = 30 years

EMI (Monthly payment) = {P*R*(1+R)^N} / {(1+R)^N-1}, where P=principal, R=rate of interest & N=tenure

            = $800000*0.625%*(1+0.625%)^30 / {(1+0.625%)^30-1}

            = $800000*0.625%*1.20552661024/ {(1.20552661024-1}

            = $ 29327.75

Annual payment = Monthly payment * 12

                                    = $29327.75 * 12

                                    = $ 351933

(e) Debt coverage ratio

Debt coverage ratio = Net operating income / debt service

                                    = $ 140250 / $ 800000

                                    = 0.1753

(f) Debt yield ratio

Debt yield ratio = Debt coverage ratio multiplied by 100%

                        = 17.53%

(g) Overall capitalisation rate = Net Operating Income / Investment value

                                                = $ 140250 / $ 1000000

                                                = 0.14025

(h) Equity dividend rate           = Equity Investment / cash flows before tax

      Cash flows before tax = Net operating income – (Annual payment for mortgage loan + Capital expenditures)

                                    = $ 140250 – ($ 351933 + $ 25500)

                                    = - 237183

Equity dividend rate = $ 100000 / - $ 237183

                                    = - 4.21


Related Solutions

A firm has the opportunity to make a capital investment with the expectation that the investment...
A firm has the opportunity to make a capital investment with the expectation that the investment will add economic value to the firm, increase customer satisfaction, and increase shareholder return. The investment is for a new supply chain inventory system, using state of the art 5G technologies and tracking capabilities. This system was recently developed and very few of your industry competitors are currently using it. To complete this case you will use Excel to format and solve a capital...
Use the following information to answer the remaining multiple-choice questions: An investment opportunity having a market...
Use the following information to answer the remaining multiple-choice questions: An investment opportunity having a market price of $2,000,000 is available. You could obtain a $1,400,000, 30-year fully amortizing mortgage loan requiring equal monthly payments with interest at 6.0 percent. The following operating results are expected during the first year. The effective gross income is $450,000 and the operating expenses and CAPX add up to $250,000 combined. 8. What is the gross income multiplier for year one? A. 4.00 B....
Nielson Motors is considering an opportunity that requires an investment of $1,000,000 today and will provide...
Nielson Motors is considering an opportunity that requires an investment of $1,000,000 today and will provide $250,000 one year from now, $450,000 two years from now, and $650,000 three years from now. If the appropriate interest rate is 10%, then the NPV of this opportunity is closest to: A. $350,000 B. -$88,000 C. $1,350,000 D. $88,000
You received an investment opportunity in real estate. The required investment amount is $1,000,000. Since you...
You received an investment opportunity in real estate. The required investment amount is $1,000,000. Since you do not have enough money, you are searched for partners. You found one friend who would like to enter the investment. Although she does not have the necessary funds today, she promises to transfer $400,000 in 4 years. Accordingly, you have decided to take two loans: 1) A 4-year bullet loan with an annual stated interest rate (APR) of 6.6% compounded monthly. The loan...
A company will invest with an initial investment of $1,000,000. Assuming a market interest rate of...
A company will invest with an initial investment of $1,000,000. Assuming a market interest rate of 5% and cash flow for 5 years is expected in the table below: Year Cash Flow 1 425,000 2 384,000 3 321,500 4 282,500 5 200,000 Calculate the PAYBACK PERIOD and NPV!
Evaluate a 4-year investment opportunity in a new ice-skating rink. The purchase price is $8.4M. Shipping...
Evaluate a 4-year investment opportunity in a new ice-skating rink. The purchase price is $8.4M. Shipping installation costs are $600K. The capitalized value of the asset (i.e., its beginning book value) will be depreciated down to an end-of-life book value of 0.5 M. The anticipated selling price of machine is 1M. The ice rink is expected to provide cash sales of $14.1M per year and will require cash expenditures of $9.3M each year. Also, at t=0, working capital will rise...
You are analyzing an investment opportunity for your firm. The investment will cost $10,000 to undertake...
You are analyzing an investment opportunity for your firm. The investment will cost $10,000 to undertake and will produce a cashflow of $2000 at the end of every year for the next 6 years. What is the internal rate of return? Select one: a. About 4% b. About 4.5% c. About 5% d. About 5.5% e. None of the above.
You want to have $1,000,000 in your retirement account 30 years from today. Your opportunity cost...
You want to have $1,000,000 in your retirement account 30 years from today. Your opportunity cost of capital is an APR of 7% with annual compounding. How much do you need to save each year if you limit yourself to 20 annual payments in years 11-30?
On the first day of the fiscal year, a company issues a $1,000,000, 10%, 5-year bond...
On the first day of the fiscal year, a company issues a $1,000,000, 10%, 5-year bond that pays semiannual interest of $50,000 ($1,000,000 × 10% × ½), receiving cash of $1,081,109. Journalize the bond issuance. If an amount box does not require an entry, leave it blank.
Two stocks, stock A and B, are available in the stock market. The price of the...
Two stocks, stock A and B, are available in the stock market. The price of the stock A today is $50. The price of stock A next year will be $40 if the economy is in a recession, $55 if the economy is normal, and $60 if the economy is expanding. The probabilities of recession, normal times, and expansion are 0.1, 0.8, and 0.1, respectively. Stock A pays no dividends and has a correlation of 0.8 with the market portfolio....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT