mid-term solutions 2022 1
docx
School
The University of Queensland *
*We aren’t endorsed by this school
Course
2411
Subject
Finance
Date
Apr 3, 2024
Type
docx
Pages
6
Uploaded by ColonelTeamRaccoon28
FINM 2411 MID-TERM SOLUTIONS 2022
Question 1: Total 25 points
Part A: [5 points] You have just entered into a $1 million 30-year mortgage with a rate of 3% p.a. compounding monthly. What is the amount of your monthly repayments? The repayments are a 360-period annuity with present value equal to the amount borrowed:
1,000,000
=
R
[
1
−
(
1.0025
)
−
360
0.0025
]
which implies that the monthly repayment is R=4,216.04.
Part B: [5 points] Assume that 10 years has passed – you just made the 120
th
payment. How much interest did you
pay over the last year?
The principal outstanding after 10 years is the present value of all remaining repayments:
Balance
=
4,216.04
[
1
−
(
1.0025
)
−
240
0.0025
]
which implies that the current loan balance is $760,198.09.
The principal outstanding after 9 years is the present value of all remaining repayments at that
time:
Balance
=
4,216.04
[
1
−
(
1.0025
)
−
258
0.0025
]
which implies that the current loan balance is $787,538.32
Thus, the amount of principal paid off over the last year is:
787,538.32
−
760,198.09
=
27,340.23
.
The total amount paid over the last year is:
12
×
4,216.04
=
50,592.48
.
Thus, the amount of interest paid is:
50,592.48
−
27,340.23
=
23,252.26
.
- 1 -
Part C: [5 points] Continue to assume that 10 years has passed. You have been promoted at work and decide to
increase your monthly payments to $6,000 per month. When will the loan be paid off?
Solve for n in the following equation:
760,198.09
=
6,000
[
1
−
(
1.0025
)
−
n
0.0025
]
where n=152.54. That is, you will make 152 full payments and then a partial payment to close out
the loan.
Part D: [10 points] Ignore part (c) (i.e., go back to the end of part (b) where you have just made the 120
th
monthly
payment). Suppose you lose your job, so you negotiate with the bank that you will make no
payments for the next two years, then you’ll ‘catch up’ and still have the loan paid off at the end of
the initial 30-year period. (Your thinking is that it might take you a while to find the right job, but
when you do, it will involve a high salary). The bank agrees, but proposes that you should pay a
‘penalty’ rate of interest of 6% p.a. (compounded monthly) during the two-year period while you
are making no payments. What is the amount of the new monthly payment – for when you resume
payments after the two-year period?
First note that, at the end of the two-year period, the loan balance will have increased to:
760,198.09
(
1.005
)
24
=
856,864.71
.
The repayments are a 216-period annuity (18 years remaining) with present value equal to the
amount borrowed:
856.864.71
=
R
[
1
−
(
1.0025
)
−
216
0.0025
]
which implies that the monthly repayment is R=5,138.82.
Question 2: Total 25 points
Part A: [15 points] What is the current value of a
$100
4%
government bond that matures in
5
years and 2
months from
today if the yield to maturity is 3% p.a.
(compounding semi-annually)?
Measuring time in years, the cash flow stream is as follows:
- 2 -
First find the value at the time of the first coupon:
2
+
2
[
1
−
(
1.015
)
−
10
0.015
]
+
100
(
1.015
)
10
=
106.61
.
Now discount this back to the present:
106.61
(
1.015
)
2
/
6
=
106.08
.
Graphically, we are performing the following operation:
Part B: [5 points] A one-year $100 zero-coupon bond is currently trading at $97. A two-year zero-coupon bond is
currently trading at $94. What rate of interest could you lock in today for a loan that starts one year
from now and finishes two years from now? Assume that all of these instruments have the same
counterparty, so are of equivalent risk.
The current one-year rate can be found by solving:
97
(
1
+
r
0,1
)
1
=
100
in which case r
0,1
=
3.0928%
.
The current two-year rate can be found by solving:
94
(
1
+
r
0,2
)
2
=
100
in which case r
0,2
=
3.1421%
.
- 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
This implies that the forward rate from time 1 to time 2 must be such that:
(
1
+
r
0,1
)(
1
+
f
1,2
)
=
(
1
+
r
0,2
)
2
(
1.030928
)
(
1
+
f
1,2
)
=
(
1.031421
)
2
where f
1,2
=
3.1915%
.
Part C: [5 points] Consider a collateralised debt obligation based on a reference set of 100 corporate bonds. Assume
that all of the bonds are equally weighted and that the recovery rate is set to 40%. You are
considering a product that loses all of its value once 4.8% of the capital is subject to a credit event.
What is the probability of a total loss of value if we assume that credit events are independent
across bonds and over time, such that each bond has a 3% probability of experiencing a credit event
during the life of the product you are considering?
How does that probability change if we assume that there is a 50/50 chance of the default
probability being 0% or 6% over the relevant period?
First, note that each bond represents 1% of the total capital. Since each credit event results in an
assumed 60% loss of value for that bond, each credit event results in an assumed loss of 0.6% of the
total capital. Hence a ‘detachment point’ of 4.8% pertains to 8 credit events.
The relevant probabilities can be computed from the binomial distribution as follows:
Probability of default
3.00%
6.00%
Number of bonds
100
100
Required number of defaults
8
8
Probability of >= X defaults
1.06%
25.17%
Thus, the probability of total loss, assuming a flat 3% chance of a credit event is 1.06%, and the
probability assuming a 50/50 chance of 0% or 6% is 12.58%.
Question 3: Total 25 points
Part A: [15 points] XYZ pays dividends twice a year at the end of June and December. It is currently the end of March
and the next dividend (paid in June) is expected to be $1 per share. The following dividend (paid in
December) is expected to be 10% higher. Dividend growth is then expected to decline linearly to 3% over the following 10 years. That is, the
dividend in June next year will be somewhat less than 10% bigger than the December dividend.
The growth in the next dividend will be smaller again, and so on. Once we get to the June dividend
10 years from now, growth thereafter will be 3% in perpetuity. (Note: This is 3% growth from one
dividend to the next – it is not annual growth.) If the appropriate discount rate is 10%, what is the present value of this dividend stream?
The present value of this series of cash flows is $101.88. See attached spreadsheet.
- 4 -
Part B: [10 points] You are about to start a new job. You will be paid monthly and $2,500 per month will be paid into
your retirement account. The first payment will be made one year from now. You expect this
amount to increase by 3% on each annual anniversary of your employment. You plan to work for
40
years at which point you will retire. You expect the fund to generate a return of 6% p.a. (Note:
This is an annual rate).
During your retirement, you plan to make annual withdrawals at the beginning
of each year where
each withdrawal should have the same purchasing power as $200,000 today.
Assume that inflation
is expected to be 2.5% p.a.
At what point during your retirement will the funds be exhausted?
What is the most that you could afford to withdraw each year (expressed in current
purchasing power terms like the $200,000 figure above) such that you would have sufficient
funds to cover your expected 30-year retirement?
See the attached spreadsheet. When withdrawals are $200,000 per year real, the funds will be sufficient to cover 17 full years
(given the first withdrawal starts at t=0) and part of the amount for the end of the 17
th
year.
Use Goalseek to set the 30-year closing balance to 0, by changing cell N6. You can afford to
withdraw $137,160 real each year.
Alternatively, by hand:
(
1
+
r
mth
)
=
1.06
Therefore, r
mth
=
0.487 %
FV of annual contribution i.e. annual contribution at end of year 1
FV
=
2500
[
(
1.00487
)
12
−
1
0.00487
]
=
$
30,816.32
Growing this annual contribution at 3%, we have a growing annuity
PV
=
30,816.32
0.06
−
0.03
[
1
−
(
1.03
1.06
)
40
]
=
$
701,438.58
Thus, the future value at retirement is
FV
=
701,438.58
×
(
1
+
6%
)
40
=
$
7,214,799.36
The future value of the first withdrawal, given that it grows with inflation is
200,000
×
(
1
+
2.5%
)
40
=
537,012.77
The first cashflow in the annuity formula (i.e. the second withdrawal) is
- 5 -
537,012.77
×
(
1
+
2.5%
)
=
550,438.09
At what point the funds will be exhausted requires solving for n in a growing annuity formula
7,214,799.36
−
537,012.77
=
550,438.09
0.06
−
0.025
[
1
−
(
1.025
1.06
)
n
]
Using logs, we get
n
=
ln
(
0.5754
)
ln
(
0.9670
)
=
16.46
Reaching the same conclusion that the funds will be able to cover withdrawals up until the end of
the 16
th
year.
To calculate the amount we could afford to draw each year to cover 30 years of withdrawals, need
to solve for P
7,214,799.36
1.06
=
P
0.06
−
0.25
[
1
−
(
1.025
1.06
)
31
]
Note we need to use n=31 to include the first payment that is paid at t=0 of retirement. So that the
annuity formula includes this first cashflow, we need to discount the FV of total funds at retirement
back by one period. The ‘P’ used here refers to the cashflow at t=0
Solving the above, we get P
=
368,283.44
Discounting this back to present value, we have
368,283.44
1.025
40
=
$
137,160
This reconciles with the Goalseek excel method.
- 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
Related Questions
QUESTION ONEA fully amortizing mortgage loan is made for sh.100,000 at 6 percent interest for 20 years.Required;Calculate the monthly payment for a CPM loan.What will the total of payments be for the entire 20-year period? Of this total, how much will be interest?Assume the loan is repaid at the end of 8 years. What will be the outstanding balance? How much total interest will have been collected by then?The borrower now chooses to reduce the loan balance by sh.5,000 at the end of year 8.What will be the new loan maturity assuming that loan payments are not reduced?Assume the loan maturity will not be reduced. What will the new payments be?
arrow_forward
Question 14
Suppose for an annuity due, you want to have $30,000 in the bank after 20 years. Assuming you make deposits at the beginning of
each year at an interest rate of 4%, how much would you have to deposit at the start of each year, assuming that each deposit is the
same amount?
A) s968.70
B
$816.22
$625.00
$737.24
arrow_forward
Qw.12.a
A fully amortizing mortgage loan is made for $104,000 at 6 percent interest for 20 years. Required: a. Calculate the monthly payment for a CPM loan. b. What will the total of payments be for the entire 20-year period? Of this total, how much will be the interest? c. Assume the loan is repaid at the end of eight years. What will be the outstanding balance? How much total interest will have been collected by then? d. The borrower now chooses to reduce the loan balance by $5,400 at the end of year 8. (1) What will be the new loan maturity assuming that loan payments are not reduced? (2) Assume the loan maturity will not be reduced. What will the new payments be?
arrow_forward
+II
MI
A loan of $14,800 is to be amortized with quarterly payments over 7 years. If the interest on the loan is 8% per year, paid on the unpaid balance, answer the following
questions.
a. What is the interest rate charged each quarter on the unpaid balance?
b. How many payments are made to repay the loan?
c. What payment is required quarterly to amortize the loan?
a. The interest rate each quarter is %.
2
uide
tents
access
Enter your answer in the answer box and then click Check Answer.
Success
2 parts
remaining
Clear All
Check Answer
edia Library
ase Options
SO Type here to search
近
L.
PrtSc
Delete
Esc
同回
F10
+D
F5
F7
F8
F11
F12
区
6
F2
F4
&
%23
$
2
7
5.
6
3.
4.
R.
P.
C
A
G
K
7.
B.
Alt
Ctrl
Alt
Home
arrow_forward
1Assume you plan to borrow $400,000 from your bank to buy a home. The bank offers: • a 5-year fixed rate of 6.05%, compounded monthly. • a 3-year fixed rate of 5.75%, compounded monthly. If you choose to repay the borrowing in equal installments monthly over a 20 years, what would be the difference between your monthly payments at the two different APRs? a. $89.32 b. $68.94 c. $26.98 d. $154.58
2You expect that the interest rate will decrease in the near future, therefore you eventually choose the 3-year fixed rate. Then, what will be your mortgage balance after 3 years? a. $321,598.59 b. $452,321.21 c. $365,056.12 d. $379,325.89
3Three years passed, it's time to renew your mortgage. Upon your renewal, your bank is now offering a new 3-year fixed rate of 4.5%, what would be your monthly repayment amount after renewal? a. 2825.32 b. 2598.54 c. 1965.21 d. 2563.60
4How much interests in total you have paid during the first 3 years of your mortgage? a. $54,365.22 b. $45,654.21 c.…
arrow_forward
ques 1
arrow_forward
Suppose that the mortgage loan described in question 10 is a one-year adjustable rate
mortgage (ARM), which means that the 10.5% interest applies for only the first year.If the interest rate goes up to 12% in the second year of the loan, what will your new monthly payment be?
arrow_forward
QUESTION 1
A bank makes a 30 year Fully Amortizing, Fixed Rate Mortgage (FRM) for $2,000,000 at an annual interest rate of 4.125% compounded monthly, with monthly
payments. What is the market value of this loan after 7 years of payments if the annual interest rate for this loan is 10% compounded monthly?
O A. $ 680,688.05
O B. $1,045,425.62
OC. $1,726,113.67
O D.$1,101,017.63
arrow_forward
D
Question 18
Consider a 20-year mortgage for $182,892 at an annual interest rate of 5.3%. After 7 years, the mortgage is refinanced to an annual interest rate of
2.5%. What are the monthly payments after refinancing?
Round your answer to the nearest dollar.
arrow_forward
Solve this problem
arrow_forward
Consider a 30-year, fixed-rate mortgage for $120,000 at a nominal rate of 6% with monthly payments. If the borrower pays an additional $120 with each monthly payment, what will be the amount of the last monthly payment?
A.
$839.46
B.
$357.77
C.
$843.66
D.
$419.85
E.
$355.99
F.
$420.90
G.
$418.81
H.
$841.55
arrow_forward
What amount today
arrow_forward
Question 5
How much the monthly payment on a $114,000 home be if you get
4.1% interest over a 15 year loan with a $25,000 dollar balloon
payment (rounded to the nearest dollar)?
arrow_forward
Give me answer general accounting
arrow_forward
2. Problem 5.17 (Effective Interest Rate)
еВook
You borrow $225,000; the annual loan payments are $30,017.40 for 30 years. What interest rate are you being charged? Round your answer to the nearest
whole number.
%
arrow_forward
ASSIGNMENT #2 MA10078 LOANS & MORTGAGES (1) LUMP SUM PAYMENT. $200,000 mortgage with a 5 year term at 6% compounded semi-annually is amortized for 25 years with monthly payments. The client can put 20% of the original mortgage down without penalty once/year. At the end of the 2nd year he paid a lump sum amount. (a) What was the lump sum payment? (b) How much will the mortgage be shortened? Answer in years & months. (2) A $100,000 mortgage with monthly payments is amortized for 25 years. At the end of 5 years they increased their monthly payments by 20%. Interest is 7.5% compounded semi-annually. How much will the mortgage be shortened? (3) A $500,000 mortgage is amortized for 25 years with monthly payments. Interest is 4% compounded semi-annually. Round the monthly payments UP TO THE NEAREST $100. How much will the amortization be shortened? And what is the final payment? (4) A $40,000 loan has monthly payments of $300 at 5% compounded semi-annually. Find the final payment. How…
arrow_forward
Question 2:
You borrow a five-year $13,000 loan with monthly payments of S250. What is the annual
percentage rate (APR) on the loan?
arrow_forward
fx
D.
Amount of loan:
%24
50,000
Annual payment:
%24
10,000
Interest rate:
8%
6.
How many years will it take to pay off the loan?
arrow_forward
QUESTION 6
You have a 7-year loan of $80,000. The borrower will pay $8,500 at the end of Year 1, $9,500 at the end of Year 2, and $7,500
at the end of Year 3, plus X at the end of each year from Year 4 through Year 7. X is the fixed but unspecified cash flow. The
loan's rate is 9%. What is X?
O $22,3617.01
O $21,954.25
$23,350.31
O $19,411.02
arrow_forward
Q1
arrow_forward
Jaspreet received a 15 year loan of $300,000 to purchase a house. The interest rate on
the loan was 3.70% compounded semi-annually.
a. What is the size of the monthly loan payment?
$0.00
Round to the nearest cent
Question 5 of 6
b. What is the balance of the loan at the end of year 2?
$0.00
Round to the nearest cent
c. By how much will the amortization period shorten if Jaspreet makes an extra
payment of $30,000 at the end of year 2?
SUBMIT QUESTION
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

PFIN (with PFIN Online, 1 term (6 months) Printed...
Finance
ISBN:9781337117005
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Related Questions
- QUESTION ONEA fully amortizing mortgage loan is made for sh.100,000 at 6 percent interest for 20 years.Required;Calculate the monthly payment for a CPM loan.What will the total of payments be for the entire 20-year period? Of this total, how much will be interest?Assume the loan is repaid at the end of 8 years. What will be the outstanding balance? How much total interest will have been collected by then?The borrower now chooses to reduce the loan balance by sh.5,000 at the end of year 8.What will be the new loan maturity assuming that loan payments are not reduced?Assume the loan maturity will not be reduced. What will the new payments be?arrow_forwardQuestion 14 Suppose for an annuity due, you want to have $30,000 in the bank after 20 years. Assuming you make deposits at the beginning of each year at an interest rate of 4%, how much would you have to deposit at the start of each year, assuming that each deposit is the same amount? A) s968.70 B $816.22 $625.00 $737.24arrow_forwardQw.12.a A fully amortizing mortgage loan is made for $104,000 at 6 percent interest for 20 years. Required: a. Calculate the monthly payment for a CPM loan. b. What will the total of payments be for the entire 20-year period? Of this total, how much will be the interest? c. Assume the loan is repaid at the end of eight years. What will be the outstanding balance? How much total interest will have been collected by then? d. The borrower now chooses to reduce the loan balance by $5,400 at the end of year 8. (1) What will be the new loan maturity assuming that loan payments are not reduced? (2) Assume the loan maturity will not be reduced. What will the new payments be?arrow_forward
- +II MI A loan of $14,800 is to be amortized with quarterly payments over 7 years. If the interest on the loan is 8% per year, paid on the unpaid balance, answer the following questions. a. What is the interest rate charged each quarter on the unpaid balance? b. How many payments are made to repay the loan? c. What payment is required quarterly to amortize the loan? a. The interest rate each quarter is %. 2 uide tents access Enter your answer in the answer box and then click Check Answer. Success 2 parts remaining Clear All Check Answer edia Library ase Options SO Type here to search 近 L. PrtSc Delete Esc 同回 F10 +D F5 F7 F8 F11 F12 区 6 F2 F4 & %23 $ 2 7 5. 6 3. 4. R. P. C A G K 7. B. Alt Ctrl Alt Homearrow_forward1Assume you plan to borrow $400,000 from your bank to buy a home. The bank offers: • a 5-year fixed rate of 6.05%, compounded monthly. • a 3-year fixed rate of 5.75%, compounded monthly. If you choose to repay the borrowing in equal installments monthly over a 20 years, what would be the difference between your monthly payments at the two different APRs? a. $89.32 b. $68.94 c. $26.98 d. $154.58 2You expect that the interest rate will decrease in the near future, therefore you eventually choose the 3-year fixed rate. Then, what will be your mortgage balance after 3 years? a. $321,598.59 b. $452,321.21 c. $365,056.12 d. $379,325.89 3Three years passed, it's time to renew your mortgage. Upon your renewal, your bank is now offering a new 3-year fixed rate of 4.5%, what would be your monthly repayment amount after renewal? a. 2825.32 b. 2598.54 c. 1965.21 d. 2563.60 4How much interests in total you have paid during the first 3 years of your mortgage? a. $54,365.22 b. $45,654.21 c.…arrow_forwardques 1arrow_forward
- Suppose that the mortgage loan described in question 10 is a one-year adjustable rate mortgage (ARM), which means that the 10.5% interest applies for only the first year.If the interest rate goes up to 12% in the second year of the loan, what will your new monthly payment be?arrow_forwardQUESTION 1 A bank makes a 30 year Fully Amortizing, Fixed Rate Mortgage (FRM) for $2,000,000 at an annual interest rate of 4.125% compounded monthly, with monthly payments. What is the market value of this loan after 7 years of payments if the annual interest rate for this loan is 10% compounded monthly? O A. $ 680,688.05 O B. $1,045,425.62 OC. $1,726,113.67 O D.$1,101,017.63arrow_forwardD Question 18 Consider a 20-year mortgage for $182,892 at an annual interest rate of 5.3%. After 7 years, the mortgage is refinanced to an annual interest rate of 2.5%. What are the monthly payments after refinancing? Round your answer to the nearest dollar.arrow_forward
- Solve this problemarrow_forwardConsider a 30-year, fixed-rate mortgage for $120,000 at a nominal rate of 6% with monthly payments. If the borrower pays an additional $120 with each monthly payment, what will be the amount of the last monthly payment? A. $839.46 B. $357.77 C. $843.66 D. $419.85 E. $355.99 F. $420.90 G. $418.81 H. $841.55arrow_forwardWhat amount todayarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- PFIN (with PFIN Online, 1 term (6 months) Printed...FinanceISBN:9781337117005Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning

PFIN (with PFIN Online, 1 term (6 months) Printed...
Finance
ISBN:9781337117005
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning