LM Business Finance - Q3 W6-8 - Module 9 F
LM Business Finance - Q3 W6-8 - Module 9 F
LM Business Finance - Q3 W6-8 - Module 9 F
Business Finance
Week 6 to 8 – Module 9
Business Finance
Grade 12 Week 6 to 8 – Module 9
First Edition, 2020
Copyright © 2020
La Union Schools Division
Region I
All rights reserved. No part of this module may be reproduced in any form without
written permission from the copyright owners.
Management Team:
In your previous lesson, you are done calculating future value and
present value of money and how to compute loan amortization using
mathematical concepts and the present value tables.
This module will provide you with information and activities that will
help you understand mathematical tools and concepts in computing for finance
and investment problems.
Before going on, check how much you know about this topic. Answer the pretest on the
next page in a separate sheet of paper.
1
Module Mathematical Concepts and Tools in
11
Computing for Finance and Investment
Problems
In this Module, you will learn about mathematical concepts and tools in
computing for finance and investment problems and will explain risk-return
trade-off.
Pre-Test
Directions: Read carefully each item. Use separate sheet for your answers.
Write only the letter of the best answer for each test item.
1. Elimann Systems is considering a project that has the following cash flow
and cost of capital (r) data. What is the project’s NPV? Note that if a project’s
expected NPV is negative, it should be rejected.
r = 9.00%
Year Cash Flows
0 1000
1 500
2
2 500
3 500
3
r = 10.00%
Year Cash Flows
0 950
1 500
2 400
3 300
8. Nichols Inc. is considering a project that has the following cash flow data.
What is the project’s IRR? Note that a project’s IRR can be less than the cost of
capital or negative, in both cases it will be rejected.
Year Cash Flows
0 1250
1 325
2 325
3 325
4 325
4
9. Kiley Electronics is considering a project that has the following cash flow
data. What is the project’s IRR? Note that a project’s IRR can be less than the
cost of capital or negative, in both cases it will be rejected.
Year Cash Flows
0 1100
1 450
2 470
3 490
5
Jumpstart
For you to understand the lesson well, do the following activities. Have fun
and good luck!
Jack is a poor little boy who lives in the forest with his mom. The
son and mother live off their cow’s milk, but one day when the cow
doesn’t produce any milk, Jack’s mom tells him to go sell the cow in the
market for money and food. When Jack is on the way to sell the cow he
meets a man who says he has magic beans that grow really tall overnight.
Jack decides to exchange the cow for the magical beans and when Jack
gets home he proudly shows his mother the beans, but she becomes very
angry with Jack and throws the beans out the window. His mother then
sends Jack to bed with no dinner and when Jack wakes up the next
morning he realizes that the bean sprouted into a giant beanstalk
travelling all the way up to the sky. Jack is curious as to what is up at
the top, so he climbs up the beanstalk and walks down the road to fins a
giant castle. Jack enters the castle and saw a giant women and asks her
for food because he hasn’t eaten since yesterday’s lunch. The women gave
Jack food, but when her child-eating husband comes home Jack hides in
the oven. Once the husband falls asleep Jack escapes the oven, steals a
chicken that poops gold and a gold harp. The last time he travels up the
beanstalk the giant husband saw Jack as he is running out of the house
with the harp, and chases after him. Once Jack gets down the beanstalk
he cuts the beanstalk causing the giant fall to death.
Question 1: In the story, what was the possession of Jack he traded in?
Question 2: What did the product/s did they gave in return?
Question 3: Was the trading good for Jack? Why?
Question 4: If you Jack will you also take the risk to exchanging your family
cow for a magic beans? Why or why not?
6
.
Discover
7
with one another. The acceptance of one eliminates all other proposals
that serve a similar function from further consideration.
Unlimited Funds vs. Capital Rationing
The amount and availability of funds affects the company’s decisions in
capital outlays. If the company has unlimited funds, then all projects
which pass the risk-return criteria will be accepted and implemented.
Otherwise, firms will operate under capital rationing and will accept
only projects which provide the best opportunity to increase shareholder
wealth.
Accept-Reject vs. Ranking Approaches
The Accept-Reject is usually done for mutually exclusive projects where
one project is favored over the others. The approach accepts project
which pass a certain criterion. Ranking is done when there are several
projects passing the criteria and the company is only able to fund so
much. The highest ranking projects will be selected for implementation.
Project A
Project B
1. Playback Method
This is the simplest method used in capital budgeting. It measures the
amount of time, usually in years, to recover the initial investment. To illustrate
this method, let us use the previous examples for relevant cash flows.
8
For project A, the initial cash flow is PhP72,000.00. In 4 years, Mr.
Alfonso would have generated total cash flow of PhP68,000.00. To get the
actual time period, let us divide the remaining amount (4,000) * and divide it
by the cash flow for year 5. we get .24, so the total playback period for Project A
is 4 + .24 = 4.24 years. Conversely, if the cash flows are equal, you may derive
the answer by dividing the initial cash flow by the annuity, 72,000/17,000 =
4.24 years. Using the method for Project B, we get the payback period of
80,000/21,000 = 3.81 years.
9
3. Internal Rate of Return (IRR)
The IRR is one of the most widely used technique in capital budgeting. It
is defined as the discount rate that equates the NPV of an investment to zero. If
this method is used for capital budgeting analysis, the project’s IRR is
compared to the company’s cost of capital. If the IPP is greater than the cost of
capital, the project should be accepted otherwise, it should be rejected. Manual
computation of the IRR involves trial and error, however, this IRR computation
is a lot easier using applications like Microsoft Excel.
For example, you are planning to build a branch for your business at
PhP350,000 and expect to receive PhP400,000 in 1 year. First, compute for the
rate of return (profit/investment).
We compute for the rate of return because the NPV of a project with cost
of capital equal to the rate of return is equal to zero. To illustrate:
The IRR can easily be computed using Microsoft Excel using the IRR
function.
The NPV and IRR are interrelated techniques. An IRR greater than the
cost equates to a positive NPV and vice versa. On a purely theoretical view, NPV
is the better measure since it measures the actual cash value a project creates
for shareholders. However, IRR is also a widely used tool since financial
managers usually like to think in terms of ratios and percentages.
RISK-RETURN TRADE-OFF
Risk and return are two parameters for selecting investment in the
finance world. Risk is the possibility of loss or harm while return is the
appreciation (gain) or depreciation (loss) in the value of the asset.
10
In making investment decisions, financial managers take note of the risk
and returns they are entering.
Recall the story of Jack and the Beanstalk. In the story, Jack trades his
cow for three magic beans. This is a very risky move for Jack since these beans
may be fake and therefore, worthless. Luckily those magic beans grew into
beanstalk that gave Jack the opportunity to gather riches beyond his wildest
dreams, while fighting with a giant along the way. Jack gambles in this
transaction. Should Jack decide not to sell the cow for magic beans and
instead sold it at the current market value, the story would be different. As we
can see, the higher the risk, the higher the returns, but of course, if turned
sour, the higher the losses as well.
This situation is also true for making financial decisions. Taking a higher
risk gives you the opportunity to earn higher returns. Low risk investments like
treasury, also called risk-free instruments, earn a low and steady income flow.
In making investment decisions, financial managers ensure that the proposed
business will earn more than the risk-free rate since they need to compensate
for the risk the investment entail.
Ways on how the risk and return trade-off can be applied in real life:
Fixed income vs. commission based income
Earning interest from time deposits vs. earning from stocks
Entering in a business with steady income vs. entering into seasonal high
profit business
Investing in preferred vs. common stock
11
Explore
Here are some enrichment activities for you to work on to master and
strengthen the basic concepts you have learned from this lesson.
3. If PhP50,000 is earned on the 3rd year of the project, what is the new
NPV of the project? What is the payback period?
12
Deepen
Scenario 1:
You are the investment manager if an appliance company. The industry
is currently in the expansion face and the CEO would like to capture as much
of the market share as possible. You asked your analysis to submit project
proposals as summarized below.
Scenario 3:
Rahul has been pleading with his father for over a month to revise his
pocket money. Finally, his father decided to use this as an opportunity to teach
him an important investing lesson. He called Rahul and told him that he was
ready to reconsider his pocket money. He gave him 2 options to choose from:
Option A: I will increase your pocket money by 20% if you score above
90% in your upcoming exams. However, if you score below 90%, your pocket
money will have reduced by 15%.
Option B: your pocket money will be increased by 5% effective
immediately and will not depend on how you score in your exam.
13
If you will be Rahul, what option will you choose? Answer this by
providing a computation per option.
Rubrics
Category Weigh 4 3 2 1
t
Mathematic 35% 90-100% of Almost all Most (75- More than
al error the steps (85-89%) of 84%) of the 25% of the
and the steps steps and steps and
solutions and solutions solutions
have no solutions have no have
mathematic have no mathematic mathematic
al error mathematic al error. al errors.
al errors.
Explanation 25% Explanation Explanation Explanation Explanation
is detailed is clear. is a little is difficult to
and clear difficult to understand
understand and is
but includes missing
critical several
components. components
or was not
included.
Neatness 15% The work is The work is The work is The work
and presented in presented in presented in appears
Organizatio a neat, a neat and an organized sloppy and
n clear, organized fashion but unorganized
organized fashion that may be hard . It is hard
fashion that is usually to read at to know
is easy to easy to read. times. what
understand information
goes
together.
Completion 25% All problems All but one All but two Several of
are of the of the the
completed problems problems problems
are not are not are not
completed. completed. completed.
14
Gauge
Directions: Read carefully each item. Use separate sheet for your answers.
Write only the letter of the best answer for each test item.
1. Elimann Systems is considering a project that has the following cash flow
and cost of capital (r) data. What is the project’s NPV? Note that if a project’s
expected NPV is negative, it should be rejected.
r = 9.00%
Year Cash Flows
0 1000
1 500
2 500
3 500
15
4. Reed Enterprises is considering a project that has the following cash flow
and cost of capital (r) data. What is the project’s NPV? Note that if project’s
expected NPV is negative, it should be rejected.
r = 10.00%
Year Cash Flows
0 1050
1 450
2 450
3 450
16
8. Nichols Inc. is considering a project that has the following cash flow data.
What is the project’s IRR? Note that a project’s IRR can be less than the cost of
capital or negative, in both cases it will be rejected.
Year Cash Flows
0 1250
1 325
2 325
3 325
4 325
11. McGlothin Inc. is considering a project that has the following cash flow
data. What is the project’s payback?
Year Cash Flows
0 1150
1 500
2 500
3 500
17
12. Garner Inc. is considering a project that has the following cash flow data.
What is the project’s payback?
Year Cash Flows
0 350
1 200
2 200
3 200
13. Worthington Inc. is considering a project that has the following cash flow
data. What is the project’s payback?
Year Cash Flows
0 500
1 150
2 200
3 300
15. Suzanne’s Cleaners is considering a project that has the following cash flow
data. What is the project’s payback?
Year Cash Flows
0 1100
1 300
2 310
3 320
4 330
5 340
18
while Project B’s IRR is 14%. When the cost of capital is 8%, the projects have
the same NPV. Given this information, which of the following statements is
CORRECT?
A. If the cost of capital is 9%, Project A’s NPV will be higher than Project
B’s.
B. If the cost of capital is 6%, Project B’s NPV will be higher than Project
A ‘s.
C. If the cost of capital is 9%, Project B’s NPV will be higher than Project
A’s.
D. If the cost of capital is 13%, Project A’s NPV will be higher than Project
B’s.
17. You are considering two mutually exclusive, equally risky projects. Both
have IRRs that exceed the cost of capital. Which of the following statements is
CORRECT? Assume that the projects have normal cash flows, with one outflow
followed by a set of inflows.
A. If the cost of capital is greater than the crossover rate, then the IRR
and the NPV criteria will not result in a conflict between the
projects. The same project will rank higher by both criteria.
B. If the cost of capital is less than the crossover rate, then the IRR and
the NPV criteria will not result in a conflict between the projects.
The same project will rank higher by both criteria.
C. For a conflict to exist between NPV and IRR, the initial investment cost
of one project must exceed the cost of the criteria.
D. If the two project’s NPV profiles do not cross, then there will be a
sharp conflict as to which one should be selected.
18. Consider projects S and L. Both have normal cash flows and the projects
have the same risk, hence both are evaluated with the same cost of capital,
10%. However, S has a higher IRR than L. Which of the following statements is
CORRECT?
A. If project S has a positive NPV, Project L must also have a positive NPV.
B. If the cost of capital increases, each project’s IRR will decrease.
C. If the cost of capital fails, each project’s IRR will increase.
D. If Projects S and L have the same NPV at the current cost of capital,
10%, then Project L, the one with the lower IRR, would have a
higher NPV if the cost of capital used to evaluate the projects
decline.
19
19. Suppose a firm relies exclusively on the payback method when making
capital budgeting decisions, and it sets a 4-year payback regardless of
economic conditions. Other things held constant, which of the following
statements is most likely to be true?
A. It will accept too many long-term projects and reject too many short-
term projects (as judged by the NPV).
B. The firm will accept too many projects in all economic states because
a 4-year payback is too low.
C. The firm will accept too few projects in all economic states because a
4-year payback is too high.
D. If the 4-year payback results in accepting just the right set of projects
under average economic conditions, then this payback will result
in too few long-term projects when the economy is weak.
20. Which of the following statement is CORRECT? Assume that the project
being considered has normal cash flows, with one outflow followed by a series
of inflows.
A. If a project has normal cash flows and its IRR exceeds its cost of
capital, then the project’s NPV must be positive.
B. The IRR calculation implicitly assumes that cash flows are withdrawn
from the business rather than being reinvested in the business.
C. The IRR calculation implicitly assumes that all cash flows are
reinvested at the cost of capital.
D. If Project A has a higher IRR than project B, then Project A must also
have a higher NPV.
20
References
Printed Materials:
Valix, Conrado T. and Peralta. Jose F. (2000). Financial Accounting Vol. II.
Claro M. Recto, Manila: Conanan Educational Supply.
Website:
Jack and the Beanstalk: A Risk Assessment (2016, December 16). Retrieved
July 22, 2020 from https://terryburridge.wordpress.som/2016/
12/16/jack-and-the-beanstalk-risk-assessment-story.html
Understanding the risk-return tradeoff and how it can help you invest wisely
(n.d). Retrieved July 26, 2020 from https://finpeg.com/blog/riks-
return-trade-off.html
How to calculate Risk Return Trade Off (n.d). retrieved July 26, 2020 from
https://www.motilaloswal.com/article_new.aspx/1844/Understanding-
your-risk-return-trade-off-before-investing-in-equities.html
21