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

1 / 4

# Construct a spreadsheet to calculate the payback period, internal rate of return - PowerPoint PPT Presentation

Assignment Solutions, Case study Answer sheets \nProject Report and Thesis contact\naravind.banakar@gmail.com\nwww.mbacasestudyanswers.com\nARAVIND â€“ 09901366442 â€“ 09902787224\n

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'Construct a spreadsheet to calculate the payback period, internal rate of return' - salesmbacasestudyhelp

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

### Finance Mgmt

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.)

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?

Global Study Solutions

Dr. Aravind Banakar

aravind.banakar@gmail.com