Prepare spreadsheet calculation of the net present value

Assignment Help Financial Management

Reference no: EM131617362

EXPANSION PROJECT – RICH INDUSTRIES

Your client, Rich Industries, is considering an expansion of its plant facilities to increase its capacity for a new product line. This new product is expected to have a 5-year life cycle. The company has provided the following information for your analysis.

Capital Costs:

Cost of New Building $ 15,000

Cost of Equipment $ 5,000

Equipment Installation Cost $ 3,000

Net Working Capital Requirements (Upfront) $ 2,000

Sales and Expenses:

New Product Annual Sales $ 30,000

Variable Cost Ratio 75%

Fixed Costs (Annual) $ 500

Tax Rate 40%

Depreciation (use Straight-line depreciation):

Building 20 year expected Life

Equipment 5 year expected life

Salvage Value in Year 5:

Building $ 12,000

Equipment $ 1,000

The controller has told you that Rich Industries uses a 10% hurdle rate for discounting future cash flows.

Your Job: Prepare a spreadsheet calculation of the Net Present Value and Internal Rate of Return for the expansion project under consideration, including supporting information for your work. Answer this question: should the expansion project be undertaken? Why or why not?

Reference no: EM131617362

Questions Cloud

Determine the forced motion velocity : Consider a 5-m-long vertical plate at 60°C in water at 25°C. Determine the forced motion velocity above which natural convection heat transfer.

Determine the u-factor for the center-of-glass section : Determine the U-factor for the center-of-glass section of a double-pane window with a 13-mm air space for winter design conditions.

Why database system is a critical component of business is : Why database system is a critical component of business information systems? Why IT department of a company needs to backup databases regularly?

What will u-factor be when wind velocity outside is doubled : The overall U-factor of a fixed wood-framed window with double glazing is given by the manufacturer to be U = 2.76 W/m2.K under the conditions of still air.

Prepare spreadsheet calculation of the net present value : Prepare a spreadsheet calculation of the Net Present Value and Internal Rate of Return for the expansion project under consideration

What are the common misconceptions about research : Provide a real life example of each of the misconceptions and explain what you plan to do to make sure others don't hold onto that misconception.

Creates a system in which poor teachers cannot be replaced : Challengers of tenure argue that it creates a system in which poor teachers cannot be replaced and the schools retain complacent teachers.

How much money the new windows will save the home : The owner of an older house in Wichita, Kansas, is considering replacing the existing double-door type wood framed single-pane windows with vinyl-framed.

Carl jung theory of personality type : This module discusses the Myers-Briggs personality test, based on Carl Jung's theory of personality type, and its usefulness as a tool to help a work.

User Account

All Pages