21
pdf
keyboard_arrow_up
School
The University of Western Australia *
*We aren’t endorsed by this school
Course
1102
Subject
Finance
Date
Jan 9, 2024
Type
Pages
3
Uploaded by GeneralStrawNightingale11
2023/9/3 11:46 Corporate Finance 6E, Fall 1 2023-Yueheng Wang Student: Yueheng Wang Course: Corporate Finance 6E, Fall 1 2023 Instructor: Ko Wang Book: Berk/DeMarzo: Corporate Finance, 6e Date: 9/3/23 Time: 11:46 AM Your friend tells you he has a very simple trick for taking one-third of the time it takes to repay your mortgage: Use your holiday bonus to make an extra payment on January 1 of each year (that is, pay your monthly payment due on that day twice). Assume that the mortgage has an original balance of $100,000, has an original term of 30 years, and has an APR of 12.1%. a. If you take out your mortgage on January 1 (so that your first payment is due on February 1), and you make your first extra payment at the end of the first year, in what year will you finish repaying your mortgage? b. If you take out your mortgage on July 1 (so that the first payment is on August 1), and you make the extra payment each January, in how many months will you pay off your mortgage? c. How will the amount of time it takes to pay off the loan given this strategy vary with the interest rate on the loan? Note: Make sure to round all intermediate calculations to at least 6 decimal places. a. If you take out your mortgage on January 1 (so that your first payment is due on February 1), and you make your first extra payment at the end of the first year, in what year will you finish repaying your mortgage? Here is the cash flow timeline for this problem: Periods 0 1 2 360 Cash Flows $100,000 -C -C C For the original mortgage, we are paying interest every month at a monthly interest rate of 12.1%/12 = 1.0083%. Therefore, the monthly loan payment can be calculated using the following formula: PV 1 1 _— 1_ r [ <1+r>"] where C is the monthly payment, PV is the loan amount, r is the monthly discount rate, and n is the number of compounding periods per year. Therefore, $100,000 C= =$1,036.29 1 1 —_— 1 - 0.010083 [ (1+ 0.010083)360 ] The monthly loan payment is $1,036.29. Using a financial calculator or Excel: N Y PV PMT FV Given: 360 1.0083 100,000 0 Solve for: -1,036.29 Excel Formula: = PMT(RATE,NPER,PV,FV) = PV(0.010083,360,100000,0) Here is the cash flow timeline with the original monthly payments and extra payments: Periods 0 1 12 13 24 25 n Cash Flows$100,000 — $1,036.29 -$1,036.29%$1,036.29 -$1,036.29%$1,036.29 -$1,036.29 -$1,036.29 -$1,036.29 Next, let's find the equivalent one time annual payment to these cash flows (as though we only made a single payment each January). The future value of the above cash flows is the future value of the monthly annuity plus the future value of the extra payment: (1+n7-1 FV=Cx f +C Therefore, (1+0.010083)12 - 1 0.010083 FVy yr = $1,036.20 [ ] +$1,036.29=$14,185.11 So, the new payment plan is equivalent to paying $14,185.11 at the end of every year. Then, to compute the number of years to pay off the loan, we set the present value of the loan payments equal to the original balance and solve for n using the following formula: https://xlitemprod.pearsoncmg.com/apifv1/print/en-us/highered 1/3
2023/9/3 11:46 Corporate Finance 6E, Fall 1 2023-Yueheng Wang lwa] PV=—x|1- r (140" where PV is the original loan amount, C is the annual payment, r is the annual interest rate, and n is the number of years. The equivalent annual interest rate is r= (1 + 0.010083)12 -1=0.127937 = 12.7937%. Therefore, $100.000 $14.185.11 [ 1 L ST o x - 0.127937 (1+0.127937)" 1 $100,000 x 0.127937 (1+0.127937)" $14,185.11 (1+0.127937)" =10.194774 log(10.194774) n= =19.29 log(1 + 0.127937) The approximate number of years to pay off the loan is 19.29 years. Using a financial calculator or Excel: N Y PV PMT FV Given: 12.7937 100,000 -14,185.11 0 Solve for: 19.29 Excel Formula: = NPER(RATE,PMT,PV,FV)=NPER(0.127937, - 14185.11,100000,0) It will take about 19 years to pay off the loan, which is close to 2/3 of its life of 30 years, and your friend is right. b. If you take out your mortgage on July 1 (so that the first payment is on August 1), and you make the extra payment each January, in how many months will you pay off your mortgage? Here is the cash flow timeline with the original monthly payments and extra payments: Periods 0 1 6 7 18 19 n Cash Flows$100,000 — $1,036.29 -$1,036.29%$1,036.29 - $1,036.29%$1,036.29 -$1,036.29 -$1,036.29 -$1,036.29 Let's find the equivalent one time annual payment to these cash flows (as though we only made a single payment each July). The future value of the above cash flows is the future value of the monthly annuity plus the future value of the extra payment: (1+n"-1 — FV=C><[ +Cx(1+nt where t is the number of periods the extra payment is compounded. Therefore, (1+0.010083)12 - 1 0.010083 FVy yr =$1,036.29 [ ] +$1,036.29 x (1 +0.010083)° = $14,249.41 So, the new payment plan is equivalent to paying $14,249.41 at the end of every year. Then, to compute the number of years to pay off the loan, we set the present value of the loan payments equal to the original balance and solve for n using the following formula: $100.000 $14,249.41 1 1 ’ e —— x - 0.127937 (1+0.127937)" 1 __ $100,000x0.127937 (1+0.127937)" $14,249.41 (1+0.127937)" = 9.788632 log(9.788632) "= Tog(1+0.127937) _ The approximate number of years to pay off the loan is 18.95 years. Using a financial calculator or Excel: https://xlitemprod.pearsoncmg.com/apifv1/print/en-us/highered 2/3
2023/9/3 11:46 Corporate Finance 6E, Fall 1 2023-Yueheng Wang N Iy PV PMT FV Given: 12.7937 100,000 - 14,249.41 0 Solve for: 18.95 Excel Formula: = NPER(RATE,PMT,PV,FV)=NPER(0.127937, — 14249.41,100000,0) It will take about 19 years to pay off the loan, which is close to 2/3 of its life of 30 years, and your friend is right. c. How will the amount of time it takes to pay off the loan given this strategy vary with the interest rate on the loan? This strategy will reduce the amount of time to pay off the loan by a greater amount as the interest rate increases. https://xlitemprod.pearsoncmg.com/apifv1/print/en-us/highered 3/3
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
Related Documents
Related Questions
dit View
@
Window
History Bookmarks
standing Loans and Simple Interest - 21516 MAT142 Topics In Coll...
W
DERIVITA
Tiana Klughart
Principal
a) What is the principal of her mortgage?
Nellie wants to buy a $1,110,000.00 house. She makes a $140,000.00 down
payment and takes out a 25-year mortgage to pay for the rest. Her monthly mortgage
payment is $4,350.00.
π
ab
va sin
b) How much interest will she pay over the life of her loan?
Total interest-
$
aº
C
CHECK ANSWER
3
8
c) How much will she pay in total for her house?
Total paid
$
J
E
80
Help
b
$
d21.pima.edu
D2L 5.2 Understanding Loans and Simple Interest - 21516 MAT142 Topics...
4
R
%
5
T
3D
6
3
MacBook Pro
Y
&
7
U
8
Question 3 of 15
DZL Chapter 5.2 - 21516
Preview
(
9
www
BALKAN
BACK
Question 1
H
Question 2
Question 3
Question 4
Question 5
Question 6
Question 7
Question 8
Question 9
Question 1
Question 1
Question 1
Question 1
Question 1
Question 1
Summary
0
0
arrow_forward
I need answer typing
arrow_forward
In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, create a function that determines what your monthly payment will be.
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working!
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
Please helppp, this is for financial mathematics, thank youuu
arrow_forward
tion
□ [myUT
1
ovide your answer below:
N
Module 2.5: Understanding
ALT
Courses
CURRENT OBJECTIVE
Calculate the monthly payment and interest cost for a mortgage
Question
A mutual fund manager wishes to purchase a property that's been valued at $1.5 m. She has $200,000 in cash to use as a
deposit, and she will require a mortgage for the rest. The annual interest rate on the loan is 2.45% and the loan is for 25
years. Calculate the monthly payments.
Round your answer to the nearest cent.
Do NOT round until you have calculated the final answer.
X
C
knewton.com
V
B
Module 2.5: Understanding & in
N
FEEDBACK
3
V-
Content
ALT
MORE INSTRUCTION
A
+
2.1
FN
88
11
SUB
SHIFT
4
arrow_forward
You lend a friend
$10,000,
for which your friend will repay you
$27,027
at the end of
5
years. What interest rate are you charging your "friend"?
Question content area bottom
Part 1
The interest rate you are charging your friend on the loan is
enter your response here%.
arrow_forward
Stephen has just purchased a home for $128000 A mortgage company has approved his loan application for a 30-year fixed-rate loan at 4.75 %. Stephen has agreed to pay 30%
of the purchase price as a down payment. Find the down payment, amount of mortgage, and monthly payment.
LOADING...
Click the icon to view the table of the monthly payment of principal and interest per $1,000 of the amount financed.
Question content area bottom
Part 1
The down payment is about?
(Round to the nearest cent as needed.)
Part 2
The mortgage amount is about?
(Round to the nearest cent as needed.)
Part 3
The monthly mortgage payment is about?
(Round to the nearest cent as needed.)
arrow_forward
Assignment - 11. Quiz: Savings Accounts
ASSIGNMENTS
COURSES
SECTION 1 OF 1
QUESTION 2 OF 8
Attempt 1 of 1
1
4
7
8
<.
Charlie invests $500 in a savings account with an annual interest rate of 12%. How much simple interest will he collect in
4 years?
O 48
O 120
240
O 420
NEXT QUESTION
O ASK FOR HELP
TURN IT IN
Type here to search
arrow_forward
fari File
D2L Understanding Loans and Simple Interest - 21516 MAT142 Topics In Coll...
IMG_384
Edit View History Bookmarks Window Help
IMG_38
esc
1
<
2
Tiana Klughart
Nellie wants to buy a $509,000.00 house. She makes a $120,000.00 down payment
and takes out a 15-year mortgage to pay for the rest. Her monthly mortgage payment
is $4,050.00.
a) What is the principal of her mortgage?
Principal
$
b) How much interest will she pay over the life of her loan?
Total interest
$
c) How much will she pay in total for her house?
Total paid
$
CHECK ANSWER
d2l.pima.edu
D2L 5.2 Understanding Loans and Simple Interest - 21516 MAT142 Topics...
7
3
Q
$
4
%
5
3D
6
&
7
e
8
9
Question 3 of 1
DEL Ch
www.
1
www
.
1
C
S
0
arrow_forward
Problem Set for Credit Card Debt
MATH 113: Section 9.4a
Page 2 of 2
3. Rachel is purchasing a new camera that costs $3800 for her photography business. Rachel
uses a credit card that has an APR of 16.99%.
a. How long will it take her to pay off the camera if she makes monthly payments of
$75?
b. How much will she pay in the long run for the camera if she makes monthly
payments of$75?
arrow_forward
Accounting you are considering purchasing new solve this question
arrow_forward
Help me sir please in text not handwritten
arrow_forward
Practice Question 2You need to borrow $800,000 to buy a house.You borrow the money from a bank via amortgage with a 25-year term. The mortgagerequires you to make monthly repayments, withthe first payment one month from now. If themonthly interest rate is 0.5%, work out the fairmonthly repayment that you will have to make.
arrow_forward
Please help me get the right answer A thru D
arrow_forward
Pls. Help me with only e and f part. Only e and f
arrow_forward
er
A https://player-ui.mheducation.com/#/epub/sn_7cac#epubcfi(%2F6%2F326%5Bdata-uuid-ab153a0624d544c2822
6. Comparing Total Mortgage Payments. Which mortgage would result in higher total payments?
Mortgage A: $970 a month for 30 years
Mortgage B: $760 a month for 5 years and $1,005 for 25 years
1.1
20
far $120.000 storts ot 4.01
arrow_forward
Can you fill in the tables and answer the questions?
I would appreciate it If you could also explain how to plug this into a financial calculator.
Here's a link to a financial calculator: http://www.fncalculator.com/financialcalculator?type=tvmCalculator
arrow_forward
Hi expart give correct solution for this question
arrow_forward
View
History Bookmarks
Bookmarks Window Help
rtized Loans - 21516 MAT142 Topics In College Math
DERIVITA
Tiana Klughart
$
CHECK ANSWER
O
John is looking for a new car. He has a down payment of $1,750.00 and wants to pay
$450.00 per month for 4 years. The best deal he found for an amortized loan is his
local bank, at a rate of 2.75%. What is the highest price car he should consider
buying?
7
a
$
**** --
d2l.pima.edu
%
D2L 5.3 Amortized Loans - 21516 MAT142 Topics In College Math
Activity Details
5
СЛ
Chapter 5.3
S
* S
C
307+
Question 3 of:
(
C
S
arrow_forward
Question Help ▼
You plan to deposit $800 in a bank account now and $500 at the end of the year. If the account earns 3% interest per year, what will be the balance in the account right after you make the second
deposit?
The balance in the account right after you make the second deposit will be $
(Round to the nearest dollar.)
Enter your answer in the answer box.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- dit View @ Window History Bookmarks standing Loans and Simple Interest - 21516 MAT142 Topics In Coll... W DERIVITA Tiana Klughart Principal a) What is the principal of her mortgage? Nellie wants to buy a $1,110,000.00 house. She makes a $140,000.00 down payment and takes out a 25-year mortgage to pay for the rest. Her monthly mortgage payment is $4,350.00. π ab va sin b) How much interest will she pay over the life of her loan? Total interest- $ aº C CHECK ANSWER 3 8 c) How much will she pay in total for her house? Total paid $ J E 80 Help b $ d21.pima.edu D2L 5.2 Understanding Loans and Simple Interest - 21516 MAT142 Topics... 4 R % 5 T 3D 6 3 MacBook Pro Y & 7 U 8 Question 3 of 15 DZL Chapter 5.2 - 21516 Preview ( 9 www BALKAN BACK Question 1 H Question 2 Question 3 Question 4 Question 5 Question 6 Question 7 Question 8 Question 9 Question 1 Question 1 Question 1 Question 1 Question 1 Question 1 Summary 0 0arrow_forwardI need answer typingarrow_forwardIn the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, create a function that determines what your monthly payment will be.arrow_forward
- help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working!arrow_forwardTtme 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_forwardPlease helppp, this is for financial mathematics, thank youuuarrow_forward
- tion □ [myUT 1 ovide your answer below: N Module 2.5: Understanding ALT Courses CURRENT OBJECTIVE Calculate the monthly payment and interest cost for a mortgage Question A mutual fund manager wishes to purchase a property that's been valued at $1.5 m. She has $200,000 in cash to use as a deposit, and she will require a mortgage for the rest. The annual interest rate on the loan is 2.45% and the loan is for 25 years. Calculate the monthly payments. Round your answer to the nearest cent. Do NOT round until you have calculated the final answer. X C knewton.com V B Module 2.5: Understanding & in N FEEDBACK 3 V- Content ALT MORE INSTRUCTION A + 2.1 FN 88 11 SUB SHIFT 4arrow_forwardYou lend a friend $10,000, for which your friend will repay you $27,027 at the end of 5 years. What interest rate are you charging your "friend"? Question content area bottom Part 1 The interest rate you are charging your friend on the loan is enter your response here%.arrow_forwardStephen has just purchased a home for $128000 A mortgage company has approved his loan application for a 30-year fixed-rate loan at 4.75 %. Stephen has agreed to pay 30% of the purchase price as a down payment. Find the down payment, amount of mortgage, and monthly payment. LOADING... Click the icon to view the table of the monthly payment of principal and interest per $1,000 of the amount financed. Question content area bottom Part 1 The down payment is about? (Round to the nearest cent as needed.) Part 2 The mortgage amount is about? (Round to the nearest cent as needed.) Part 3 The monthly mortgage payment is about? (Round to the nearest cent as needed.)arrow_forward
- Assignment - 11. Quiz: Savings Accounts ASSIGNMENTS COURSES SECTION 1 OF 1 QUESTION 2 OF 8 Attempt 1 of 1 1 4 7 8 <. Charlie invests $500 in a savings account with an annual interest rate of 12%. How much simple interest will he collect in 4 years? O 48 O 120 240 O 420 NEXT QUESTION O ASK FOR HELP TURN IT IN Type here to searcharrow_forwardfari File D2L Understanding Loans and Simple Interest - 21516 MAT142 Topics In Coll... IMG_384 Edit View History Bookmarks Window Help IMG_38 esc 1 < 2 Tiana Klughart Nellie wants to buy a $509,000.00 house. She makes a $120,000.00 down payment and takes out a 15-year mortgage to pay for the rest. Her monthly mortgage payment is $4,050.00. a) What is the principal of her mortgage? Principal $ b) How much interest will she pay over the life of her loan? Total interest $ c) How much will she pay in total for her house? Total paid $ CHECK ANSWER d2l.pima.edu D2L 5.2 Understanding Loans and Simple Interest - 21516 MAT142 Topics... 7 3 Q $ 4 % 5 3D 6 & 7 e 8 9 Question 3 of 1 DEL Ch www. 1 www . 1 C S 0arrow_forwardProblem Set for Credit Card Debt MATH 113: Section 9.4a Page 2 of 2 3. Rachel is purchasing a new camera that costs $3800 for her photography business. Rachel uses a credit card that has an APR of 16.99%. a. How long will it take her to pay off the camera if she makes monthly payments of $75? b. How much will she pay in the long run for the camera if she makes monthly payments of$75?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education