Amortization _FS_Fin605_Villa
docx
keyboard_arrow_up
School
Dominican University *
*We aren’t endorsed by this school
Course
605
Subject
Finance
Date
Jan 9, 2024
Type
docx
Pages
2
Uploaded by verovilla4543
Veronica Villa
FIN 605
Application Assignment
December 2023
Using Trulia, I chose a home in West Elsdon. This home is 4 bed, 3 bath, single family home
listed at $309,900. After gathering the information from Trulia, I used a random number
generator on the website Calculator.net for my down payment, annual interest rate, and loan
life. I attached screenshots of my results at the end of this document. The summary information
is:
Summary Information
Home Price
$309,900
Down payment
$18,540
Loan Amount $
$291360
Annual Interest Rate
6.14%
Period Interest Rate
0.512%
Loan Life (in years)
27
Number of Payments per
Year
12
Total Number of Payments
324
Payment per period
$1,843.59
Sum of payments
$597,323.33
Interest Cost
After completing the excel sheet and reviewing the change in interest and principal, I noticed
that the interest and principal payments change over the life of the loan. In the first few years,
most of the monthly payments go towards interest, while the principal is a significantly lower
portion of the payment. As time goes on making payments and the balance of the loan
decreases, more of the monthly payment goes towards the principal amount. This is seen in the
declining interest amounts and increasing principal amounts in the payment schedule. Over the
27-year loan life, there is a steady decrease in the outstanding balance, which indicates a
steady reduction in the loan amount. This seems to be a common amortization pattern for fixed-
rate loans, where there is initially more interest towards the payment but gradually contribute
more toward the principal as the payments go on.
Home:
https://www.trulia.com/home/5544-s-kilbourn-ave-chicago-il-60629-2057846551
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
23
eBook
Print
References
Determine the amount of the Earned Income Credit in each of the following cases. Assume that the person or persons are eligible to
take the credit. Use Table 9-3.
Required:
Calculate the credit using the formulas.
Note: For all requirements, do not round intermediate calculations. Round your final answers to the nearest whole dollar amount.
a. A single person with earned income of $8,720 and no qualifying children.
Earned Income
Credit
$
667
b. A single person with earned income of $24,200 and two qualifying children.
$
6,195
c. A married couple filing jointly with earned income of $36,060 and one qualifying child.
$
2,849
arrow_forward
O CONSUMER MATHEMATICS
Finding the monthly payment, total payment, and interest for a...
When Laura bought her house, she got her mortgage through a bank.
The mortgage was a personal, amortized loan for $99,500, at an interest rate of 3.75%, with monthly payments for a term of 40 years.
For each part, do not round any intermediate computations and round your final answers to the nearest cent.
If necessary, refer to the list of financial formulas.
(a) Find Laura's monthly payment.
(b) If Laura pays the monthly payment each month for the full term,
find her total amount to repay the loan.
$0
(c) If Laura pays the monthly payment each month for the full term,
find the total amount of interest she will pay.
$0
X
Monthly Payment Formula
M=
P
r
12
r
1- ( 1 + 12 )
- 12t
arrow_forward
Q Search
References
Review
View
Help
Tell me what you want to do
O Editing
I U Dv Av .….
11
A
A B
出<=<三v|
Use the following information to answer questions #1-4
Mrs. Smith has a monthly payment of $230 for health insurance, a $500 deductible, an 80%/20% co-
insurance and co-payments of $15 for prescriptions and $45 for office visits.
1.
What is Mrs. Smith's premium?
a.
$45
b. $230
C.
$500
d. $1,000
2.
What amount will Mrs. Smith have to pay for medical services before the policy begins to pay?
a.
$45
b.
$230
C.
$500
d. $1,000
r for a small nrocedure costing $1,000 what percentage of the me
arrow_forward
I need help with the questions, provide the steps and find the right work in the Excel spreadsheet.
arrow_forward
The question is how do I make the Excel Tables correctly before trying to plot the remaining units and get by solving those in the spreadsheet?
arrow_forward
Need help plz
arrow_forward
fari File
D2L Understanding Loans and Simple Interest - 21516 MAT142 Topics In Coll...
IMG_384
Edit View History Bookmarks Window Help
IMG_38
esc
1
<
2
Tiana Klughart
Nellie wants to buy a $509,000.00 house. She makes a $120,000.00 down payment
and takes out a 15-year mortgage to pay for the rest. Her monthly mortgage payment
is $4,050.00.
a) What is the principal of her mortgage?
Principal
$
b) How much interest will she pay over the life of her loan?
Total interest
$
c) How much will she pay in total for her house?
Total paid
$
CHECK ANSWER
d2l.pima.edu
D2L 5.2 Understanding Loans and Simple Interest - 21516 MAT142 Topics...
7
3
Q
$
4
%
5
3D
6
&
7
e
8
9
Question 3 of 1
DEL Ch
www.
1
www
.
1
C
S
0
arrow_forward
Typed plzzz
Asap
Dont use AI BOT for the answer
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working!
arrow_forward
Denger
Don't upload image please
arrow_forward
Pls do fast its urgent... I will rate instantly for sure
Try to give solution in typed form
4. North Carolina provisional broker create a personal website separate from their friends website to advertise their real estate listing Ines Carolina Real Estate Commission rule their website must include
A. The National Association of Realtors trademark
B. the Brokers individual real estate license number
C. the name of the sole proprietor with a firm with which the broker is affiliated
D. A disclaimer that all the information on the website is believed to be true but is not guaranteed
arrow_forward
Hi I’m confused about these questions can you help me please?
arrow_forward
eBook
Question Content Area
Time Value of Money Concept
The following situations involve the application of the time value of money concept. Use the full factor when calculating your results.
Use the appropriate present or future value table:
FV of $1, PV of $1, FV of Annuity of $1 and PV of Annuity of $1
1. Janelle Carter deposited $9,840 in the bank on January 1, 2000, at an interest rate of 10% compounded annually. How much has accumulated in the account by January 1, 2017? Round to the nearest whole dollar.
2. Lee Spony made a deposit in the bank on January 1, 2010. The bank pays interest at the rate of 10% compounded annually. On January 1, 2017, the deposit has accumulated to $13,120. How much money did Lee originally deposit on January1, 2010? Round to the nearest whole dollar.
arrow_forward
Please Introduction and explanation and proper solution no copy without plagiarism please I give upvote
arrow_forward
Explanation it correctly and not use excel
arrow_forward
Goal
To use recursive sequence to determine the amount money owed on a loan after months
Role
You are a loan officer at a mortgage company.
Audience
Jim and Joan Miller are customers applying for a mortgage.
Situation
Jim and Joan Miller are borrowing $120,000 at 6.5% per annum compounded monthly for 30 years (360 months) to purchase a home. Their monthly
payment is determined to be $758.48.
Performance Task
You need to present Jim and Joan with a report detailing the following:
• Arecursive formula for their balance after each monthly payment has been made.
• To do this, use the formula: a, = an-1 (1+r) – 758.48
A determination of Jim and Joan's balance after the first payment. Don't forget the interest affecting their payment!
• Use a spreadsheet or graphing utility to create a table showing their balance after each monthly payment.
• Determine when the balance will be below $75,000.
• Determine when the balance will be paid off.
• Determine the interest expense when the loan is…
arrow_forward
Safari File Edit View History Bookmarks Window Help
Inbox (3,222) - tonygonzalez0100@g...
Bb Welcome, Tony - Blackboard Learn
learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com
Screenshot
2. Suppose Grandma wants to accumulate $100,000 for her grandchild's college education in 18
years. How much must she deposit today into an account with an APR of 4%, compounded
semiannually in order to have $100,000 in 18 years? Assume no additional deposits are made.
O
Bb NCBM 0222/MATD 0485 Unit 4 Conte...
DEC
7
Bb https://learn-us-east-1-prod-fleet02-x...
3. You want to save enough to have $40,000 for a down payment on a house in 6 years. How much
should you deposit today into an account with an APR of 4% compounded weekly in order to
have the down payment in 6 years?
tvi
PV:
=
PMT=
FV =
APR =
Periods =
Compounding:
PV: =
PMT=
FV =
APR =
Periods =
Compounding:
A
32
Wed Dec 7 12:03 AM
b Search results for 'Suppose Grandma...
t
PM
PM
. PM
t
t
PM
PM
t
PM
arrow_forward
Need correct answer with half an hour I'll upvote your answer
arrow_forward
Need help General accounting
arrow_forward
Preparing income and expense statement
Use Worksheet 2.2 Ariana and Nicholas Peterson are about to construct their income and expense statement for the year ending December 31, 2020. Nicholas is finishing up college and currently has no income. They have put together the following income and expense information for 2020:
Ariana's salary
$43,000
Reimbursement for travel expenses
1,700
Interest on:
Savings account
110
Bonds of Delta Corporation
70
Groceries
4,150
Rent
9,300
Utilities
960
Gas and auto expenses
650
Nicholas' tuition, books, and supplies
3,300
Books, magazines, and periodicals
280
Clothing and other miscellaneous expenses
2,900
Cost of photographic equipment purchased with charge card
2,200
Amount paid to date on photographic equipment
1,600
Ariana's travel expenses
1,950
Purchase of a used car (cost)
9,750
Outstanding loan balance on car
7,300
Purchase of bonds in Delta Corporation
4,900
Using the information provided,…
arrow_forward
Hello tutor please provide correct answer general accounting question
arrow_forward
eBook
Repaying a Loan
While Mary Corens was a student at the University of Tennessee, she borrowed $9,000 in student loans at an annual interest rate of 11%. If Mary repays $1,500 per year, then how long (to the nearest year) will it take her to repay the loan? Do not round intermediate calculations. Round your answer to the nearest whole number.
year(s)
arrow_forward
A borrower has two alternatives for a loan: (1) issue a $630,000, 75-day, 6% note or (2) issue a $630,000, 75-day note that the creditor discounts at 6%. Assume a 360-day
year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.
X
Open spreadsheet
a. Compute the amount of the interest expense for each option. Round your answer to the nearest dollar.
for each alternative.
b. Determine the proceeds received by the borrower in each situation. Round your answers to the nearest dollar.
< (1) $630,000, 75-day, 6% interest-bearing note: $
(2) $630,000, 75-day note discounted at 6%: $
c. Alternative
is more favorable to the borrower because the borrower
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working!
arrow_forward
QUESTION 32
Good news! Louie has been approved for a 25-year mortgage with an 8% interest rate for the
dollar amount of $95,000. What will Louie's monthly payment be (to the nearest cent).
Neatly write out your work and answer on paper (or a tablet) and then upload it as a pdf, png, gif,
ing
arrow_forward
webapps%252Fportal
Jsp%253
tab_tab_gr..
Jill Diamond bought a home for $190,000 with a down payment of $65,000. The rate of interest was 7% for 35 years. Her monthly mortgage payment is:
Multiple Choice
$843.75
$978.57
$798.75
$834.57
None of these
回可可
ace
arrow_forward
None
arrow_forward
groceries
vision
8. Calculate the total annual housing costs for a couple with bi-weekly mortgage payments of $978.88, monthly
condominium fees of $325, and monthly utility expenses averaging $275.
a. $58 101.76
b. $32 650.88
c. $18 946.56
d. $13 073.28
arrow_forward
None
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

