subject
Business, 10.06.2021 06:20 extra678

[Can anyone please help me out on this one . . thanking you in advance] A couple purchased a home and signed a mortgage contract for $900; 000 to be paid with half-yearly payments over a 25-year period. The interest rate applicable is j2 = 5:5% p. a. applicable for the first five years, with the condition that the interest rate will be increased by 12% every 5 years for the remaining term of the loan.

Based on the given information, use Excel software to:

(a) Calculate the half-yearly payment required for each five-year interval

(b) Calculate the loan outstanding (outstanding balance) at the beginning of each five year interval.

(c) Prepare a loan amortization table for the final 12 half-years of the loan term.

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 09:00
Consider the scenario below and let us know if you believe lauren smith's actions to be ethical. let us know why or why not. lauren smith is the controller for sports central, a chain of sporting goods stores. she has been asked to recommend a site for a new store. lauren has an uncle who owns a shopping plaza in the area of town where the new store is to be located, so she decides to contact her uncle about leasing space in his plaza. lauren also contacted several other shopping plazas and malls, but her uncle’s store turned out to be the most economical place to lease. therefore, lauren recommended locating the new store in her uncle’s shopping plaza. in making her recommendation to management, she did not disclose that her uncle owns the shopping plaza. if management decided to go with lauren's uncle's plaza, what additional information would be needed in the financial statements?
Answers: 2
question
Business, 22.06.2019 20:00
Modern firms increasingly rely on other firms to supply goods and services instead of doing these tasks themselves. this increased level of is leading to increased emphasis on management.
Answers: 2
question
Business, 22.06.2019 21:00
Identify whether the statements are true or false by dragging and dropping the appropriate term into the bin provided. long-run economic growth is unlikely to be sustainable because of finite natural resources. in the modern economy, countries that possess few domestic natural resources essentially have no chance to develop economically. finding alternatives to natural resources will be very important to long-term economic growth. in the modern economy, human and physical capital are generally less important in productivity than natural resources. in the 19th century, countries with the highest per capita gdp were nearly always abundant in minerals and productive farming land.
Answers: 1
question
Business, 22.06.2019 21:20
Which of the following best describes vertical integration? a. produce goods or services previously purchasedb. develop the ability to produce products that complement the original productc. develop the ability to produce the specified good more efficiently than befored. build long term partnerships with a few supplierse. sell products to a supplier or a distributor
Answers: 2
You know the right answer?
[Can anyone please help me out on this one . . thanking you in advance] A couple purchased a home a...
Questions
question
Mathematics, 12.11.2020 23:40
question
Biology, 12.11.2020 23:40
question
Mathematics, 12.11.2020 23:40
question
Mathematics, 12.11.2020 23:40
Questions on the website: 13722361