Question

In: Finance

INSTRUCTIONS: Read the information below, including Parts a and b of Question 1. Create a new...

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

(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 it’s 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.

Solutions

Expert Solution

a] PROJECT A:
Year Cash Flow Cumulative Cash Flow PVIF at 11% PV at 11% PVIF at 15% PV at 15% PVIF at 14% PV at 14%
0 $               (7,500) $          (7,500) 1 $           (7,500) 1 $          (7,500) 1 $       (7,500)
1 $                  1,500 $          (6,000) 0.90090 $             1,351 0.86957 $            1,304 0.87719 $          1,316
2 $                  2,500 $          (3,500) 0.81162 $             2,029 0.75614 $            1,890 0.76947 $          1,924
3 $                  3,000 $              (500) 0.73119 $             2,194 0.65752 $            1,973 0.67497 $          2,025
4 $                  2,000 $            1,500 0.65873 $             1,317 0.57175 $            1,144 0.59208 $          1,184
5 $                  1,500 $            3,000 0.59345 $                 890 0.49718 $                746 0.51937 $             779
6 $                  1,000 $            4,000 0.53464 $                 535 0.43233 $                432 0.45559 $             456
$                 816 $                (11) $             183
Payback period = 3+500/2000 = 3.25 Years
NPV = $                 816
IRR = 15%-1%*11/(11+183) = 14.94%
PROJECT B:
Payback period = 4100/1200 = 3.42 Years
NPV = -4100+1200*(1.11^5-1)/(0.11*1.11^5) = $                 335
IRR:
When discounted at IRR,
4100 = 1200*PVIFA(irr,5)
PVIFA(irr,5) = 4100/1200 = 3.4167
Annuity interest factors for 14% & 14% 15%
15% for n = 5 are 3.4331 3.3522
IRR = 14%+1%*(3.4331-3.4167)/(3.4331-3.3522) = 14.20%
PROJECT C:
Payback period = 5500/2000 2.75 Years
NPV = -5500+2000*(1.11^4-1)/(0.11*1.11^4) = $                 705
IRR:
PVIFA(irr,4) = 5500/2000 = 2.7500
16% 17%
Annuity interest factors for 16% & 2.7982 2.7432
and 17% for n = 4 are =
IRR = 16%+1%*(2.7982-2.75)/(2.7982-2.7432) = 16.88%
Project D:
Payback period = 3500/1700 = 2.06
NPV = -3500+1700*(1.11^3-1)/(0.11*1.11^3) = $                 654
IRR:
PVIFA(iir,3) = 3500/1700 = 2.0588
Annuity interest factors for 21% & 21% 22%
22% for n = 3 are 2.0739 2.0422
IRR = 21%+1%*(2.0739-2.0588)/(2.0739-2.0422) = 21.48%
TABULATION OF RESULTS AND RECOMMENDATION
Project Payback in Years NPV IRR Life in years PVIFA at 11% EANPV
A 3.25 $                816 14.94% 6 4.23054 $                193

Related Solutions

INSTRUCTIONS: Read the information below, including Parts a and b of Question 2. Create a new...
INSTRUCTIONS: Read the information below, including Parts a and b of Question 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. Perfect Binding Ltd provides specialist binding services to the printing industry. The company’s production manager is investigating whether to replace an old burst binding machine and has provided you with the following...
Question 1 [25 Marks] Read the news extract below and answer Question 1 (a) and (b):...
Question 1 [25 Marks] Read the news extract below and answer Question 1 (a) and (b): The South African government has approved sectorial minimum wages with effect from January 2019. a. Suppose the minimum wage is above the equilibrium wage in the market for unskilled labour. Using relevant diagrams and hypothetical numbers of the unskilled labour market, show the potential impact of the minimum wage on the labour market in South Africa. b. If the demand for unskilled labour were...
Instructions: Read the case Below and answer the question that follow: In the garment industry, quality...
Instructions: Read the case Below and answer the question that follow: In the garment industry, quality control is mainly practiced right from the initial stage of sourcing raw materials to the stage of final finished garment. For textile and apparel industry, product quality is calculated in terms of quality and standard of fibers, yarns, fabric construction, color fastness, surface designs and the final finished garment products. David, the quality manager of an international garment company, states that "quality is ultimately...
QUESTION 9 Instructions: Please read the passage below, then answer the questions that follow. ------------------------------------------------------------------------------------------------ Zoey...
QUESTION 9 Instructions: Please read the passage below, then answer the questions that follow. ------------------------------------------------------------------------------------------------ Zoey wanted to buy a new car but was having difficulty deciding what kind of car to buy. She was feeling anxious and wanted to make a decision soon. It was a very cold day in January, and she was preparing for a long day; so Zoey decided to wear her glasses, a long pea coat, and her work satchel. Zoey had conducted some research...
Using the below information fill in the answers to parts (a), (b) and (c) for a...
Using the below information fill in the answers to parts (a), (b) and (c) for a change in accounting principle Partial Income Statement using Completed- contract-method for its long-term construction contracts: 2015 2016 2017 Income before taxes 400,000 160,000 190,000 Income tax expense (40%) 160,000 64,000 76,000 Net Income 240,000 96,000 114,000 Partial Income Statement using Cost-to-Cost-method for its long-term construction contracts: 2015 2016 2017 Income before taxes 600,000 180,000 200,000 Income tax expense (40%) 240,000 72,000 80,000 Net Income...
Use the data below to answer the question parts (a) and (b). This data is for...
Use the data below to answer the question parts (a) and (b). This data is for forecasting fure sale consdiering additive seasonality approach and answer related questions. SHOW EACH CALCULATION STEP AND DESCRIBE IT ROUND answers to 2 decimal points. Time Year Season Sale 1 2018 Q1 1 2 Q2 7 3 Q3 3 4 Q4 2 5 2019 Q1 6 6 Q2 8 7 Q3 1 8 Q4 9 PART a) What is the seasonality index for second season...
Objectives: 1. Create classes to model objects Instructions: 1. Create a new folder named Lab6 and...
Objectives: 1. Create classes to model objects Instructions: 1. Create a new folder named Lab6 and save all your files for this lab into this new folder. 2. You can use any IDE (such as SciTE, NetBeans or Eclipse) or any online site (such as repl.it or onlinegdb.com) to develop your Java programs 3. All your programs must have good internal documentation. For information on internal documentation, refer to the lab guide. Problems [30 marks] Problem 1: The Account class...
Objectives: 1. Create classes to model objects Instructions: 1. Create a new folder named Lab6 and...
Objectives: 1. Create classes to model objects Instructions: 1. Create a new folder named Lab6 and save all your files for this lab into this new folder. 2. You can use any IDE (such as SciTE, NetBeans or Eclipse) or any online site (such as repl.it or onlinegdb.com) to develop your Java programs 3. All your programs must have good internal documentation. For information on internal documentation, refer to the lab guide. Problem : The Fraction class (Filename: TestFraction.java) Design...
INSTRUCTIONS for the Case Analysis: 1. Read the case below and answer ALL the questions which...
INSTRUCTIONS for the Case Analysis: 1. Read the case below and answer ALL the questions which follow. 2. Your answers may be entered using a Microsoft Excel spreadsheet OR may be entered in a table format using Microsoft Word. HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new production line of portable electrocardiogram (ECG) machines for its clients who suffer from cardiovascular diseases. The company has to invest in equipment which costs $2,500,000...
Question 1 (this question has three parts, (a), (b), and (c)) (a) As a response to...
Question 1 (this question has three parts, (a), (b), and (c)) (a) As a response to the recent COVID-19 outbreak, the Commonwealth Government put in place lockdown restrictions. Using the dynamic AD-AS framework, analyse and demonstrate the impact of the COVID-19 pandemic on the level of output (or real GDP), unemployment, and inflation. [4+4 marks ] (b) In response to the COVID-19 pandemic, in March 2020 the Commonwealth Government announced a fiscal stimulus which included income support for workers and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT