other students are interested:
Assignment 2: Genesis Capital Plan Report
Assignment 2: Genesis Capital Plan Report
The Genesis 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:
Calculate the firm’s WACC.
Prepare and analyze each planned capital expenditure.
Evaluate, rank, and recommend the capital expenditures according to beneficial value to the organization, using 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.
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.
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.
Prepare an executive summary along with a separate document showing the calculations.
Following the example of the operations management team, do the following:
Download the Capital Budgeting spreadsheet, and compute the WACC for Genesis.
Using the information provided in the spreadsheet, analyze Genesis’s project options.
Using the information provided, calculate the periodic and cumulative net cash flows for each potential project and its associated options. Please note that there are 5 projects (facility, equipment pieces 1, 2, and 3, and internal inspection) and that each project offers multiple configuration options (facility size, equipment type, etc.).
Evaluate, rank, and recommend a specific option for each capital project according to beneficial value to the organization, using evaluation tools NPV, payback, and IRR.
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.
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).
Write a 5–6-page report in Word format. Apply APA standards to citation of sources
the file is attached
body preview (0 words)
file1.xlsx preview (529 words)
Sheet1
| xxxxxxx WACC | ||||||||||||
| xxxx | xxxxxx xxxxxx | x | xxxxxxxx | xWeighted | ||||||||
| Total | xxxx | Rate | ||||||||||
| xxxxxxxx xxxxxxx | * 300,000 | xxxxxx | 8% | |||||||||
| xxxxxxxxxx xxxx Payable | x xxxxxxx | 2.50% | xx | |||||||||
| xxxxx xxxxxxx xxxxxxxxxxx | x* 400,000 | xxx | ||||||||||
| xxxxxxxxx xxxx Payable | x xxxxxxx | xxxxxxx | xxx | |||||||||
| xxxxxxxx xxxxxxx | xx 1,200,000 | x30.00% | xxx | |||||||||
| xxxxx Liabilites | xx 1,600,000 | xx | ||||||||||
| Common xxxxx Equity | x* xxxxxxxxx | xxxxxxx | 10% | |||||||||
| Operating xxxxxx | * xxxxxxx | xxxxxx | 10% | 5.0% | ||||||||
| Total Liabilities and xxxxxx | x 4,000,000 | xxxxxxx | ||||||||||
| xx | ||||||||||||
| Genesis Captial Projects | payback | |||||||||||
| xxxxxxx xxxxxxxxxx | Cash xxxx | xCash Flow | Cash Flow | xxxx xxxx | Cash Flow | xxxxxxxxx | xxxxx Flow | xCash xxxx | xxxx xxxx | xxxxx xxxx | ||
| xx | xxx | xx | xxx | xY5 | xxx | Y7 | Y8 | xxx | xY10 | |||
| xxxxxxx A: 25-emp xxxxxxxx | xxxx | xxxx | x-300 | -400 | x200 | xxxx | x1000 | 1000 | x1000 | 1000 | 1000 | 7.33 |
| Project xx xxxxxx xxxxxxxx | 2500 | xxxx | x-200 | xxx | xxxx | xxxx | 1500 | 1500 | xxxx | xxxx | xxxxx | xxxxx |
| Project xx 75-emp facility | xxxxx | -300 | -400 | x-100 | xxx | x700 | 2000 | 2000 | x2000 | x2000 | x2000 | x7.25 |
| xxxxxxxxx 1 x xxxxx automatic | xxxxx | -100 | x100 | xxx | xxxx | 200 | xxxx | x800 | 800 | xxxx | x800 | xxx |
| xxxxxxxxx 1 - semi-automatic | xxxx | xxx | -100 | xxxx | x200 | 300 | xxxx | xxx | 600 | xxxx | xxxx | 6.75 |
| Equipment x - manual | xxxx | xxxx | x150 | xxx | xxxx | x150 | xxx | xxx | xxx | xxx | xxx | xx |
| xxxxxxxxx x - Standard | xxxx | -175 | 200 | xxxx | xxx | x300 | xxx | 700 | 700 | xxxx | x700 | xxx |
| xxxxxxxxx x x xxx of line | 1500 | xxxx | x275 | xxxx | xxxx | xxx | 1500 | xxxx | xxxx | xxxx | xxxx | 5.2 |
| Equipment 3 x xxxxx machine | x700 | x-200 | x-150 | xxxx | x300 | 350 | ||||||
| xxxxxxxxx 3 x 2-man machine | x600 | -175 | -100 | xxx | 175 | xxxx | ||||||
| Equipment x - 5-man xxxxxxx | x750 | x-300 | x-200 | xxx | xxxx | xxxx | ||||||
| In-house |
- - - more text follows - - -
file2.docx preview (1468 words)
xxxxxxxxx xxx firm’x WACC.
A xxxxxxxxxxx of x firm's cost of capital xx which xxxx xxxxxxxx of xxxxxxx xx xxxxxxxxxxxxxxx xxxxxxxxx All capital xxxxxxx - common stock, xxxxxxxxx stock, bonds xxx xxx xxxxx long-term xxxx - xxx included in a xxxx calculation.
xxxx xx xxx average of xxx costs xx xxxxx sources xx xxxxxxxxxx xxxx of which xx xxxxxxxx by its respective xxx xx the xxxxx xxxxxxxxxx By xxxxxx x xxxxxxxx average, we xxx xxx how xxxx xxxxxxxx xxx company xxx to pay for every xxxxxx xx finances. x firm's xxxx xx xxx overall required return on the firm xx a whole xxxx xx xxxxx xx xx xxxxx xxxx xxxxxxxxxx xx company directors xx xxxxxxxxx the xxxxxxxx feasibility xx expansionary opportunities and xxxxxxxx It xx the appropriate xxxxxxxx xxxx to xxx for cash xxxxx xxxx risk that xx xxxxxxx xx that of xxx xxxxxxx firm.
Where: Re = xxxx xx xxxxxx xx = cost of debt x = xxxxxx xxxxx xx the xxxxxx equity x x market value xx xxx xxxxxx debt V x x + D xxx x xxxxxxxxxx xx
- - - more text follows - - -
Buy this answer | Try it before you buy it |


