Optimal Financial Planning Under Constraints
docx
keyboard_arrow_up
School
Kibabii University College *
*We aren’t endorsed by this school
Course
1110
Subject
Finance
Date
Nov 24, 2024
Type
docx
Pages
9
Uploaded by WAMURE
1
Optimal Financial Planning Under Constraints
By (Name)
Affiliation
Course
Instructor
Date
2
Part 1 - The Investment Portfolio
Introduction
This section will examine several investment possibilities and apply linear programming
to ascertain the best way to divide the client's $150,000 into shares and a savings account. In
order to choose the best bank account and share alternatives, preliminary research will be done,
taking into account variables like interest rates, fees, and possible returns. These will influence
the linear programming problem's objective function and constraints. To illustrate how the ideal
investment combination is determined based on maximizing returns within the client's risk
profile, comprehensive computations and graphs will be shown. Assumptions and limitations
will also be covered.
Client Information
Based on discussions with the client, it has been determined that they have $150,000
available to invest for a 1 year timeframe. The client is relatively conservative and risk-averse in
their investment approach. They expressed a strong preference to minimize their exposure to
volatile assets like shares. Specifically, the client specified that the amount invested in shares
should be less than or equal to half of the amount invested in lower-risk savings accounts. This
constraint will inform the linear programming analysis to determine the optimal investment
portfolio allocation. Other factors such as expected returns, interest rates, fees and the client's
desire to maximize their profits within their risk tolerance will also inform the analysis. A
tailored investment portfolio recommendation will be presented to align with the client’s
conservative risk appetite and goal of maximizing returns on their $150,000 lump sum
investment. Word count: 150
Banking Options
3
After researching savings account options from major Australian banks, I recommend
investing the savings portion of the portfolio into the RAMS Saver Account offered by Westpac.
This account offers a competitive ongoing variable interest rate of 3.00% p.a. with no ongoing
fees (Westpac, 2023). The account requires a minimum deposit of $200 to open and $0 to
maintain the minimum balance. Interest is calculated daily and paid monthly. One limitation is
that the interest rate is variable and subject to change, however the rate has remained steady at
3.00% for the past year indicating stability. The RAMS Saver Account was selected for its high
interest rate, no fees, and easy online accessibility for the client to deposit, track, and withdraw
funds.
Based on an initial investment of $100,000 into this savings account at the current
published rate of 3.00% p.a., the expected return after 1 year is $103,000, calculated as follows:
Original Deposit: $100,000
Interest Rate: 3.00% p.a
Interest Earned in 1 Year: $100,000 x 0.03 = $3,000
Balance after 1 Year: $100,000 + $3,000 = $103,000
In summary, the RAMS Saver Account is recommended to optimize returns on the
savings portion of the client’s portfolio based on its highly competitive interest rate and no fees
structure.
Investment in Shares Options
After researching companies listed on the Australian Securities Exchange (ASX), I
recommend investing the shares portion of the portfolio into HMC Capital Ltd (HMC). HMC is
an investment management services company that offers stable returns. As of November 16th,
2023, HMC is trading at $9.60 per share, up 2.1% from $9.40 per share at the start of the year
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
(ASX, 2023). This indicates a healthy upwards trajectory and potential for further capital
appreciation. Dividends are paid biannually and the current dividend yield is 5% or $0.48 per
share annually. There are no trading fees to buy or sell HMC shares through most standard online
brokers.
Based on the current share price of $9.60 and dividend yield of 5%, the expected total
return in the first year from investing $50,000 into HMC shares is:
- Capital appreciation of 2.1% of $50,000 = $1,050
- Dividend income of 5% of $50,000 = $2,500
- Total expected return = $1,050 + $2,500 = $3,550
This equates to an expected return of $3,550 on an initial $50,000 investment, or 5.8%
total return over the 1 year time horizon.
In summary, investing in HMC shares is expected to provide the highest returns on the
shares portion of the portfolio based on strong historical performance and steady dividend
payments.
Analysis
To determine the optimal investment allocation, a linear programming model was
formulated with the objective of maximizing total returns within the client's conservative risk
tolerance. The decision variables were:
x = amount invested in the RAMS Saver Account
y = amount invested in HMC shares
The constraints were:
1) x + y = $150,000 (Total amount available to invest)
2) y ≤ 0.5x (Amount in shares ≤ 50% of amount in savings)
5
3) x ≥ 0 and y ≥ 0 (Non-negativity constraints)
4) x ≤ $150,000 (Maximum amount to invest in savings)
5) y ≤ $150,000 (Maximum amount to invest in shares)
The objective function was:
Maximize: R = 0.03x + 0.058y
Where 0.03 is the expected 3% return from the savings account, and 0.058 is the expected
5.8% return from HMC shares based on current performance.
Optimal solution was obtained:
Constraint
Equation
Values (x, y)
1
x
+
y
=150,000
(0, 150,000), (100,000, 50,000)
2
y
≤32
x
(0, 0), (100,000, 66,667)
3
y
≥0.5
x
(0, 0), (100,000, 50,000)
4
x
≤100,000
(0, 50,000), (100,000, 50,000)
5
y
≤50,000
(0, 0), (100,000, 50,000)
Appendix A
6
0
20000
40000
60000
80000
100000
120000
140000
160000
0
20000
40000
60000
80000
100000
120000
140000
160000
(100,000, 50,000) ---------------
\
\
(0, 150,000) ------------------------ (100,000, 50,000)
/
(0, 0) -----------------------------/
(0, 50,000)
x = $100,000
y = $50,000
Therefore, the maximum returns within the client's risk tolerance is achieved by investing
$100,000 in the RAMS Saver Account and $50,000 in HMC shares.
The total expected return after 1 year is:
Return on $100,000 in savings at 3% interest = $3,000
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
Return on $50,000 in shares at 5.8% return = $2,900
Total Expected Return = $3,000 + $2,900 = $5,900
This demonstrates that by optimizing the investment portfolio allocation using linear
programming, the maximum first year returns possible within the client’s risk profile is $5,900.
Conclusion
In conclusion, this analysis determined an optimal portfolio allocation of $100,000 in a
RAMS Saver Account and $50,000 invested in HMC shares to maximize expected returns within
the client’s conservative risk tolerance. Applying linear programming led to an expected total
return of $5,900 in the first year. This demonstrates an optimized investment strategy tailored
specifically to the client’s financial situation and goals. While assumptions were made about
expected returns, this provides a basis for an investment plan that aligns with the client’s
objectives. Overall, a balanced approach between savings and shares was recommended to
generate optimal returns on the client’s $150,000 lump sum investment.
8
Reference
ASX. (2023). HMC Historical Share Prices. Retrieved from
https://www.asx.com.au/HMC
Westpac. (2023). RAMS Saver Account. Retrieved from
https://www.westpac.com.au/personal-
banking/bank-accounts/savings-accounts/rams-saver-account/
9
Appendix A
0
20000
40000
60000
80000
100000
120000
140000
160000
0
20000
40000
60000
80000
100000
120000
140000
160000
Appendix B
Constraint
Equation
Values (x, y)
1
x
+
y
=150,000
(0, 150,000), (100,000, 50,000)
2
y
≤32
x
(0, 0), (100,000, 66,667)
3
y
≥0.5
x
(0, 0), (100,000, 50,000)
4
x
≤100,000
(0, 50,000), (100,000, 50,000)
5
y
≤50,000
(0, 0), (100,000, 50,000)
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
Corporate Finance Application Complete both parts of this assignment. You will work on some of these pieces earlier in the course when you submit the Module 3: Portfolio Milestone and the Module 5 Portfolio Milestone. Part One: Ratio Analysis Pick one debt ratio and one profitability ratio, which you did not analyze, from the week three portfolio milestone. Research a publicly traded technology company and access the financial statements needed to calculate those two ratios. Provide a cross-sectional analysis comparing the results from TechnoTCL Download TechnoTCLand your chosen company for the two ratios. Prepare a presentation (maximum of 4 slides – no speaker notes required) with the following information: Slide One: Analyze the two ratios including how the ratio is calculated and how it is used. Slide Two: Introduce the public company chosen, describe the information used for the ratios and calculate the two selected ratios. Slide Three: Show the two ratios for the two companies…
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working!
arrow_forward
Topic: Exploring the Growing Popularity of Mutual Funds in US Capital Markets
Explain why this topic is interesting in the field of business.
What is the brief history of the problem? This consists of a summary and results of prior research articles
Finally, the learner needs to demonstrate why this proposed study is needed for academic research. Explain why it will expand academic literature, contribute to society, or the professional environment. Who is the intended audience for this research? Dear Expect please note the topic highlighted above as a guideline for answering the questions that follow. This is a dissertation.Thank you.
arrow_forward
Briefly explain the following investment channels with each one’s own returns and Risks.
Bank Deposits
Insurance Certificates
National Savings Certificates
Private Company’s shares
Precious metal investment
arrow_forward
Which of the following would be part of a financial manager's investment decision? *a. Collecting receivables from customersb. Paying loansc. Allocating funds for permanent current assetsd. Paying dividends to shareholders
arrow_forward
Asset allocation is the decision of how you divide your investment portfolio between various assets. Typical asset categories include cash or short-term securities (Treasury bills, CDs, etc.), bonds (municipal bonds, corporate bonds, etc.), and equity funds or equities (stocks, stock mutual funds, etc.).
The following table illustrates several model portfolios that you can use as a basis for your own investment plan, depending on such factors as your time horizon, risk tolerance, and investment philosophy.
Model Portfolios and Time Horizons
Risk Tolerance/Investment Philosophy
0–5 Years
6–10 Years
11+ Years
High Risk/Aggressive
10% Cash
20% Bonds
100% Equities
30% Bonds
80% Equities
60% Equities
Moderate Risk/Moderate
20% Cash
10% Cash
20% Bonds
40% Bonds
30% Bonds
80% Equities
40% Equities
60% Equities
Low Risk/Conservative
35% Cash
20% Cash
10% Cash
40% Bonds
40% Bonds
30% Bonds
25% Equities
40% Equities
60% Equities…
arrow_forward
Asset allocation is the decision of how you divide your investment portfolio between various assets. Typical asset categories include cash or short-term securities (Treasury bills, CDs, etc.), bonds (municipal bonds, corporate bonds, etc.), and equity funds or equities (stocks, stock mutual funds, etc.).
The following table illustrates several model portfolios that you can use as a basis for your own investment plan, depending on such factors as your time horizon, risk tolerance, and investment philosophy.
Model Portfolios and Time Horizons
Risk Tolerance/Investment Philosophy
0–5 Years
6–10 Years
11+ Years
High Risk/Aggressive
10% Cash
20% Bonds
100% Equities
30% Bonds
80% Equities
60% Equities
Moderate Risk/Moderate
20% Cash
10% Cash
20% Bonds
40% Bonds
30% Bonds
80% Equities
40% Equities
60% Equities
Low Risk/Conservative
35% Cash
20% Cash
10% Cash
40% Bonds
40% Bonds
30% Bonds
25% Equities
40% Equities
60% Equities…
arrow_forward
Choose the correct option
A major activity in the planning component of financial planning is:
a. selecting insurance coverage
b. evaluating investment alternatives.c. gaining occupational training and experience. d. allocating current resources for spending
e. establishing line of credit
arrow_forward
Case Questions
Directions: Using the data provided, and your knowledge of finance, answer all questions listed below. Qualitative questions can be addressed in a word document; calculations, including all work required for each question, should be submitted on an Excel spreadsheet.
Note on Question #6: NPV calculations should use the formula for TVM based on =NPV(rate, value 1, value 2...)+original purchase price as a negative. You DO NOT need to calculated the XNPV values.
Question #1What are the total revenues for Property 1?
Question #2What are the revenues for Property 2 in September 2019?
Question #3What are the costs for Property 3 in October 2020?
Question #4What are total revenues less total costs for Property 4a?
Question #5What is the absolute value of difference in operating costs between Properties 4a and 4b?
Question #6Using the provided data, calculate the NPV for each project.
Question #7: Analyzing your data from Property 4, should you complete the overhaul (choice B)…
arrow_forward
Imagine that you are a financial manager researching investments for your client. Think of a friend or a family member as a client. Define their characteristics and goals such as an employee or employer, relatively young (less than 40 years) or close to retirement, having some savings/property, a risk taker or risk averter, etc. Next, use Nexis Uni at the Strayer University library, located at Nexis Uni, click on “Company Dossier” to research the stock of any U.S. publicly traded company that you may consider as an investment opportunity for your client. Your investment should align with your client’s investment goals. (Note: Please ensure that you are able to find enough information about this company in order to complete this assignment. You will create an appendix, in which you will insert related information.)
Provide a rationale for the stock that you selected, indicating the significant economic, financial, and other factors that led you to consider this stock.
Suggest the…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780357033609/9780357033609_smallCoverImage.jpg)
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Related Questions
- Corporate Finance Application Complete both parts of this assignment. You will work on some of these pieces earlier in the course when you submit the Module 3: Portfolio Milestone and the Module 5 Portfolio Milestone. Part One: Ratio Analysis Pick one debt ratio and one profitability ratio, which you did not analyze, from the week three portfolio milestone. Research a publicly traded technology company and access the financial statements needed to calculate those two ratios. Provide a cross-sectional analysis comparing the results from TechnoTCL Download TechnoTCLand your chosen company for the two ratios. Prepare a presentation (maximum of 4 slides – no speaker notes required) with the following information: Slide One: Analyze the two ratios including how the ratio is calculated and how it is used. Slide Two: Introduce the public company chosen, describe the information used for the ratios and calculate the two selected ratios. Slide Three: Show the two ratios for the two companies…arrow_forwardhelp please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working!arrow_forwardTopic: Exploring the Growing Popularity of Mutual Funds in US Capital Markets Explain why this topic is interesting in the field of business. What is the brief history of the problem? This consists of a summary and results of prior research articles Finally, the learner needs to demonstrate why this proposed study is needed for academic research. Explain why it will expand academic literature, contribute to society, or the professional environment. Who is the intended audience for this research? Dear Expect please note the topic highlighted above as a guideline for answering the questions that follow. This is a dissertation.Thank you.arrow_forward
- Briefly explain the following investment channels with each one’s own returns and Risks. Bank Deposits Insurance Certificates National Savings Certificates Private Company’s shares Precious metal investmentarrow_forwardWhich of the following would be part of a financial manager's investment decision? *a. Collecting receivables from customersb. Paying loansc. Allocating funds for permanent current assetsd. Paying dividends to shareholdersarrow_forwardAsset allocation is the decision of how you divide your investment portfolio between various assets. Typical asset categories include cash or short-term securities (Treasury bills, CDs, etc.), bonds (municipal bonds, corporate bonds, etc.), and equity funds or equities (stocks, stock mutual funds, etc.). The following table illustrates several model portfolios that you can use as a basis for your own investment plan, depending on such factors as your time horizon, risk tolerance, and investment philosophy. Model Portfolios and Time Horizons Risk Tolerance/Investment Philosophy 0–5 Years 6–10 Years 11+ Years High Risk/Aggressive 10% Cash 20% Bonds 100% Equities 30% Bonds 80% Equities 60% Equities Moderate Risk/Moderate 20% Cash 10% Cash 20% Bonds 40% Bonds 30% Bonds 80% Equities 40% Equities 60% Equities Low Risk/Conservative 35% Cash 20% Cash 10% Cash 40% Bonds 40% Bonds 30% Bonds 25% Equities 40% Equities 60% Equities…arrow_forward
- Asset allocation is the decision of how you divide your investment portfolio between various assets. Typical asset categories include cash or short-term securities (Treasury bills, CDs, etc.), bonds (municipal bonds, corporate bonds, etc.), and equity funds or equities (stocks, stock mutual funds, etc.). The following table illustrates several model portfolios that you can use as a basis for your own investment plan, depending on such factors as your time horizon, risk tolerance, and investment philosophy. Model Portfolios and Time Horizons Risk Tolerance/Investment Philosophy 0–5 Years 6–10 Years 11+ Years High Risk/Aggressive 10% Cash 20% Bonds 100% Equities 30% Bonds 80% Equities 60% Equities Moderate Risk/Moderate 20% Cash 10% Cash 20% Bonds 40% Bonds 30% Bonds 80% Equities 40% Equities 60% Equities Low Risk/Conservative 35% Cash 20% Cash 10% Cash 40% Bonds 40% Bonds 30% Bonds 25% Equities 40% Equities 60% Equities…arrow_forwardChoose the correct option A major activity in the planning component of financial planning is: a. selecting insurance coverage b. evaluating investment alternatives.c. gaining occupational training and experience. d. allocating current resources for spending e. establishing line of creditarrow_forwardCase Questions Directions: Using the data provided, and your knowledge of finance, answer all questions listed below. Qualitative questions can be addressed in a word document; calculations, including all work required for each question, should be submitted on an Excel spreadsheet. Note on Question #6: NPV calculations should use the formula for TVM based on =NPV(rate, value 1, value 2...)+original purchase price as a negative. You DO NOT need to calculated the XNPV values. Question #1What are the total revenues for Property 1? Question #2What are the revenues for Property 2 in September 2019? Question #3What are the costs for Property 3 in October 2020? Question #4What are total revenues less total costs for Property 4a? Question #5What is the absolute value of difference in operating costs between Properties 4a and 4b? Question #6Using the provided data, calculate the NPV for each project. Question #7: Analyzing your data from Property 4, should you complete the overhaul (choice B)…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780357033609/9780357033609_smallCoverImage.jpg)
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning