Loan amortization schedule-cash flows of different options

Assignment Help Financial Management
Reference no: EM131188348

Q LTD is a telecommunication services provider looking to expand to a new territory Z; it is analyzing whether it should install its own telecom towers or lease them out from a prominent tower-sharing company T-share, Inc.

Leasing out 100 towers would involve payment of $500,000 per year for 5 years. A residual payment of $400,000 will secure ownership of the tower if Q LTD Decides to buy them at the end of the lease period.

Erecting 100 news towers would cost $2,000,000 including the cost of equipment and installation, etc. The company has to obtain a long-term secured loan of $2 million at 6% per annum.

Owning a tower has some associated maintenance costs such as security, power and fueling, which amounts to $1,000 per annum per tower.

The company’s tax rate is 45% while its long-term weighted average cost of debt is 6%. The tax laws allow straight-line depreciation for 5 years.

Make three options:

A. Purchase it with a bank loan

B. Using a Financial Lease where they would own the plant

C. Using an Operating Lease there they would not won the plant at the end.

Show following details:

1. Loan amortization schedule

2. Cash flows of three different options

3. Show the NPV profiles and show a sensitivity analysis of the outcomes of above analysis and discuss the feasibility of each financing options in different scenarios such as pessimistic, most-likely and optimistic, for variables such as cost of capital (the discount rate) and net operating cash flows.

Reference no: EM131188348

Questions Cloud

Use the present value formula : Think of something you want or need for which you currently do not have the funds. It could be a vehicle, boat, horse, jewelry, property, vacation, college fund, retirement money, etc. Select something which costs somewhere between $2,000 and $50,000..
Indicate whether variance is favourable or unfavourable : Winky Wink CC's standard and actual costs per pillow for December 20.16, during which 750 pillows were actually produced, From the foregoing information, compute the following variances. Indicate whether the variance is favourable (F) or unfavourable..
Liquidating dividend and the firm will cease to exist : DM Inc. is expected to pay dividends of $150 per share at the end of one year and $150 at the end of the second year. The dividend in the second year is a liquidating dividend and the firm will cease to exist. Investors require a 13% return on invest..
Discuss the deductibility-preparing partnership agreement : Discuss the deductibility or not of the following amounts: Interest paid in respect of an overdraft used to purchase additional equipment used in the business. $1,200 paid to lawyers for advising and preparing a partnership agreement. In a chart of a..
Loan amortization schedule-cash flows of different options : Q LTD is a telecommunication services provider looking to expand to a new territory Z; it is analyzing whether it should install its own telecom towers or lease them out from a prominent tower-sharing company T-share, Inc. Loan amortization schedule...
True of inventory level : Which of the following is true of inventory level?  A manufacturing manager would keep raw materials inventories low to ensure use of latest materials in production process.
What is the companys cost of equity : Chandeliers Corp. has no debt but can borrow at 6.3 percent. The firm’s WACC is currently 8.1 percent, and the tax rate is 35 percent. What is the company’s cost of equity? If the firm converts to 50 percent debt, what will its cost of equity be?
Required in order to meet the minimum profit goal : A private equity fund is considering investing in a company, which wants to produce a new product. The variable cost per unit is estimated at $9.51, the sales price would be set at $19.45, and fixed costs are estimated at $1202.28. The private equity..
Both stocks have equal reward-to-risk premiums : Stock A has a beta of 1.09 while Stock B has a beta of .76 and an expected return of 8.2 percent. What is the expected return on Stock A if the risk-free rate is 4.6 percent and both stocks have equal reward-to-risk premiums? 11.73 percent 8.07 perce..

Reviews

Write a Review

Financial Management Questions & Answers

  What is the financial breakeven point for each plan

There are two financing plans available to the Small/Downey Construction Company summarized herewith: Assuming a 40 percent tax rate, what is the financial breakeven point for each plan?

  Compensation plan does indeed affect behavior

You may deal with employees who work for various business and companies from time to time. Do you feel that an employee’s compensation plan affects how he or she behaves to one another and to his or her customers? Why or why not? If the compensation ..

  What is the future value-retirement goal is to accumulate

What is the future value of $4000 in 5 years if it is invested at an interest rate of 6.00%? Suppose your retirement goal is to accumulate $400 in 2.5 years. How much do you need to deposit in the bank today to meet your goal if the bank offers an in..

  Compute the internal rate of return on both projects

Compute the internal rate of return on both projects. Compute the profitability index of both projects. Compute the payback period on both projects.

  Volatility of the exchange rate is quoted

An exchange rate is currently 0.8000. The volatility of the exchange rate is quoted as 12% and interest rates in the two countries are the same. Using the lognormal assumption, estimate the probability that the exchange rate in 3 months will be a) Le..

  What is maximum price-you should be willing to pay for bond

Assume that you wish to purchase a 15-year bond that has a maturity value of $1,000 and a coupon interest rate of 11%, paid semiannually. If you require a 6.5% rate of return on this investment (YTM), what is the maximum price that you should be will..

  What is the required return on the companys stock

Bruer, Inc., is expected to maintain a constant 6.05 percent growth rate in its dividends, indefinitely. If the company has a dividend yield of 4.55 percent, what is the required return on the company’s stock?

  Approximate real rate of return on this investment

Last year, you purchased a stock at a price of $53 a share. Over the course of the year, you received $2 in dividends and inflation averaged 2.8 percent. Today, you sold your shares for $53.9 a share. What is your approximate real rate of return on t..

  Determine the coupon rate of bond

Dave needs to pay $1000 at the end of each year for the next 3 years. He purchased 3 different annual coupon bonds to match the liabilities exactly. The bonds have the following properties: Determine the coupon rate of Bond B to match the cash flows ..

  Complete the financial reporting for each period and

complete the financial reporting for each period and develop recommendations using the templates provided. procedure1.

  Deposit products use different compounding frequencies

Loan/deposit products use different compounding frequencies. For example, mortgage, CDs use monthly compounding. Credit cards use daily compounding, even though customers pay interest on a monthly basis. Bonds use quarterly, semiannual or annual comp..

  Starting to save money-expected to earn an annual return

Bob is 20 years old today and is starting to save money, so that he can get his MBA. He is interested in a 1-year MBA program. Tuition and expenses are currently $20,000 per year, and they are expected to increase by 5% per year. Bob plans to begin h..

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