Mortgage Amortization Homework | Best Assignment Helpers

MATH 123 PROJECT 2
Introduction
The purpose of this project is to delve more deeply into the details of mortgage loans. Students will learn
how to create an amortization schedule, determine total payments, total interest, and use ratios to compare
and interpret quantities. In addition to an in-depth view of mortgages, other details of home ownership will
be investigated: property taxes, maintenance and insurance costs, closing fees, equity, and more. When
completed, this comprehensive mortgage loan project can be used to investigate many of the details in
involved in choosing a mortgage loan.
Data
Research your expected income after you graduate. A link to annual median salaries can be found at:
http://www.bls.gov/oes/current/oes_in.htm#27-0000. Assume the following: an affordable loan amount is 2.5
times your annual salary, a 4.25% APR, and a 30-year mortgage. With this information, the monthly
mortgage payment can be calculated.
In addition to monthly mortgage payments, there are additional monthly fees we will consider: property
taxes, maintenance fees, and home owner’s insurance. We will also consider buyer and seller closing costs1
,
which occur at the time of purchase and selling of a property. Other fees/costs, such as down payments,
landscaping, etc.2 will not be considered here. Also, we will assume that no value in property is lost. That is,
Buying and selling prices are the same. Table 1 summarizes the fees/costs, their percentages/amounts, and
how to calculate them.
Table 1. Additional monthly fees and closing costs3
.
Fee Percentage/Amount How to Calculate
Property Tax 1.1% π‘€π‘œπ‘›π‘‘β„Žπ‘™π‘¦ 𝑓𝑒𝑒 =
0.011 Γ— π‘ƒπ‘Ÿπ‘œπ‘π‘’π‘Ÿπ‘‘π‘¦ π‘‰π‘Žπ‘™π‘’π‘’
βˆ—
12
Maintenance Fees 1.5% π‘€π‘œπ‘›π‘‘β„Žπ‘™π‘¦ 𝑓𝑒𝑒 =
0.015 Γ— π‘ƒπ‘Ÿπ‘œπ‘π‘’π‘Ÿπ‘‘π‘¦ π‘‰π‘Žπ‘™π‘’π‘’
12
Homeowners Insurance $100 per month π‘€π‘œπ‘›π‘‘β„Žπ‘™π‘¦ 𝑓𝑒𝑒 = $100
Closing Costs (Buyer) 4% 𝐹𝑒𝑒 π‘Žπ‘‘ π‘‘π‘–π‘šπ‘’ π‘œπ‘“ π‘π‘’π‘Ÿπ‘β„Žπ‘Žπ‘ π‘’ = 0.04 Γ— π‘ƒπ‘Ÿπ‘œπ‘π‘’π‘Ÿπ‘‘π‘¦ π‘‰π‘Žπ‘™π‘’π‘’
Closing Costs (Seller) 9% 𝐹𝑒𝑒 π‘Žπ‘‘ π‘‘π‘–π‘šπ‘’ π‘œπ‘“ 𝑠𝑒𝑙𝑙𝑖𝑛𝑔 = 0.09 Γ— π‘ƒπ‘Ÿπ‘œπ‘π‘’π‘Ÿπ‘‘π‘¦ π‘‰π‘Žπ‘™π‘’π‘’
*For this project, property value is equal to the cost of the home and the amount of the mortgage loan.
Background
Carl Sagan, a prominent scientist and educator, said: β€œWe live in a society exquisitely dependent on science
and technology, in which hardly anyone knows anything about science and technology.” He also suggested:
β€œScience confers power on anyone who takes the trouble to learn it.” As a lifelong educator in the
mathematical and scientific arts, I believe these statements are truer and truer every day. In this project, we’ll
investigate some common beliefs and use logical reasoning to come to our own conclusions, based on a
quantitative analysis.
Buying a home is usually an exciting and nerve-wracking event, especially for first-time buyers who may be
beginning their family lives and/or careers. Most people in the United States believe that home ownership
1 More information on closing costs can be researched at: https://www.investopedia.com/mortgage/mortgageguide/closing-costs/ and https://www.zillow.com/sellers-guide/closing-costs-for-sellers/
2 Other fees may include: hazard insurance, heating and electricity, water, sewage, internet/cable, property management
fees, private mortgage insurance
3 Property taxes can vary widely; a national average is used. Maintenance fees usually range from 1%-4%. Homeowners
insurance can vary widely; $100 per month is assumed here. Buyer closing costs are typically 3%-6%, and seller closing
costs are typically 8%-10%. More information on closing costs can be found in the links above.
MATH 123 PROJECT 2
actually means, β€œowning their home.” However, for many, this is a myth. Most Americans who have home
mortgages will never own their own home, because most will never pay off their mortgage loan (and even if
they manage, property taxes need to be paid).
Not long ago, people lived in their homes for at least the timeframe of the mortgage (15-30 years), up to 40-
50 years. Today, that statistic has radically changed. The average length of a mortgage fluctuates, but
recently it has been an average of 10 years. In some years, it has been as low as 7 years4
. So how does this
work? If families aren’t really owning their homes, who does? Who are the families’ β€œlandlords”—from
whom are the families β€œrenting?”5
In addition to the myth of owning a home, many people believe they are making an investment that will grow
in time. Part of every mortgage payment goes toward paying off the loan (principal), and part goes to paying
interest on the loan. The cumulative sum of all those parts of payments going toward the principal is called
equity. For example, say a loan was for $150,000, and after so many years the buyer owes $130,000. The
difference, $20,000, is how much of the loan has been paid off, and this amount is called equity. However,
you will show that this equity can be less than the interest payments, and that the plethora of fees and costs
diminish the equity into hardly anything that could be considered an β€œinvestment.”
Calculations/Spreadsheet
Create an amortization schedule for the loan amount/housing cost based on the median salary you found and
a 4.25% APR, 30-year mortgage. Use the schedule and the formulas learned in class to answer the following
questions. Organize the data and results using a spreadsheet, i.e., Excel. Use programmed formulas for any
and all calculations. An example of a data table is shown in Figure 1. Be sure to display your entered and
calculated data in an organized fashion. Use currency/accounting, percent, and decimal formatting to present
your data in a professional matter. You will be graded on accuracy and presentation.
Total length of loan calculations (30 years)
1) What are the mortgage loan amount and mortgage monthly payment?
2) What is the total amount of all mortgage payments? What total interest is paid over the life of the loan?
3) What is the ratio of total interest paid to mortgage loan amount? Express this as a percentage.
4) Using the property tax and maintenance rates, calculate the additional monthly fees from these sources.
5) Using the fees calculated in 4) and the $100 amount for insurance, what is the total monthly payment?
(total monthly payment = mortgage monthly payment + taxes + maintenance + insurance).
6) What is the total amount paid over the course of the loan?
7) What is the ratio of total amount paid (the value calculated in 6) to mortgage loan amount? Express this
as a decimal.
Partial length of loan calculations (7 and 10 years)
8) What are the total closing costs (buyer AND seller)?
9) Use the amortization schedule and report the total equity, interest, mortgage amount, and total amounts
paid for 7 and 10 years.
10) What are the β€œGrand Totals” for 7 and 10 years? (Total paid + Closing costs). This represents the total
β€œrent” paid for 7 and 10 years.
11) Subtract the total equity from the Grand Total for 7 and 10 years. This represents the total cost of
β€œrenting” for 7 and 10 years.
12) Use the total cost of β€œrenting” and calculate the β€œEffective Monthly Rent,” which is the total cost of
β€œrenting” divided by the number of months. Do this for 7 and 10 years.
13) What is the ratio of total interest to total equity for 7 and 10 years? Express these as decimals.
4 https://themortgagereports.com/26307/homebuyer-tenure-how-long-are-people-staying-in-their-houses
5 Quotes are used here because technically speaking β€œlandlord” and β€œrent” are used in a different context. However,
β€œmath logic” (quantitative reasoning) will show there is a very fine line in these definitions.
MATH 123 PROJECT 2
Figure 1. An example of a data table in Excel. Note that the amortization columns extend downward to
month 360, which is 30 years.
If you are having difficulties with any of the tasks in Excel, please watch the tutorial for this project.
However, it is crucial to read the entire project instructions, including the Calculations/Spreadsheet AND
Discussion/Paper sections. PROJECT 2 TUTORIAL (Ctrl + Click to follow link)
Discussion/Paper
Answer the following questions written in the format of a paper, i.e., not a bulleted-list, numbered answers,
etc. Use good grammar, complete sentences, and write the paper to an appropriate audience (a typical person
not trained in MATH 123). Use paragraphs to organize your answers, and think carefully about how you are
going to discuss them (you may want to read all of the questions first). Answers should be justified using
your calculations (quantitative reasoning), and be sure to explain the results in a way that most people can
understand. You will be graded on organization, accuracy, clarity, and basic composition.
MATH 123 PROJECT 2
Total length of loan discussion (30 years)
a) In problem 3, you determined the ratio of total interest paid to mortgage loan amount. Write at least a
sentence explaining what this means. Why is this percentage so much larger than the APR? In your opinion,
does the APR seem misleading?
b) How does the total monthly payment (problem 5) compare to the mortgage monthly payment (problem 1)?
Use a relative change statement with the mortgage monthly payment as the reference value, 𝑄𝑖
.
c) In problem 7, you determined the ratio of total amount paid to mortgage loan amount. Write at least a
sentence explaining what this means.
Partial length of loan discussion (7 and 10 years)
In problem 12, you calculated the β€œEffective Monthly Rent.” Basically, this number represents what it cost
per month to live in the loaned home. After all fees, costs, interest payments, and equity earned are all tallied
over the time from the first day of purchase, to the last day at selling, this amount is what is paid per month,
effectively, like a β€œrent.” If this value is more than the total monthly payment calculated in problem 5, then
this suggests that negative equity was earned. If the Effective Monthly Rent is less than the total monthly
payment, then we can view the difference as the amount of effective equity earned per month. Let’s refer to
this as the β€œEffective Monthly Equity.” (Effective Monthly Equity = Total Monthly Payment – Effective
Monthly Rent)
d) For very short periods of stay, like 5 years or less, the Effective Equity will be negative. Discuss how this
value could be negative; what is the cause of actually losing money on the investment, even though cash
is spent paying off the principal, and thus building equity? Where does this equity go?
e) What is the Effective Monthly Equity for 7 and 10 years? What is the total β€œEffective Equity” for 7 and
10 years?
f) Some argue that Effective Monthly Rent should be compared to the Mortgage Monthly Payments, and not
the Total Monthly Payments(Effective Monthly Equity = Mortgage Monthly Payment – Effective Monthly
Rent). They argue that β€œrenters” don’t have to pay property taxes, maintenance fees, and other costs
incurred by homeowners, so those fees and costs shouldn’t be included when figuring the build-up of
equity. If this were the case, calculate the Effective Monthly Equity and the Total Effective Equity for the
entire life of the loan (30 years).
g) Consider the answers to parts e) and f). Discuss whether you think this is a significant investment as many
people believe. Use quantitative reasoning to justify your statements.
h) In problem 13 you calculated the ratio of total interest to total equity for 7 and 10 years. Describe in
straightforward terms what these ratios mean.
i) Make a concluding argument about the work done in this project. You are welcome to express opinions in
your conclusion as long as they are supported by facts.
CAUTIONARY NOTE: Be aware that errors in the spreadsheet formulas will result in incorrect values, and
therefore, missed points. Furthermore, since the paper refers to those values, points could be deducted again
for inaccurate results. It is very important to make sure your data is accurate before discussing them in your
paper. Also, make sure to thoroughly justify your answers to the questions. If there is more than one piece of
evidence supporting an argument, be sure to mention it.

