9-21 Quiz

docx

School

Rutgers University *

*We aren’t endorsed by this school

Course

33:390:435

Subject

Finance

Date

Jan 9, 2024

Type

docx

Pages

5

Uploaded by MinisterDiscovery7644

Report
Quiz Real Estate Finance and Mortgage Fall, 2023 Prof. Stephen Cassidy TA Shane Omundsen Name: Date: 1. A fully amortizing (hint, FV = Ø) mortgage loan is made for $80,000 at 6 percent interest for 25 years. Payments are to be made monthly. Calculate: a. Monthly payments. (PMT) b. Interest and principal payments during month 1. c. Total principal and total interest paid over 25 years. d. The outstanding loan balance if the loan is repaid at the end of year 10. a. Monthly Payments (PMT) : Monthly payment for the loan can be calculated Excel PMT formula, see attached excel file. b. Interest and principal payments during month 1. Interest payment during month 1: Interest payment during month 1=Beginning balance during month 1   Monthly interest  rate Interest PMT=$80,000×(6%12)=$400.00 Principal payment during month 1: Principal payment during month 1=Monthly payment − Interest payment during month  Principle PMT=$515.44−$400=$115.44 1
c. Calculate total principal and total interest paid over 25 years: Total principal repaid over 25 years = Loan amount = $80,000 Total interest paid over 25 years = Total monthly payment paid over 25 years – Principle Repaid = ($515.44*25*12) – ($80,000) = $74,632 d. The outstanding loan balance if the loan is repaid at the end of year 10. The outstanding loan balance can be calculated using the excel FV formula. Please see attached excel file. 2. What documents provide for legal transfer of real estate? What documents shows other potential claims and previous ownership of real estate? A property deed is the document that allows for the legal transfer of real estate. Abstract of title is the document that shows a detailed history of the property 3. What two documents work in unison to provide a lenders first legal position and financial terms under which they loan money with real estate as collateral? Promissory Note and Mortgage Deed. 4. You expect to receive a one-time payment of $5,500 in five years. What is the present value of this amount assuming that you require a 9% return on investment and your return is compounded on an annual basis? a. $3,512.84 b. $3,574.63 c. $5,045.87 d. $5,995.00 The correct answer for this is $3,574.63 which is option b. Please see the attached excel file for further clarification. 2
5. You expect to receive a one-time payment of $5,500 in five years. What is the present value of this amount assuming that you require a 9% return on investment and your return is compounded on a monthly basis? (a) $3,512.84 ( b) $3,574.63 (c) $5,045.87 (d) $5,995.00 The correct answer for this is $3,512.84 which is option a. Please see the attached excel file for further clarification 6. You know that you'd like to buy a house sometime in the near future and decide to start saving for a down payment. If you put $500 a month into a savings account that offers a 6% annual rate, that is compounded on a monthly basis, what is the amount you will have to put down on a new home in three years? (a) $16,981. 13 (b) $18,000.00 (c) $19,668.05 (6) $21.540.25 The correct answer for this is $19,668.05 which is option c. Please see the attached excel file for further clarification 7. On a lark, you bought a lottery ticket and won $10,000. The problem is that it takes for the lottery commission one year to verify the ticket and you can't receive your winnings until that happens. If your current savings account offers an annual interest rate of 3%, compounded annually, what is the lowest price you would accept from someone if you sell the ticket today? 3 (a) $9,700.00 (b) $9,708.74 (c) $10,000.00 (d) $10,300.00
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
The correct answer for this is $9,708.74 which is option b. Please see the attached excel file for further clarification 8. At retirement, you cash in your savings and purchase an annuity offering an annual payment of $40,000 a year for 15 years. If the annuity is based on a 8% interest rate that is compounded annually, and you will receive the first annuity payment one year from now, how much did you save for retirement? (a) $189,145.02 (b) $342,379.15 (c) $541,516.25 (d) $600,000.00 The correct answer for this is $342,379.15 which is option b. Present value of annuity = Annual payment * PVAF (8%, 15 years) PVAF (8%, 15 years) = 8.5595 Present value of annuity = $40,000 * 8.5595 = $342,379.15 Bonus Section: 1. What is the name of the company that Professor Cassidy and Shane work at? Denholtz Properties 2. What University did Professor Cassidy attain his Masters degree at and what type of degree was it in? (Need both parts correct) Masters in Accounting at Rutgers Formulas The future value of a constant annuity of C dollars received for T periods: 4
The present value of a constant annuity of C dollars received for T periods: The present value of a constant perpetuity of C dollars: 5