Construct a spreadsheet to calculate the payback period, internal rate of return

1
Finance Mgmt
2

• Finance Mgmt
•  
• Q1.Who are the two parties to this potential
  lease transaction?
• Q2.How will these alternative decisions impact
  the company's Capital Structure and its balance
  sheet?
• Q3.What discount rate should be used in this Net
  Present Value analysis? Why?
• Q4.In the Purchase Decision, what are the cash
  flow impacts of the Bank Loan? (Please focus on
  the after tax cash flows.)

3

• Q5.Construct a spreadsheet to calculate the
  payback period, internal rate of return, modified
  internal rate of return, and net present value of
  the proposed mine.
• Q6.Based on your analysis, should the company
  open the mine?
• Q7.If the cost of capital is 8, which of the 3
  projects should the ABC Company accept?
• Q8.As a Statistician, advice what kind of
  Sampling schemes can we consider, and what
  factors will influence choice of scheme. What are
  the questions we should ask Mr. Namdeo, who works
  in the assembly line?

4

• Global Study Solutions
• Dr. Aravind Banakar
• aravind.banakar_at_gmail.com
• www.mbacasestudyanswers.com
• 9901366442 9902787224