Solution:
1.
For 20-year loan, the monthly payments are |
PVA = PMT({1 – [1/(1 + r)] t } / r) |
$35,000,000 = PMT{[1 – 1 / (1 + .061/12) 360] / (.061/12)} |
PMT = $212,098.17 |
For 30-year loan, the monthly payments are |
PVA = PMT({1 – [1/(1 + r)] t } / r) |
$35,000,000 = PMT{[1 – 1 / (1 + .061/12) 240] / (.061/12)} |
C = $252,774.22 |
2.
6-month Amortization table for 30-year mortgage | ||||
Pmt | Principal | Interest | Balance | |
0 | 35000000.00 | |||
1 | 212098.17 | 34181.51 | 177916.7 | 34965818.49 |
2 | 212098.17 | 34355.26 | 177742.9 | 34931463.23 |
3 | 212098.17 | 34529.90 | 177568.3 | 34896933.32 |
4 | 212098.17 | 34705.43 | 177392.7 | 34862227.89 |
5 | 212098.17 | 34881.85 | 177216.3 | 34827346.04 |
6 | 212098.17 | 35059.17 | 177039 | 34792286.88 |
3.
Bi Weekly Payments | =212098.17/2 |
106049.09 | |
Present Value of Annuity | 35000000.00 |
Annuity per period (PMT) | 106049.09 |
Using the Present Value of Annuity Formula we get |
PVA = PMT({1 – [1/(1 + r)]t} / r) |
$35,000,000 = $106,049.09{[1 – 1 / (1 + .061/26)t] / (.061/26)} |
Solve for 't' |
1/1.00235t= 1 – [($35,000,000)(.00235) / ($106,049.09)] |
1.00235t= 1/.2384 = 4.1950 |
t = ln 4.1950 / ln 1.00235 |
t = 635.24 periods |
No. of bi-weekly periods in a year | 26 |
No.of Years | =635.24 / 26 |
24.43230769 |
It takes 24.43 years to pay off under a smart loan |
Total Paymenst under the traditional loan |
30-year total payments = 360 × $212,098.17 |
30-year total payments = $76,355,342.98 |
Total Payments under Bi weekly mortgage |
Bi-weekly total payments = 635.24 × ($106,049.09/2) |
Bi-weekly total payments = $67,366,136.74 |
Interest Savings |
=76,355,342.98 -67,366,136.74 |
8989206.24 |
4.
Bullet Loan |
The loan payments for the first 59 months are the same as the traditional 30-year mortgage, which is $212,098.17. This mortgage payment will be made in the 60th month as well, but the company will also make the bullet payment. The bullet payment can be found by using an amortization table, but the easier method is to find the present value of the remaining loan payments. The present value of the remaining loan payments in month 60 will be: |
PVA = C({1 – [1/(1 + r)]t} / r) |
PVA = $212,098.17{[1 – 1 / (1 + .061/12)300] / (.061/12)} |
PVA = $32,609,016.11 |
So, the total payment in month 60 will be: |
Month 60 payment = $212,098.17 + 32,609,016.11 |
Month 60 payment = $32,821,114.28 |
164 PART 3 Valuation of Future Cash Flows CHAPTER CASE S&S Air's Mortgage M ark Sexton...
S&S Air’s Mortgage ark Sexton and Todd Story, the owners of S&S Air, Inc., greatest Interest savings. At Todd's prompting, she goes IV Iwere impressed by the work Chris had done on finan on to explain a bullet loan. The monthly payments of a clal planning. Using Chris's analysis, and looking at the de bullet loan would be calculated using a 30-year tradi- mand for light alrcraft, they have decided that their existing tional mortgage. In this case, there would...
3. How long would it take for S&S Air to pay off the smart loan assuming 30-year traditional mortgage payments? Why is this shorter than the time needed to pay off the traditional mortgage? How much interest would the company save? S&S Air’s Mortgage ark Sexton and Todd Story, the owners of S&S Air, Inc., greatest Interest savings. At Todd's prompting, she goes IV Iwere impressed by the work Chris had done on finan on to explain a bullet loan....
3. [Loan Amortization] You have just obtained a $300,000 mortgage loan from the Chase bank toward the purchase of a home at 6% APR. The amortization schedule of your mortgage is set in the monthly payments for the next 30 years. A) What is the monthly loan payment? B) What is the balance of the loan after 20 years of loan payments? C) From the previous mortgage loan question, what will be the principal and the total interest that...
Mark Sexton and Todd Story have been discussing the future of S&S Air. The company has been experiencing fast growth, and the two see only clear skies in the company’s future. However, the fast growth can no longer be funded by internal sources, so Mark and Todd have decided the time is right to take the company public. To this end, they have entered into discussions with the investment bank of Crowe & Mallard. The company has a working relationship...
Mark Sexton and Todd Story have been discussing the future of S&S Air. The company has been experiencing fast growth, and the two see only clear skies in the company’s future. However, the fast growth can no longer be funded by internal sources, so Mark and Todd have decided the time is right to take the company public. To this end, they have entered into discussions with the investment bank of Crowe & Mallard. The company has a working relationship...
Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...
19. Mortgage payments Aa Aa Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals and are treated as reverse annuities. Mortgages are the reverse of annuities, because you get a lump-sum amount as a loan in the beginning, and then you make monthly payments to the lender. You've decided to buy a house that is valued at $1 million. You have $500,000 to use as a down payment on the house, and want to take out...
12. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals and are treated as reverse annuities. Mortgages are the reverse of annuities, because you get a lump-sum amount as a loan in the beginning and then you make monthly payments 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 want to take out a mortgage...
4. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals and are treated as reverse annuities. Mortgages are the reverse of annuities, because you get a lump-sum amount as a loan in the beginning, and then you make monthly payments to the lender. You've decided to buy a house that is valued at $1 million. You have $150,000 to use as a down payment on the house, and want to take out a mortgage...
Real Estate Finance answer all please . John Corbitt takes a fully amortizing mortgage for $80,000 at 10 percent interest for 30 years, monthly payments. What will be his monthly payment? 2. Dave Burns wants to buy a house. To do so, he must incur a mortgage. A local lender has determined that Dave can afford a monthly payment of $600, principal and interest. If the current interest rate on 30-yearm fixed-rate mortgage is 9.50 percent, what is the maximum...