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 reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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