PFIN (with PFIN Online, 1 term (6 months) Printed...
Finance
ISBN:9781337117005
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Related Questions
- 23 eBook Print References Determine the amount of the Earned Income Credit in each of the following cases. Assume that the person or persons are eligible to take the credit. Use Table 9-3. Required: Calculate the credit using the formulas. Note: For all requirements, do not round intermediate calculations. Round your final answers to the nearest whole dollar amount. a. A single person with earned income of $8,720 and no qualifying children. Earned Income Credit $ 667 b. A single person with earned income of $24,200 and two qualifying children. $ 6,195 c. A married couple filing jointly with earned income of $36,060 and one qualifying child. $ 2,849arrow_forwardO CONSUMER MATHEMATICS Finding the monthly payment, total payment, and interest for a... When Laura bought her house, she got her mortgage through a bank. The mortgage was a personal, amortized loan for $99,500, at an interest rate of 3.75%, with monthly payments for a term of 40 years. For each part, do not round any intermediate computations and round your final answers to the nearest cent. If necessary, refer to the list of financial formulas. (a) Find Laura's monthly payment. (b) If Laura pays the monthly payment each month for the full term, find her total amount to repay the loan. $0 (c) If Laura pays the monthly payment each month for the full term, find the total amount of interest she will pay. $0 X Monthly Payment Formula M= P r 12 r 1- ( 1 + 12 ) - 12tarrow_forwardQ Search References Review View Help Tell me what you want to do O Editing I U Dv Av .…. 11 A A B 出<=<三v| Use the following information to answer questions #1-4 Mrs. Smith has a monthly payment of $230 for health insurance, a $500 deductible, an 80%/20% co- insurance and co-payments of $15 for prescriptions and $45 for office visits. 1. What is Mrs. Smith's premium? a. $45 b. $230 C. $500 d. $1,000 2. What amount will Mrs. Smith have to pay for medical services before the policy begins to pay? a. $45 b. $230 C. $500 d. $1,000 r for a small nrocedure costing $1,000 what percentage of the mearrow_forward
- fari File D2L Understanding Loans and Simple Interest - 21516 MAT142 Topics In Coll... IMG_384 Edit View History Bookmarks Window Help IMG_38 esc 1 < 2 Tiana Klughart Nellie wants to buy a $509,000.00 house. She makes a $120,000.00 down payment and takes out a 15-year mortgage to pay for the rest. Her monthly mortgage payment is $4,050.00. a) What is the principal of her mortgage? Principal $ b) How much interest will she pay over the life of her loan? Total interest $ c) How much will she pay in total for her house? Total paid $ CHECK ANSWER d2l.pima.edu D2L 5.2 Understanding Loans and Simple Interest - 21516 MAT142 Topics... 7 3 Q $ 4 % 5 3D 6 & 7 e 8 9 Question 3 of 1 DEL Ch www. 1 www . 1 C S 0arrow_forwardTyped plzzz Asap Dont use AI BOT for the answerarrow_forwardhelp please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working!arrow_forward
- Denger Don't upload image pleasearrow_forwardPls do fast its urgent... I will rate instantly for sure Try to give solution in typed form 4. North Carolina provisional broker create a personal website separate from their friends website to advertise their real estate listing Ines Carolina Real Estate Commission rule their website must include A. The National Association of Realtors trademark B. the Brokers individual real estate license number C. the name of the sole proprietor with a firm with which the broker is affiliated D. A disclaimer that all the information on the website is believed to be true but is not guaranteedarrow_forwardHi I’m confused about these questions can you help me please?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- PFIN (with PFIN Online, 1 term (6 months) Printed...FinanceISBN:9781337117005Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning

PFIN (with PFIN Online, 1 term (6 months) Printed...
Finance
ISBN:9781337117005
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning