In which month does the amount of principal in a monthly payment first exceed the amount of interest? _____ (b) How much interest is repaid for the term of the loan? (Round your answer to the nearest cent.) _____$ (c) If the loan amount was $750,000 instead of $500,000, would the month in which the amount of principal in a monthly payment first exceeded the amount of interest change?

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter19: Lease And Intermediate-term Financing
Section: Chapter Questions
Problem 14P
icon
Related questions
Question

Using a spreadsheet program, create an amortization schedule for a 30-year mortgage of $500,000 at an annual interest rate of 4.24%.

(a) In which month does the amount of principal in a monthly payment first exceed the amount of interest?

_____

(b) How much interest is repaid for the term of the loan? (Round your answer to the nearest cent.)

_____$

(c) If the loan amount was $750,000 instead of $500,000, would the month in which the amount of principal in a monthly payment first exceeded the amount of interest change? 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 8 steps with 32 images

Blurred answer
Similar questions
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L
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
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning