Compute appropriate net present value, Finance Basics

Assignment Help:

Imagine Joy is the project coordinator in a company where four projects are running concurrently. He's employed you as the senior business analyst to perform some financial calculations for him. Below are specific instructions on how to prepare a report for Joy.

  • A2: Project 1
  • A3: Project 2
  • B1: Time
  • C1:I1: 1 2 3 4 5 6 7
  • C2:I2 → -400 200 600 -900 1000 250 230 (cash flow amounts)
  • C3:I3 → -200 150 150 200 300 100 80 (cash flow amounts)
  • J1: NPV (r=0.2)
  • K1: NPV (r=0.01)
  • Compute appropriate NPV's in J2, J3, K2, K3. Format this in blue.
  • B4: IRR Proj 1 No Guess
  • C4: IRR Proj 2 No Guess
  • In B5 and C5, compute the no-guess IRR's.
  • Add a comment in B5 explaining what this # signifies.
  • Next, Joy wants to check if Project 1 and 2 have more than one IRR. Set up a schedule to check this. Use the spreadsheet area between rows 7-19 to do your work. Use appropriate headings. If more than one IRR, format them in red.
  • A20: Project 3
  • B20:E20 → -20 82 -60 2 (cash flow amounts)
  • C21: Plain IRR
  • Compute the no-guess IRR in D21.
  • Now, Joy wants you to check if Project 3 has a unique IRR. Set up a schedule to check this. Use the spreadsheet area below rows 21 to do your work. Use appropriate headings. If there's a unique IRR, format them in yellow. Else, flag in red.
  • A36: Project 4
  • B36:D36 → 10 -30 35 (cash flow amounts)
  • Finally, Joy wants you to check if Project 4 has an IRR at all. Set up a schedule to check this. Use the spreadsheet area below rows 36 to do your work. Use appropriate headings. If there's an IRR, format them in blue. Else, flag the results in red.

 


Related Discussions:- Compute appropriate net present value

Interpolation method, Interpolation method Consequently, r denote...

Interpolation method Consequently, r denotes required rate of return Consequently, r = 14 percent + (15 percent - 14 percent) x 253 .646 /253 .646 + 5.375

Present value of a lump sum - dcf technique, Present Value of a Lump Sum - ...

Present Value of a Lump Sum - DCF Technique Generally an investor would want to know how much he or she would stop currently to get a provided amount in year 1, 2, ... n.  In

Throughput accounting, state a case where throughput according system is re...

state a case where throughput according system is required

Compute appropriate net present value, Imagine Joy is the project coordinat...

Imagine Joy is the project coordinator in a company where four projects are running concurrently. He's employed you as the senior business analyst to perform some financial calcula

Risk adjusted discounting rate – methods of computing cost, Risk Adjusted D...

Risk Adjusted Discounting Rate - Methods of Computing Cost of Capital This method is used to establish the discounting rate to be used for a provided project. The cost of capi

Discuss potential problems of internal finance, Internal finance can avoid ...

Internal finance can avoid the agency costs of debt and equity finance. In practice it is the most important source of funding.   (a)  Discuss potential problems of internal finan

Characteristics of sole proprietorship, Characteristics of Sole Proprietors...

Characteristics of Sole Proprietorship A. It caters for customers' personal attention B. Accounts do not must be audited C. Limited to such finances like: F

Cash flow statement, how to calculate cash flow? What components are requir...

how to calculate cash flow? What components are required to calculate it ?

US Tsys, How often does the "on the run" tsy change?

How often does the "on the run" tsy change?

Example of miller-orr model, Example of Miller-Orr Model XYZ's managem...

Example of Miller-Orr Model XYZ's management has put the minimum cash balance to be equivalent to Sh.10, 000. The standard deviation of daily cash flow is of Sh.2, 500 and the

Write Your Message!

Captcha
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