Compute appropriate net present value, Finance Basics

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.

 

Posted Date: 2/23/2013 2:28:14 AM | Location : United States







Related Discussions:- Compute appropriate net present value, Assignment Help, Ask Question on Compute appropriate net present value, Get Answer, Expert's Help, Compute appropriate net present value Discussions

Write discussion on Compute appropriate net present value
Your posts are moderated
Related Questions
thew amount of money investedin a retirement fund is an example of

Question 1: a) What is dependency ratio and why is it important for pensions? b) For which types of schemes is dependency ratio mostly relevant? Explain c) What is the

Profitability in relation to investment - Profitability Ratio a) Return on Investment (ROI) or return on total asset (ROTA) = (Net profit/ Total asset) x 100 The ratio i

Eye Field - Vertebrate Eye The development of eyes starts with evagination of the lateral wall of the forebrain. one on each side, which make the optic vesicles. By vital dye

what are financial markets. why do they exist

The scope of supply chain management  Supply chain management includes the determination of suppliers; distributors, distribution channels and warehousing; manufacturing infor

Question   Clifton-Peters Ltd is a manufacturer of household goods located in Melbourne. They presently make and wholesale fruit juicers, blenders and baking equipment. The Gen

Yard Stick Required in Ratio Analysis 1. Past performance of the company The company's previous performance past ratio is needed to gauge or measure the company's present

Dividend Cover Ratio Dividend cover = EPS/ DPS = Earning to ordinary shares/Dividend paid       This signifies the number of times dividend can be paid from earnin

Bases of Share Valuation Share valuation can be done on the basis of income and asset values. On the basis of income still a share will be entitled to two forms of income. For