Calculations of the NPV, IRR and the payback for the project and an analysis of the results. I need the excel formula calculation and analysis of the questions

You have identified a potential opportunity for WBC, which involves undertaking a project that will have a ten-year life. The project requires an initial purchase of equipment and furniture totalling $4,500,000, plus ancillary programming capability and machinery costing $1,500,000. The equipment and furniture will depreciate and have a salvage value of $500,000 at the end of the projects life, and the programing machinery will have nil salvage value at the end of the projects life. Depreciation is calculated on a straight-line basis over five years. Information related to the project is as follows: Sales will be $3,050,000, $4,000,000 and $5,000,000 respectively in each of the first three years of operation, expected to grow at 10 per cent per annum for a further four years thereafter, and then settle to a growth of 5 per cent per annum indefinitely thereafter. In the event of not undertaking this project, all of this income would be lost. Variable costs associated with the project will be 65 per cent of sales. Fixed costs associated with the project will be $400,000 in the first year and expected to grow at 5 per cent per annum thereafter. Even though this project will not add additional expenses to head office, WBC has a policy of allocating a head office charge of $200,000 a year to each major project. Research for this project and its capability was conducted during the previous year at a cost of $300,000. It yielded valuable information. The corporate tax rate is 30 per cent. GSB003 Managing Financial Resources: Course Outline 3 Financiers of this type and risk in this industry are presently requiring a rate of 12 per cent after corporate tax. In order to undertake this project, WBC is considering various financing options. One option is to borrowing $5,000,000 at 7 per cent per annum. This loan will be paid off in 10 equal annual instalments. Required Evaluate this project, and provide a report to WBC management discussing whether or not you recommend it should undertake the project, providing a full explanation of your recommendation. As support for your recommendation ensure your answer includes the following: Calculations of the NPV, IRR and the payback for the project and an analysis of the results. Justification for the correct discount rate to be used in evaluating the project. Your assessment of the advantages and disadvantages of each methodology (NPV, IRR and payback), and which you therefore recommend is applied to evaluate this project. Details of any other (financial and non-financial) matters you would consider before making a recommendation in respect of this project.