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

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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