Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are interested in purchasing a home. You will take out a mortgage of $310,000 to pay for the home and pay 4.5% interest. What

You are interested in purchasing a home. You will take out a mortgage of $310,000 to pay for the home and pay 4.5% interest. What will your monthly payment be if you take 15 years to pay off the loan?


Reference the loan information in the "Task 6-8 Data" cells as the arguments for your function.


What will your monthly payment be if you take 30 years to pay off the loan you worked with in task 6? (Please reference the loan information in the "Task 6-8 Data" cells as the arguments for your functions.)

Reference the loan information in the "Task 6-8 Data" cells as the arguments for your function.


How much money will you save if you pay off the loan in 15 years instead of 30 years?


Reference the total payment amounts in cells C38 and D38 to calculate the difference?


 



Task 6-8 Data Loan Amount Interest Rate* Number of Payments Monthly Payment 15 Year Mortgage -$310,000.00 4.50% 180 $0.00 30 Year Mortgage -$310,000.00 4.50% 360 Total Payments (PMT * # of PMTs) Difference between 30-year and 15-year payback (the 30 year amount - the 15 year amount) * Remember to divide the interest rate by 12 (to calculate the monthly interest rate) in your functions. $0.00

Step by Step Solution

3.47 Rating (167 Votes )

There are 3 Steps involved in it

Step: 1

SOLUTION To calculate the monthly payment for a 15year mortgage of 310000 at 45 interest we can use the PMT function in Excel PMT4512 1512 310000 This ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert Kemp, Jeffrey Waybright

2nd edition

978-0132771801, 9780132771580, 132771802, 132771586, 978-0133052152

More Books

Students also viewed these Accounting questions