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
a.  In the accompanying diagram (which represents the market for chocolate candy bars), the initial equilibrium is at the intersection of S1 and D1. Circle the new equilibrium if t

(Interest-rate risk) Philadelphia Electric has many bonds trading on the New York Stock Exchange. Suppose PhilEl''s bonds have identical coupon rates of 9.125% but that one issue m

Give an example of how capital budgeting decisions affect a company's value, strategy or operations. Companies always tend to look for capex projects which will add value to

Sapp Trucking's balance sheet shows a total of noncallable $45 million long-term debt with a coupon rate of 7.00% and a yield to maturity of 6.00%. This debt currently has a marke

Market Segmentation Theory This theory states as the main investors lenders and borrowers are confined to a particular segment of the market and will not change even whether t

what makes a preference shares a hybrid?

Stock Market Index Definition of Stock Market Index An index is a numerical figure that measures relative change in variables between two type of durations. Examples

(i) Find out operating leverage from the following data: Sales                             Rs.50000 Variable Cost               60% Fixed Cost                   Rs.12000


Example of Accounting Rate of Return Method                                    Shs. Project X cost              500,000 Scrap value                 100,000 Stream of