Week 2 - Assignment
docx
keyboard_arrow_up
School
SKANS School of Accountancy (Tariq Block Campus) *
*We aren’t endorsed by this school
Course
12009A
Subject
Finance
Date
Nov 24, 2024
Type
docx
Pages
9
Uploaded by MatePowerAlligator34
Week 2 Assignment-Ethics in Financial Services
Maruthi Nallapati
Forbes School of Business and Technology
FIN 680
Marcus Crawford
26/9/2023
1
Active versus Passive Management
Return Performance
Description
1 Year
3 Year
5 Year
10
Year
Voya Large-Cap Growth Fund Class I (PLCIX)
18.13%
4.84%
9.97%
12.87
%
S&P 500 TR USD2Benchmark
19.44%
11.28
%
10.16
%
11.97
%
Northern Income Equity Fund NOIEX (JICAX1)
17.60%
9.39%
8.92%
10.87
%
S&P 500 TR USD2Benchmark
19.44%
11.28
%
10.16
%
11.97
%
MFS Blended Research Value Equity Fund Class
A (BRUDX)
21.89%
12.06
%
10.72
%
12.30
%
S&P 500 TR USD2Benchmark
19.44%
11.28
%
10.16
%
11.97
%
American Funds American Mutual Fund® Class F-
1 (AMFFX)
16.20%
12.15
%
8.80%
10.42
%
S&P 500 TR USD2Benchmark
19.44%
11.28
%
10.16
%
11.97
%
Northern Income Equity Fund NOIEX (NOIEX1)
6.80%
9.27%
7.85%
9.69%
S&P 500 TR USD2Benchmark
19.44%
11.28
%
10.16
%
11.97
%
Return Performance of Actively Managed Funds
The Voya Large-Cap Growth Fund Class I (PLCIX) has underperformed the S&P 500 TR
USD2 benchmark in all time periods analyzed (1 year, 3 years, 5 years, and 10 years). This
means that the fund has generated lower returns for investors compared to the benchmark.
Over the past year, the fund has returned 18.13%, slightly lower than the benchmark's
return of 19.44%. Over the longer term, the fund's 3-year and 5-year returns have also been
lower than the benchmark's, indicating that the fund has not been able to keep up with the
2
market's performance over that time period. However, over a 10-year period, the fund's returns
have been slightly higher than the benchmark's, suggesting that the fund's active management
may have led to some outperformance over a longer time horizon.
The return performance of the Northern Income Equity Fund (NOIEX or JICAX1) over
the past 1, 3, 5, and 10 years has been 17.60%, 9.39%, 8.92%, and 10.87%, respectively. This
means that the fund has had positive returns for each of these time periods. However, compared
to the benchmark index, the S&P 500 TR USD, the fund has underperformed in terms of annual
returns. The S&P 500 TR USD benchmark has had returns of 19.44%, 11.28%, 10.16%, and
11.97% over the same time periods.
This underperformance suggests that the actively managed fund has not been able to
outperform the overall market as measured by the benchmark index. The fund may have not been
able to generate as high returns due to a number of factors, such as higher expenses, lower
diversification, or a less successful investment strategy. Additionally, the fund may have also
experienced lower returns due to its focus on income-producing securities, which may not have
seen as much growth as other sectors in the market.
The above actively managed fund, MFS Blended Research Value Equity Fund Class A,
has shown a consistent outperformance against its benchmark, the S&P 500 TR USD2, over the
past 1, 3, 5, and 10 year periods. In the 1-year time frame, the fund has returned 21.89%,
outpacing the index's return of 19.44% by 2.45%. This could be attributed to the fund's active
management approach, where the fund managers have the flexibility to select stocks that they
believe are undervalued and have the potential for growth, thus leading to higher returns. Over
the 3-year and 5-year time frames, the actively managed fund has also outperformed the index by
0.78% and 0.56% respectively. This further demonstrates the success of the fund managers'
3
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
investment strategy and their ability to generate alpha (excess returns) for investors. Even over
the long-term period of 10 years, the actively managed fund has outperformed the index by
0.33%. This suggests that the fund managers have been able to consistently identify undervalued
stocks and generate superior returns for investors over the past decade.
The return performance of the American Funds American Mutual Fund® Class F-1
(AMFFX) was lower than the S&P 500 TR USD2 benchmark in the 1 year, 3 year, and 5 year
time periods, but higher in the 10 year time period. This suggests that the fund may have
underperformed in the short term, but has shown better performance over a longer period of
time. This could be due to the investment strategy of the fund, which may focus on long-term
growth rather than short-term gains. Additionally, the fund is actively managed, which means
that a team of managers makes investment decisions and actively trades securities in an attempt
to outperform the market. This can result in higher fees and expenses for the fund, which may
contribute to its lower return performance compared to the index. However, it is worth noting
that the AMFFX fund still had positive returns in all time periods and showed stronger
performance in the 10 year period, indicating the potential benefits of active management over a
longer time horizon.
The Northern Income Equity Fund (NOIEX) underperformed its benchmark, the S&P
500 TR USD, in all time periods shown. This means that the fund was not able to achieve the
same level of return as the overall market represented by the index. However, it is worth noting
that the fund still posted positive returns in all time periods, indicating some level of success in
its investment strategy. In the one-year period, NOIEX returned 6.80% compared to the
benchmark's 19.44%. This underperformance can be attributed to market conditions, as the S&P
500 experienced a significant rally in this time period. However, over the longer-term periods of
4
three, five, and ten years, NOIEX still underperformed the benchmark, suggesting that the fund
may not have been able to keep up with the overall market performance. It is also worth noting
that NOIEX is an income fund, which means it may have a different investment strategy
compared to the overall market. Income funds typically focus on generating income for investors
through dividends, which may result in lower returns compared to growth-oriented funds.
Consistent Generation of Alpha by Chosen Funds
Out of the five funds chosen, only one consistently generated alpha, which is the MFS
Blended Research Value Equity Fund Class a (BRUDX). This means that the fund has
consistently outperformed its benchmark, the S&P 500 TR USD2, over the past 1, 3, 5, and 10
year time periods. This suggests that the fund managers have been able to select undervalued
stocks and generate positive returns for investors.
The other four funds, including Voya Large-Cap Growth Fund Class I (PLCIX), Northern
Income Equity Fund NOIEX (JICAX1), American Funds American Mutual Fund® Class F-1
(AMFFX), and Northern Income Equity Fund NOIEX (NOIEX1), have not consistently
generated alpha. While some funds may have outperformed their benchmark in certain time
periods, they have also underperformed in others. This suggests that the funds may have had
some successful periods, but could not consistently beat the market.
It is also worth noting that only one of the five funds, American Funds American Mutual
Fund® Class F-1 (AMFFX), showed consistent positive returns in all time periods analyzed. The
other four funds all had positive returns in the 1-year time frame, but experienced negative
5
returns in one or more of the longer-term time periods. This suggests that the returns of these
funds may be volatile and not consistently positive.
Pros and Cons of Active Management for an Equity Portfolio
Pros:
1. Potential for higher returns: The primary goal of active management is to outperform
the market, also known as generating alpha. This means that with successful stock selection and
market timing, actively managed funds have the potential to generate higher returns for
investors.
2. Flexibility in investment decisions: Actively managed funds have the flexibility to buy
and sell investments based on market trends and the fund manager's investment strategy. This
allows for more nimble decision-making and the ability to take advantage of market
opportunities.
3. Personalized approach: With active management, investors typically have access to a
team of professional fund managers who can provide personalized investment advice and
actively manage their portfolio according to their goals, risk tolerance, and time horizon.
Cons:
1. Higher fees and expenses: Actively managed funds typically charge higher fees and
expenses compared to passively managed funds. These fees can eat into investors' returns and
potentially limit the fund's overall performance.
6
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
2. Increased risk: Because fund managers actively make investment decisions and may
take on higher-risk investments in pursuit of outperformance, actively managed funds can be
riskier than passively managed funds. This can result in higher returns, but also greater potential
losses.
3. No guarantee of performance: While active management aims to outperform the
market, there is no guarantee that fund managers will be successful in achieving this goal. In
fact, research has shown that the majority of actively managed funds underperform their
respective benchmarks over the long term.
4. Limited diversification: Some actively managed funds may have a concentrated
portfolio, meaning they hold a smaller number of stocks compared to passively managed funds.
This lack of diversification can increase the overall risk of the portfolio.
Pros and Cons of Passive Management for an Equity Portfolio
Pros:
1. Lower fees: Passive management typically involves investing in index funds or ETFs,
which have lower fees and expenses compared to actively managed funds. This means investors
can keep more of their returns.
2. Broad market exposure: Passive management involves investing in a broad index or
market, such as the S&P 500, which provides exposure to a wide range of companies. This can
help reduce risk and provide diversification for investors.
7
3. Consistent returns: Unlike actively managed funds, passive funds aim to replicate the
performance of their benchmark index. This means that investors can expect consistent returns,
without the risk of the fund underperforming.
4. Easy to understand: Index funds and ETFs are relatively straightforward investments,
making them easy for investors to understand and track. This can make passive management a
good option for beginner investors or those who prefer a hands-off approach.
Cons:
1. Lack of flexibility: Passive management means following the performance of a specific
benchmark, which limits the fund manager's ability to make changes based on market trends or
their own investment strategy.
2. Limited potential for outperformance: By design, passive funds aim to match the
performance of their benchmark index, so they do not have the potential to outperform the
market. This means that investors may miss out on opportunities for higher returns.
3. No personalized approach: Unlike actively managed funds, passive funds do not offer
personalized investment advice or strategy. They simply aim to replicate the performance of the
index they track.
4. Unable to avoid overvalued stocks: Passive funds hold all or a large number of stocks
in their chosen index, even if some of those stocks are overvalued. This means that investors are
exposed to the potential risks of overvalued stocks.
8
References
Tamplin, T. (2023). Active Management | Definition, Benefits, Drawbacks, Strategies. Finance
Strategists.
https://www.financestrategists.com/wealth-management/investment-
management/active-management/#:~:text=Active%20management%20has%20benefits%2C
%20such,the%20risk%20of%20human%20error.
Nason, D. (2016, December 13). Weighing the pros and cons of active portfolio management.
CNBC.
https://www.cnbc.com/2016/12/12/weighing-the-pros-and-cons-of-active-portfolio-
management.html
BRI Wealth Management. (2021, February 24). The pros and cons of active and passive
Investments - BRI Wealth Management. https://brigroup.co.uk/the-pros-and-cons-of-active-and-
passive-investments/
Snelling, D. (2020, November 3). Investment funds – 12 pros and cons of active and passive
funds
-
Charlton
House.
Charlton
House.
https://charltonhousewealthmanagement.hk/investment-funds-12-pros-and-cons-of-active-and-
passive-funds/
9
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
Related Questions
Week 6 Homework
4.
5.
6.
O
Problem Walk-Through
A company is analyzing two mutually exclusive projects, S and L, with the following cash flows:
0
4
B
Project S
Project L
Icon Key
eBook
%
1
2
3
-$1,000 $879.32 $260
$10 $15
$420 $809.54
-$1,000 $5
$250
The company's WACC is 9.5%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your
answer to two decimal places.
5
Check My Work (1 remaining)
arrow_forward
D
5
=
B
D
D
▪
= Investment A
↓
A
▪
Investment A
Investment B
Investment C
3
9
Investment A
= Investment B
Investment C
Formulas
5 Formulas
B
C
Growth Rate
(Expected) Year 0
11% $3,000
6% $3,000
4% $3,000
Growth Rate
(Expected) Year 0
11% $3,000
D
Year 1
Growth Rate
(Expected) Year 0
11% $3,000
6% $3,000
4% $3,000
"Take each value in column C and multiply it by its adjacent growth rate in column B (which is 1 plus the percentage expected growth)."
ABSOLUTE CELL REFERENCES
Year 5
Year 1
#N/A
Year 1
Formulas
▼
#N/A
#N/A
#N/A
E
#N/A
#N/A
#N/A
▼
▼
Year 2
#N/A
F
Year 2
#N/A
#N/A
#N/A
Year 3
#N/A
G
H
RELATIVE CELL REFERENCES
#N/A
#N/A
#N/A
Year 4
▼
▼
▼
#N/A
▼ #N/A
#N/A
#N/A
#N/A
"Start in column D, then move across allowing the column to change, and multiply the preceding value by its FIXED growth rate in cell $B$13 (which is 1 plus the percentage expected growth) to get the current valu
FIXED COLUMN / RELATIVE ROW CELL REFERENCES
Year 3
Year 4
▼
▼
▼
Year 5
Year 6
#N/A
#N/A
#N/A
#N/A
Year 6…
arrow_forward
Given
Discount rate
14%
Year 5 multiple
5.00
Debt
$ 2,100,000
Year
Cash flows
1
$ 1,100,000
2
1,149,500
3
1,201,228
4
1,255,283
5
1,311,770
Solution
a. Enterprise Value
b. Equity Value
arrow_forward
D
5
=
B
D
D
▪
= Investment A
↓
A
.
Investment A
Investment B
Investment C
3
9
Investment A
= Investment B
Investment C
Formulas
6 Formulas
B
C
Growth Rate
(Expected) Year 0
11% $3,000
6% $3,000
4% $3,000
Growth Rate
(Expected) Year 0
11% $3,000
D
Year 1
Growth Rate
(Expected) Year 0
11% $3,000
6% $3,000
4% $3,000
"Take each value in column C and multiply it by its adjacent growth rate in column B (which is 1 plus the percentage expected growth)."
ABSOLUTE CELL REFERENCES
Year 5
Year 1
#N/A
Year 1
Formulas
▼
#N/A
#N/A
#N/A
E
#N/A
#N/A
#N/A
▼
▼
Year 2
#N/A
F
Year 2
#N/A
#N/A
#N/A
Year 3
#N/A
H
RELATIVE CELL REFERENCES
G
#N/A
#N/A
#N/A
▼
▼
▼
Year 4
#N/A
▼ #N/A
#N/A
#N/A
#N/A
"Start in column D, then move across allowing the column to change, and multiply the preceding value by its FIXED growth rate in cell $B$13 (which is 1 plus the percentage expected growth) to get the current valu
FIXED COLUMN / RELATIVE ROW CELL REFERENCES
Year 3
Year 4
▼
▼
▼
Year 5
Year 6
#N/A
#N/A
#N/A
#N/A
Year 6…
arrow_forward
HI5002 Finance for business
Question 1
You are a newly employed finance manager for Finance Adventure Ltd. The following data is available for the company as of 31 June 2020:
Current assets of $293,950
Current liabilities $68,700
Total assets $765,600
Equity $305,890
Required:
The company’s Management Board required you to evaluate two alternative options of debt funding and equity funding for a new project. What is the job are you doing to complete the task? (referring to one out of 3 important questions of corporate finance for your answer)
Calculate non-current assets, non-current liabilities and build a balance sheet for the company?
Calculate the return on assets (ROA) of the company given that return on equity (ROE) is 35%?
What is the price earnings ratio (PE) of the company, given total number of outstanding ordinary shares is 57,000 and…
arrow_forward
PROJECT 8 QR Spring 2020 Finances - Word
A jrush416
erences
Mailings
Review
View
Help
Tell me what you want to do
A
Aa -
三 T
AaBbCcDc AaBbCcDc AaBbC AAB6CCE
TNormal
T No Spac. Heading 1
Heading 2
Paragraph
Styles
5. Suppose you want to have $900,000 forretirement in 30 years. Your account earns 8% interest.
a) How much would you needto deposit in the account each month
b) How much interest will you earn?
arrow_forward
Super confused
arrow_forward
Question 7
arrow_forward
None
arrow_forward
Princip X
Princip x
Princip X
, Accorc X
O Sophia X
* Premie X
. UNIT X
O icamp. X
"strayer.sophia.org/spcc/principles-of-finance-practice-milestone-1-1/5
3
4
5, 6
8
9
10
11
12 13
14 15
16 17 18
19 20 21 22 23 24
O This is a practice Milestone and does not count towards your score.
Question
Unit 1 Tutorials
A If you need help
Question 5
O Mark this question
What principle of corporate governance requires companies to operate in ways that respect the
social and legal relationships they have with employees and creditors, among others?
O Integrity and ethical behavior
O Disclosure and transparency
O Interests of other stakeholders
O Integrity and ethical behavior
SAVE AND CONTINUE
search
arrow_forward
Question P10-22-B
arrow_forward
Question 2
You are a senior investment consultant at Mercer Investment Consulting. You have
been appointed by Qatar Investment Authority to pick an investment manager to
oversee a US$1 billion portfolio of Asian Equites. Based on your research you identify
two managers who have made your shortlist. The following data is provided for your
consideration which shows performance over the past ten years:
Manager Actual Av Return Standard Deviation
A
B
12.20%
10.80%
14.00%
(b) What is the alpha for Manager A and B?
11.90%
Beta
1.40
1.00
The risk-free rate is 3.5% and the risk premium for the market portfolio is 6%.
(a) Using the CAPM, calculate the expected returns for Manager A and B.
(c) Which manager would you choose for your client? Justify your answer.
arrow_forward
Question
EXHIBIT 1: ANNUAL RETURNS (%)
YEAR
ALUWORKS
AGA
Lyxor USDJIA
Lyxor World
2009
2.00
5.86
5.56
7.69
2010
4.25
22.40
6.11
5.79
2011
-29.40
-27.07
7.94
-3.28
2012
13.23
0.60
18.29
20.75
2013
8.86
-6.84
17.09
14.14
2014
2.31
33.87
14.20
15.06
2015
-2.96
-9.28
-4.71
-4.28
EXHIBIT 2: PORTFOLIO WEIGHTS (%)
ASSETS
EXISTING PORTFOLIO
NEW PORTFOLIO
ALUWORKS
60
40
AGA
40
30
LYXOR
30
Required1.Using the annual return data provided in Exhibit 1 of the case for ALUWORKS and AGA,calculate their mean returns, standard deviations, covariance, and correlation. With these numbers,calculate the standard deviation and return for Desiree Mofakye’s entire portfolio.
2. After adding Lyxor USDJIA, what is the portfolio’s new standard deviation and return? Howdoes the new portfolio compare with the calculation in Question 1?
3. Based on your data analysis, should Desiree Mofakye diversify her portfolio or remain invested in SA and GHANA only?
4. Calculate the…
arrow_forward
/1 16. If an initial investment of $3000.00 had doubled 2 times over the course of 24 years, what is the
interest rate?
a. 1.5%
te24 years
b. 3%
c. 6%
d. 9%
arrow_forward
Question 8
Capital and asset types
Tier1 capital
Tier 2 capital
Corporate debenture
Mortgage loan
Loan to government
('000)
3000
1000
9000
45,000
4000
a) Calculate risk weighted asset
b) Calculating the Capital Adequacy Ratio (CAR)
c) Why Capital Adequacy Ratio Matters?
Risk weight
90%
75%
0
arrow_forward
Details
WACC
0
SGWN-O
1
2
3
4
5
6
7.80%
Project A Project B
-1225
395
402
423
432
489
512
-2146
592.5
603
634.5
648
733.5
768
1. Construct NPV profile table by using cashflows from Project A and B above.
2. Draw NPV profile
3. Compute crossover rate
To receive EC your work has to be done in Excel.
arrow_forward
:
Exercise 24-22A (Algo) Using Excel to compute IRR LO P4
Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company
requires a 10% return from its investments.
Pool
Spa
Initial investment
$ (173,000) $ (118,000)
Net cash flows in
Year 1
41,300
33,300
Ces
Year 2
57,300
51,300
Year 3
81,595
67,300
Year 4
91,700
73,300
Year 5
66,300
25,300
Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.)
IRR
Pool
Spa
%
arrow_forward
11. Calculate the Rate of Return on Investment for Company 2 for the year ending 2019.
arrow_forward
2. Find All four present values
arrow_forward
Incorrect
Question 16
0 / 1 pts
Best Invest seeks to allocate $10,000 between three funds A, B, and
C. Best Invest's goal is to achieve an expected portfolio return of
10% at the lowest possible risk level. Best Invest has ten quarters of
annualized performance data on the three funds that are shown
below and provided in the Excel workbook for this quiz.
Quarter
Fund A
Fund B
Fund C
1
9.90%
5.00%
8.70%
2
8.90%
7.70%
20.50%
3
10.10%
5.10%
36.40%
4
2.00%
17.00%
-13.30%
5
3.00%
5.90%
11.40%
6
7.10%
11.50%
-9.00%
7
5.30%
18.00%
5.20%
8
10.40%
12.50%
47.20%
9
10.50%
19.00%
-3.40%
10
6.80%
12.50%
17.60%
Which of the following statements are true regarding funds A, B, and
C?
(Note: Round answers to two significant digits except for covariance
values which are rounded to 5 significant digits.)
The 10-quarter average performance for fund A is 7.40%.
The 10-quarter standard deviation in performance for fund B is
5.37%.
The 10-quarter covariance in performance between funds A and C is
0.00316
The…
arrow_forward
Answer this financial accounting problem 7 pts
arrow_forward
Problem 9
Intro
Apollo Learnings needs $39 million to build a new campus. The company has a target debt-equity ratio of 1.
The flotation cost for new equity is 9% and the flotation cost for new debt is 4%.
Part 1
What are the weighted average flotation costs as a fraction of the amount invested?
4+ decimals
Submit
Part 2
What is the true cost of building the new campus (in $ million)?
1+ decimals
Submit
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Week 6 Homework 4. 5. 6. O Problem Walk-Through A company is analyzing two mutually exclusive projects, S and L, with the following cash flows: 0 4 B Project S Project L Icon Key eBook % 1 2 3 -$1,000 $879.32 $260 $10 $15 $420 $809.54 -$1,000 $5 $250 The company's WACC is 9.5%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places. 5 Check My Work (1 remaining)arrow_forwardD 5 = B D D ▪ = Investment A ↓ A ▪ Investment A Investment B Investment C 3 9 Investment A = Investment B Investment C Formulas 5 Formulas B C Growth Rate (Expected) Year 0 11% $3,000 6% $3,000 4% $3,000 Growth Rate (Expected) Year 0 11% $3,000 D Year 1 Growth Rate (Expected) Year 0 11% $3,000 6% $3,000 4% $3,000 "Take each value in column C and multiply it by its adjacent growth rate in column B (which is 1 plus the percentage expected growth)." ABSOLUTE CELL REFERENCES Year 5 Year 1 #N/A Year 1 Formulas ▼ #N/A #N/A #N/A E #N/A #N/A #N/A ▼ ▼ Year 2 #N/A F Year 2 #N/A #N/A #N/A Year 3 #N/A G H RELATIVE CELL REFERENCES #N/A #N/A #N/A Year 4 ▼ ▼ ▼ #N/A ▼ #N/A #N/A #N/A #N/A "Start in column D, then move across allowing the column to change, and multiply the preceding value by its FIXED growth rate in cell $B$13 (which is 1 plus the percentage expected growth) to get the current valu FIXED COLUMN / RELATIVE ROW CELL REFERENCES Year 3 Year 4 ▼ ▼ ▼ Year 5 Year 6 #N/A #N/A #N/A #N/A Year 6…arrow_forwardGiven Discount rate 14% Year 5 multiple 5.00 Debt $ 2,100,000 Year Cash flows 1 $ 1,100,000 2 1,149,500 3 1,201,228 4 1,255,283 5 1,311,770 Solution a. Enterprise Value b. Equity Valuearrow_forward
- D 5 = B D D ▪ = Investment A ↓ A . Investment A Investment B Investment C 3 9 Investment A = Investment B Investment C Formulas 6 Formulas B C Growth Rate (Expected) Year 0 11% $3,000 6% $3,000 4% $3,000 Growth Rate (Expected) Year 0 11% $3,000 D Year 1 Growth Rate (Expected) Year 0 11% $3,000 6% $3,000 4% $3,000 "Take each value in column C and multiply it by its adjacent growth rate in column B (which is 1 plus the percentage expected growth)." ABSOLUTE CELL REFERENCES Year 5 Year 1 #N/A Year 1 Formulas ▼ #N/A #N/A #N/A E #N/A #N/A #N/A ▼ ▼ Year 2 #N/A F Year 2 #N/A #N/A #N/A Year 3 #N/A H RELATIVE CELL REFERENCES G #N/A #N/A #N/A ▼ ▼ ▼ Year 4 #N/A ▼ #N/A #N/A #N/A #N/A "Start in column D, then move across allowing the column to change, and multiply the preceding value by its FIXED growth rate in cell $B$13 (which is 1 plus the percentage expected growth) to get the current valu FIXED COLUMN / RELATIVE ROW CELL REFERENCES Year 3 Year 4 ▼ ▼ ▼ Year 5 Year 6 #N/A #N/A #N/A #N/A Year 6…arrow_forwardHI5002 Finance for business Question 1 You are a newly employed finance manager for Finance Adventure Ltd. The following data is available for the company as of 31 June 2020: Current assets of $293,950 Current liabilities $68,700 Total assets $765,600 Equity $305,890 Required: The company’s Management Board required you to evaluate two alternative options of debt funding and equity funding for a new project. What is the job are you doing to complete the task? (referring to one out of 3 important questions of corporate finance for your answer) Calculate non-current assets, non-current liabilities and build a balance sheet for the company? Calculate the return on assets (ROA) of the company given that return on equity (ROE) is 35%? What is the price earnings ratio (PE) of the company, given total number of outstanding ordinary shares is 57,000 and…arrow_forwardPROJECT 8 QR Spring 2020 Finances - Word A jrush416 erences Mailings Review View Help Tell me what you want to do A Aa - 三 T AaBbCcDc AaBbCcDc AaBbC AAB6CCE TNormal T No Spac. Heading 1 Heading 2 Paragraph Styles 5. Suppose you want to have $900,000 forretirement in 30 years. Your account earns 8% interest. a) How much would you needto deposit in the account each month b) How much interest will you earn?arrow_forward
- Princip X Princip x Princip X , Accorc X O Sophia X * Premie X . UNIT X O icamp. X "strayer.sophia.org/spcc/principles-of-finance-practice-milestone-1-1/5 3 4 5, 6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 O This is a practice Milestone and does not count towards your score. Question Unit 1 Tutorials A If you need help Question 5 O Mark this question What principle of corporate governance requires companies to operate in ways that respect the social and legal relationships they have with employees and creditors, among others? O Integrity and ethical behavior O Disclosure and transparency O Interests of other stakeholders O Integrity and ethical behavior SAVE AND CONTINUE searcharrow_forwardQuestion P10-22-Barrow_forwardQuestion 2 You are a senior investment consultant at Mercer Investment Consulting. You have been appointed by Qatar Investment Authority to pick an investment manager to oversee a US$1 billion portfolio of Asian Equites. Based on your research you identify two managers who have made your shortlist. The following data is provided for your consideration which shows performance over the past ten years: Manager Actual Av Return Standard Deviation A B 12.20% 10.80% 14.00% (b) What is the alpha for Manager A and B? 11.90% Beta 1.40 1.00 The risk-free rate is 3.5% and the risk premium for the market portfolio is 6%. (a) Using the CAPM, calculate the expected returns for Manager A and B. (c) Which manager would you choose for your client? Justify your answer.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you