Assigment 2
xlsx
keyboard_arrow_up
School
University of British Columbia *
*We aren’t endorsed by this school
Course
370
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
9
Uploaded by BailiffValorSparrow28
Q1
The R&M Bank has offered you the choice between two investment accounts:
#1 pays interest at a rate of 12% compounded semi-annually
#2 pays interest at a rate of 11% compounded monthly
Which investment account do you prefer and why?
Rate
m
Effect
#1
0.12
2
0.123600000
#2
0.11
12
0.1157188362
Q2
Andre has obtained a $250,000 mortgage. The mortgage is amortized over 25 years a
The mortgage interest rate is 9% compounded annually. Andre will begin making an
$22,500.00
$21,944.81
$18,470.51
$2,290.64
Mortgage
EAR
0.09
Monthly rate
Mortgage
250,000.00 n
25
PMT
$25,451.56
FV
Amortization schedule
Period
Opening Bal
Pmt
Interest
1 250,000.00 25,451.56 22,500.00 2 247,048.44 25,451.56 22,234.36 3 243,831.23 25,451.56 21,944.81 4 240,324.48 25,451.56 21,629.20 5 236,502.12 25,451.56 21,285.19 6 232,335.75 25,451.56 20,910.22 7 227,794.41 25,451.56 20,501.50 8 222,844.34 25,451.56 20,055.99 9 217,448.77 25,451.56 19,570.39 10 211,567.60 25,451.56 19,041.08 11 205,157.12 25,451.56 18,464.14 12 198,169.69 25,451.56 17,835.27
13 190,553.40 25,451.56 17,149.81 14 182,251.65 25,451.56 16,402.65 15 173,202.73 25,451.56 15,588.25 16 163,339.42 25,451.56 14,700.55 17 152,588.40 25,451.56 13,732.96 18 140,869.80 25,451.56 12,678.28 19 128,096.51 25,451.56 11,528.69 20 114,173.64 25,451.56 10,275.63 21 98,997.70 25,451.56 8,909.79 22 82,455.93 25,451.56 7,421.03 23 64,425.40 25,451.56 5,798.29 24 44,772.13 25,451.56 4,029.49 25 23,350.06 25,451.56 2,101.51 Q3
Amy has obtained a $250,000 mortgage. The mortgage is amortized over 25 years and the te
The mortgage interest rate is 9% compounded semi-annually. Amy will begin making month
Mortgage
$2,069.94
EAR
0.092025
Monthly rate
0.00736312303
$2,097.99
Mortgage
250,000.00 n
300
$5,169.68
PMT
$2,069.94
FV
$5,189.59
Q4
If Frank is indifferent between receiving $1,000 today and $1,200 in one year, his opp
20.000%
Q5
The present value is always __________ than the future value if the opportunity cost
Group of answer choices
Less than; greater than
Equal to; equal to
Greater than; less than
All of the above are true
Q6
The R&M Bank has offered you the choice between two loans:
#1 charges interest at a rate of 9% compounded quarterly
#2 charges interest at a rate of 9.05% compounded semi-annually
Which loan do you prefer and why?
Group of answer choices
#1
#1, lowest effective rate
m 4
#2, lowest effective annual rate
EAR
0.09308331879
#1, highest effective rate
#2, highest effective rate
Q7
Why is a dollar today always worth at least a dollar in the future?
Group of answer choices
Because of the risk involved with investing
Because of the opportunity cost of money
Because of inflation
All of the above
Q8
As the amortization period of a mortgage increases, holding interest rates constant, t
Group of answer choices
Stay the same.
Increase.
Decrease.
There is no connection between the amortization period and the size of the payment
Q9
Elvira is considering buying a 20 year ordinary annuity to provide her with retiremen
If her opportunity cost is 7%, what is the maximum she should pay for the annuity?
$1,096,629.42
$1,024,887.31
$283,389.88
$264,850.36
$264,850.36
Q12
Rob plans to retire 30 years from today and wants to have sufficient funds saved in o
payable at the beginning of each year. Rob also estimates that at the time of his retir
he will be able to sell his business for $250,000. The expectation is that interest rates
thereafter declining to 5% per year forever. Rob would like to make equal annual de
How much will Rob need to deposit each year in order to meet his retirement objecti
25 Annual (start of year) withdrawls:
rate = 5%
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
nper =
25
pmt = 5.00E+04
PV (time 30) = -$739,932.09
Net required after sale of business:
-$489,932.09
Annual (end of year) investment for 35 years:
rate =
6%
nper =
30
PMT = $6,197.11
Q13
Wilma borrows $10,000 from Joe and promises to repay Joe a total of $10,500 in one
5.00%
Q14
You invested $2,000 at 5 percent compounded annually.
Determine how much interest was earned in the fifth year?
121.550625
$100.00
$121.55
6.17%
$500.00
6.03%
$552.56
10%
8.45%
-$283,389.88
0.10506479278
5.25%
$17,623.42
$26,086.96
Freq
7%
2
6.88%
12
6.78%
and the term of the mortgage is 25 years.
nnual payments of $25,451.56 at the end of the year. How much of Andre’s third payment is inter
Principal repayment
Ending Bal
2,951.56 247,048.44 3,217.20 243,831.23 3,506.75 240,324.48 3,822.36 236,502.12 4,166.37 232,335.75 4,541.34 227,794.41 4,950.07 222,844.34 5,395.57 217,448.77 5,881.17 211,567.60 6,410.48 205,157.12 6,987.42 198,169.69 7,616.29 190,553.40
8,301.76 182,251.65 9,048.91 173,202.73 9,863.32 163,339.42 10,751.02 152,588.40 11,718.61 140,869.80 12,773.28 128,096.51 13,922.88 114,173.64 15,175.94 98,997.70 16,541.77 82,455.93 18,030.53 64,425.40 19,653.28 44,772.13 21,422.07 23,350.06 23,350.06 0.00 erm of the mortgage is 5 years.
hly payments at the end of the month. The monthly payment is closest to:
portunity cost must be close to:
t is _____________ zero.
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
2
0.0925475625
the monthly payments will:
t.
nt income. The annuity will make annual payments of $25,000. order to have an annual income of $50,000 for 25 years, rement, s will be stable at 6% per year for the next 30 years,
eposits at the end of each of the next 30 years.
tive?
$5,751.42
$9,359.34
$6,197.11
$4,922.55
e month. What is the effective annual interest rate charged by Joe?
EAR
rest?
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
Please answer everything asap. DONT USE EXCEL!
arrow_forward
The bank offers you the following three options to pay back the loan from the previous
question:
I:
To pay the interest of 6.00% annually
II:
To pay an interest of 0.49% monthly
III:
To pay an interest of 1.46% quarterly
Which of these three options would be most beneficial for you?
O All three options would be equally beneficial
Option II
○ Option III
Option I
O Option II and Option III would be equally beneficial
arrow_forward
Loan amount = $175,591
Assume that your broker agents introduce/assess you to a local bank of Belize. The bankoffers you their lowest interest rate at 9.25% APR, either a 10-year fixed interest rate or20-year fixed interest rate.a) If you want a 10-year, fixed-rate mortgage loan, find the monthly mortgagepayment.b) Determine the total amount to be paid over the full term of the loan.c) How much interest that will be paid on the loan over the 10 years
arrow_forward
Your bank offers the following options on a $100,000 mortgage:
1. A 15-year, 4% loan with no points
2. A 15-year, 3.5% loan, with 1.5 discount points..
The interest portion of the first payment (INT) is.
for option 2.
$333.33: $291,67
None of the above.
O $4,000; $3,500
O $406.36; $423.21
for option 1, and
arrow_forward
Give only typing answer with explanation and conclusion
arrow_forward
Finding the Interest Rate: Concept Connection Example 6-3 (page 237) 18. What interest rates are implied by the following lending arrangements?
a. You borrow $500 and repay $555 in one year.
b. You lend $1,850 and are repaid $2,078.66 in two years.
c. You lend $750 and are repaid $1,114.46 in five years with quarterly compounding.
d. You borrow $12,500 and repay $21,364.24 in three years under monthly compounding. (Note. In parts c and d, be sure to give your answer as the annual nominal rate.)
Lasher, William R.. Practical Financial Management (Page 276). South-Western College Pub. Kindle Edition.
arrow_forward
Please answer fast
arrow_forward
Suppose a bank offers you a 4.99% interest rate on a 20-year mortgage to be paid back with monthly payments. Suppose the most you can afford to pay in monthly payments is $1500. How much of a mortgage could you afford?
a.) $224,787.34
b.) $227,478.34
c.) $227,847.25
d.) $228,743.72
arrow_forward
Find the interest rates earned on each of the following:
A. You borrow $700 and promise to pay back $749 at the end of 1 year
B. You lend $700 and the borrower promises to pay you back $749 at the end of 1 year
C. You borrow $85,000 and promise to pay back $201,229 at the end of 10 years
D. You borrow $9,000 and promise to make payments of $2,684.80 at the end of each year for 5 years
arrow_forward
You arrange a mortgage from the Pinder Bank of Australia. The amount you borrow is $760,000 with payments required on a monthly basis over the next 25 years with the first payment required one month from today. The interest rate quoted by the bank is 12% p.a. compounding monthly. Which of the following is closest to the monthly payment required by the bank?
Group of answer choices
A. $6,088
B. Need more information to answer the question
C. $8,005
D. $7,057
E. $6,906
arrow_forward
SOLVE FOR NUMBER 4 ONLY
3. Citibank pays 9% ordinary simple interest on a 30-day time deposit. If Gino deposits Php 1 500.00, how much will he have using:a. Exact interest b. Ordinary interest
4. After solving the problem in number 3, what conclusion can you draw between ordinaryand exact interest? If you are the banker, what kind of interest will you use and why?How about if you are the depositor?
arrow_forward
Please explain each step, step by step
arrow_forward
Q2. You plan to purchase a house for $195,000 using a 30-year mortgage obtained from your local bank. You will make a down payment of 20% of the purchase price and monthly payment. You will not pay off the mortgage early.
Your bank offers you the following three options the payment:
Option 1: Mortgage rate of 5.5% and zero points.
Option 2: Mortgage rate of 5.35% and 1 point
Option 3: Mortgage rate of 5.35 % and 1.5 points
arrow_forward
Need all four quest...
arrow_forward
Solve part a,b,c. Typed a
arrow_forward
1. Joe agrees to make the ff. payments from the lending investor
End-of-year
1
2
3
4
Payment
5000
6000
7000
8000
9000
5
Required:
a. Determine the amount of money that he can loan from the lending investor.
b. In case Joe opts to return the money plus interest in equal end-of-year payments, compute the
annuities or the amount of annual payments needed to make. Use 12% interest rate.
arrow_forward
Use PMT =
to determine the regular payment amount, rounded to the nearest dollar. The price of a home is $181,000. The bank requires a 20% down payment and three points at the time of closing. The cost of
1-
the horme is financed with a 30-year fixed-rate mortgage at 7.5%. Complete parts (a) through (e) below.
a. Find the required down payment.
b. Find the amount of the mortgage.
c. How much must be paid for the three points at closing?
$ (Round to the nearest dollar as needed.)
d. Find the monthly payment (excluding escrowed taxes and insurance).
$ (Round to the nearest dollar as needed.)
e. Find the total cost of interest over 30 years.
$ (Round to the nearest dollar as needed.)
Next
MacBook Air
8884
%23
24
%
&
*
2
3
4
5
6
8.
9.
R.
T
Y
D
K
F.
S'
arrow_forward
effective rates of interest find the interest rate earned on each of the following :
a. You borrow $700and promise to pay back $749 at the end of 1 year
b. You lend $700 and borrower promises to pay you $749 at the end of 1 year
c. You borrow $8,500 and promise to pay back $201,229 at the end of 10 years
d. You borrow $9,000 and promise to make payments of $2,684.80 at the end of each year for 5 years
arrow_forward
=t
K
A friend asks to borrow $54 from you and in return will pay you $57 in one year. If your bank is offering a 6.1% interest
rate on deposits and loans:
a. How much would you have in one year if you deposited the $54 instead?
b. How much money could you borrow today if you pay the bank $57 in one year?
c. Should you loan the money to your friend or deposit it in the bank?
a. How much would you have in one year if you deposited the $54 instead?
If you deposit the money in the bank today you will have $
b. How much money could you borrow today if you pay the bank $57 in one year?
You will be able to borrow $ today. (Round to the nearest cent.)
c. Should you loan the money to your friend or deposit it in the bank?
From a financial perspective, you should
end of
year.
in one year. (Round to the nearest cent.)
(Select from the drop-down menu.)
▼
as it will result in more money for you at the
arrow_forward
The following formula is used for figuring out a monthly home mortgage payment: 7(12t) r Lr1+ 12 M = 12t 12 1+ 12 -1 Where: L = the loan amount in dollars the annual interest rate expressed as decimal t = the number of years of the loan M= the monthly payment in dollars r = You are looking to buy a $275,599.00 home in Haverhill. If Bank of America will give them a 30-year mortgage at 6.75% annual interest rate for the cost of the house after they receive a 10% down payment. A. Determine the loan amount? B. How much their monthly payment will be? C. At the end of the 30-years, how much total money will you have paid to Bank of America for your home? In another word how much did the $275,599.00 house really cost the couple? D. How much interest will they have paid? E. How many of her monthly payment go toward the interest? F. What percent increase over the cost of the home does this interest represent? G. Redo and re-answer all questions, but this time for 15 years? Do analysis…
arrow_forward
Suppose bank a offers a 229020 year 6.4% fixed rate mortgage with closing cost of 2600 + 4 points what are their closing costs associated with this mortgage
arrow_forward
Ttme Value of of Money
Tim wants to borrow $400,000 from Bank of America on a 30-year mortgage.
a. What would Tim's monthly payments be on his motgage?
b. Amortize the loan and determine:
Interest expense for the first quarter of the loan.
Cash flows for the first quarter of the loan.
Loan balance at the end of the first quarter of the loan.
Please show your calculations, part b is very important. If you are using the TVM chart, please state whether you used PVoA, FVoA, PVoSA, FVoSA.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Please answer everything asap. DONT USE EXCEL!arrow_forwardThe bank offers you the following three options to pay back the loan from the previous question: I: To pay the interest of 6.00% annually II: To pay an interest of 0.49% monthly III: To pay an interest of 1.46% quarterly Which of these three options would be most beneficial for you? O All three options would be equally beneficial Option II ○ Option III Option I O Option II and Option III would be equally beneficialarrow_forwardLoan amount = $175,591 Assume that your broker agents introduce/assess you to a local bank of Belize. The bankoffers you their lowest interest rate at 9.25% APR, either a 10-year fixed interest rate or20-year fixed interest rate.a) If you want a 10-year, fixed-rate mortgage loan, find the monthly mortgagepayment.b) Determine the total amount to be paid over the full term of the loan.c) How much interest that will be paid on the loan over the 10 yearsarrow_forward
- Your bank offers the following options on a $100,000 mortgage: 1. A 15-year, 4% loan with no points 2. A 15-year, 3.5% loan, with 1.5 discount points.. The interest portion of the first payment (INT) is. for option 2. $333.33: $291,67 None of the above. O $4,000; $3,500 O $406.36; $423.21 for option 1, andarrow_forwardGive only typing answer with explanation and conclusionarrow_forwardFinding the Interest Rate: Concept Connection Example 6-3 (page 237) 18. What interest rates are implied by the following lending arrangements? a. You borrow $500 and repay $555 in one year. b. You lend $1,850 and are repaid $2,078.66 in two years. c. You lend $750 and are repaid $1,114.46 in five years with quarterly compounding. d. You borrow $12,500 and repay $21,364.24 in three years under monthly compounding. (Note. In parts c and d, be sure to give your answer as the annual nominal rate.) Lasher, William R.. Practical Financial Management (Page 276). South-Western College Pub. Kindle Edition.arrow_forward
- Please answer fastarrow_forwardSuppose a bank offers you a 4.99% interest rate on a 20-year mortgage to be paid back with monthly payments. Suppose the most you can afford to pay in monthly payments is $1500. How much of a mortgage could you afford? a.) $224,787.34 b.) $227,478.34 c.) $227,847.25 d.) $228,743.72arrow_forwardFind the interest rates earned on each of the following: A. You borrow $700 and promise to pay back $749 at the end of 1 year B. You lend $700 and the borrower promises to pay you back $749 at the end of 1 year C. You borrow $85,000 and promise to pay back $201,229 at the end of 10 years D. You borrow $9,000 and promise to make payments of $2,684.80 at the end of each year for 5 yearsarrow_forward
- You arrange a mortgage from the Pinder Bank of Australia. The amount you borrow is $760,000 with payments required on a monthly basis over the next 25 years with the first payment required one month from today. The interest rate quoted by the bank is 12% p.a. compounding monthly. Which of the following is closest to the monthly payment required by the bank? Group of answer choices A. $6,088 B. Need more information to answer the question C. $8,005 D. $7,057 E. $6,906arrow_forwardSOLVE FOR NUMBER 4 ONLY 3. Citibank pays 9% ordinary simple interest on a 30-day time deposit. If Gino deposits Php 1 500.00, how much will he have using:a. Exact interest b. Ordinary interest 4. After solving the problem in number 3, what conclusion can you draw between ordinaryand exact interest? If you are the banker, what kind of interest will you use and why?How about if you are the depositor?arrow_forwardPlease explain each step, step by steparrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you