Purchase Solution

Rykers: NPV & Inventory

Not what you're looking for?

Ask Custom Question

5.The following data have been collected by capital budgeting analysts at Rykers concerning an investment in an expansion of the company's product line. Analysts estimate that an investment of $210,000 will be required to initiate the project at the beginning of 2010. Estimated cash returns from the new product line are summarized in the following table; assume that the returns will be received in a lump sum at the end of
each year.
Amount of
Year Cash Return
2010 $90,000
2011 80,000
2012 70,000
2013 60,000

The new product line will also require an investment in working capital of $30,000; this investment will become available for other purposes at the end of the project. Salvage value of machinery and equipment at the end of the product line's life is expected to be $20,000. The cost of capital used in Rykers capital budgeting analysis is 10%.

Required:
A) Calculate the net present value of the proposed investment. Ignore income taxes.
B) Calculate the present value ratio of the investment.
C) Calculate the payback period of the investment.

6. Ping Rentals, Inc., has actual sales for July and August and forecasted sales for September, October, November, and December as follows:
Actual:
July 5,900 units
August 6,200 units
Forecast:
September 6,000 units
October 6,800 units
November 5,600 units
December 6,100 units

Additional Information:
The firm's policy is to have finished goods inventory on hand at the end of the month that is equal to 70 percent of the next month's sales. It is currently estimated that there will be 4,200 units on hand at the end of August.

Each unit of finished product requires 6.5 pounds of raw materials. The firm's policy is to have raw material inventory on hand at the end of each month that is equal to 60 percent of the next month's estimated usage. It is currently estimated that 26,000 pounds of raw materials will be on hand at the end of August.

Required:
A) Calculate the number of units to be produced in each of the months of September, October, and November.
B) Calculate the number of pounds of raw materials to be purchased in each of the months of September and October.

Purchase this Solution
Solution Summary

Your tutorial is in excel, attached. Click in cells to see computations. You can see how to compute NPV, PV ratio and payback with instructional notes. The process for budgeting production and materials is shown.

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

View More Free Quizzes
Related BrainMass Solutions

  • Net Present Value

    )5 NPV = - 75 + 181.82 + 165.28 + 150.26 + 204.90 + 186.27 NPV = - 75 + 888.53 NPV = 813.53 million This solution is comprised of a detailed explanation to answer what would be the estimated NPV (in millions of dollars) of the new

  • Cash conversion cycle, NPV for credit, Economic order quantity

    Average inventory level=100,000 4. Total annual inventory cost=$2*100,000+$100*100,000=$10,200,000 Cash conversion cycle, NPV for credit and economic order quantity is examined.

  • Capital Budgeting

    * Inventory cost savings of $60,000 per year, as the inventory software on the new system will help Global keep better track of inventory (levels) and allow Global to order inventory Just In Time basis.

  • Calculating Payback period and NPV

    factor for n=8 and rate=10%=52000*5.3349=277416 NPV=-142000+277416+10263=145679 c) NPV is a positive number, product should be accepted Solution describes the steps for calculating payback period and NPV for the given investment

  • NPV and IRR Sensitivity Analysis

    Additionally, it illustrates how to use Excel's NPV and IRR functions.

  • Calculating a Project's NPV

    152920 Calculating a Project's NPV A new, more efficient machine will last four years and allow inventory levels to decrease by $100,000 during its life.

  • Financial payback, NPV, IRR, MIRR

    $ 35,000 Installation $ 75,000 Rise in inventory $ 150,000 Rise in A/P from Inv

  • NPV - IRR

    567424 computing the net present value (NPV) Being taught how to compute the NPV and IRR with the following: initial investment outlay of $30 million, consisting of $25 million for equipment and $5 million for net working capital (NWC) (plastic substrate

  • Evaluate new product launch for manufacturing company: Cash flows, payback, NPV

    - Calculate the payback period (P/B) and the net present value (NPV) for the project. Answer the following questions based on your P/B and NPV calculations: - Do you think the project should be accepted? Why?

View More Related Solutions