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
In a capture-recapture study, 97 grizzly bears were tagged and released back into the wild. A month later, 200 bears were captur
3241004551 [841]

Answer:

539

Step-by-step explanation:

Let the total population of  grizzly bears=x

In the first capture, 97 were tagged.

Therefore, ratio of the total population to the tagged=x:97

A month later, when 200 bears were captured, 36 were tagged.

Ratio of the sample to the tagged=200:36

Since a sample is representative of the population, the ratios are the same. We therefore have:

x:97=200:36

\dfrac{x}{97} =\dfrac{200}{36}\\ $Cross multiply\\36x=200 X 97\\x=200 X 97 \div 36\\x=538.9 \approx 539

There are about 539 grizzly bears in the population

7 0
3 years ago
PLA HELP PLS I NEED TO PASS !! Mendel team built a structure for a competition using wooden spheres and cylinders. The wood they
Ainat [17]
The answer to your question is 22.875
6 0
3 years ago
What is the volume of the following rectangular prism? 9/5 2/3
MaRussiya [10]

Answer:

1.2

Step-by-step explanation:

9/5*2/3=1.2

4 0
3 years ago
Read 2 more answers
What is the area of a field that is 132.4m long by 28m wide?
svetlana [45]

Answer:

B

Step-by-step explanation:

its 132.4 times 28

=3707.2

7 0
3 years ago
What is 3x+6y=16. what do i do please help
DochEvi [55]
Ok, so for this you're likely graphing in y=mx+b format (slope intercept). So to start, you'all first subtract 3x from the equation to get 6y=-3x+16. Now you'll divide the equation by 6 to get y alone. Your final equation will be y=-1/2x+16/6
7 0
2 years ago
Other questions:
  • A slope of -2 passing through the point (-11,-17)
    8·1 answer
  • Sunita creates a scale model of an aeroplane. The scale of the model is 5 cm to 13 m. Sunita's model has a wingspan of 24 cm. Wh
    14·1 answer
  • 2.
    8·1 answer
  • The sum of two numbers is 8, and their product is 80.
    14·1 answer
  • A car depreciated by 25% during the first year. If the car was purchased for 28,000 what is the car worth today? Show your work.
    10·1 answer
  • Plz help look at the pic
    14·1 answer
  • I will give brainliest if you add details:
    9·1 answer
  • Three consecutive even numbers add up to 105 determine the product of the three numbers​
    7·1 answer
  • The similarity ratio of two regular octagons is 5:9. The area of the smaller octagon is 100 in2. Find the area of the larger oct
    10·2 answers
  • Choose ALL answers that describe the polygon FGHI if FG=GH=HI=IF and m angle F=m angle G=m angle H = m angle I
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!