Please prepare an npv analysis of the rondo project

Assignment Help Finance Basics
Reference no: EM13833878

Activity 1. Memo from Bob:

I need to help our client, Rondo, make a decision on whether or not to go ahead with a project. I’d like you to do a net present value (NPV) analysis on this special production project. The project will require an initial investment in a piece of manufacturing equipment. The product will be sold exclusively to the client over the next three years.

Please prepare an NPV analysis of the Rondo project. I have compiled the following cost and sales estimates from engineering and marketing.

1.Project life is 3 years.

2.Initial investment is $7,550,000 for equipment invoice, transportation, and installation.

3.Worker training for operating new equipment is $18,000.

4.First-year sales are projected to be $4,500,000 escalated at 3.5% each year thereafter.

5.Operating overhead (excluding depreciation) is estimated at 27% of annual sales.

6.Administrative overhead is estimated at 35% of annual sales.

7.Depreciation is straight line, 5 years.

8.The tax rate is 40%.

9.The new equipment can be salvaged at the end of the project (end of YR 3) for $2,500,000.

10.Cost of capital is 10%.

You’ll need to create an Excel cash flow spreadsheet and calculate the NPV and IRR. Make your recommendation on the project.

A few observations:

1.  Please do not forget how to treat the depreciation: first as an item for the net income and then to add it back for the cash flows; and it is straight line depreciation.

2.  Worker training to be expensed in period 0.  But keep in mind that you would want to view it on an after tax basis.

3.  Please do not forget the terminal cash flow which depends on the salvage value and the remaining book value of the asset! 

Activity2: Calculation of the Outcomes of the Calls and Puts Held Long and Short

Bob needs your opinion. You receive a voice mail.

In order to make the decision on the best course of action, two tables of calculations are needed:

1.One table for calculations on:

 a.The possible outcomes of buying a call option for $2.10, exercise price $37.50

b.Possible price ranges for the underlying stock: 25 30 35 40 45 50 55 60 

2.A second table for calculations on:

 a.The possible outcomes of buying a put option for $1.65, exercise price $37.50

b.Possible price ranges for the underlying stock: 25 30 35 40 45 50 55 60 

Deliverables

1.A worksheet showing your calculations of the outcomes for the suggested stock price ranges for the call option buying strategy;

2.A worksheet showing your calculations of the outcomes for the suggested stock price ranges for the put option buying strategy.

Reference no: EM13833878

Questions Cloud

Discuss the various strategies of influence and persuasion : Discuss the various strategies of influence and persuasion that can be used to change people's beliefs and behaviours, using one of your own personal experiences as an example.
State the legal issue rule analysis of the rule to the facts : Claudia then disclaimed liability on the debt, asserting that she had not authorized her agent to enter into the loan agreement. Paul brought this action to collect on the loan. What is the decision? Please state the following: legal issue, legal rul..
Optimal bidding function : Problem: Consider a first-price auction with three bidders, whose valuations are independently drawn from a uniform distribution on the interval (0, 30). Thus, for each player i and any fixed number y ∈ (0, 30), y/30 is the probability that player..
Analyze a number of dga data from field transformers : In this assignment students will analyse a number of DGA data from field transformers. Different relevant standards and other internationally accepted methods can be used to predict incipient faults/conditions.
Please prepare an npv analysis of the rondo project : Please prepare an NPV analysis of the Rondo project. I have compiled the following cost and sales estimates from engineering and marketing. 1.Project life is 3 years. 2.Initial investment is $7,550,000 for equipment invoice, transportation, and insta..
Capital budgeting evaluation : Capital Budgeting Evaluation - 1.     How does a firm assess a new capital project? 2.     How would models of project evaluation such as NPV and IRR incorporate changes in economic outlook?
What can employers do in order to comply with the eeoc : What can employers do in order to comply with the EEOC requirements of reporting the race and sex of applicants? Collect the data after the hiring decision has been made. Gather the information on the application blank during the pre-screening proces..
Prepare a sequence diagram for booking confirmation use case : Prepare a sequence diagram for the booking confirmation use case. Must include a detailed description. Create a communication diagram for the booking confirmation use case.
Solve the dilemma using kants ethics : 1. Create a 2-4 paragraph "dilemma" similar to the other dilemmas you have been solving throughout this term. 2. Solve the dilemma using Kant's ethics (Categorical Imperative). 3. Solve the dilemma using any other method we have discussed to date (wi..

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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!

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