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

  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