FIN 550 - Milestone Four -Macroeconomic Items
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
550
Subject
Finance
Date
Jan 9, 2024
Type
docx
Pages
7
Uploaded by SargentSandpiperMaster672
1 | P a g e
Milestone Four: Macroeconomic Items
Southern New Hampshire University
FIN 550 – Corporate Financial Management
November 05,2023
Macroeconomic Items
Analyze the
implications
of interest rate changes on any of the calculations you performed.
2 | P a g e
Current Market Interest Rate at 8%
Interest Rate
8.00%
Years
2020
2021
2022
Amounts*
6,373.00
$ 6,991.00
$ 5,604.00
$ Pv*
(5,900.93)
$ (5,993.66)
$ (4,448.64)
$ Total Pv*
(16,343.22)
$ *In millions
If the current market interest rates are 8%, we notice that PepsiCo’s PV will continue to increase in ’20 & ‘21 because the FCF is increasing as well. In 2022 the FCF decreased significantly, causing the PV to decrease as well. When analyzing the relationship between FCF and PV at a high level we notice that they move in the same direction. When FCF increases so does PV and when FCF decreases, PV goes down as well.
Lower Current Market Interest Rate to 4%
Interest Rate
4.00%
Years
2020
2021
2022
Amounts*
6,373.00
$ 6,991.00
$ 5,604.00
$ Pv*
(6,127.88)
$ (6,463.57)
$ (4,981.94)
$ Total Pv*
(17,573.39)
$ *In millions
If the market rates were to decrease from 8% to 4% over the same three-year period, we notice that the total PV for PepsiCo will increase by $1,230. The company finances most of its operations by debt, at the end of 2022 PepsiCo had a total long-term debt of $74.9B. When market rates go down, PepsiCo’s interest expense on debt will decrease. The decrease in market interest rates allows the company to allocate less of its cash flow to service debt. As a result, its FCF increases, allowing the company to pursue other investments or increase its shareholder
3 | P a g e
value. When market rates decrease, the value of existing bonds will increase because the fixed coupon rates on existing bonds become more attractive for the investors when compared to newly issued bonds which offer lower coupon rates. Therefore, the bond prices will increase above their face value which in return will make investors pay a premium to acquire them. The increase in price and demand for the bonds will have a positive effect on the company that is trying to raise capital and they will raise more capital than originally anticipated. A decrease in market interest rates also impacts the PV of the company because it impacts the DCF analysis by lowering the discount rate. A lower discount rate means that future cash flows are worth more in today's terms. Therefore, the PV of a company's future cash flows will increase. As a result, the company looks more attractive to investors, as its assets and expected cash flows are more valuable. (Ehrhardt, M. C., & Brigham, E. F. 2019)
3. Increase Current market Interest Rate to 12%
Interest Rate
12.00%
Years
2020
2021
2022
Amounts*
6,373.00
$ 6,991.00
$ 5,604.00
$ Pv*
(5,690.18)
$ (5,573.18)
$ (3,988.82)
$ Total Pv*
(15,252.18)
$ *In millions
When market interest rates increase from 8% to 12% for the same three-year period, we notice a decrease in FCF and a decrease in total PV of $1,091.04. An increase in market rates means that the company will have to pay a higher interest rate for existing debt, and it will cost the company more to raise new debt. Since PepsiCo is allocating more funds towards the higher interest rate, that means that their FCF will decrease. This will also lead to a decrease in capital investments which will result in smaller revenue and lower FCF. An increase in market interest
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
4 | P a g e
rates will also cause an increase in the discount rate. Since the discount rate is used to calculate a company’s PV, that means that the PV will decrease when the Market rates increase.
How might an issue (negative or positive) within the overall
stock market
impact the company’s stock valuation numbers, other financial variables, or its overall portfolio management? The overall stock market's performance can directly influence a company's stock valuation, financial variables, and portfolio management strategies in different ways depending on the specific company. The stock market’s status of “bear” or “bull” is the one condition that affects all companies. “A bull market refers to major upswing in the markets, while a bear market
is a pronounced market downturn. Bull markets often correspond to periods of economic and job growth; bear markets are often tied to periods of economic decline and a shrinking economy (Wohlner, 2023). During a bear market the stock prices of many companies decline, this results in a lower valuation for the company. Because a bear market happens during an economic decline, the consumers will not purchase items that are non-essential such as sodas and chips. The behavior of the consumer will affect sales and revenues. A decline in sales and revenue will directly influence the company’s financial variables. The downturn in the economy will also impact the company’s liquidity and financing. It can become harder for PepsiCo to raise capital by issuing new equity or debt. Meanwhile, portfolio managers need to make the necessary adjustments to balance their portfolio. They might need to sell underperforming assets and purchase safer investments. They also need to diversify their portfolio to minimize their risk exposure. On the other hand, a bull market will have the opposite effect on PepsiCo. Since the economy is in a period of economic growth, that means that consumers will be spending more money purchasing the various products owned by PepsiCo, directly increasing sales and revenue.
5 | P a g e
The increase in revenue will make it easier for PepsiCo to raise capital at favorable terms. Since the bull market will have a positive impact on the company’s financial variables, that will make the company more attractive to investors and its stock price will increase. Portfolio managers will also adjust their strategies by increasing investments in riskier assets that promise higher returns.
Analyze the impact of any
external factor
(i.e., external to the company) discussed throughout the course on the company’s financial position.
PepsiCo is following a great approach to minimize the effects of external factors on their financial position. In their website the company identifies stakeholders as “groups who directly or indirectly impact our business success, or who are impacted by our operations. The insights that we receive from customers, consumers, shareholders, employees, suppliers, governments, and civil society including non-governmental organizations (NGOs) is critical to how we develop, implement, and evolve our business and sustainability agendas. Engaging with our stakeholders helps us to identify emerging sustainability risks and opportunities, prioritize our efforts, and create long-lasting value for our company and society.” (Stakeholder-engagement, 2023). Even though Pepsi has taken measures to protect itself from external factors, like other large corporations, it will be influenced by a variety of external factors such as economic, political, social, technological, and environmental. As mentioned earlier, economic conditions such as a declining economy or a growing one will affect consumers behavior which in return will directly affect the company’s revenues. Consumer behavior can also negatively affect the company during a bull market if the consumers are moving away from traditional snacks and beverages and are able to afford healthier options that could be more expensive. Since PepsiCo is
a multinational corporation, it is affected by fluctuations in currency exchange rates. “The effects
6 | P a g e
of exchange rates are important because the cash flows in various parts of a multinational corporate system will be denominated in different currencies.” (Ehrhardt, M. C., & Brigham, E. F. 2019) A strong US dollar can reduce the value of overseas profits when converted into the U.S
currency. Some political and regulatory factors that can affect PepsiCo are government regulations and taxation. “The terms under which companies compete, the ability to curtail unprofitable operations, and the terms of trade on various transactions often are determined not in the marketplace but by direct negotiation with host governments.” (Ehrhardt, M. C., & Brigham, E. F. 2019) Domestic government regulations such as changes in health and safety standards and food labeling requirements can impact their profitability as well. Changes in tax laws and rates both in the US and internationally can cause strikingly different after-tax cash flows for identical transactions. Other external factors that can affect PepsiCo is the behavior of their main competitors, especially competitors like Coca-Cola that is strong enough to influence pricing and market share. Lasty, global events like political instability, trade issues and conflicts in different regions of the world affect the companies’ finances by disrupting their supply chain and directly impacting revenue and profits.
References:
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
7 | P a g e
Ehrhardt, M. C., & Brigham, E. F. (2019). Corporate Finance: A Focused Approach (7th ed.). Cengage Learning US.
https://mbsdirect.vitalsource.com/books/9781337910231
Wohlner, R. (2023, September 8). Bear vs Bull Market: Key differences for investors to know | time stamped. Time. https://time.com/personal-finance/article/bear-vs-bull-market/
Stakeholder engagement. PepsicoUpgrade. (2023). https://www.pepsico.com/our-impact/esg-
topics-a-z/stakeholder-engagement
Related Documents
Related Questions
Pls help fast sir pls with explanation also
arrow_forward
No in excell please
arrow_forward
View Policies
Current Attempt in Progress
Write a formula for the quantity described.
The balance in an interest-bearing bank account,
if the balance triples in 20 years.
Let Bo be the initial balance and t be the number of years.
NOTE: Round your answer to three decimal places.
B =
IT
||
eTextbook and Media
2
Q Search
fg
PRE
hp
fg
10
S
>11
H
mehp
arrow_forward
DLTR
TGT
Moody's
Rating and
Date
Baa2
07 July 2023
A2
29, March
2023
Standard and Poor's Global
Rating and last Reviewed
Date
BBB
19 January 2023
A
16, March 2023
b. Explain what the ratings mean based on each agencies credit rating. Based on the
ratings which company would you invest in the company's long term debt issuance?
Why?
arrow_forward
Reported
Horiron Period
S millions
2018
2019
2020
2021
2022 Terminal Period
$14.768 $15454 $16591517,589 $18.644
2711 2880
9.462 10.028 10630 11268 11544
Sales
S15017
NOPAT
3,053
3236
JA10
NCA
12.183
Answer the following requirements assuming a discount rate (WACC) of 735, a terminal period growth rate of 2% common shares outstanding of 328.1 miion, and net nonoperating
obligations (NN0) of 16,204 million
(al Estimate the value of a share of ITWS common stock using the discounted cash flow (DCF model as of December 31, 2018
Instructions:
• Round all answers to the nearest whole number, except for discount factors, shares outstanding (do not roundi and stock price per share.
Round discount factors to 5decimal.places
• Round stock price per share to two decimalplaces
Do not use negative signs with any of your answers
Forecast Horizon
2021
Reported
2020
2022
Terminal Period
(S milions)
2018
2019
increase in NOA
FCFF INOPAT increase in NOA)
Discount factor 1/
Present value of horuon FCFF…
arrow_forward
QUESTION FOUR (4)
a) Suppose that it is JUNE 2022. COCOBOD sells 800,000 tons of premium cocoa
at $2,400 for delivery to Cadbury in JUNE 2023. Under what circumstances will
the short and the long positions make a profit? Draw a diagram showing how the
profit on a long position and a short position vary with the price of the underlying
asset
at
maturity.
b) Consider a simplified balance sheet of a financial institution as below:
Assets
1. Short-term consumer loans
(one year maturity)
2. Long-term consumer loans
(two-year maturity)
Liabilities
GHS50
1. Equity capital(fixed)
GHS20
25
2. Demand deposits
40
3. Three-month Treasury bills
4. Six-month Treasury notes
30
3. Passbook savings
35
4. Three-month CDs
424
30
40
5. Three-year Treasury bonds
70
5. Three-month bankers'
acceptances
20
20
6. Six-month commercial
6. 10-year fixed-rate mortgages
20
paper
60
7. 30-year floating-rate
mortgages (rate adjusted every
nine months)
40
7. One-year time deposits
20
8. Two y me deposits
40
270
270
3…
arrow_forward
Financial Accounting
arrow_forward
Real-Time Data Analysis Exercise
Click the following link to view interest rate data from FRED*. Then use that data to answer the following questions.
*Real-time data provided by Federal Reserve Economic Data (FRED), Federal Reserve Bank of Saint Louis.
Using the data from FRED, enter the values for the interest rates indicated for the date shown below. (Enter your responses exactly as they appear in FRED.)
Series
Series ID
Apr 2023
4.68 %
3.76 %
1-Year Treasury Constant Maturity Rate
3-Year Treasury Constant Maturity Rate
5-Year Treasury Constant Maturity Rate
10-Year Treasury Constant Maturity Rate
20-Year Treasury Constant Maturity Rate
30-Year Treasury Constant Maturity Rate
According to the table above, interest rates are expected to
GS1
GS3
GS5
GS10
GS20
GS30
3.54 %
3.46 %
3.80 %
3.68 %
O A. fall significantly in the future because the yield curve is inverted.
B. rise in the future because the yield curve is relatively flat.
C. rise in the future because the yield curve is…
arrow_forward
From 4.1 to 4.9 use financial calculator
arrow_forward
13
arrow_forward
Find the interest rate

