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

Tarniwala and dealer in non-cleared securities, Tarniwala and Dealer in N...

Tarniwala and Dealer in Non-cleared Securities Tarniwala: He/she is a specialist or jobber in selected shares. He/she makes market i.e. provide continuity to dealings. They

Agency relationship between government and the shareholders, Agency Relatio...

Agency Relationship between Government and the Shareholders Shareholders and via extension, the company they own operate within the environment requiring the charter or licens

Tracking order, when will I receive my order and how will I receive it?

when will I receive my order and how will I receive it?

What is debt-equity ratio, Louis Futon Co. is currently an all-equity firm....

Louis Futon Co. is currently an all-equity firm. The current market value of the company is $80 million. The corporate tax rate is 35%. What is the new value of the company if Loui

Advantages of residual theory, Advantages of Residual Theory 1. Savin...

Advantages of Residual Theory 1. Saving on floatation costs No require to raise debt or equity capital as there is high retention of earnings that necessitates no floatat

Profitability index or p.i., Profitability Index or P.I. P.I. (benefit...

Profitability Index or P.I. P.I. (benefit-cost ratio) = Present value of inflows / Present value of cash outlay Whether P.I. is greater than 1.0, invest and whereas less th

Present value of an annuity - dcf technique, Present Value of an Annuity - ...

Present Value of an Annuity - DCF Technique An individual investor may not necessarily acquire a lump sum after several years however rather obtain a constant periodic amount

Revenue Reserves - Retained Earnings, Revenue Reserves - Retained Earnings ...

Revenue Reserves - Retained Earnings These are undistributed earnings.  Those reserves are retained for the given reasons like: A. To create up for the fall in profits so a

Financial performance analysis, given profit margin 7%, total asset turnove...

given profit margin 7%, total asset turnover is 1.94, Return on equity is 23.7%, what is the debt equity ratio

Assiogment, Ask question #MinimQuestion You are the financial accountant ...

Ask question #MinimQuestion You are the financial accountant of Donald Bhd, a manufacturer and wholesaler of soft drinks. Donald Bhd is in direct competition with Fizz Bhd and Po

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