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 1 year 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 [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...
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...
INSTRUCTIONS: Using the financial information below, prepare a proper cash flow statement, including any necessary disclosures....
INSTRUCTIONS:
Using the financial information below, prepare a proper cash flow
statement, including any necessary disclosures.
COMPARATIVE BALANCE SHEET
Year 2
Year 1
Cash
133,000
195,000
Accounts Receivable
372,000
110,000
Allowance for Doubtful Accounts
(20,000)
(10,000)
Inventory
395,000
155,000
Reserve for Obsolete Inventory
(5,000)
(5,000)
Prepaid Expenses
15,000
-
Equipment, net
155,000
165,000
Total Assets
1,045,000
610,000
Accounts Payable
81,000
100,000
Corporate Income...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|