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

  The detergent is expected to generate sales revenue of 1

parker products manufactures a variety of household products. the company is considering introducing a new detergent.

  Zippy corporation just purchased computing equipment for

zippy corporation just purchased computing equipment for 27000. the equipment will be depreciated using a five-year

  Discuss financial ratio analysis

Find two articles that discuss financial ratio analysis. Identify two advantages and two disadvantages to using ratios in financial analysis. Be sure to cite your sources using APA format.

  Distributes several varieties of potato chips

Happy Chips Inc. currently manufactures and distributes several varieties of potato chips to different types of retail accounts:

  Companies are sometimes able to show very rapid growth in

companies are sometimes able to show very rapid growth in eps over a few years. this often gets investors interested

  Jemisens firm has expected earnings before interest and

jemisens firm has expected earnings before interest and taxes of 1500. its unlevered cost of capital is 15 percent and

  Carolina and south carolina

Carolina and South Carolina. A small group of private Investigators in Atlanta, Georgia area is interested in financing the startup company and two financing plans have been put forth for consideration:

  Highly compensated employees

All the following employees are considered highly compensated employees in the following year EXCEPT

  What is the aftertax cost of debt

Jiminy's Cricket Farm issued a 30-year, 9.8 percent semiannual bond 5 years ago. The bond currently sells for 87 percent of its face value. The company's tax rate is 40 percent.

  A firm evaluates all of its projects by applying the irr

1. calculating npv. for the cash flows in the previous problem suppose the firm uses the npv decision rule.

  Calculation of margin

Phoenix Trader opens a brokerage account and purchases 600 shares of Widget Company at $50 per share. He borrows $6,000 from his broker to help pay for buy.

  Work breakdown schedules-uncertainty

Work Breakdown Schedules, Uncertainty, and Dependency Relationships. Write a develop a three to five (3-5) page paper that addresses the following:

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