arrow_forward
ere Finsnce Question ba x +
2%208%201130%20Project%20Directions%20Fall2020%20(2).pdf
E A Read aloud y
Draw V
Saving Early Plan 2: Invest $350 at the end of each month into an account paying 7.5%
compounded monthly for 15 years then leave the money in the account earning interest until
retirement (making no additional withdrawals or investments until retirement).
Using the assumptions above, write down your answer to each of the following questions:
6. Create the following table of values for this investment plan, Saving Early Plan 2, (the
table should be handwritten) to find the amount available after 15 years. Write N/A next
to any variable that does not apply and write Solve next to the appropriate variable.
7. Indicate the best formula to use to compute the amount available after 15 years.
8. Substitute the values into the formula and compute how much money will be available
after 15 years.
9. Now create the following table of values for this investment plan, Saving Early Plan 2,…
arrow_forward
Please provide this question solution general accounting
arrow_forward
1
2
3.
4
ΕΟΥ
7
8.
9.
10
20
21
22
23
24
25
26
27
28
29
30
CF
$300 A2
Аз
A4
A5
Five deposits are made at the EOYS 2021-2025, as shown in the CF table above. The deposit amounts decrease by 10% every year. If the interest
rate is 6% compounded annually, what is the amount in the account at the end of 2030?
arrow_forward
a company payis the following dividends
2018
2019
2020
2021
2022
In 2023 they will pay 8.5
WHAT IS THE GROWTH RATE
7
2
3
6
7
arrow_forward
Quèstion 10
In year 2019, the rate on one-year Treasury securities was 12 percent and inflation was measured at 3 percent. What was the real rate of interest in year 20197
O 9%
O 15%
O 12%
O 4%
O None of the listed items is correct
A Moving to another question will save this response.
MacBook Air
esc
%
2
з
4
Q
W
E
R
arrow_forward
please help with this Q
arrow_forward
Please prvode step by step explaination
What is the future value of $14,000 invested for one year at an interest rate of 5% p.a.?
a.
$14700
b.
$13333
c.
$9000
d.
$19000
arrow_forward
Question content area top
Part 1
Calculate the percentage return on a 1-year Treasury bill with a face value of
$10 comma 00010,000
if you pay
$9 comma 764.359,764.35
to purchase it and receive its full face value at maturity.
arrow_forward
Question One
Njenge Bank has the following balance sheet (in millions) with the risk weights in parentheses.
Assets Liabilities and Equity
Cash K20 Deposits K175
OECD Interbank deposits K25 Subordinated debt (2.5 years) K3
Mortgage loans K70 Cumulative preferred stock K5
Consumer loans K70 Equity K2
Total Assets K185 Total Liabilities & Equity K185
In addition, the bank has K30 million in performance-related standby letters of credit (SLCs), and K300 million in six-year interest rate swaps. Credit conversion factors…
arrow_forward
Accounting question
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Related Questions
- Pls help fast sir pls with explanation alsoarrow_forwardNo in excell pleasearrow_forwardView Policies Current Attempt in Progress Write a formula for the quantity described. The balance in an interest-bearing bank account, if the balance triples in 20 years. Let Bo be the initial balance and t be the number of years. NOTE: Round your answer to three decimal places. B = IT || eTextbook and Media 2 Q Search fg PRE hp fg 10 S >11 H mehparrow_forward
- DLTR TGT Moody's Rating and Date Baa2 07 July 2023 A2 29, March 2023 Standard and Poor's Global Rating and last Reviewed Date BBB 19 January 2023 A 16, March 2023 b. Explain what the ratings mean based on each agencies credit rating. Based on the ratings which company would you invest in the company's long term debt issuance? Why?arrow_forwardReported Horiron Period S millions 2018 2019 2020 2021 2022 Terminal Period $14.768 $15454 $16591517,589 $18.644 2711 2880 9.462 10.028 10630 11268 11544 Sales S15017 NOPAT 3,053 3236 JA10 NCA 12.183 Answer the following requirements assuming a discount rate (WACC) of 735, a terminal period growth rate of 2% common shares outstanding of 328.1 miion, and net nonoperating obligations (NN0) of 16,204 million (al Estimate the value of a share of ITWS common stock using the discounted cash flow (DCF model as of December 31, 2018 Instructions: • Round all answers to the nearest whole number, except for discount factors, shares outstanding (do not roundi and stock price per share. Round discount factors to 5decimal.places • Round stock price per share to two decimalplaces Do not use negative signs with any of your answers Forecast Horizon 2021 Reported 2020 2022 Terminal Period (S milions) 2018 2019 increase in NOA FCFF INOPAT increase in NOA) Discount factor 1/ Present value of horuon FCFF…arrow_forwardQUESTION FOUR (4) a) Suppose that it is JUNE 2022. COCOBOD sells 800,000 tons of premium cocoa at $2,400 for delivery to Cadbury in JUNE 2023. Under what circumstances will the short and the long positions make a profit? Draw a diagram showing how the profit on a long position and a short position vary with the price of the underlying asset at maturity. b) Consider a simplified balance sheet of a financial institution as below: Assets 1. Short-term consumer loans (one year maturity) 2. Long-term consumer loans (two-year maturity) Liabilities GHS50 1. Equity capital(fixed) GHS20 25 2. Demand deposits 40 3. Three-month Treasury bills 4. Six-month Treasury notes 30 3. Passbook savings 35 4. Three-month CDs 424 30 40 5. Three-year Treasury bonds 70 5. Three-month bankers' acceptances 20 20 6. Six-month commercial 6. 10-year fixed-rate mortgages 20 paper 60 7. 30-year floating-rate mortgages (rate adjusted every nine months) 40 7. One-year time deposits 20 8. Two y me deposits 40 270 270 3…arrow_forward
- Financial Accountingarrow_forwardReal-Time Data Analysis Exercise Click the following link to view interest rate data from FRED*. Then use that data to answer the following questions. *Real-time data provided by Federal Reserve Economic Data (FRED), Federal Reserve Bank of Saint Louis. Using the data from FRED, enter the values for the interest rates indicated for the date shown below. (Enter your responses exactly as they appear in FRED.) Series Series ID Apr 2023 4.68 % 3.76 % 1-Year Treasury Constant Maturity Rate 3-Year Treasury Constant Maturity Rate 5-Year Treasury Constant Maturity Rate 10-Year Treasury Constant Maturity Rate 20-Year Treasury Constant Maturity Rate 30-Year Treasury Constant Maturity Rate According to the table above, interest rates are expected to GS1 GS3 GS5 GS10 GS20 GS30 3.54 % 3.46 % 3.80 % 3.68 % O A. fall significantly in the future because the yield curve is inverted. B. rise in the future because the yield curve is relatively flat. C. rise in the future because the yield curve is…arrow_forwardFrom 4.1 to 4.9 use financial calculatorarrow_forward
- 13arrow_forwardFind the interest rate arrow_forwardere Finsnce Question ba x + 2%208%201130%20Project%20Directions%20Fall2020%20(2).pdf E A Read aloud y Draw V Saving Early Plan 2: Invest $350 at the end of each month into an account paying 7.5% compounded monthly for 15 years then leave the money in the account earning interest until retirement (making no additional withdrawals or investments until retirement). Using the assumptions above, write down your answer to each of the following questions: 6. Create the following table of values for this investment plan, Saving Early Plan 2, (the table should be handwritten) to find the amount available after 15 years. Write N/A next to any variable that does not apply and write Solve next to the appropriate variable. 7. Indicate the best formula to use to compute the amount available after 15 years. 8. Substitute the values into the formula and compute how much money will be available after 15 years. 9. Now create the following table of values for this investment plan, Saving Early Plan 2,…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
