Calculate the npv and irr and mirr

Assignment Help Finance Basics
Reference no: EM13850154

The director of finance has discovered an error in his WACC calculation. He did not factor in the tax rate when determining the cost of debt. UPC has a line of credit at 4% interest, and the company is taxed at 30%. Further, assume that UPC's required rate of return on equity is 14%, and its capital structure is 40% debt and 60% equity. Additionally, the budget committee question and answer session revealed that UPC has discovered a technology that will increase its product life span by 1 year. The new technology will add $120,000 and $130,000 to projects A and B's initial capital outlay, respectively. Further, the finance department has determined that cash flows for years 1, 2, and 3 will be unchanged. However, net cash flows for year 4 will be $300,000 and $150,000 for projects A and B, respectively.

Using the attached Excel file, the UPC scenario, and the new information above, calculate the NPV, IRR, MIRR, and payback periods from projects A and B. You must input all of your data into an Excel spreadsheet and show all formulas.

Using MS Word, explain any risk factors inherent in the budgeting for the 2 projects

Word document must include Introductory paragraph and conclusion paragraph

Reference no: EM13850154

Questions Cloud

Is trade finance is trade credit and insurance guarantees : According to the World Trade Organization (WTO), a significant percentage of world trade relies on trade finance. Trade finance is trade credit and insurance guarantees, mostly of a short-term nature.
Who has an insurable interest in the damaged property : Who has an insurable interest in the damaged property and who is insured for the damaged property? What property is insured under the policy and during what time period? What is the cause of loss
First annual payment will be principal reduction : You take out a $800,000 amortized loan for your new beach house. You will make equal annual payments at the end of each of the next 10 years. The interest rate is 8%. How much of the first annual payment will be principal reduction?
Cash management is often the heart of the firm : Cash management is often the 'heart' of the firm in that a firm (just as would an individual or family) must assure that disbursements match-up with available and adequate cash. Consider two firms: The second firm is a manufacturer of industrial prec..
Calculate the npv and irr and mirr : the UPC scenario, and the new information above, calculate the NPV, IRR, MIRR, and payback periods from projects A and B. You must input all of your data into an Excel spreadsheet and show all formulas.
What constant annual interest rate were you earning : If you deposit $2,000 into a bank account at the end of each of the next 10 years and it has grown to $27,633, what constant annual interest rate were you earning?
Estimate the libor zero rates for maturities : The LIBOR zero curve is flat at 4% (continuously compounded) out to 2 years. Swap rates for 3- and 4-year annual pay swaps are 4.5% and 5%, respectively. Estimate the LIBOR zero rates for maturities of 3 and 4 years. Give your answers as annual rates..
Cost of preferred stock-cost of preferred stock financing : The preferred stock of Gator Industries sells for $35.85 and pays $2.71 per year in dividends. What is the cost of preferred stock financing? What are the floatation costs for issuing the preferred shares and how should this cost be incorporated into..
Determine who may have legal liability for the fire : Determine whether B&B Bouquets has coverage for the allegations made in the lawsuits and other claims made against them. Determine who may have legal liability for the fire

Reviews

Write a Review

Finance Basics Questions & Answers

  Description of inventory system

Write a summary which includes: 250- to 350-word description of each inventory system.

  Determine the total two-year interest cost

Boatler Used Cadillac Corporation needs $80,000 in financing over the next 2-years. The company can borrow  funds for 2-years at 9% interest every year.

  Determine the incremental cost

Consider the production cost information for Sally's spaghetti sauce in problem The corporation is currently producing and selling 250,000 jars of sauce yearly.

  Discuss the income and estate tax treatment

Discuss the use of disability insurance in financial planning, including the tax ramifications; OR Discuss the income and estate tax treatment of life insurance proceeds, giving an example.

  Q1 an investor enters into a short forward contract to sell

q.1 an investor enters into a short forward contract to sell 100000 british pounds for u.s. dollars at an exchange rate

  Objective type questions on payback period, npv and irr

Objective type questions on payback period, NPV and IRR and what is the internal rate of return on this project

  Assume that springfields economy moves into a recession and

the widget industry in springfield is competitive with numerous buyers and sellers. consumers dont differentiate among

  Find the cost of retained earnings

Pony Corporation is undertaking a capital budgeting analysis. The firm's beta is 1.5. The rate on thirty year U.S. Treasury bonds is 5 percent, and the return on the S&P 500 index is 12 percent.

  The income statement

Under this approach management makes the decision on whether or not an item is extraordinary and therefore excluded from the income statement.

  In what activity belonging to contract administration

Question 1. In what activity belonging to contract administration is an observation made to confirm or controvert a hypothesis, and a prediction made based on the difference between an expectation and a measurement? Explain your answer.

  If sales increase by 10 percent to 11000 units by what

firm a has 10000 in assets entirely financed with equity. firm b also has 10000 in assets but these assets are financed

  Determining profit or loss from an investment

Determining Profit or Loss from an Investment. Three years ago, you purchased 150 shares of IBM stock for $88 a share. Today, you sold your IBM stock for $103 a share. For this problem, ignore commissions that would be charged to buy and sell y..

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