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

  Financial information and works out the investment plan

Peter is interested in investing in Hong Kong and will set up a porfolio worth $100,000. He received the following financial information and works out the investment plan. ABC Company paid a dividend of $2.50 and announced that the next dividend woul..

  Suspended loss under the passive activity loss rules

Pamela earns a yearly salary of $150,000. During year 1 she invested $80,000 for a 20% interest in a passive activity. In addition, her share of the activity’s nonrecourse debt is $20,000. Operations of the activity in year 1 resulted in a loss of $5..

  Calculate the break even revenue for the firm

Calculate the break-even revenue for the firm above if the fixed cost stays the same at $5,700 but the variable cost increases to $2.65 per unit and the product is sold at $9.00 now.

  Uncertainty surrounding the cash flows of this project

Using the following assumptions, develop a budget in pesos and dollars for this project: Explain why there is uncertainty surrounding the cash flows of this project.

  Changes in growth and stock valuation

Changes in Growth and Stock Valuation Consider a firm that had been priced using a 6 percent growth rate and a 9 percent required rate. The firm recently paid a $.70 dividend. The firm has just announced that because of a new joint venture, it will l..

  Dividend is expected to grow-what is estimated stock price

Stock ABC just paid a $1 dividend yesterday. The dividend is expected to grow at a rate of 25% for the next 3 years when the required return is 15%. After that, from year 4 and thereafter (forever), the expected dividend growth rate will be 5% and th..

  Find the modified duration of each bond

Consider the following two bonds: A 10-year zero-coupon bond with Macaulay duration 10 and yield to maturity 4%. Find the modified duration of each bond. If market interest rates rise by 0.75%, find the percent change in the price of each bond. Expre..

  Chance to buy an annuity

You have a chance to buy an annuity that pays $28000 at the beginning of each year for 5 years. You could earn 4.5% on your money in other investments with equal risk. What is the most you should pay for the annuity?

  Securities will likely have the highest liquidity premium

Which of the following securities will likely have the highest liquidity premium ?

  What is the current price of the bonds

ABC Corporation issued 20-year, noncallable, 7.4% annual coupon bonds at their par value of $1,000 one year ago. Today, the market interest rate on these bonds is 6.5%. What is the current price of the bonds, given that they now have 19 years to matu..

  How is net present value profile used to compare projects

How is a net present value profile used to compare projects? What causes conflict in the ranking of projects via net present value and internal rate of return? Does the assumption concerning the reinvestment of intermediate cash inflows tend to favor..

  What is the net proceeds from the debt issue

A firm issues $200 million straight bonds at an original issue discount of 7.5% and a coupon rate of 7%. The firm pays fees of 2.5% on the face value of the bonds. What is the net proceeds from the debt issue?

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