Assignment: NVP, IRR, Payback Period Calculations In Excel
Project Proposal 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 project's life, and the programming machinery will have nil salvage value at the end of the project's 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.
• 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 be 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.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Calculations.rar