9-21 Quiz
docx
keyboard_arrow_up
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
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
Related Documents
Related Questions
Question
Consider the first payment against a $200,000 mortgage that last for 25 years.
Fixed repayments are made on a monthly basis. The first row of the amortization
schedule is shown below.
Payment #
1
2
Payment
d
Interest
716.67
...
Debt Payment
P1
Calculate d, the fixed monthly payments that are made.
Round your answer to the nearest cent.
Balance
b₁
Ih
arrow_forward
question on the pic
arrow_forward
list
K
Complete the first month of the amortization schedule for a fixed-rate mortgage. Complete parts (a) through (d).
Mortgage: $103,000
Interest rate: 5.5%
Term of loan: 15 years
Click the icon to view the Real Estate Amortization Table.
Complete the first payment of the amortization schedule.
(Do not round until the final answer. Then round to the nearest cent as needed.)
Amortization Schedule
Payment
Number
1
Total
Payment
(a) $841.60
Interest
Payment
...
(b) $472.03
Principal
Payment
(c) $369.57
Balance of Principal
Save
(d) $472.03
arrow_forward
Make an amortization table to show the first two payments for the mortgage.
Amount of mortgage
Annual interest rate
Years in mortgage
Monthly payment
$407,181
5.50%
35
$2186.63
Question content area bottom
Part 1
Month
Monthly payment
Interest
Principal
End-of-month principal
1
$2186.63
$enter your response here
$enter your response here
$enter your response here
2
$2186.63
$enter your response here
$enter your response here
arrow_forward
Consider the first payment against a $200,000 mortgage that last for 25 years. Fixed repayments are made on a monthly
basis. The first row of the amortization schedule is shown below.
Payment # Payment Interest
1
d
716.67
2
Debt Payment
Balance
P1
b₁
arrow_forward
ONLINE 721757
K
Complete the first month of the amortization schedule for a fixed-rate mortgage.
Mortgage: $110,000
Interest rate: 6.5%
Term of loan: 25 years
Click the icon to view the Real Estate Amortization Table.
Payment
Number
1
Amortization Schedule
Total Payment Interest Payment Principal Payment Balance of Principal
(a) $
(b) $
(b) $
(d) $
arrow_forward
Correct answer general Accounting
arrow_forward
Fl in an amortization table (in dollars) for a loan of $8,500 to be paid back over 2 years, at an annual interest rate of 1.3, compounded quarterly. For eech value in the table, round your
answer to the nearest cent and use this value to calculate the next value.
Payment
number
Payment
amount
Payment amount
to interest
Payment amount
to debt
Outstanding
principal
S0.500
13
14
arrow_forward
Answer in typing
arrow_forward
help
arrow_forward
A fully amortizing mortgage loan is made for $84,000 at 6 percent interest for 25 years. Payments are to be made monthly.
Required:
a. Calculate monthly payments.
b. Calculate interest and principal payments during month 1.
c. Calculate total principal and total interest paid over 25 years.
d. Calculate the outstanding loan balance if the loan is repaid at the end of year 10.
e. Calculate total monthly interest and principal payments through year 10.
f. What would the breakdown of interest and principal be during month 50?
arrow_forward
A fully amortizing mortgage loan is made for $99,000 at 6 percent interest for 25 years. Payments are to be made
monthly.
Required:
a. Calculate monthly payments.
b. Calculate interest and principal payments during month 1.
c. Calculate total principal and total interest paid over 25 years.
d. Calculate the outstanding loan balance if the loan is repaid at the end of year 10.
e. Calculate total monthly interest and principal payments through year 10.
f. What would the breakdown of interest and principal be during month 50?
Complete this question by entering your answers in the tabs below.
Required A Required B Required C
Required D
Required E
Required F
What would the breakdown of interest and principal be during month 50? (Do not round intermediate calculations. Round
final answers to 2 decimal places.)
Interest payment
Principal payment
arrow_forward
K
Make an amortization table to show the first two payments for the mortgage.
Amount of
mortgage
Annual interest rate Years in mortgage Monthly payment
$407,292
5.50%
35
$2187.22
Monthly
End-of-month
Month
Interest
Principal
payment
principal
1
$2187.22
2
$2187.22
$
(Round to the nearest cent as needed.)
arrow_forward
Amortization schedule
Loan amount to be repaid (PV)
$25,000.00
Interest rate (r)
11.00%
Length of loan (in years)
3
a. Setting up amortization table
Formula
Calculation of loan payment
#N/A
Year
Beginning Balance
Payment
Interest
Repayment of Principal
Remaining Balance
1
2
3
b. Calculating % of Payment Representing Interest and Principal for Each Year
Year
Payment % Representing Interest
Payment % Representing Principal
Check: Total = 100%
1
2
3
Formulas
Year
Beginning Balance
Payment
Interest
Repayment of Principal
Remaining Balance
1
#N/A
#N/A
#N/A
#N/A
#N/A
2
#N/A
#N/A
#N/A
#N/A
#N/A
3
#N/A
#N/A
#N/A
#N/A
#N/A
b. Calculating % of Payment Representing Interest and Principal for Each Year
Year
Payment %…
arrow_forward
1
arrow_forward
Loan Receivable and Receivable Financing
Activity 1: Problems
Problem 1:
PDR Bank granted a loan to a borrower on January1, 2020. The interest on the loan is 10% payable annually
starting December 31, 2020. The loan matures in three years on December 31, 2022.
Principal amount
Origination fee charged againstthe borrower
Direct origination cost incurred
Indirect origination costs
2,000,000
171,050
75,000
15,000
After considering the origination fee charged againstthe borrower and the direct origination costincurred, the
effective rate on theloan is 12.5%.
Q1. The carrying amount oftheloan on January 1, 2020: is
Q2: The journal entries on January 1,2020:
Problem 2:
LSB granted a loan to the borrower on January1, 2020. The interest on the loan is 8% payable annually
starting December 31, 2020. Theloan matures in three years on December 31, 2022.
Principal amount
Origination fee charged against the borrower
Direct origination cost incurred
1,500,000
50,000
130,150
After considering the…
arrow_forward
Make an amortization table to show the first two payments for the mortgage.
Amount of mortgage
Annual interest rate
Years in mortgage
Monthly payment
$407,550
5.25%
35
$2122.29
Month
Monthly payment
Interest
Principal
End-of-month principal
1
$2122.29
$enter your response here
$enter your response here
$enter your response here
2
$2122.29
$enter your response here
$enter your response here
$enter your response here
arrow_forward
Q1
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
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
Required
information
A-1 Mortgage
makes loans with
the interest charged
on the loan
principal rather than
on the unpaid
balance. Consider
a 6-year loan of
$10,000 at 15% per
year.
If interest is charged on the
unrecovered balance, what equal
annual payment would be
required to complete the
repayment of the loan in 6 years?
The equal annual payment
required is $
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Question Consider the first payment against a $200,000 mortgage that last for 25 years. Fixed repayments are made on a monthly basis. The first row of the amortization schedule is shown below. Payment # 1 2 Payment d Interest 716.67 ... Debt Payment P1 Calculate d, the fixed monthly payments that are made. Round your answer to the nearest cent. Balance b₁ Iharrow_forwardquestion on the picarrow_forwardlist K Complete the first month of the amortization schedule for a fixed-rate mortgage. Complete parts (a) through (d). Mortgage: $103,000 Interest rate: 5.5% Term of loan: 15 years Click the icon to view the Real Estate Amortization Table. Complete the first payment of the amortization schedule. (Do not round until the final answer. Then round to the nearest cent as needed.) Amortization Schedule Payment Number 1 Total Payment (a) $841.60 Interest Payment ... (b) $472.03 Principal Payment (c) $369.57 Balance of Principal Save (d) $472.03arrow_forward
- Make an amortization table to show the first two payments for the mortgage. Amount of mortgage Annual interest rate Years in mortgage Monthly payment $407,181 5.50% 35 $2186.63 Question content area bottom Part 1 Month Monthly payment Interest Principal End-of-month principal 1 $2186.63 $enter your response here $enter your response here $enter your response here 2 $2186.63 $enter your response here $enter your response herearrow_forwardConsider the first payment against a $200,000 mortgage that last for 25 years. Fixed repayments are made on a monthly basis. The first row of the amortization schedule is shown below. Payment # Payment Interest 1 d 716.67 2 Debt Payment Balance P1 b₁arrow_forwardONLINE 721757 K Complete the first month of the amortization schedule for a fixed-rate mortgage. Mortgage: $110,000 Interest rate: 6.5% Term of loan: 25 years Click the icon to view the Real Estate Amortization Table. Payment Number 1 Amortization Schedule Total Payment Interest Payment Principal Payment Balance of Principal (a) $ (b) $ (b) $ (d) $arrow_forward
- Correct answer general Accountingarrow_forwardFl in an amortization table (in dollars) for a loan of $8,500 to be paid back over 2 years, at an annual interest rate of 1.3, compounded quarterly. For eech value in the table, round your answer to the nearest cent and use this value to calculate the next value. Payment number Payment amount Payment amount to interest Payment amount to debt Outstanding principal S0.500 13 14arrow_forwardAnswer in typingarrow_forward
- helparrow_forwardA fully amortizing mortgage loan is made for $84,000 at 6 percent interest for 25 years. Payments are to be made monthly. Required: a. Calculate monthly payments. b. Calculate interest and principal payments during month 1. c. Calculate total principal and total interest paid over 25 years. d. Calculate the outstanding loan balance if the loan is repaid at the end of year 10. e. Calculate total monthly interest and principal payments through year 10. f. What would the breakdown of interest and principal be during month 50?arrow_forwardA fully amortizing mortgage loan is made for $99,000 at 6 percent interest for 25 years. Payments are to be made monthly. Required: a. Calculate monthly payments. b. Calculate interest and principal payments during month 1. c. Calculate total principal and total interest paid over 25 years. d. Calculate the outstanding loan balance if the loan is repaid at the end of year 10. e. Calculate total monthly interest and principal payments through year 10. f. What would the breakdown of interest and principal be during month 50? Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required F What would the breakdown of interest and principal be during month 50? (Do not round intermediate calculations. Round final answers to 2 decimal places.) Interest payment Principal paymentarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you