Martinakom

Not Rated (0)

$12/per page/Negotiable

About Martinakom

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Architecture and Design,Biology,Business & Finance,Calculus,Chemistry,Computer Science,Geology Hide all
Teaching Since: Jul 2017
Last Sign in: 399 Weeks Ago, 1 Day Ago
Questions Answered: 5023
Tutorials Posted: 5024
Category > Business & Finance Posted 17 Aug 2017 My Price 4.00

I am having trouble with the NPV function in excel. I do not think I am using it correctly.

Please help. I am having trouble with the NPV function in excel. I do not think I am using it correctly.

 

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 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.

Answers

Martinakom
Not Rated (0)
Status NEW Posted 17 Aug 2017 04:08 PM My Price 4.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r y-----------our----------- in-----------ter-----------est----------- an-----------d b-----------uyi-----------ng -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll -----------be -----------qui-----------ckl-----------y

Not Rated(0)