Final fin 301_2
docx
School
Texas Southern University *
*We aren’t endorsed by this school
Course
460
Subject
Finance
Date
Apr 3, 2024
Type
docx
Pages
6
Uploaded by MateRainDuck43
FIN 301_2 / Dr. Fernandez
FINAL TEST
FINAL
TEST
FIN
301-2
Use your calculator,
Excel,
and
formula to answer all the questions. Make sure you
show
your
work, as I will need to see it to give you credit.
1.
Fill in the following tables.
a.
Future Values = FV = PV × (1+r)
n
Present
Value
Future
Value
Number
of
Periods
Interest
Rate
$55,000.00
$250,000.00
50
$37,500.00
$55,000.00
25
b.
Present Values = FV × [1/(1+r)
n
]
Present
Value
Future
Value
Interest
Rate
Number
of
Periods
$25,000.00
$235,609.76
0.08
$37,000.00
$350,000.00
0.13
c.
Interest rate or discount rate. Fill in the interest rate for the following table Using the interest rate formula, r = (FV/PV)
1/n
– 1
Present
Value
Future
Value
Number
of
Periods
Interest
Rate
$55,000.00
$250,000.00
50
$37,500.00
$55,000.00
25
d.
Waiting period. Fill in the number of periods for the following
table. Using the waiting period formula, n = ln(FV/PV) / ln(1+r).
Present
Value
Future
Value
Interest
Rate
Number
of
Periods
$25,000.00
$235,609.76
0.08
$37,000.00
$350,000.00
0.13
FIN 301_2 / Dr. Fernandez
FINAL TEST
2.
Bill wants to borrow $37,000 for a car. He wants to pay in a period of 4 years. The lender offers a 9% interest rate. Estimate the yearly payment and prepare a loan amortization schedule for the amortized
loan. Show
your
work.
Year
Beg.
Bal.
Payment
Interest
Prin.
Red.
End
Bal.
1
2
3
4
FIN 301_2 / Dr. Fernandez
FINAL TEST
3.
Using the data below, calculate Stock XYZs expected return, E(r), and standard deviation σ (r)
. Show your work.
State of the Economy
Probability of Economic State
Return in Economic State
Recession
30%
27%
Steady
25%
15%
Boom
45%
–30%
E(r)
= ∑Probability of Economic State × Return in Economic State
σ2 (r)= ∑[Return in State
i – E(r)
]2 × Probability of State
i
σ (r) = √ σ
a.
Show the range of results with a 95% probability in the table below
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
s riskier? Explain.
FIN 301_2 / Dr. Fernandez
FINAL TEST
4.
Calculate the portfolio beta for the following combination of stocks.
Investment
Weight
Beta
X
$15,200
0.9
Y
$13,400
1.9
Z
$4,800
0.6
K
$2,500
1.2
a.
Compare the individual stock betas versus the portfolio’s beta. What i
5.
The data below, shows the prices of S&P 500 and Proctor and Gamble (P&G). Use it to answer
the following questions.
S&P
PG
Date
Close*
Close
1-Jan-22
4,515.55
160.45
1-Feb-22
4,373.94
155.89
1-Mar-22
4,530.41
152.80
31-Mar-22
4,131.93
160.55
30-Apr-22
4,132.15
147.88
31-May-22
3,785.38
143.79
30-Jun-22
4,130.29
138.91
31-Jul-22
3,955.00
137.94
31-Aug-22
3,585.62
126.25
30-Sep-22
3,871.98
134.67
31-Oct-22
4,080.11
149.16
1-Dec-22
3,941.26
149.28
7-Dec-22
3,933.92
150.24
a.
Get two new columns with the growth rate of the prices of S&P500 and P&G
b.
Produce a scatter plot with S&P in the horizontal axis.
FIN 301_2 / Dr. Fernandez
FINAL TEST
a.
Add a trend line and find the slope.
c.
Do a linear regression and find Beta for P&G.
a.
Is this a risky asset? Why?
d.
Compare the slope of the trend line in the beta you obtained in the previous question. Comment.
6.
Answer the following questions. SHOW YOUR WORK.
a.
Profits
. What are the profits of the following investments?
Investment
Original Cost
or Invested $
Selling Price of Investment
Distributions Received $
Dollar
Profit
Bond
$889.00
$880.00
$15.00
Bike
$285.00
$120.00
$0.00
b.
Returns. What are the returns on the following investments?
Investment
Original Cost
or Invested $
Selling Price of Investment
Distributions Received $
Percent
Return
Stock
$2,500.00
$3,200.00
$85.00
Bike
$1,520.00
$1,250.00
$0.00
FIN 301_2 / Dr. Fernandez
FINAL TEST
7.
Historical returns. Calculate the variance and standard deviation of Tesla Inc from 2015 to 2020. Use Excel and formulas.
P&G (2018-2022)
Year
Return
2018
5.40%
2019
6.20%
2020
7.01%
2021
9.50%
2022
12.30%
a.
Write your results in the following distribution table and show the range of returns you would obtain with a 68 percent of probability. Is this a safe investment? Why?
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 Documents
Related Questions
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
P
QUESTION 18
Prepare a time diagram for the future value of an ordinary annuity with three payments of $300. Be sure to indicate the periods in which interest is added.
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
BIUS Paragraph
V Arial
1
P
+8
== E
X² X₂
图图 † {;}
田田
EE
Q Search
V 10pt
><
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
CAMER 4
23
SH 50%
:E
+
ABC
A V
IT
V Ix % 0
ΠΩ
HA
V
0 WORDS
Save All Answers
arrow_forward
From 4.1 to 4.9 use financial calculator
arrow_forward
Appendix F - HW Question 5 of 5 - View Policies Show Attempt History Current Attempt in Progress Your answer is incorrect. Patricia Quick made an investment of $7,909.96. From this investment, she will receive $1, 100 annually for the next
15 years starting one year from now. Click here to view the factor table What rate of interest will Patricia's investment be earning for her? (Hint: Use Table 4.) (For calculation purposes, use 5 decimal places as displayed in the factor table
provided. Round answer to 0 decimal places, e.g. 25 %.) Qate of interest %
arrow_forward
Multiple Choice
Assume you are investing $100 today in a savings account. Which one of the following terms refers to the total value
of this investment one year from now?
о
O
O
Future value
Present value
Principal amount
Discounted value
Invested principal
5
Saved
Help Save & Exit
8
Submit
arrow_forward
Dont use ai solution general Accounting question
arrow_forward
Question 25
B0/1 pt 03 3 99
Detail
Suppose you invest $140 a month for 6 years into an account earning 7% compounded monthly.
After 6 years, you leave the money, without making additional deposits, in the account for another
30 years. How much will you have in the end?
24
Question Help: Message instructor
ICalculator
Submit Question
arrow_forward
3SP MAT1060NL04 Math Applications
Question 5
dy
S
You deposit $500 each month into an account earning 6% interest compounded monthly.
a) How much will you have in the account in 35 years?
S
MyOpenMath
c) How much total interest will you earn?
Question Help: Video 1
Submit Question
Video 2
Search
H
arrow_forward
Dyanne Godoy
Math Models B: Practice Test
2. Choose the correct answer.
What is the maturity date of NewZealandGovt 9
16?
1816
2009
2029
2016
2026
O 3. Choose the correct answer.
Bill plans to deposit $1,500 quarterly for 30 years at 5.5% interest, compounded m
the account in 30 years?
$468,780.80
lenova
O O O O O
arrow_forward
A
B
C
Problem 1
Problem 2
Problem 3
Problem 4
Problem 5
D
E
F
G
500.00 How much money do you plan to save each period?
Cell Styles
H
I
J
0.1 Expected return on your savings before retirement (this is an EAR)
0.05 Expected return on your savings during retirement (this is an EAR)
L
Editing
Sensitivity
Add-ins
Analy
Format v
Dat
35 Years until your retirement
25 Years you plan to be in retirement (how long your money needs to last)
12 How frequently do you save money each year? Annually (1), quarterly (4), or monthly (12 times each year)?
18
4.89% Expected return on your savings during retirement (this is an APR)
9.57% Expected return on your savings before retirement (this is an APR)
$1,699,395.51 Amount you'll have in your account at retirement based on the amount you save each period (answer should be about $1,699,396).
$9,824.85 Amount you could spend each period during your retirement
50000 How much money do you currently have in savings?
Problem 6
Problem 7
$3,104,517.35 Amount…
arrow_forward
mni.4
arrow_forward
Find the interest earned on $5,750 deposited into a savings account for 3 1/2 years at an annual interest rate of 4 1/2%
a. What formula should be used?
b. What are you trying to find and what variable does it represent in the formula?
c. Solve the problem showing all of your work (must show all steps!!)
d. Interpet your answer using a complete sentence
You may use the box below to upoload a picture of your written explanation or type it out in the box. Use the "mountain"
button to add pictures.
arrow_forward
esc
A ALEKS-Harley Biltoc - Learn
O Exponential and Logarithmic Functions
Finding the present value of an investment earning compound interest
$
Explanation Check
50
F1
*
To help with a down payment on a home, Rita is going to invest. Assuming an interest rate of 1.67% compounded daily, how much would she have to invest to
have $23,400 after 8 years?
F2
A
Do not round any intermediate computations, and round your final answer to the nearest dollar. If necessary, refer to the list of financial formulas. Assume there
are 365 days in each year.
80
F3
X
9
F4
www-awu.aleks.com
$
myPascoConnect
F5
MacBook Air
F6
Ć
F7
DII
F8
2/5
DD
F9
Portal
F10
© 2023 McGraw Hill LLC. All Rights Reserved. Terms of Use | Privacy Center | Accessibility
Harley V
4
F11
Español
& T
?
A₁
4)
F12
arrow_forward
tion
□ [myUT
1
ovide your answer below:
N
Module 2.5: Understanding
ALT
Courses
CURRENT OBJECTIVE
Calculate the monthly payment and interest cost for a mortgage
Question
A mutual fund manager wishes to purchase a property that's been valued at $1.5 m. She has $200,000 in cash to use as a
deposit, and she will require a mortgage for the rest. The annual interest rate on the loan is 2.45% and the loan is for 25
years. Calculate the monthly payments.
Round your answer to the nearest cent.
Do NOT round until you have calculated the final answer.
X
C
knewton.com
V
B
Module 2.5: Understanding & in
N
FEEDBACK
3
V-
Content
ALT
MORE INSTRUCTION
A
+
2.1
FN
88
11
SUB
SHIFT
4
arrow_forward
Question 4 of 5
Using Technological Tools: Future Value of a Single Sum - Knowledge Check
Knowledge Check
0.34/1
You deposit $600 today into a fund that you intend to leave invested for 6 years. The fund earns 4% interest compounded
annually. Indicate the inputs to be entered into the financial calculator keys. What is the value of the fund to be accumulated at the
end of year 6? (Round future value answer to two decimal places (e.g., 52.75) and interest rate to one decimal place (e.g., 527.5).)
Inputs
Calculator Keys
N
Future value
$
Save for Later
N/A
?
PV
PMT FV
Attempts: 0 of 3 used
Submit Answer
SUPPORT
arrow_forward
MAA MATHEMATICAL ASSOCIATION OF AMERICA
Simple and Compound Interest / 8
Previous Problem Problem List Next Problem
HW 20 Simple and Compound Interest: Problem 8
(2 points)
How much do you need to invest in an account earning an annual interest rate of 3.734% compounded weekly, so that your money will grow to $7,550.00 in 44 weeks?
The amount you need to invest is
(Note: Your answers should include a dollar sign and be accurate to two decimal places)
Preview My Answers
Submit Answers
You have attempted this problem 0 times.
You have unlimited attempts remaining.
Page generated at 05/04/2024 at 02:45pm EDT
WeBWorK 1996-2022 | theme: math4-green | ww_version: 2.17 | pg.version 2.17 | The WaßWork Project
arrow_forward
T
R
E
# 3
%24
Question 15
You want to be able to withdraw $35,000 from your account each year for 25 years after you retire.
You expect to retire in 15 years.
If your account earns 6% interest, how much will you need to deposit each year until retirement to achieve
your retirement goals?
Question Help: D Video
Submit Question
MacBook Ai
DD
08
F3
F8
F4
F5
F2
&
$
4
%
%23
2
9
M
arrow_forward
Fast pls solve this question correctly in details 5 min pls I will give u like for sure
Surbh
arrow_forward
00
2.
Question 11
You deposit $400 each month into an account earning 2% interest compounded monthly.
a) How much will you have in the account in 30 years?
b) How much total money will you put into the account?
24
c) How much total interest will you earn?
24
Question Help: D Video 1 D Video 2
Submit Question
114
08
F3
F6
F5
F4
F2
23
$
4.
arrow_forward
Question 22 solution send me only text typing work
you just won a lottery and are offered three options for the payment(s). Which one would you prefer, based on. the largest present value? The interest rate assumption is 4.5%
A. A payment of $1,2000,000 to paid now.
B. $150,000 per year for the next 10 years.
C. $12,500 paid monthly for 10 years.
Calculate and show your work on how you arrived at your decision to get full credit
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- 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 mehparrow_forwardP QUESTION 18 Prepare a time diagram for the future value of an ordinary annuity with three payments of $300. Be sure to indicate the periods in which interest is added. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIUS Paragraph V Arial 1 P +8 == E X² X₂ 图图 † {;} 田田 EE Q Search V 10pt >< Click Save and Submit to save and submit. Click Save All Answers to save all answers. CAMER 4 23 SH 50% :E + ABC A V IT V Ix % 0 ΠΩ HA V 0 WORDS Save All Answersarrow_forwardFrom 4.1 to 4.9 use financial calculatorarrow_forward
- Appendix F - HW Question 5 of 5 - View Policies Show Attempt History Current Attempt in Progress Your answer is incorrect. Patricia Quick made an investment of $7,909.96. From this investment, she will receive $1, 100 annually for the next 15 years starting one year from now. Click here to view the factor table What rate of interest will Patricia's investment be earning for her? (Hint: Use Table 4.) (For calculation purposes, use 5 decimal places as displayed in the factor table provided. Round answer to 0 decimal places, e.g. 25 %.) Qate of interest %arrow_forwardMultiple Choice Assume you are investing $100 today in a savings account. Which one of the following terms refers to the total value of this investment one year from now? о O O Future value Present value Principal amount Discounted value Invested principal 5 Saved Help Save & Exit 8 Submitarrow_forwardDont use ai solution general Accounting questionarrow_forward
- Question 25 B0/1 pt 03 3 99 Detail Suppose you invest $140 a month for 6 years into an account earning 7% compounded monthly. After 6 years, you leave the money, without making additional deposits, in the account for another 30 years. How much will you have in the end? 24 Question Help: Message instructor ICalculator Submit Questionarrow_forward3SP MAT1060NL04 Math Applications Question 5 dy S You deposit $500 each month into an account earning 6% interest compounded monthly. a) How much will you have in the account in 35 years? S MyOpenMath c) How much total interest will you earn? Question Help: Video 1 Submit Question Video 2 Search Harrow_forwardDyanne Godoy Math Models B: Practice Test 2. Choose the correct answer. What is the maturity date of NewZealandGovt 9 16? 1816 2009 2029 2016 2026 O 3. Choose the correct answer. Bill plans to deposit $1,500 quarterly for 30 years at 5.5% interest, compounded m the account in 30 years? $468,780.80 lenova O O O O Oarrow_forward
- A B C Problem 1 Problem 2 Problem 3 Problem 4 Problem 5 D E F G 500.00 How much money do you plan to save each period? Cell Styles H I J 0.1 Expected return on your savings before retirement (this is an EAR) 0.05 Expected return on your savings during retirement (this is an EAR) L Editing Sensitivity Add-ins Analy Format v Dat 35 Years until your retirement 25 Years you plan to be in retirement (how long your money needs to last) 12 How frequently do you save money each year? Annually (1), quarterly (4), or monthly (12 times each year)? 18 4.89% Expected return on your savings during retirement (this is an APR) 9.57% Expected return on your savings before retirement (this is an APR) $1,699,395.51 Amount you'll have in your account at retirement based on the amount you save each period (answer should be about $1,699,396). $9,824.85 Amount you could spend each period during your retirement 50000 How much money do you currently have in savings? Problem 6 Problem 7 $3,104,517.35 Amount…arrow_forwardmni.4arrow_forwardFind the interest earned on $5,750 deposited into a savings account for 3 1/2 years at an annual interest rate of 4 1/2% a. What formula should be used? b. What are you trying to find and what variable does it represent in the formula? c. Solve the problem showing all of your work (must show all steps!!) d. Interpet your answer using a complete sentence You may use the box below to upoload a picture of your written explanation or type it out in the box. Use the "mountain" button to add pictures.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you