Use the cash flows table and time value of money

Assignment Help Financial Management
Reference no: EM131055300

Option 1 utilizes 100% debt. The JSL group would take out a private loan in the amount of $35 million (or 48% of the total cost) at 6% interest. The city would back the remaining $37 million (that is, 52% of the total cost) by issuing bonds at 3.75% interest. This would be partially backed with general obligation bonds from San Marcos residents (which still requires voter approval), and partially with revenue from the facility itself. The annual debt payment on this form of financing (interest + principal) is $5,314,176.00.

Option 2 utilizes 60% city-backed debt at 4.25% interest. This would be paid back through a visitor tax increase on hotels and rental cars, as well as revenue from the facility itself. This tax increase does not require voter approval. The remaining 40% would be offered to preferred limited stockholders. This preferred stock would be offered at $45/share. The dividend expected would be $5 per share and the flotation cost is an inexpensive $1.50 per share. The annual debt payment on this form of financing (interest + principal) is $3,180, 526.00.

Option 3 utilizes a mix of private loans and public ownership of the facility. In this option, JSL owns 25% of the facility through a limited private stock offering to its internal partners. This would be offered at $43/share, with a $3 dividend and $2 flotation cost. Then, JSL finances an additional 30% through private bank loans (so that its total controlling share is 55%). These loans are issued at 6%. The final 45% of the facility will be offered as common stock to the residents of San Marcos, then surrounding communities. This stock will sell for $20/share with a $2 dividend, $2 flotation cost, and 1.5% growth rate. The annual debt payment on this form of financing (interest + principal) is $2,275,482.00.

Your Task After this initial leg-work, the task force has hired you as a consultant to help them make their final analysis and recommendations on the project. Your job is to utilize the revenue and cost to calculate the cash flows from the facility, calculate the WACC of the three project options, and then compute the returns (using NPV and IRR) of the three options. After a full analysis of the cash flows and the returns, you are to prepare a recommendation to the city and JSL concerning the best course of action for financing the new facility, from both political and financial perspectives. Note: you do not need to analyze whether or not the project is feasible, but only the best financing option given the projected cash flows from the project. Please follow the outline below in preparing your report:

1. Estimate the cash flows from the project over a 10 year project life. (Use the 7 year depreciation schedule attached with no depreciation in years 9, 10). You can use the template provided below. You will probably want to use a spreadsheet program (e.g., Microsoft Excel) as the numbers are rather large and unrounded.

2. Use the cash flows table and Time Value of Money Table D to calculate the IRR for the project over a 10 year time period.

3. Calculate the WACC for each of the financing options provided above.

4. Use the Time Value of Money Table B to calculate the NPV for each of the financing options. Use the WACC for each option as the discount rate for that option.

5. List 3 strengths and 3 weaknesses of each financing option—be sure to consider your ability to make your debt payments on top of existing operational costs (i.e., after you have your final cash flows for each year—could you make the debt payment for each option?).

6. Provide an overall recommendation to the city based on your analysis. Your recommendation should include both financial and socio-political considerations. Figure 1: Cash Flows Template Sales -Op expenses -Deprec = EBT -taxes =Net Income + Deprec =Cash Flow

Reference no: EM131055300

Questions Cloud

