Question
In this lab, you will: Required: 1. Calculate the monthly payment for a 30-year mortgage loan. 2. Calculate the amount of interest that youd pay
In this lab, you will:
Required:
1. Calculate the monthly payment for a 30-year mortgage loan.
2. Calculate the amount of interest that youd pay for a 30-year mortgage loan.
Ask the Question: How much interest do you pay over the life of a 30-year mortgage?
Master the Data: There is no data file for this lab. We will make the needed calculations and input the data as we go.
To compute the mortgage payments, well need to know a few things:
- The size of the mortgage loan
- The interest rate
- The length of the loan (number of months)
Lets suppose you would like to buy a home for $250,000. But like most U.S. citizens, you dont have enough cash on hand to pay for the full house. But were in luck! Signature Bank has agreed to offer you a 30-year mortgage loan, but requires that you pay 20 percent down ($50,000 = 20% of $250,000) to qualify for their mortgage loan of $200,000 in this way:
$250,000 | Cost of home |
50,000 | Required 20% down payment ($50,000 = 20% of $250,000) (The |
cash you need to have available to pay when closing on the home) | |
$200,000 | Amount of the bank loan |
Software needed
- Excel
- Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)
Perform the Analysis: Refer to Lab 1-3 in the text for instructions and steps for each of the lab parts.
Share the Story: Accountants need to know how much of each monthly mortgage (or bond) payment goes toward interest
Upload the Word or PDF document containing your Lab screenshots using the button below.
Take a screenshot of the top 20 lines of your 360-month amortization schedule and label it Lab 1-3 Submission.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started