i have done question one and need it with 6 hrs its easy excel expert work
RATIO ANALYSIS & CAPITAL BUDGETING
Develop a capital investment decision for your firm. This decision should involve a choice
between two options and involve you discounting cash flows for between 5 and 10 years.
Please use a required cost of capital of 10% (Hint: This is the discount rate to use).
Calculate the payback period, net present value (NPV) and internal rate of return (IRR) for
each of the two options for your firm that you developed and advise your company which
option it should invest capital in.
Please go to the ‘NPV & IRR’ worksheet and calculate the NPV and IRR for each of the
two capital investment options for your firm in this worksheet, using the NPV and IRR
functions in Excel. See this short video for guidance about how to calculate NPV and IRR
using Excel (control + click on this link):