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

  Financial measurements in manufacturing

The PQ Piston Plant makes two sizes of pistons for reciprocating engines. Their plant has 4-machines. Currently, the demand for their products is 100 'p" pistons every week,

  The case is designed to determine and evaluate the payment

the case is designed to determine and evaluate the payment amount of a car loan and a mortgage based on your income. if

  Question on payout policy

Find out the expected stream of dividends per share for investor who plans to retain his shares rather than sell them back to the company? Check your estimate of share vaue by discounting this stream of dividends per share.

  Revenue recognition of brooke bennett marina

Brooke Bennett Marina has 300 available slips that rent for $900 per season. Payments should be made in full at the start of boating season, April 1, 2008. Make the appropriate journal entries for fiscal 2007.

  Katz corporation has issued 400000 shares of common stock

katz corporation has issued 400000 shares of common stock and holds 20000 shares in treasury. the charter authorized

  The dividend was raised to 140 though declining market

the stock of trudeau corporation went from 27 to 40 last year. the firm also paid 1 in dividends during the same year.

  Calculate the annual end of year loan payment amount

Calculate the annual end of year loan payment amount. Prepare a loan amortization schedule showing the interest and principal break down of each of the three loan payments.

  Present value of all future earnings

You are running a hot internet company. Analysts predict that its earnings will grow at 30% for each year for the next five years. After that, as competition rises, earnings growth is expected to slow to 2% per year and continue at that level fore..

  How long were robinson cycles and cash conversion cycles

If sales in 2010 were $1.2 million, sales in 2011 were $1.3 million, and cost of goods sold was 70 percent of sales, how long were Robinson's cycles and cash conversion cycles in each of these three years? What caused them to change during this ti..

  Occurring with the use of variance analysis

What type of inventory control considerations do you think are occurring with the use of variance analysis?

  Economic policy and international finance

From the first e-Activity, explain whether you believe it is U.S. consumers or policy makers who affect the money supply the most. Provide a rationale for your response.

  Discuss global economic outlook and research the current

discuss global economic outlook and research the current and long-term for the following countries united states

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