Insigne Corporation is considering two investment projects (projects A and project B) that are mutually exclusive. Project A requires an initial cash out flow of $10,000,000 today and Project B requires an initial cash out flow of $15,000,000 today.  The expected end-of-year cash inflows of each project are given in the following table:   Year Cash Inflow project A Cash Inflow project B 1 3,500,000 7,500,000 2 6,000,000 8,000,000 3 6,000,000 4,000,000 4 9,000,000 4,500,000               Weighted average cost of capital is 13% for both projects.   What is the IRR of each project? What is the NPV of each project? What is MIRR of each project? What is payback of each project? Which project should Insigne Corporation take? Please explain why

Question

Insigne Corporation is considering two investment projects (projects A and project B) that are mutually exclusive. Project A requires an initial cash out flow of $10,000,000 today and Project B requires an initial cash out flow of $15,000,000 today.  The expected end-of-year cash inflows of each project are given in the following table:

 

Year

Cash Inflow project A

Cash Inflow project B

1

3,500,000

7,500,000

2

6,000,000

8,000,000

3

6,000,000

4,000,000

4

9,000,000

4,500,000

 

 

 

 

 

 

 

Weighted average cost of capital is 13% for both projects.

 

  1. What is the IRR of each project?
  2. What is the NPV of each project?
  3. What is MIRR of each project?
  4. What is payback of each project?

Which project should Insigne Corporation take? Please explain why

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Finance

Related Finance Q&A

Find answers to questions asked by students like you.

Q: Better Mousetraps has developed a new trap. It can go into production for an initial investment in e...

A: At the outset, I want to bring to your notice that in the leading line of the question, we have been...

Q: In Porter's five-factor model why does Porter not include market size and growth rate when determini...

A: Porter's five forces analysis is a structural framework to evaluate the attractiveness of an industr...

Q: You strongly believe that the price of Breener Inc. stock will rise substantially from its current l...

A: Current, stock price, S0 = $ 137Amount to invest, A = $ 13,700Strike price on call option, K = $ 140...

Q: You need to borrow $139,970 to buy a Ferrari. The current loan rate is 4.99%compounded monthly and y...

A: Calculation of size of monthly payment: Excel spread sheet for PMT calculation:

Q: One year ago, Berardi corporation issued a series of 13% semiannual coupon callable bonds with par v...

A: We will use the RATE function inexcel to calculate the yield. Before we do so, please note the follo...

Q: You have your choice of two investment accounts. Investment A is a 9-year annuity that features end-...

A: All financials below are in $.Characterisitics of Investment A:Monthly annuity, M = 1,780Frequency i...

Q: I now have $16,000 in the bank earning interest of 1.00% per month. I need $26,000 to make a down pa...

A: Calculation of Duration of the Investment:The Duration of the Investment can be calculated using a e...

Q: A firm has a market value equal to its book value. Currently, the firm has excess cash of $2,000 and...

A: Outstanding Shares: The number of shares that are currently held by the company’s shareholders are r...

Q: Storico Co. just paid a dividend of $2.65 per share. The company will increase itsdividend by 20 per...

A: Calculation of Price of Stock Today:Excel Spreadsheet:

Q: Assume the​ zero-coupon yields on​ default-free securities are as summarized in the following​ table...

A: Calculation of coupon value:

Q: Bethesda Water has an issue of preferred stock outstanding with a coupon rate of 3.80 percent that s...

A: Calculation of cost of preferred stock:

Q: A project costs $1 million and has a base-case NPV of exactly zero (NPV sign. Enter your answers in ...

A: a.Calculation of Adjusted Present Value:

Q: What is the present value of end-of-year cash flows of $9,000 per year, with the first cash flow rec...

A: Cash flow: It denotes to the sum of cash that keeps flowing in the business and out of business duri...

Q: The following table shows the nominal returns on Brazilian stocks and the rate of inflation. Nominal...

A: Excel spread sheet of calculation of standard deviation of the market returns:

Q: And what are the expected returns for stocks A and B if the conditions are as follows? A0 0.03...

A: Calculation of Expected Return for Stock A:

Q: 2. What are the free cash flows that are relevant to analyzing the two projects? Compute the NPVs of...

A: Free cashflow is calculated using formula:FCFF = EBIT - Taxes + Depreciation - Capex - Change in NWC...

Q: Assume Technical Investors is thinking about three different size offerings for issuance of addition...

A: The percentage underwriting spread for each size offer is calculated as follows:Percentage underwrit...

Q: Your company has been approached to bid on a contract to sell 21,000 voice recognition (VR) computer...

A: As per the details provided in the question, following are the required calculation where selling pr...

Q: Your client is currently 19 years old. Your client wishes to retire at age 71. Your client's expecte...

A: Two assumptions are required to be made because the question is silent about them:All cash flows i.e...

Q: What is the value of the cost pool and allocation rate if patient service is used as cost driver and...

A: a ) What is the Value of Cost Pool?The Value Cost pool is 1, 00,000

Q: 2. Bond valuation The proces value of the cash flows that the security will generate in the future s...

A: A bond’s coupon rate partially determines the interest-based return that a bond will pay and a bondh...

Q: I already ask this but I whant know how you do the calculation, please could you show me all the ste...

