New Scenario (Independent): Brian takes out a home loan of $473,800 today. He wants to make equal yearly repayments $47,380 starting one year from today. The interest rate is 7.4 % p.a. compounded weekly. Calculate the number of yearly repayments (including the final smaller repayment) Brian needs to make to fully repay the loan.

EBK CFIN
6th Edition
ISBN:9781337671743
Author:BESLEY
Publisher:BESLEY
Chapter4: Time Value Of Money
Section: Chapter Questions
Problem 25PROB
icon
Related questions
Question

Use one of excel's TVM functions among =PV, =FV, =PMT, =RATE, =NPER, =CUMIPMT, =CUMPRINC answer this questions. (Please input the functions in excel and screeshot it )

 

New Scenario (Independent):
Brian takes out a home loan of $473,800 today. He wants to make equal yearly repayments of
$47,380 starting one year from today. The interest rate is 7.4 % p.a. compounded weekly.
Calculate the number of yearly repayments (including the final smaller repayment) Brian
needs to make to fully repay the loan.
Transcribed Image Text:New Scenario (Independent): Brian takes out a home loan of $473,800 today. He wants to make equal yearly repayments of $47,380 starting one year from today. The interest rate is 7.4 % p.a. compounded weekly. Calculate the number of yearly repayments (including the final smaller repayment) Brian needs to make to fully repay the loan.
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Cost of Credit
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning