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

Determine tax cash flows & irr, An industrial engineer proposed the purchas...

An industrial engineer proposed the purchase of a RFID Fixed Asset Tracking System for the company's warehouse and weave rooms.  The engineer though that the system would provide a

Buying shares of a company, Buying Shares of a Company Factors should ...

Buying Shares of a Company Factors should be refer when Buying Shares of a Company 1. Economic situation of the country and other non-economic factors as like unfavorable c

Assignment, Following details are related to three companies which are iden...

Following details are related to three companies which are identical except in terms of ''''r''''. Company ABC Ltd. MNC Ltd. XYZ Ltd. Cost of capital 10% 10% 10% Earn per Share Rs

What is the execution of order in the stock exchange, What is the Execution...

What is the Execution of order in the Stock Exchange When broker receives the margin money and is clear about the order received by him, he puts details in the 'order book'.

What are the types of financial assets, What are the types of financial ass...

What are the types of financial assets? Types of Financial Assets: a. Loans b. Bank Deposits c. Stocks A share of ownership within a company d. Bonds A promis

Dividend policies and decisions, Dividend Policies and Decisions Divid...

Dividend Policies and Decisions Dividend policy determines the division of earnings among payments to stock holder's ad re-investment in the firm.  Hence now it looks at the f

Debt finance in us of small companies, Debt Finance in US of Small Companie...

Debt Finance in US of Small Companies Why It CAN Be Difficult For Small Companies to Raise Debt Finance in US Lack of safety avoidances of finances available

Dividend policy, Charleston Industrial revised its dividend policy and deci...

Charleston Industrial revised its dividend policy and decided that it wants to maintain a retained earnings account of $1 million. The company''s retained earnings account at the e

Term structure of interest rates, Term Structure of Interest Rates The...

Term Structure of Interest Rates The term structure of interest rate give details the relationship between the term to maturity and interest rates and the differences between

Funding venture capital, Funding Venture Capital Whenever a company's ...

Funding Venture Capital Whenever a company's directors look for support from a venture capital institution, so they must distinguish that as: a) The institution will would

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