Do you think GFC could be repeated again : FIN200 Assignment - Discuss the possible causes of the financial crisis. Do you think GFC could be repeated again? Discuss.
Island off the coast of belize : The Great blue hole is a cylindrical trench located on lighthouse reef atoll, an island off the coast of belize. it is about 400 feet deep and holds about 2,349,911,302 gallons. how long will it take to swim across the great blue hole at a rate of..
Account with annual compounding and an apr : How much must be deposited today in the following account in order to have $35,000 in 5 years on a down payment for a house? An account with annual compounding and an APR of 6%
Research the possible ways of creating such a cctv system : MN603 Wireless Networks and Security Assignment. Research the possible ways of creating such a CCTV system for the above Case study to help Raju out. Which way would be the best possible approach. Justify your answer
Use the cash flows table and time value of money : Utilizes 100% debt. The JSL group would take out a private loan in the amount of $35 million (or 48% of the total cost) at 6% interest. The city would back the remaining $37 million (that is, 52% of the total cost) by issuing bonds at 3.75% interest...
Annual percentage yield is what percent : A bank offers an APR of 1.55% compounded monthly. What is the annual percentage yield is what percent?
Work design-communication-organizational structure : Organizational behavior - OB is defined as a study of individual behavior and group dynamics in the organization. b. Organization variables that affect human behavior are - Jobs, work design, communication, organizational structure and organizati..
Discuss aboriginal invlovment in sports : Discuss Aboriginal invlovment in Sports - The Black History of Australian Football, The International Journal of the History of Sport.
Hockey or a soccer program : A local high school offers a hockey or a soccer program for its Grade 12 students. There are 75 students enrolled in hockey and 60 students enrolled in soccer. However, there are only 100 students in Grade 12. Explain how this is possible.

Reviews

Write a Review

Financial Management Questions & Answers

  What was the rate of inflation

The April 21, 2015 University Press reported that faculty salaries rose an average of 3.1% in the past year, but after adjusting for inflation, there was actually an average decrease of 0.3%. What was the rate of inflation?

  What is the value for which share can be expected to trade

If the market requires a 12 percent rate of return on a stock of this risk and maturity, what is the maximum value for which this share can be expected to trade?

  How much should they be willing to pay for risk reduction

A firm has a WACC of 10% and $50,000,000 in assets. They feel that that they can reduce their WACC to 9% by doing a better job of managing risk. How much should they be willing to pay for risk reduction?

  The systematic risk associated with the returns

In February 2013 the risk-free rate was 4.37 percent, the market risk premium was 7 percent, and the beta for Dell stock was 1.56. What is the expected return that was consistent with the systematic risk associated with the returns on Dell stock? (

  Maturity quoted at discount yield

What is the price of a U.S. Treasury bill with 56 days to maturity quoted at a discount yield of 1.20 percent? Assume a $1 million face value. (Round your answer to 2 decimal places. Omit the "$" sign in your response.)

  Basic interest rate swap and futures positions

Suppose that you buy an interest rate cap on three month LIBOR with a two year maturity and simultaneously sell a floor on three month LIBOR with a two year maturity. Ignore the premiums. Draw a profit diagram that indicates when you will gain and lo..

  What is after-tax cost of capital for this debt financing

Great Seneca Inc. sells $100 million worth of 21-year to maturity 8.91% annual coupon bonds. The net proceeds (proceeds after flotation costs) are $988 for each $1,000 bond. The firm's marginal tax rate is 40%. What is the after-tax cost of capital f..

  Practical exercise stock analysisthe purpose of this

practical exercise stock analysisthe purpose of this project is to familiarize you with the stock market. using

  What is the estimate of the current stock price

Stock Y issued a dividend of $2.00 today which is expected to grow at 4% for the next 5 years and then grow at a constant rate of 2% after that. The required return is 10%. Using DDM what is the estimate of the current stock price?

  What is the firms net float

On an average day, Tennis R Us writes checks totaling $2,000. These checks take three days to clear. The company receives checks totaling $1,800. These checks take two days to clear. The cost of debt is 8%. What Is the firm's net float?

  Task is to analyze two mutually exclusive projects

Your task is to analyze two mutually exclusive projects: Using the payback criterion, which investment should you chose? Why? Using the discounted payback criterion, which investment should you chose? Why? Using the NPV criterion, which investment sh..

  Estimate the present value of the cash flows

XKL Co. plans a new project that will generate $ 187,000 of continuous cash flow each year for 8 years and additionally $108,000 at the end of the project. If the continuously compunded rate of interest is 4%, estimate the present value of the cas..

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