Do My paper price
Pages (550 words)
Approximate price: -

Why Essay-writing.com

Quality Research Papers

If you’re looking for an Essay writing service to help turn all of your hard work into a product that readers can appreciate, then look no further than our essay writing website. With a team of writers who go the extra mile, and customer support representative’s around-the-clock eager to assist you, we are ready to ace any exam or provide any posterity with what they need.

Top Assignment Writers

Our essay writers are experienced professionals who have the knowledge to write an essay about any subject matter in an interesting way while maintaining academic integrity. Our professional essay writers work day and night to ensure that you receive quality essays on time without any delay or interruption. Looking to "pay someone to do my assignment"? With many years of experience behind us, our essay writing website is now led by professionals with extensive knowledge in various fields of study.

Zero Plagiarism

For any write my essay for me request, you will never need to worry about plagiarism or getting caught up in the stress of completing assignments when you use our professional services! Get started today by ordering your first paper from us and we'll give you 10% off!

24/7 Customer Support

We are available 24/7, 365 days a year to help you out with your academic needs! if you have any "do my paper" questions or technical concerns, simply chat with one of our essay writing customer service representatives via the Chat Window on the bottom right corner of this screen

Prompt Delivery and 100% Money Back Guarantee

These academic experts are distinct from most other essay writing websites because they have doctoral degrees and decades of professional experience in academia. And because they know how overwhelming college life can be, we waive all minimum deadlines so you can focus on studying without worrying about your assignment always hanging over your head.

Free Revisions

Our Academic writers are confident and highly capable to take on any challenge ranging from a simple high school essay, question and answer assignment help, PowerPoint Presentation, research paper, dissertation, among others . However, we do not allow customers who abuse the free revisions privilege.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your "pay for essay" order

Fill in the homework order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits your "do my homework" request

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

When the world rushes and deadlines increase, it's hard to put your best foot forward. The Homework help website is here to help you with top quality essays on all topics, from history papers and engineering design descriptions to sociology case studies. For any write my essay for me request, you can count on a professional team of essay writers who are well experienced and researched in their field as they develop an original paper for you with 24/7 customer support.

Essays

Homework Help Service

The assignment help website is an excellent solution for all your problems regarding writing an outstanding admission essay. You don't need to worry about anything anymore because we will provide you with high-quality papers written by expert writers who know how to write professionally!

Admissions

Paper Formats and Types

From time management skills to APA format citations; from MLA formatting rules for research papers; from college application essays where the stakes are high--all these aspects of academic life become clearer as we write it all down on paper! Essay-Writing.com is a professional essay writing service that provides students with well-researched, high quality essays on any topic and at any level of study.

Reviews

Editing & Proofreading

Some of our clients prefer to write their essays themselves and have a third-party like Essay-writing.com proofread it for errors after they are done writing. We have a skilled team of editors and assignment helpers assignment helpers who examine your paper closely, looking out for any mistakes that may lessen the appeal or effectiveness of the essay as well as make amends in order to better improve its overall quality before you submit it anywhere else! For all your editing needs, turn to Essay-writing.com

Reviews

Revision Support

You work hard at your academics, and you should be rewarded, with a revision or modification for free on any order from a discursive essay , assignment to dissertation papers.

AllEscort