Assignment_5_RE410_2023 (1)
docx
keyboard_arrow_up
School
University of Wisconsin, Madison *
*We aren’t endorsed by this school
Course
410
Subject
Finance
Date
Jan 9, 2024
Type
docx
Pages
1
Uploaded by EarlCrab248
Assignment #4 - REST 710
1.
Suppose 4 years ago you borrowed an FRM for $2,000,000, 30-yr amortization, 8%
annual rate, 10-yr maturity. Given the increase in your property value over the last
four years, you are now eligible to obtain a $2,2000,000 loan, 30-yr amortization, 10-
yr maturity. However, the new loan comes at a higher rate of 8.5%. Your refinancing
costs will add up to $40,000. You are expecting to sell this property five years now,
and you are planning to use the additional $200,000 as a downpayment towards a new
project available to you now. What is the cost of (effective interest rate) of obtaining
$200,000 through this cash-out refinancing option? Should you (cash out) refinance?
2.
You and your classmate from UW years are considering investing in an apartment
building opportunity. You project rents to be $8,000,000 during the first year and
grow at 4 percent per year. Vacancies and collection losses are expected to be 10% of
rents. Operating expenses will be 35 percent of effective gross income. You have been
approved for a 20-year FRM (fixed rate mortgage) loan for 65 percent of the purchase
price at 9 percent interest rate. The asking price is $100,000,000. The property is
expected to appreciate in value at 3 percent per year (use n=4 years of appreciation)
and is expected to be owned for five years and then sold.
a.
Write down the cash flows statement for years 1 through 5.
b.
What is the expected before-tax internal rate of return? Show your work.
c.
Re-do parts a. and b. with no borrowing (100% cash purchase).
d.
What is the impact of leverage on the IRR?
3.
Suppose you are considering the following construction project. The construction
phase is one year and all direct costs (excluding interest carry and loan fees) will be
$4.8 million. The Second Avenue Bank will provide the construction loan for the
project. The bank will finance all of the construction costs and interest carry at an
annual rate of 13% plus a loan origination fee of 2.25%. The direct cost draws will be
taken down in nine equal amounts commencing with the first month, with no draws in
the last three months of the project (notice that the draws are at the beginning of each
month!). The permanent financing for the project will come at the end of the first year
from the Third Avenue Bank. You will fund the acquisition of land with your own
equity.
Estimate the 12-month construction draw schedule, interest carry (for each month),
ending balance at the end of each month, and the total loan amount due to the
construction lender at the end of the 12-month period. What is the yield to the lender?
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Suppose you borrowed $25, 000 at a rate of 9.0% and must repay it in 4 equal installments at the end of each of the next 4 years. How large would your payments be? Select the correct answer. a. $7, 703.52 b. $7, 729.92 c. $7, 716.72 d. $7, 736.52 e. $7,723.32
arrow_forward
Part B , solution should be mathematically explained
arrow_forward
Part C, solution should be mathematically explained
arrow_forward
Explain
arrow_forward
Use the following amortization chart:
Selling priceof home
Downpayment
Principal(loan)
Rate of interest
Years
Payment per$1,000
Monthly mortgage payment
$ 95,000
$ 6,000
$ 89,000
6%
30
$ 6.00
$ 534.00
Assume the interest rate rises to 7.5%. What is the total cost of interest with the new interest rate? (Use Table 15.1.) (Do not round intermediate calculations. Round your final answer to the nearest cent.)
Total Cost of Interest
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
USE TVM SOLVER
arrow_forward
Use the following amortization chart:
Selling price of home
Down payment
Principal (loan)
Rate of interest
Years
Payment per $1,000
Monthly mortgage payment
$ 79,000
$ 6,000
$ 73,000
6%
30
$ 5.9955
$ 437.67
Assume the interest rate rises to 7.5%. What is the total cost of interest with the new interest rate? (Use Table 15.1).
Note: Round your intermediate calculations and final answer to the nearest cent.
Total cost of interest: ?????
The answer is NOT $110,753.57
TABLE 15.1
Amortization table (mortgage principal and interest per $1,000)
Rate
Interest Only
10 Year
15 Year
20 Year
25 Year
30 Year
40 Year
2.000
0.16667
9.20135
6.43509
5.05883
4.23854
3.69619
3.02826
2.125
0.17708
9.25743
6.49281
5.11825
4.29966
3.75902
3.09444
2.250
0.18750
9.31374
6.55085
5.17808
4.36131
3.82246
3.16142
2.375
0.19792
9.37026
6.60921
5.23834
4.42348
3.88653
3.22921
2.500
0.20833
9.42699
6.66789
5.29903
4.48617
3.95121
3.29778
2.625
0.21875
9.48394
6.72689
5.36014
4.54938…
arrow_forward
Use the following amortization chart:
Selling price of home
Down payment
Principal (loan)
Rate of interest
Years
Payment per $1,000
Monthly mortgage payment
$ 79,000
$ 6,000
$ 73,000
6%
30
$ 5.9955
$ 437.67
Assume the interest rate rises to 7.5%. What is the total cost of interest with the new interest rate? (Use Table 15.1).
Note: Round your intermediate calculations and final answer to the nearest cent.
Total cost of interest:???
arrow_forward
12. Amortized loans
Mortgages and other amortized loans (meaning equal or blended payments) involve regular payments at fixed intervals. These are sometimes called
reverse annuities, because you get a lump-sum amount as a loan in the beginning, and then you make the periodic payments (usually monthly or
more frequently, depending on the agreement) to the lender.
You've decided to buy a house that is valued at $1 million. You have $400,000 to use as a down payment on the house, and you take out a mortgage
for the rest. Your bank has approved your mortgage for the balance amount of $600,000 and is offering you a 25-year mortgage with 12% fixed
nominal interest rate (called the APR, or Annual Percentage Rate) compounded semiannually. According to this proposal, what will be your monthly
mortgage payment?
OOO
$7,740
$6,192
$8,359
$9,598
Your friends suggest that you take a 15-year mortgage, because a 25-year mortgage is too long and you will lose a lot of money on interest. If your
bank…
arrow_forward
Plz correct solution.
arrow_forward
Q8: Please show exact detailed steps in each problem
arrow_forward
Find the maturity value FV of the given loan amount. (Round your answer to the nearest cent.)
$1,200 borrowed at 7 1/8 % for three years...
Future Value= $ ____________
Thank you!
arrow_forward
Question 1:
Part A.
The current 10 year treasury note is approaching the important threshold of:
a) 2.75%
b) 2.95%
c) 3.25%
d) 2.0%
Part B.
In a real estate investment, you may want to obtain a mortgage. In so doing, which year would you expect to see the highest amount of principal pay-down (in a payment mix of principal and interest)?
a) year 15
b) year 20
c) year 10
d) year 25Part C.
In a Fast Market, you would rather sell a stock using a:
a) Market Order
b) Market On Close Order
c) Limit Order
d) Market On Open OrderPart D.
Given that equity markets are asymmetric in their respective moves, markets are said to take________________________
a) the slow grind higher into perpetuity
b) the stairs down and the elevator up
c) the stairs up and your mom home
d) the stairs up and the elevator down
Part E.
It is said that traders have come to employ the use of technical analysis potentially for all of the following reasons except:…
arrow_forward
Suppose you borrowed $15,000 at a rate of 8.5% and must repay it in 5 equal installments at the end of each of the next 5 years. by how much would you reduce the amount you owe at the end of the first year? (in other words, how much of the principal anount of the loan have you paid off)
A. $2,404.91B $2,531.49C. $2,930.51D. $2,790.96E. $2,658.06
arrow_forward
Use the following amortization chart:
Selling priceof home
Downpayment
Principal(loan)
Rate of interest
Years
Payment per$1,000
Monthly mortgage payment
$ 81,000
$ 4,000
$ 77,000
5.5%
30
$ 5.68
$ 437.36
Assume the interest rate rises to 7.0%. What is the total cost of interest with the new interest rate? (Use Table 15.1.) (Do not round intermediate calculations. Round your final answer to the nearest cent.)
arrow_forward
8. Suppose that you want to take a five-year loan of $80,000. The interest rate is 9% per year, and
the loan calls for equal annual payments. How much do you need to pay each year?
A. $17,120.1
B. $19,169.4
C. $20,567.4
D. $21,333.1
arrow_forward
18 .Use the following amortization chart:
Selling price of home
Down payment
Principal (loan)
Rate of interest
Years
Payment per $1,000
Monthly mortgage payment
$ 90,000
$ 5,000
$ 85,000
5 1/2%
30
$ 5.67789
$ 482.62
What is the total cost of interest?
Note: Do not round intermediate calculations. Round your answer to the nearest cent.
Total cost of interest:???
arrow_forward
Need all four quest...
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Suppose you borrowed $25, 000 at a rate of 9.0% and must repay it in 4 equal installments at the end of each of the next 4 years. How large would your payments be? Select the correct answer. a. $7, 703.52 b. $7, 729.92 c. $7, 716.72 d. $7, 736.52 e. $7,723.32arrow_forwardPart B , solution should be mathematically explainedarrow_forwardPart C, solution should be mathematically explainedarrow_forward
- Explainarrow_forwardUse the following amortization chart: Selling priceof home Downpayment Principal(loan) Rate of interest Years Payment per$1,000 Monthly mortgage payment $ 95,000 $ 6,000 $ 89,000 6% 30 $ 6.00 $ 534.00 Assume the interest rate rises to 7.5%. What is the total cost of interest with the new interest rate? (Use Table 15.1.) (Do not round intermediate calculations. Round your final answer to the nearest cent.) Total Cost of Interestarrow_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
- USE TVM SOLVERarrow_forwardUse the following amortization chart: Selling price of home Down payment Principal (loan) Rate of interest Years Payment per $1,000 Monthly mortgage payment $ 79,000 $ 6,000 $ 73,000 6% 30 $ 5.9955 $ 437.67 Assume the interest rate rises to 7.5%. What is the total cost of interest with the new interest rate? (Use Table 15.1). Note: Round your intermediate calculations and final answer to the nearest cent. Total cost of interest: ????? The answer is NOT $110,753.57 TABLE 15.1 Amortization table (mortgage principal and interest per $1,000) Rate Interest Only 10 Year 15 Year 20 Year 25 Year 30 Year 40 Year 2.000 0.16667 9.20135 6.43509 5.05883 4.23854 3.69619 3.02826 2.125 0.17708 9.25743 6.49281 5.11825 4.29966 3.75902 3.09444 2.250 0.18750 9.31374 6.55085 5.17808 4.36131 3.82246 3.16142 2.375 0.19792 9.37026 6.60921 5.23834 4.42348 3.88653 3.22921 2.500 0.20833 9.42699 6.66789 5.29903 4.48617 3.95121 3.29778 2.625 0.21875 9.48394 6.72689 5.36014 4.54938…arrow_forwardUse the following amortization chart: Selling price of home Down payment Principal (loan) Rate of interest Years Payment per $1,000 Monthly mortgage payment $ 79,000 $ 6,000 $ 73,000 6% 30 $ 5.9955 $ 437.67 Assume the interest rate rises to 7.5%. What is the total cost of interest with the new interest rate? (Use Table 15.1). Note: Round your intermediate calculations and final answer to the nearest cent. Total cost of interest:???arrow_forward
- 12. Amortized loans Mortgages and other amortized loans (meaning equal or blended payments) involve regular payments at fixed intervals. These are sometimes called reverse annuities, because you get a lump-sum amount as a loan in the beginning, and then you make the periodic payments (usually monthly or more frequently, depending on the agreement) to the lender. You've decided to buy a house that is valued at $1 million. You have $400,000 to use as a down payment on the house, and you take out a mortgage for the rest. Your bank has approved your mortgage for the balance amount of $600,000 and is offering you a 25-year mortgage with 12% fixed nominal interest rate (called the APR, or Annual Percentage Rate) compounded semiannually. According to this proposal, what will be your monthly mortgage payment? OOO $7,740 $6,192 $8,359 $9,598 Your friends suggest that you take a 15-year mortgage, because a 25-year mortgage is too long and you will lose a lot of money on interest. If your bank…arrow_forwardPlz correct solution.arrow_forwardQ8: Please show exact detailed steps in each problemarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you