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]
1 year 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]1 year 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
NEED HELP ASAP!!!!!!
melamori03 [73]
Okay so you can add up all the marbles to find a rate and divide.
Total: 20 marbles
Blue: 25% chance
Red: 40% chance
Green: 45% chance
8 0
3 years ago
Read 2 more answers
Pax wants to make fruit punch for a party suing the recipe below
faust18 [17]

the answer should be d if my math is correct

7 0
3 years ago
Read 2 more answers
Teresa is simplifying an<br> Step 1: (4x²<br> Step 2:<br> Step 3: 2x
Lesechka [4]
The answer is B






None of the rest equal up to the same thing
7 0
3 years ago
Paul is buying packages of hot dogs for a camping trip. Each package is 30 oz. If he buys 4 packages, how many ounces of hot dog
Dimas [21]

Answer:

120

Step-by-step explanation:

multipy 30 by 4 and you should get 120.

You can even do 30+30+30+30 and it will also add up to 120.

4 0
2 years ago
Read 2 more answers
One pair of corresponding sides of two similar polygons measures 12 and 15. The perimeter of the smaller polygon is 30. Find the
Yuliya22 [10]
The perimeter of the larger polygon will have the same ratio to the perimeter of the smaller as the ratio of the corresponding sides. Therefore, the larger polygon will have a perimeter of 30(15/12) = 37.5, or 38 to the justified number of significant digits stated.
5 0
3 years ago
Other questions:
  • 10x +3y =1<br> -10x -3y=-1
    8·1 answer
  • Solve: 4|x| = 32 a 8 b –8 or 8 c 24 d No solution
    13·1 answer
  • You are making necklaces for your friends. You have 72 blue beads and 42 red beads. Each friend will receive an identical neckla
    9·1 answer
  • After comparing response times between the audio and picture portions of the MIT test, the t-test resulted in a t-value of 2.97.
    13·1 answer
  • 3333333333333333333333333333333333333333333333333333333
    5·1 answer
  • 27) A man on the third floor of a building shouts down to a person on the street. If the man is 25 feet up and the distance betw
    15·2 answers
  • The slope of the line is
    14·1 answer
  • Please I need help on this question.
    8·1 answer
  • Please help, question in pic
    6·1 answer
  • Find the value of x. <br> a) x=109 <br> b) x=115<br> c) x=95<br> d) x=129
    14·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!