Assignment 2: Required Assignment 2—Genesis Energy Capital Plan Report

The Genesis Energy operations management team, nearing completion of its agreement with Sensible Essentials, was asked by senior management to present a capital plan for the operating expansion. The capital plan was not to be a wish list but an analysis of the necessary expenditures to successfully establish a fully equipped operating facility overseas.

In addition, senior management requested meaningful financial and operating metrics to ensure that the performance objectives for the facility were being met. The operations management team was given five days to accomplish the following:

1. Calculate the firm’s WACC.
2. Prepare and analyze each planned capital expenditure.
3. Evaluate, rank, and recommend the capital expenditures according to beneficial value to the organization, using the evaluation tools NPV, payback, and IRR. Evaluation, ranking, and recommendations should be by category of expenditures. For example, facility, equipment 1, 2, and 3, and inspection.
4. Using the selected choices in part three, calculate the full cost of establishing a fully equipped facility. This would include the facility, equipment 1, 2, and 3, and inspection. In addition, calculate the payback, NPV, and IRR for the completed facility.
5. Construct and recommend between three and five metrics to measure the performance of the organization. At least one metric should be dividend decision-making driven.
6. Prepare an executive summary along with a separate document showing the calculations.

Part I

Following the example of the operations management team, do the following:

1. Download the Capital Budgeting spreadsheet, and compute the WACC for Genesis Energy.
2. Using the information provided in the spreadsheet, analyze Genesis Energy’s project options. Then, calculate the periodic and cumulative net cash flows for each potential project and its associated options. Please note that there are five projects (facility, equipment pieces 1, 2, and 3, and internal inspection), and that each project offers multiple-configuration options (facility size, equipment type, etc.).
3. Evaluate, rank, and recommend a specific option for each capital project according to beneficial value to the organization, using the evaluation tools NPV, payback, and IRR.
4. Construct and recommend between three and five metrics to measure the performance of the new operating strategy. At least one metric should reflect dividend policy as it relates to rewarding shareholders.
5. Prepare an executive summary describing your recommendations for each project and the overall cost, net cash flows, and expected returns of the operating configuration that you recommend. Be sure to justify your recommendations in terms of the investment criteria applied in Step 3 above. Be sure to report the full cost of the facility as it is configured per your recommendations. Present and justify your operating strategy performance metrics.

Your complete report should include all of your calculations as appendices (5 pages, or 1 page for each project).

Part II—Executive Summary Presentation

Because of limited resources in an era of plentiful opportunities, companies must carefully select investments. You analyzed Genesis Energy’s expansion plans and explained your findings in M4: Assignment 1.

This assignment is based on those findings. In this assignment, you will create a PowerPoint presentation that will include the following information:

• An executive summary of your findings from M4: Assignment 1. Be sure to adhere to the following:

  The presentation should be approximately 6–8 minutes (or 10–12 slides).
  A statement of the problem or topic is included.
  A concise analysis of the findings is included.
  Specific details from M4: Assignment 1 to highlight or support the summary are incorporated.

Develop a 10–12-slide presentation in PowerPoint format. Apply APA standards to citation of sources. Use the following file naming convention: LastnameFirstInitial_M5_A2.ppt.

By the due date assigned, deliver your assignment to the Submissions Area.

Assignment 2 Grading Criteria Maximum PointsComputed the WACC for Genesis Energy.32Calculated the periodic and cumulative net cash flows for each of the five potential projects and their associated options.32Evaluated, ranked, and recommended a specific option for each capital project according to beneficial value to the organization using evaluation tools NPV, payback, and IRR.72Constructed and recommended 3–5 metrics to measure the performance of the organization (At least one metric should be dividend decision-making driven.).60Prepared an executive summary describing your project recommendations and the full cost of the new facility.76Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources; displayed accurate spelling, grammar, and punctuation.28Total:300

Attachments

ASSIGNMENT 2-EXCEL.xlsx(15.74 KB)

Running Head: MANAGING FINANCE

1

MANAGING FINANCE

2

Managing Finance

Student’s Name

University Affiliation

Cost of capital is defined as the cost of the fund that a business has from the different sources that is the debt and the equity financing. The cost of capital is calculated as the weighted average cost of capital because most businesses find it very hard to rely on one source of financing (Armitage, 2005). The formula is total equity as a percentage of the total capital times the cost of equity plus total debt as a percentage of the total capital times the cost of debt. For example, if equity is 30% of capital and cost of equity is 10%, while debt is 70% of capital and the cost of debt is 20%. Cost of capital is calculated as:

(30*10)+ (70*20)/100= 17%

This means that the cost of capital is 17% of the total capital invested.

Different businesses have different needs, and this is still the case when it comes to business financing. It is crucial for a company to understand the costs and risks associated with external financing to ensure that the best option among the available ones is taken by the business need.

Most small business owners desire to move at a very orderly growth rate, but different factors in the business world can cause very rapid growth which can affect business operations and turn a company bankrupt (Viguerie, Smit & Baghai, 2008). It is important to have a rapid growth plan to ensure that in such cases, which are sometimes not foreseen, a business can manage itself effectively. Other than the two options that are debt and equity financing there is no other way of funding an organization striking a balance between these two has proven to be very effective over all the years.

References

Armitage, S. (2005). The cost of capital: intermediate theory. New York: Cambridge University Press.

Viguerie, P., Smit, S. & Baghai, M. (2008). The granularity of growth: how to identify the sources of growth and drive enduring company performance. Hoboken, N.J: John Wiley & Sons.

Sheet1

Energy WACC

Rate

,000

,000

,000

400,000

,000

,000

,000

500,000

Cash Flow Cash Flow

Cash Flow

200 400

0

-200 -200 100 400 400

0

-300 -400

600

2000

-100 100 200 400 200

1000

-100 200 200 300 600

150 150 150 150 150 750

800

200 250 250 300 700

1500 -100

325 325 1500

700 -200

250 300

600 -175 -100 175 175 175

750 -300 -200 300 400 400

100 500 500 300 300 800

200 200 200 100 100

													Genesis
Item	Amount ($000)	%	Interest	Weighted
Total		Rate
Accounts Payable							300	7.50%
Short-term Note Payable						100	2.50%
Total Current Liabilities								400
Long-term Note Payable	10.00%
Mortgage Payable	1,									200	30.00%
Total Liabilites	1,			600
Common Stock Equity	1,			500	37.50%
Operating Equity	12.50%
Total Liabilities and Equity	4,000,000	100.00%
Genesis Energy Captial Projects
Initial Investment				Cash Flow	Cash flow	Cashflow
Y1	Y2	Y3	Y4	Y5	Y6-10
Project A: 25-emp facility		2000					-200			-300		-400		1000
Project B: 40-emp facility				250							150
Project C: 75-emp facility	3000					-100			700
Equipment 1 – fully automatic		1500			800
Equipment 1 – semi-automatic	-50
Equipment 1 – manual			750
Equipment 2 – Standard		–			175
Equipment 2 – top of line	275			325
Equipment 3 – 3-man machine	-150	350
Equipment 3 – 2-man machine
Equipment 3 – 5-man machine
In-house inspection	1800
Contract inspection