User Account

All Pages

Calculate the cash flows

Assignment Help Finance Basics
Reference no: EM13849112

Felicia & Fred's executive board have asked you to complete a decision model for their intended refurbishment of the former mill building. In order to make an appropriate decision, the executive team has provided you with the following information regarding WACC and cash flows. It is your job to calculate the decision rules for NPV and IRR given the information provided.

Requirements:

1. Determine the target weighted average cost of capital for Felicia & Fred, given following assumptions:

Weights of 30% debt and 70% common equity (no preferred equity)

A 35% tax rate

The cost of debt is 9%

The beta of the company is 1.2

The risk free rate is 2%

The return on the market is 12%

Use the CAPM for calculation of the cost of equity.

2. Calculate the cash flows of the project given the following assumptions:

Initial investment outlay of $60 million, comprised of $50 million for machinery with $10 million for net working capital (metal and gemstone inventory)

Project and equipment life is five years

Revenues are expected to increase $50 million annually

Gross margin percentage is 60% (not including depreciation)

Depreciation is computed at the straight line rate for tax purposes

Selling, general, and administrative expenses are 5% of sales

Tax rate is 30%, a reduced rate that reflects a tax credit due to the repurpose of the building

Compute net present value and internal rate of return of the project. You may use Excel to complete this project. The text has a number of resources that provide examples of spreadsheet solutions for this purpose. Model your responses according to these examples.
Also, provide a 250-500 word executive summary on the results of the decision rule. Would you recommend that Felicia & Fred move forward with this project based on the NPV and IRR rules and outcomes? Why or why not? Consider any qualitative aspects of the decision as well. Provide a response with quantitative details which will be presented for consideration at the next executive board meeting.

For additional details, please refer to the Short Paper/Case Study Rubric document in the Assignment Guidelines and Rubrics section of

the course.

Reference no: EM13849112

Questions Cloud

Government bond with corporate bond of the same maturity : Compare the YTM of a U.S. government bond with a corporate bond of the same maturity. Is there a difference? Why? Please cite outside source if one is used.
What kind of distribution strategy a company : Making recommendations for various situations as to what kind of distribution strategy a company should take. For each of the situations below, consider the pros and cons of each type of distribution strategy. Richardson and Gosnay (2010) and Paley (..
Expansion project-requires initial fixed asset investment : Summer Tyme, Inc., is considering a new 3-year expansion project that requires an initial fixed asset investment of $5.886 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a ma..
Write a report with the title managing across cultures : Write a Report with the title: Managing Across Cultures. The report should around 1,500 words long and you must use Peter's Links for your source (referencing) material. Open Peter's Links and skim read through all the links.
Calculate the cash flows : Calculate the cash flows
Name at least 8 factors to consider in meal : 1.  Name at least 8 factors to consider in meal or menu planning. 2.  Why is the menu writing sequence different from the serving sequence.
How does light intensity effect oxygen production : how does light intensity effect oxygen production?
Management of technological risk : Management of Technological Risk
How many leaves does the tree have : Label and find the number of edges, degrees and vertex in the above digraph and find the corresponding matrix of the digraph above - How many leaves does the tree have?

Reviews

Write a Review

Finance Basics Questions & Answers

  Maximize the market value of the stock

XYZ Company has earnings of $750,000 with 300,000 shares outstanding. Its P/E ratio is sixteen. The company is holding $400,000 of funds to invest or pay out in dividends.

  Calculate the dollar cost of using a money market hedge

Suppose the firm has no excess cash. Assume the spot rate of the pound is $2.02, the 180-day forward rate is $2.00. The British interest rate is 5 percent,

  Would you describe such an acquisition market as efficient

Suppose that stock prices of target firms in acquisitions responded to acquisition announcements over a three day period rather than almost instantly.

  Calculate value of beta

Alpha Corporation and Beta Corporation are identical in every way except their capital structures. Alpha Company, an all-equity firm, has 5,000 shares of stock outstanding, currently worth $20 per share.

  What is scientific software effective annual rate

What is Scientific Software's effective annual rate of interest if it borrows $100,000 for 12 months? For 6 months? For 3 months? (Note: Assume a 365- day year and a prime rate that remains at 8.5% during the life of the loan.)

  Estimating two possible stock prices at the end of period

Consider a stock worth $25 that can go up or down by 15% per period. The risk-free rate is 10%. Use one binomial period to.

  You are planning to save for retirement over the next 30

you are planning to save for retirement over the next 30 years. to do this you will invest 800 a month in a stock

  What is the maturity risk premium for the 2-year security

The real risk-free rate is 3%, and inflation is expected to be 3% for the next 2 years. A 2-year Treasury security yields 8.4%. What is the maturity risk premium for the 2-year security?

  What annual rate of return is earned on a 5000 investment

what annual rate of return is earned on a 5000 investment when it grows to 9500 in five years? recalculate the rate of

  Calculate the cash providedused for each cash flow category

walters inc. began operations on january 1 2009. the following information relates to walters cash flows during

  Norwood corp currently has accounts receivable of 1223675

norwood corp. currently has accounts receivable of 1223675 on net sales of 6216900. what are its accounts receivable

  Diagram the cash flows for the project using a time line

Diagram the cash flows for the project using a time line. For each of Years 1 through 5, include the following data on your diagram (in this order) : EBIT, tax, depreciation, Operating Cash Flow (OCF), and discounted OCF.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd