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
There are
cricket20 [7]

Answer:

shoes 324×2 =648

sandals 187×2 = 374

so 374 + 648 = 1022 shoes and sandal pairs

PLEASE MARK AS BRAINLIEST!!!!

ITS URGENT!!

3 0
3 years ago
Read 2 more answers
Solve.<br> 5x – 10 &lt;20<br> O (-00, 2]<br> O (-0,2)<br> O (-00, 6]<br> O (-0, 6)
aleksandr82 [10.1K]
The answer I got was -∞21/5
4 0
3 years ago
Help!!!!!!!!!!!!!!!!!!!!!!!!!
bezimeni [28]
X=(3^4) * (2^3)
x=(81)*(8)
x= 648
5 0
3 years ago
Read 2 more answers
*IN A TEST AND MUST ANSWER MUST BE BEFORE 9:20AM AT 12/7/18
dexar [7]

Answer:

X) 7, 14, 28, 35

Y) 1, 2, 4, 5

Step-by-step explanation:

NO TIME TURN THE TEST IN!!!


6 0
3 years ago
Zoo tickets for 5 people cost a total of $41. Which equation can be used to determine the cost, c, in dollars, of each ticket.
Crank

Answer:

$8.25

Step-by-step explanation:

5 0
3 years ago
Read 2 more answers
Other questions:
  • Is this correct for number 3.
    13·1 answer
  • I have 2 more questions I still need help with sorry about me keep asking questions
    9·1 answer
  • Tell whether the ordered pair (- 3, 0) is a solution of the given system. - 2x + 2y &gt;= 4an y &gt;= 2x - 6
    14·2 answers
  • A collection of 30 coins worth $5.50 consists of nickels, dimes and quarters. There are twice as many dimes as nickels. How many
    9·1 answer
  • Find the value of x in the isosceles triangle shown below. WILL MARK BRAINLIEST 18 POINTS!
    15·1 answer
  • On the scale drawing of a car, the length from bumper to bumper is 6 inches. The car’s actual length, from bumper to bumper, is
    12·1 answer
  • According to a nutrition coach, a 100 kg person should eat
    10·1 answer
  • One manufacturer boxes screws so that each box weighs the same no matter what size the screws are. The graph shows the amount of
    6·1 answer
  • Pleaseeeeeeeeeeeeee i need the answer
    12·1 answer
  • 6. Find the distance between the points (1,4) and (-2, -1).
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!