Draw cashflow diagram and calculate the irr for investment

Assignment Help Financial Management
Reference no: EM131448309

SFU Surrey is planning to expand the campus with a $90-million government investment for a fivestorey, 15,000-square-meter building. The announcement was made in Nov 2016 by Prime Minister Justin Trudeau, together with B.C.’s Premier Christy Clark and SFU President Andrew Petter. Now assuming the construction project takes three years to complete. Within the project cycle, a government financial agency loans the university with $30M at the beginning of each year. An initial cost of $60M is required to claim the land ownership. The labor and materials cost is a fixed amount of $1M per month, payable at the beginning of each month. Upon project completion and a year of grace period, the property assessment agency values the building worth of $120M. But now the university needs to pay back the government with 25M per year for four years.

a) From the government financial agency’s perspective, draw a cashflow diagram and calculate the IRR for this investment.

b) From the university’s perspective, calculate the IRR this project. (Hint: no need to consider government funds as parts of the cashflow)

After decades of operation, the university is having financial crisis and is looking to either sell or lease the building for cash. If you are a potential buyer and there are two options available: Buying the building right now will cost $200M. The other option is to lease the building, which is $10M payable at the beginning of each year. In either case, you must pay city taxes, maintenance, and utilities, which are $2M/year, payable at the end of the year. The building will be functional for 15 years. If you buy the building, you could then sell it, for an estimated $300M.

c) What rate of return will you receive by buying the office building instead of leasing it? Assuming your MARR is 10%, should you buy or lease the building? Why?

Reference no: EM131448309

Questions Cloud

Prepare loan amortization schedule : ICS plans on expanding their plant and will fund $2,000,000. Part of the funding will come from cash, but the balance of $775,000 will be financed. The interest rate will be 5% and ICS plans on borrowing the funds for 4 years. Prepare a loan amortiza..
What arbitrage opportunity does this create : 3-month LIBOR rates for Euro and USD are 4.75% and 5.70%, respectively, with continuous compounding. The current exchange rate between Euro and USD is 1.41 USD/EUR. The 3-month forward price for Euro quoted by a bank is 1.40 USD/EUR. What arbitrage o..
Three attributes of quality information in business message : What are the three attributes of quality information in a business message? Why are in-person conversations considered a rich medium? What is the difference between the topic of a message and its main idea?
In which year was the real price of televisions less : The average CPI for the year 1986 was 109.6. In 2006 the average CPI was 201.6. The average price of televisions in 1986 was $213.22. In 2006 the average price was $457.87. Convert the 1986 price to 2006 dollars. In which year was the real price of t..
Draw cashflow diagram and calculate the irr for investment : SFU Surrey is planning to expand the campus with a $90-million government investment for a fivestorey, 15,000-square-meter building. The announcement was made in Nov 2016 by Prime Minister Justin Trudeau, together with B.C.’s Premier Christy Clark an..
What is the company cost of equity under capm : WBC corporation has a stock market value of $1 billion. It has long term debt of $500 million outstanding at the borrowing cost of %7. It's stock has a beta of 1.2 and the market return is 10% with risk free rate at %4. Tax rate is 35%. What's the co..
Calculate present value of payments made under each schedule : Suppose a homeowner is offered a choice between two payment schedules on his mortgage. Schedule A has a fixed payment of $5000 per year, while Schedule B requires payment of $4000 for the first three years, after which it rises to $5500. Assume the m..
The present value of the new drug : You work for a pharmaceutical company that has developed a new drug. The patent on the drug will last 17 years. You expect that the drug's profits will be $4 million in its first year and that this amount will grow at a rate of 5% per year for the ne..
Calculate the npv of this investment : Archer Daniels Midland Company is considering buying a new farm that it plans to operate for 10 years. The farm will require an initial investment of $12 million. This investment will consist of $2 million for land and $9.60 million for trucks and ot..

Reviews

Write a Review

Financial Management Questions & Answers

  About purchasing an investment from hibond investing

Sarah is thinking about purchasing an investment from HiBond Investing. If she buys the investment, Sarah will receive $212 every three months for 8 years. The first $212 payment will be made as soon as she purchases the investment. If Sarah's requir..

  How big will the balloon payment be

You have just arranged for a $1,540,000 mortgage to finance the purchase of a large tract of land. The mortgage has an APR of 5.4 percent, and it calls for monthly payments over the next 22 years. However, the loan has an eight-year balloon payment, ..

  About the bond valuation

Callaghan Motors' bonds have 19 years remaining to maturity. Interest is paid annually, they have a $1,000 par value, the coupon interest rate is 6%, and the yield to maturity is 8%. What is the bond's current market price?

  What stock price is expected one year from now

Constant growth valuation Harrison Clothiers' stock currently sells for $36 a share. It just paid a dividend of $2.75 a share (that is, D0 = 2.75). The dividend is expected to grow at a constant rate of 6% a year. What stock price is expected 1 year ..

  The principal use of an article refers

The principal use of an article refers to: a. the purpose for which it is to be imported. b. the use that is greater than any other single use of the article. c. the use of the components once they are fully assembled. d. any one of the above.

  What is expected return on utes

You have $10,000 and you want to know if Utes,LLC is a good buy. The firm’s total risk is 15%, its systematic risk is 0.8, the t-bill rate is 1.2%, the 30 year treasury rate is 3.5%, and the average market return is 9.5%. According to the CAPM, what ..

  What is portfolio beta

You own a stock portfolio invested 30 percent in Stock Q, 35 percent in Stock R, 10 percent in Stock S, and 25 percent in Stock T. The betas for these four stocks are 1.4, .7, 1.5, and .8, respectively. What is the portfolio beta?

  Prepare journal entries to record redemption of old issue

On June 30, 2006, County Company issued 12% bonds with a par value of $826,900 due in 20 years. They were issued at 99 and were callable at 105 at any date after June 30, 2014. Prepare journal entries to record (1) the redemption of the old issue and..

  Draw a cash flow diagram and at an interest rate

Cummins crane corporation is considering replacing its controllers on its heavy lift cranes with new portable infrared controllers. 3C expects to achieve cost savings of 15k the second year, increasing by $1500 each year thereafter for the next 4 yea..

  Annual inflation rates have been forecast

The following annual inflation rates have been forecast for the next 5 years Year 1, 3% inflation, Year 2, 4% inflation, Year 3. 6% inflation, Year 4. 7%,year 5, 8 inflation Use the average annual inflation rate and 2 percent real rate to calculate t..

  Produce table and graph for the price per barrel airlines

Imagine that Segal Air entered into a forward contract (forward price of $105) for half of their 2017 fuel needs and bought calls (strike of $120 and premium of $10). Produce the table and graph for the price per barrel the airlines will pay as a fun..

  What is expected return on the portfolio

You own a portfolio that is 24 percent invested in Stock X, 39 percent in Stock Y, and 37 percent in Stock Z. The expected returns on these three stocks are 10 percent, 13 percent, and 15 percent, respectively. What is the expected return on the port..

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