Create spreadsheet that calculates all relevant cash flows

Assignment Help Financial Management

Reference no: EM131998172

Mel & Bud, Inc., is a printing company specializing in the production of coffee bags and frozen food bags. The company’s board has asked you to complete an analysis for their intended expansion into a new production space; a large mill building in close proximity to the current location will be refurbished to accomplish this task. The executive team has provided some information regarding the project, which follows.

About the Machine

The following are base assumptions regarding the equipment. Note that the cost of the building lease is included in the Cost of Goods Sold as indicated. Initial investment outlay is $70 million, with $50 million for machinery and $20 for net working capital (inventory). Life of the equipment is 5 years; the increase in annual revenues is $60 million annually. The company’s gross margin is 60% (excluding depreciation). Use straight line depreciation to calculate the cash flows. Selling, general, and administrative expenses are 3% of sales. The company’s tax rate was negotiated at 30% for the new operations.

Weighted Average Cost of Capital

Weighted average cost of capital is based on the following fact pattern. Capital structure of 40% debt and 60% common equity, there is a 30% tax rate. The cost of debt is 8%, while the company beta is 1.1. In addition, the risk free rate is 1%, and the market return is 11%.

1. Using Excel, create a spreadsheet that calculates all relevant cash flows (i.e., initial investment, periodic cash flows, and terminal value). Round all numbers to the nearest dollar.

Reference no: EM131998172

Questions Cloud

What is the credit spread on the BBB bonds : What is the price? (expressed as a percentage of the face value) of the treasury bond? What is the credit spread on the BBB bonds?

Create the by-laws for your organization : Develop the Articles of Incorporation, create the By-Laws for your organization (see Chapter 6), and include the forms and your instructions for filing.

Any other solar powered vehicle on the market : Juan Jones Engineering (JJE) has developed a solar powered vehicle that has a driving range of 200% more than any other solar powered vehicle on the market.

Receiving the proceeds from liquidation : In the event of bankruptcy, which of these financial instruments comes last in receiving the proceeds from liquidation?

Create spreadsheet that calculates all relevant cash flows : create a spreadsheet that calculates all relevant cash flows.

Which is more meaningful measure of profitability for firm : Which is a more meaningful measure of profitability for a firm, return on assets or return on equity? Why?

What are the implications of placing marketing specialists : What are the implications of placing marketing specialists in a market place without training on local customs and cultures?

Discuss the weaknesses of the compensation method : Write a 1-page report of your findings. Specifically, address strengths and weaknesses of this compensation method, both from the point of view.

Efficiency of the water delivery system in the region : The project is intended to improve water quality and increase the efficiency of the water delivery system in the region.

User Account

All Pages