Calculate the internal rate of return for the cash flows

Assignment Help Basic Computer Science
Reference no: EM131468681

Demonstrate your understanding of financial concepts by completing the following problems. Where appropriate, show or explain your work. You may use Excel to work on the problems.

Problem 1. Calculating net present value (NPV): Porter Incorporated has two exclusive projects, listed in the table below. Use the NPV rule to rank these two projects. If the appropriate discount rate is 13 percent, which project should be chosen?

Problem 1. Calculating NPV YearProject AProject B0-$12,700-$9,4001$7,000$4,8002$5,500$3,7503$2,500$3,400Problem 2. Calculating payback period: An investment project provides cash inflows of $920 per year for eight years. Calculate the project's payback period if the initial cost is each of the following:

  • $4,500.
  • $5,500.
  • $7,000.

Problem 3. Calculating internal rate of return (IRR) for cash flows: Calculate the internal rate of return for the cash flows of the two projects in the table below.

Problem 3. Calculating IRR for Cash Flows YearProject AProject B0-$4,600-$3,5001$1,400$1,2502$2,200$1,8003$2,700$1,600Problem

Problem 4. Calculating profitability index of a project: Jeff plans to open a small health club. The equipment will cost $225,000. Jeff expects that there will be after-tax cash inflows of $62,000 annually for seven years. The equipment will then be scrapped and the health club will close. At year-end of the first year, the first cash inflow occurs. The required return is 13 percent. What is the project's profitability index? Should it be accepted?

Problem 5. Calculating project NPV: Jenny's Creamery is considering the purchase of a $27,000 ice cream maker. The ice cream maker has an economic life of eight years. Using the straight-line method, it will be fully depreciated. The machine will produce 250,000 servings per year, with each costing $1.25 to make, and priced at $1.99. The discount rate is 12 percent. The tax rate is 35 percent. Should the company make the purchase? Provide a rationale using the calculations.

Reference no: EM131468681

Questions Cloud

What is the value of the investor position : The current forward price for delivery in one month is F= $1.5850 per USD. Suppose the one month rate of interest is 6%.
Identified significant staff attitude issued : Based on the past year patient grievances which identified significant staff attitude issued in the ED,
Describe process of initiating business continuity plan : Explain importance of Business Continuity Management and how it might be applied to university. Describe process of initiating a Business Continuity plan
What is an average inventory : How much does the hotel central kitchen to produce each time that would minimize the total inventory cost? What is an average inventory?
Calculate the internal rate of return for the cash flows : Calculating internal rate of return (IRR) for cash flows: Calculate the internal rate of return for the cash flows of the two projects in the table below.
Find about the efforts needed to initially design database : what effort is required to initially build (design, implement, and populate with data) in a database in your corporate.
Criteria firm should use to evaluate targets for acquisition : What do you think are the criteria a firm should use to evaluate targets for acquisition
Withdraw annually in equal beginning of year : How much could he withdraw annually in equal beginning of year amounts starting at the time he makes his last deposit and continuing for a total of 20 years
Running a series about the lack of input the community : Recently, the local newspaper has been running a series about the lack of input the community into the hospital.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Find the marginal cost

Business The controller for an electronics company has used the production figures for the last few months to determine that the function c(x) = -9x5 + 135x3 + 10,000 approximates the cost of producing x thousands of one of their products.

  Explain a business application or information system

Prepare a paper (1,200 - 1,400 words, APA format) in which you explain a business application or information system that you are familiar with that is critical to the business processes of your company (past or present employer). Write down it..

  Explain why this might be the case

If you believe a code of ethics impacts an IT professional's behaviour, explain what that impact is and why it occurs. If you do not believe a code of ethics impacts an IT professional's behaviour, explain why this might be the case.

  Great outside resources to learn programming

What is the best way to think "logically" when beginning programming, also, what are some great outside resources to learn programming on your own.

  Calculate the actual number of bytes

Although the total number of bytes varies from computer to computer, memory sizes of 65,536 to more than several million bytes are common.

  Compute and plot the 4-point dft

Using the fewest number of zeros possible, zero pad x[n] so that the DFT frequency resolution is at least Ω0 = 0.1. Compute and plot the corresponding DFT Xpad[k].

  Describe support and confidence

Describe the two main methods of representing market basket data. What are the benefits and drawbacks of each?

  Election-counting algorithm

Suppose further that a friend of yours is guessing that if the winning candidate gets more than 40% of the votes, then his or her name will be encoded with a single bit. Prove that this conjecture is true and analyze the running time of this elect..

  Calculate the average mpg for each vehicle

Calculate the average MPG for each vehicle. Enter a formula in cell C11 using the AVERAGE function to calculate the average value of C9:C10. Use only one argument.

  Discuss the impact of the roles on health care organization

Discuss the impact of the roles on the health care organizations. Create a diagram with the career choice as the focal point and identifying the work roles within one of the services or product you identify.

  Defeating physical security controls to bypass access

You might be wondering if physical security is really important in this digital age. After all, you have been studying how to protect IT assets via a keyboard, not by wearing a security officer's uniform and guarding the server room's door. Should..

  Sql dml for data modification in tables

Write SQL DML statements that will modify data from within a database. Using the Northwind database, write a SQL DML statement that will modify the data. Base it on the following requirements:

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