A: Calculating the price of bond if bond mature in 10 year. We have,Price of bond = C [1- (1 / (1+r)n ]...

Q: I already ask this but I whant know how you do the calculation, please could you show me all the ste...

A: Calculating the price of bond if interest rate on the bond is 10%. We have,Price of bond = C [1- (1 ...

Q: Suppose you pay 10 to buy a European (K=100, t=2) call option on a given security.  Assuming a conti...

A: Let S be the proce of the security and K be the stirke price of the call option and C is the cost to...

Q: A stock with a beta of 0.8 has an expected rate of return of 12%. If the market return this year tur...

A: Recall the famous CAPM equation to estimate the expected rate of return on a stock:R = Rf  + β x (Rm...

Q: Use the 2016 FICA tax rates, shown below, to answer the following question. If a taxpayer is not sel...

A: The tax payer is not self employed. He will therefore be governed by the employee's tax rates.Income...

Q: If the annual geometric mean for the equity risk premium is 8.4 percent, what percentage of the equi...

A: Calculation of Percentage of Equity Risk Premium:

Q: Can I have this explained? Am confused. Now you have $20,000 in your savings account in which you ea...

A: Calculation of Quarterly Interest Rate:

Q: The rise of globalization is due to the many companies that have become multinational corporations f...

A: Relative interest rate constitute as one of the major factors in determining the exchange rates. For...

Q: I already ask this but I whant know how you do the calculation, please could you show me all the ste...

A: Calculating the price of bond if interest rate on the bond is 6%. We have,Price of bond = C [1- (1 /...

Q: A store will give you a 4.00% discount on the cost of your purchase if you pay cash today. Otherwise...

A: Let's assume the cost of purchase is C. On immediate payment,Discount = 4%Hence, the discounted cost...

Q: USE THE INFORMATION BELOW FOR THE FOLLOWING PROBLEM   Stock Rit Rmt ai Beta C 12 10 0 0.8 ...

A: Abnormal return = Return in excess of market return in the given period = Rit - RmtFor stock C, the ...

Q: dpb corporate bonds have a coupon rate of 9.2% APR (sa). The yeild to maturity is 8.5% APR (Sa). the...

A: Semi annual payments. Hence the period here is semi annual or half year. Hence, n = 2 x years to mat...

Q: The company stock increases dividend by 5% each year and the expecteddividend in 5 years is $5. Anal...

A: Suppose the dividend paid recently=$xDividend paid in year 1=x*(1+growth rate)^1Dividend paid in yea...

Q: The following problem refers to the stock table for ABC Inc.​ (a tire​ company) given below. Use the...

A: Hi, I’m answering the first 3 subparts of the question as the given question consists of multiple su...

Q: If $1 million face amount of commercial paper(270 day paper) is sold for $982,500, what is the simpl...

A: Calculating the value of simple rate of interest paid on commercial paper. We have,Face value of com...

Q: A devoted Indiana basketball fan needs $11,200.00 to attend the Final Four exactly one year from tod...

A: As a first step let's assign a symbol to each of the information we have:Future value, FV = $ 11,200...

Q: At the age of 33​, to save for​ retirement, you decide to deposit $80 at the end of each month in an...

A: NOTE: There is some information missing in the question. The retirement age in not mentioned in the ...

Q: Assume coupons are paid annually. Here are the prices of three bonds with 10 year maturities. Assume...

A: Click to see the answer

Q: What is the present value of an annuity that pays $200 per month for 10 years if money is worth 5% c...

A: Present Value:It is the discounted value of cash flows of different period or sum of future money fr...

Q: Here are some historical data on the risk characteristics of Ford and Harley Davidson. Harley Davids...

A: Since you have asked a question with five sub parts, I will address the first three sub parts. Pleas...

Q: 3. Bonds: The three parts of this problem are related. By studying prices of zero coupon STRIPS, you...

A: If rn andrSn+1 are the spot rates for the year n and n+1 respectively, then one year forward rate be...

Q: Use the compound interest formula A = P(1 + i)n to find the indicated values A = $6,000; i = 0.03; n...

A: Compounded Interest:           It is the method for computing interest at the initial amount of prin...

Q: How I RESOLVE THIS PROBLEM Sun instrument expects to issue new stock at $34 a share with estimated f...

A: Calculation of cost of retained earnings:

Q: Robinson's has 46,000 shares of stock outstanding with a par value of $1 per share and a market pric...

A: The firm announces the stock split of 2-for-1.

Q: The simplified balance sheet for the Dutch manufacturer Rensselaer Felt (figures in € thousands) is ...

A: Recall the popular equation:Ra = Ws x Rs + Wd xRd + We x Rewhere Ra = return on assets;Ws, Wd and We...

Q: Why should a real estate listing contract be in writing and what are the essential elements of a lis...

A: Real estate contracts refer to legal aggreement between different parties. It is enforceable by law ...

Q: Micro-Technologies is a Bio Tech research firm that is conducting research on a cure for Aids. Their...

A: Step1: Calculating the value of after-tax cash outflow under lease arrangement. We have,Lease paymen...

Q: Moerdyk Corporation's bonds have a 9-year maturity, a 7.75% semiannual coupon, and a par value of $1...

A: The price of a bond can be calculated using the PV function in excel. We have to select the inputs o...

Q: What is the current price of a zero-coupon bond with a 7 percent yield to maturity that matures in 2...

A: Two assumptions are required before we proceed to calculate the price of the zero coupon bond:1. Let...