1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
andrey2020 [161]
2 years ago
11

Using a spreadsheet program, create an amortization schedule for a 30-year mortgage of $500,000 at an annual interest rate of 4.

23%.
(a)
In which month does the amount of principal in a monthly payment first exceed the amount of interest?
(b)
How much interest is repaid for the term of the loan? (Round your answer to the nearest cent.)
$
(c)
If the loan amount was $750,000 instead of $500,000, would the month in which the amount of principal in a monthly payment first exceeded the amount of interest change?
Yes
No
Mathematics
1 answer:
madreJ [45]2 years ago
3 0

This exercise requires the ability to create Amortization Schedules Using a Spreadsheet program. Based on the information given about the Amortization of the loan, the principal payable per month became greater than the interest payable per month on the 159th month (given that the loan amount is $500,000.

<h3>In which month does the amount of principal in a monthly payment first exceed the amount of interest?</h3>

The amount of principal in a monthly payment first exceeds the interest payment In 159th Month. The interest on this month is $1, 248.39 while the principal on this month is $1, 205.46.

It is to be noted that when a loan is taken, the constituents of the amounts being paid back is the Principal and part of the interest on the loan.

<h3>How do you Calculate Amortization of Loans?</h3>

The yearly interest rate must be divided by 12.

Your monthly interest rate, for instance, will be 0.3525 percent if your annual interest rate is 4.23 percent (0.0423 annual interest rate x 12 months).

Additionally, you'll add 12 to the number of years remaining on your loan term.

<h3>How much interest is repaid for the term of the loan?</h3>

The total amount of interest that is paid for the term loan is $383,385.54

<h3>If the loan amount was $750,000 instead of $500,000, would the month in which the amount of principal in a monthly payment first exceeded the amount of interest change?</h3>

Yes it would change. It would change to the 165th month. In this month, the interest paid is $1, 834.00 while the principal paid back is $1,846.77. See the attached image for answer C.

Learn more about Amortization at;
brainly.com/question/10561878
#SPJ1

You might be interested in
The balance in a student’s bank account is $1000. Each month, $150 is withdrawn.
UNO [17]

Answer:

I think its 900

Step-by-step explanation:

3 0
3 years ago
Read 2 more answers
Please help... #18 and #28
Vesna [10]
I hope this helps you

5 0
3 years ago
Read 2 more answers
If you divide 3,180 and 4 what would the answer be?
rodikova [14]
3,180 divided by 4 = 795!
3 0
3 years ago
Read 2 more answers
The following table shows the working populations, average salaries, and income tax rates of France and Ger
ra1l [238]

Answer:

a.

The French government gathers €85,930,190,677 more than the German government

Step-by-step explanation:

8 0
3 years ago
You select a card at random from the cards that make up the word “replacement”. Without replacing the card, you choose a second
musickatia [10]
Replacement = 11 total

probability of choosing a consonant = 7/11
without replacing the card
probability of choosing an e = 3/10

probability of choosing both = 7/11 * 3/10 = 21/110 <===
8 0
3 years ago
Other questions:
  • What is the other angle?
    9·1 answer
  • The endpoints of are A(1, 4) and B(6, -1). If point C divides in the ratio 2 : 3, the coordinates of C are
    12·1 answer
  • A customer went to a garden shop and bought some potting soil for $11.50 and 9 shrubs. The total bill was $94.75. Write and solv
    12·2 answers
  • Find the area?????????
    9·2 answers
  • Factor x2 – 6x – 7.
    9·1 answer
  • Simplify 7 + (−3). please hlep
    9·1 answer
  • If 2x – 1 is a factor of 16x4<br> 24x3 + 2x + f, find f.
    7·1 answer
  • Can you plssss helppp
    5·1 answer
  • At Midland Elementary, there are 22 students in each of seven fourth- grade classes. How many students are in fourth-grade at Mi
    8·1 answer
  • Find the surface area of a cylinder with radius 2 yards and height 6 yards.<br> Give me the answer
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!