Calculate the npv-irr and mirr, Finance Basics

Assignment Help:

Task:

  • Decide upon 2 mutual exclusive projects.
  • Calculate the income statement, balance sheet, and statement of cash flows for all year
  • Calculate the NPV, IRR, and MIRR.
  • Check if IRR and MIRR are consistent with the NPV for various rates of cost of capital.

Assumptions:

  • One project has a reinvestment in the middle of its productive life of 50% of the initial cost
  • Project length is at least 4 years
  • 30% annual growth of Revenues
  • Profit Margin 2% in t=0 (that might change over time)
  • Dividend is 0% of net income
  • You are operating at 100% capacity in year zero and thereafter
  • Initiating the investments will have some impact on net working capital
  • At least one of your balance sheet entries, such as inventory, should be forecasted based on a regression (utilize the attached historic data)
  • If you need additional financing, finance 40% with debt and 60% with equity
  • You will finance 40% of the asset with debt in either case
  • Taxes are 35%, cost of debt is 5% and cost of equity is 12%
  • Customers pay after 60 days
  • Suppliers are paid after 90 days
  • If you sell your assets in the final year you will incur an extraordinary gain

Related Discussions:- Calculate the npv-irr and mirr

Analysis on capital budgeting npv or eaa, As the Chief Financial Officer fo...

As the Chief Financial Officer for the wholly Australian owned, Australian Stock Exchange listed company, Toy Show Ltd., an importer and manufacturer of a range of quality children

Challenges to finance manager., Ask question #Minimum what are the challeng...

Ask question #Minimum what are the challenges that a finance manager may face?

Draw the network diagram, Draw the network diagram of the following project...

Draw the network diagram of the following project according to the activity list and relationships mentioned below Table 1 Activity Du

Dividend cover ratio, Dividend Cover Ratio Dividend cover = EPS/ DPS =...

Dividend Cover Ratio Dividend cover = EPS/ DPS = Earning to ordinary shares/Dividend paid       This signifies the number of times dividend can be paid from earnin

Value chain, what do you consider to be the main inbound logistics for bank...

what do you consider to be the main inbound logistics for banking

Present value of an annuity - dcf technique, Present Value of an Annuity - ...

Present Value of an Annuity - DCF Technique An individual investor may not necessarily acquire a lump sum after several years however rather obtain a constant periodic amount

Student, evaluate the importance of leverage in financial management of a s...

evaluate the importance of leverage in financial management of a small scale company

Contracting cost - agency costs, Contracting Cost - Agency Costs These...

Contracting Cost - Agency Costs These are costs acquired in devising the contract between the shareholders and managers. The contract is drawn to ensure management act in t

Eoq assumptions, EOQ Assumptions The basic EOQ model creat...

EOQ Assumptions The basic EOQ model creates the following supposition as: i) The demand is identified and constant over the year ii) The ordering cost is con

Disadvantages of debt finance, Disadvantages of Debt Finance It is...

Disadvantages of Debt Finance It is a conditional finance that is it is not invested along with any approval of lender. Debt finance, whether used in excess may interr

Write Your Message!

Captcha
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