Construct a spreadsheet to calculate the payback period


Question: 1. 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.

2. Based on your analysis, should the company open the mine?

3. Bonus question: Most spreadsheets do not have a built-in formula to calculate the payback period. Write a VBA script that calculates the payback period for a project.

Information related to above question is enclosed below:

Attachment:- CHAPTERCASE.rar

Request for Solution File

Ask an Expert for Answer!!
Accounting Basics: Construct a spreadsheet to calculate the payback period
Reference No:- TGS02798016

Expected delivery within 24 Hours