subject
Business, 24.03.2020 05:31 123jefe

Build a loan amortization schedule using goal seek. The info of the loan:
Amount of the loan: $500,000
Length of the loan: 30 years
Interest rate: 4% for the first 15 years, and 5% for the rest of the 15 years.
Payment:
During the first 15 years, the borrower pays fixed amount of payment. Then during the second 15 years, the borrower pays another fixed amount of payment thatâs 3% more than that in the first 15-year period.

Answers

ansver
Answer from: idk9329

The amortization schedule and the formula is shown in the table attached below

Explanation:

ansver
Answer from: Quest

answer: e

explanation:

ansver
Answer from: Quest

you get a crown by getting lots of points and you get points by answering other peoples questions

Other questions on the subject: Business

image
Business, 21.06.2019 20:20, webbjalia04
Jimmy owns an ice cream parlor. he designs a schedule for the different tasks the employees have to perform in order to prevent monotony at work. according to the schedule, if an employee makes waffle cones on a day, he serves ice creams the next day and clears the tables on the day after that. jimmy is using the approach at his ice cream parlor.
Answers: 2
image
Business, 22.06.2019 11:20, andrea1704
Aborrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. the first two years of the loan have a "teaser" rate of 4%, after that, the rate can reset with a 5% annual payment cap. on the reset date, the composite rate is 6%. what would the year 3 monthly payment be?
Answers: 3
image
Business, 22.06.2019 12:40, gldven7636
When cell phones were first entering the market, they were relatively large and reception was undependable. all cell phones were essentially the same. but as the technology developed, many competitors entered, introducing features unique to their phones. today, cell phones are only a small fraction of the size and weight of their predecessors. consumers can buy cell phones with color screens, cameras, internet access, daily planners, or voice activation (and any combination of these features). the history of the cell phone demonstrates what marketing trend?
Answers: 3
image
Business, 22.06.2019 19:50, ParallelUniverse
Our uncle has $300,000 invested at 7.5%, and he now wants to retire. he wants to withdraw $35,000 at the end of each year, starting at the end of this year. he also wants to have $25,000 left to give you when he ceases to withdraw funds from the account. for how many years can he make the $35,000 withdrawals and still have $25,000 left in the end? a. 14.21b. 14.96c. 15.71d. 16.49e. 17.32
Answers: 1
You know the right answer?
Build a loan amortization schedule using goal seek. The info of the loan:
Amount of the loan:...

Questions in other subjects: