Assigment 2

xlsx

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

Report
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