Question
In: Finance
INSTRUCTIONS: Read the information below, including Parts a and b of Question 1. Create a new...
INSTRUCTIONS:
- Read the information below, including Parts a and b of Question 1.
- 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 | |||
 jeff jeffy answered 2 years agoRelated SolutionsINSTRUCTIONS: 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 Instructions: Please read the passage below, then answer the questions that follow. -------------------------------------------------------------------- David...QUESTION 1
Instructions: Please read the passage below, then answer the
questions that follow.
--------------------------------------------------------------------
David and Kathy are about to go on a date. David really wants to
make a good first impression, so the night of their date he makes
sure to wear his best outfit and sprays himself with cologne. David
knows that if Kathy has fun on their date she will most likely let
him take her out again, so throughout the entire night he makes...
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...
QUESTION 18 Instructions: Please read the passage below, then answer the questions that follow. -------------------------------------------------------------------------------------- George...QUESTION 18
Instructions: Please read the passage below,
then answer the questions that follow.
--------------------------------------------------------------------------------------
George is a white man in his early 40s that has just been given
a group assignment for his Psychology class. To do this assignment
he has to form a group with his other classmates. Looking around
the room, he notices a number of people that don’t appear to be in
a group yet. The first person he talked to completely ignored him,
and George...
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|