Provide summary of your findings and the results of the npv

Assignment Help Accounting Basics

Reference no: EM131460244

Assignment: Financial Expansion Analysis

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%.

Requirements of the Assignment

1. (Due Module 5) Using Excel, create a spreadsheet that calculates all relevant cash flows (i.e., initial investment, periodic cash flows, and terminal value). Note: The spreadsheet should have data at the top and the cash flow calculations completely in equations, or picking up numbers from a previous cell. The instructor should be able to change inputs. The spreadsheet automatically adjusts to those changes. Round all numbers to the nearest dollar.

Submit the spreadsheet by Sunday of Week 5 so the instructor can review your work and provide suggestions for improvement. No points will be assigned for this, but points will be deducted from your final grade on the Portfolio Project if you fail to submit this assignment by the end of Week 5. Additionally, work received later than Week 6 of the course will not receive feedback prior to the final grading of the Portfolio Project.

2. Compute the weighted-average cost of capital (WACC) for the chosen firm on your spreadsheet. Take this number out to the nearest hundredth of a percent (e.g., 33.33%). There is no preferred stock in the company. Determine the weight of debt and common equity by the current market value.

Complete Requirement 2 and submit your work by Sunday of this week so your professor can review and provide suggestions for improvement. No points will be assigned for this, but points will be deducted from your final grade on the Portfolio Project if you fail to submit this assignment by the end of Week 6. Additionally, work received later than Week 7 of the course will not receive feedback prior to the final grading of the Portfolio Project.

3. Using Excel equations, compute the NPV and IRR.

4. There is a possibility that the cash flows from revenues will decrease by 50% if the demand for coffee bags decreases in favor of single serve coffee cups. Likewise, the net working capital will be cut by 50%. Given this assumption, recalculate the NPV and IRR for this scenario. Would you advise Mel & Bud to engage in this project if this was the reality of the marketplace competitive environment? Your answer should address the change in NPV and IRR versus the original scenario.

5. Provide a 250-500 word summary of your findings, the results of the NPV and IRR calculations, and indicate whether you would advise Mel & Bud to engage in this project.

Your paper must meet the following requirements:

• Be sure to follow the CSU-Global Guide to Writing and APA. Each paper should include an introduction, a body with at least two fully developed paragraphs, and a conclusion.

• Your paper must be clearly and well written using excellent grammar and style techniques. If you need assistance with your writing style, start with Tools for Effective Writing at the CSU-Global Library, accessible from the Library's homepage.

Refer to the Portfolio Project grading rubric available in the Module 8 Folder for information on grading details.

Reference no: EM131460244

Questions Cloud

What percent of the homes in the us were foreclosed : A recent study challenges the media narrative that foreclosures are dangerously widespread (N e w York Times, March 2 , 2009).

Five years of on ordinary annuity cash flow : What is the future value in five years of on ordinary annuity cash flow of $2134 every quarter of the year at the end of the period, add on annual interest rate

What is the probability that a patient did not have surgery : According to results from the Spine Patient Outcomes Research Trial, or SPORT, surgery for a painful, common back condition resulted in significantly reduced.

What is the real rate of return for a t bill : Assume that the inflation rate during the last year was 1.53%. US government T-bills had the nominal rate of return of 4.19%.

Provide summary of your findings and the results of the npv : Provide a summary of your findings, the results of the NPV and IRR calculations, and indicate whether you would advise Mel & Bud to engage in this project.

Calculate the effective annual rate : Calculate the effective annual rate, or EAR (annual percentage yield).

Targeted capital structure : Wilson Corporation (not real) has a targeted capital structure of 40% long term debt and 60% common stock. The debt is yielding 6% and the corporate tax rate.

What price would an investor be expected to pay : What price would an investor be expected to pay per share ten years in the? future?

Explain why events a and b are not exhaustive : You apply for a position at two firms. Let event A represent the outcome of getting an offer from the first firm and event B represent the outcome.

User Account

All Pages