Mortgage Worksheet Template printable pdf download

Mortgage Worksheet Template

Roaring Springs Mortgage

Name _______________________

Mortgage Calculator:

Note: You must click OUTPUT PARAMETERS to see all you payment numbers.

Business owners use different tools to help them plan fixed finances. We will use a web-based mortgage calculator to determine

how our mortgage payments would change with different payment plans, down payments, or interest rates. We will not use the

PMI or Property taxes for this study. Complete the table as you go. What patterns do you notice? How would this information

change our risk or opportunity cost depending on our decision?

You must use this formula to determine the Loan Amount: HOME VALUE - $500,000 = LOAN AMOUNT

Home Value

$2,000,000

$1,550,000

$1,050,000

Check out your savings by entering all

of the possible prices in the table as a

Loan Amount

360 month loan at a 4% interest rate:

Monthly

Payment

Monthly

Payment Pay-

off Date

Monthly Total

Interest Paid

Bi-Weekly

Payment

Bi-Weekly

Pay-off Date

Total Bi-

Weekly

Interest Paid

Risk or

Opportunity?

Mortgage Worksheet Template