INSTRUCTIONS:

1. Read the information below, including Parts a and b of Question 1.
2. Create a new Excel spreadsheet. Record your answers to all parts of the question into the spreadsheet. Use bold text to clearly label your responses to Part a and Part b. Save your work regularly

(a) For the following mutually exclusive projects (A, B, C and D), find the Payback period, NPV, and IRR. The required rate of return is 11.00%.p.a. Assume all future cash flows only occur by the end of each year. Based on your results, which project should be accepted and why.

Year	0	1	2	3	4	5	6
A	-7,500	1,500	2,500	3,000	2000	1500	1,000
B	-4,100	1200	1200	1200	1200	1200
C	-5,500	2,000	2,000	2,000	2,000
D	-3,500	1,700	1,700	1,700

(4 marks)

(b) AAA energy company is considering a project of solar energy plant. There are two different grades of solar panel under consideration. These two grades of solar panel come with different cost and efficiency. Grade A is the best in efficiency and lasts for 15 years with higher cost. Grade B is less efficient and lasts for 10 years, but the cost if lower. The company has already secured the land usage contract for the energy plant. The local government has granted the company free usage of the land as long as it operates as support for green energy and environment. The company intends to operate the project for infinite time, which means that the solar panels will be replaced once they reached their maximum useful life. The project team provided some estimated figures as below:

Detail	Grade A	Grade B
Purchase Price	$545,000	$350,000
Yearly Revenue	$110,000	$85,000
Yearly Costs	($12,000)	($8,000)
Salvage Value	$10,000	$9,000
Useful Life	15 years	10 years

Assuming its a perfect capital market that there are no taxes or inflation, so the above figures won't change in the future. The project team conducted a further analysis and provided some information below: Project beta 1.5, risk free rate 5%.p.a, and expected market return 11%.p.a. Please complete the analysis for AAA energy company and provide advice on the choice of solar panel.