Residential economic irr calculations-sensitivity case

Assignment Help Financial Management
Reference no: EM131347249

Residential Economic IRR Calculations: Sensitivity Case (Leveraged)

Given:

A development of a track of homes is started during an economic slow period. The pessimistic estimate is that the project will take 18 months. The forecast development costs are: Month’s 1-6 at an expenditure rate of $900,000 per month, the expenditure rate for months 7-12 are $500,000 per month, and $250,000 for month’s 13-18. Homes will be sold beginning in the ninth month with forecast gross income for month’s 9-12 of $500,000 per month and for month’s 13-18 income of $2,000,000 per month. You borrow 80% of expenditures from the construction bank as a line of credit and pay interest only of 2% / month on the borrowed funds till the end of the project. At end of project you pay back the principal borrowed.

Determine:

a) Internal Rate of Return for the project

b) The simple payback period

c) NPV at 10% /yr. interest rate

d) Due to heavy sales promotion the income in Months 13-18 drops from $2,000,000 per month down to $1,500,000 per month.   Calculate the IRR and NPV @10 discount with the new cash flow.

Reference no: EM131347249

Questions Cloud

Bank expected liquidity deficit or surplus over next week : John Camey, the money manager of the First State Bank, has estimated that the bank has a 20 percent chance of a liquidity deficit of $700 million, a 30 percent chance of a liquidity deficit of $200 million, a 30 percent chance of a liquidity surplus ..
Use an annual cash flow analysis : When John purchased his home, he borrowed $200,000 from his bank at 6% interest rate per year to be repaid in 360 equal annual end-of-month payments in 30 years. The new loan would be made equal to the balance due on the old loan plus the $2,000 serv..
What is the bank total legal reserve requirement : The Shirley State Bank has $90 million in transaction deposits subject to legal reserves. The bank must hold 3 percent legal reserves up to $43.9 million of transaction deposits and 10 percent legal reserves on any amount above this. What is the bank..
What are the implications for macroeconomic policy : Write down the government budget constraint and explain how it can be used to understand the relationship between fiscal and monetary policies.
Residential economic irr calculations-sensitivity case : A development of a track of homes is started during an economic slow period. The pessimistic estimate is that the project will take 18 months. The forecast development costs are: Month’s 1-6 at an expenditure rate of $900,000 per month, the expenditu..
Analyze issues associated with strengthening the competency : Build on your previous discussion answer about change strategies and performance measures, and analyze issues and / or needs associated with strengthening the competency-base of employees in meeting the needs of globalization.Recommend at least tw..
Offset any fees charged by the federal reserve : A bank maintains an average clearing balance of $5,000,000 with the Federal Reserve. The Federal funds rate is currently 6.5 percent. What amount of credit will the bank earn over the reserve maintenance period that can be used to offset any fees cha..
What is the transfer-line manufacturing system : ETM 430:What is the transfer-line manufacturing system? What are its advantages? What are its disadvantages? What is the flexible manufacturing? What are its advantages? What are its disadvantages?What is the just-in-time manufacturing? How to achiev..
Discuss the role of either the cfo or controller : Discuss the role of either the CFO or controller within a small to mid-sized privately held company. What are their duties, responsibilities, and/or function within the firm?

Reviews

Write a Review

Financial Management Questions & Answers

  Compute the standard deviation

Lowe Technology Corp is evaluating the introduction of a new product. The possible levels of unit sales and probabilities of their occurrence are given. Compute the Standard Deviation

  Alternative should be accepted using present value analysis

An industrial firm can purchase a special machine for $20,000. A down payment of $2,000 is required and the balance can be paid in 5 equal year-end installments plus 7% interest on the unpaid balance. As an alternative the machine can be purchased fo..

  Pay the loan off by making your planned monthly payments

Your Christmas ski vacation was great, but it unfortunately ran a bit over budget. All is not lost: You just received an offer in the mail to transfer your $13,000 balance from your current credit card, which charges an annual rate of 20.8 percent, t..

  What is future value of the lump sum at the end of year 5

What is the future value of the lump sum at the end of year 5?- What is the future value of the mixed stream at the end of year 5?

  Bank offering certificates of deposit yielding

You are saving to buy a $182,000 house. There are two competing banks in your area, both offering certificates of deposit yielding 6.7 percent. How long will it take your initial $99,000 investment to reach the desired level at First Bank, which pays..

  What is the coupon rate of the bond

The bond pays annual coupons and the next coupon is due in one year. What is the coupon rate of the bond?

  Weighted average cost of capital

(Weighted average cost of capital) In the spring of last year, Tempe Steel learned that the firm would need to re-evaluate the company's weighted average cost of capital following a significant issue of debt. The firm now has financed 43 percent of i..

  What are bond equivalent and discount yields

The treasurer of a large corporation wants to invest $25 million in excess short-term cash in a particular money market investment. However, the treasurer wants to know the money market yield on this instrument to make it comparable to the T-bills an..

  The cost of debt capital to a business is measured

The cost of debt capital to a business is measured by

  The corporate bylaws are identical for all firms incorporate

The corporate bylaws are identical for all firms incorporated in a particular state. Corporate bylaws dictate a firm's behavior inside its home country and corporate charter outline rules for operating in foreign countries. For a manufacturing firm, ..

  Long-term net lease is expected

First-year NOI for a long-term net lease is expected to be $75,000. Rent is escalating at a rate of 4 percent per year, but there is a two-year period between adjustments. Thus, the income for years 1 and 2 will be $50,000, increasing to $50,000 (1+...

  Total real return on investment

You bought one of Great White Shark Repellant Co.’s 8.2 percent coupon bonds one year ago for $1,050. These bonds make annual payments and mature 13 years from now. Suppose you decide to sell your bonds today, when the required return on the bonds is..

Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd