Your company is doing well and has a profit of about $40,000. You want to make your profit work harder so you have looked at some investment opportunities available. They are • To insulate the current company offices at a cost of $12,000 which will provide a fuel savings of $1,400 per year over the next 10 years. • To pay the lump sum of $20,000 to the mortgage of $40,000 that has a loan term of 10 years at 7.5% interest per annum. • To invest $10,000 into a new business, which has been estimated to return double the amount in 5 years' time. • To keep the profit $40,000 in a savings account earning an interest of 5.0% per annum for the next 6 years. After 6 years, there will be no interest for this savings account. Assumptions: If only a part of the profit $40,000 is invested in a project, the remaining amount is still kept in the pocket (i.e. no investment). The investment/cost occurs at the beginning of a year, and the investment benefits are obtained at the end of a year. (a) Given the profit you have and assuming a discount rate of 5.3%, perform and document appropriate NPV calculations for 10 years for all possible investment options you identified. Graph the results to show the payback analysis of each investment option. You must use Microsoft Excel or an equivalent spreadsheet program to perform and present your calculations. Do not use the Excel NPV function and demonstrate you understand the formulas by calculating the NPV. You may confirm the calculated NPV using the NPV excel function. Ensure you format the spreadsheets so they use references rather than hard coding data. This allows experimenting with the data, e.g., if I change the discount rate the data should react and change accordingly. Use bolding, colors etc. to ensure the data is easy to interpret. [7 marks] (b) From your calculations in (a), which investment would you take up and why? Use a Weighted Scoring Model (see an example on pages 154-155 of the textbook) to discuss the results and explain in detail why you have chosen one option over the others. It is not always just the figures that determine the final decision. [3 marks] Create a report in Word or PDF format to present the outcomes of (a) and (b). Use the data, graphs etc. created within the spreadsheet program to present the outcomes. Question 2 (10 marks) You are building a new office for your company. After some discussion with your builder, you identified some of the key tasks, the duration and the costs to complete the build. As you are a project manager you have decided to monitor the progress of their build using Earned Value Management (EVN). Answer the following questions using the following information