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.

Answers: 2

Show answers

Other questions on the subject: Business

Business, 22.06.2019 14:30, SophieCasey

The state in which the manufacturing company you work for is located regulates the presence of a particular substance in the environment to concentrations ≤ x. recently-released, reliable research endorsed by the responsible federal agency conclusively demonstrates that the substance poses no risks at concentrations up to 5x. your company has asked you to consider designing a new process with a waste discharge stream containing up to 2x of the substance. based on the stated conditions, describe this possible.

Answers: 2

continue

Business, 23.06.2019 00:10, gisset9

Mno corporation uses a job-order costing system with a predetermined overhead rate based on direct labor-hours. the company based its predetermined overhead rate for the current year on the following data: total estimated direct labor-hours 50,000 total estimated fixed manufacturing overhead cost $ 285,000 estimated variable manufacturing overhead per direct labor-hour $ 3.80 recently, job p123 was completed with the following characteristics: total actual direct labor-hours 20 direct materials $ 710 direct labor cost $ 500 the amount of overhead applied to job p123 is closest to:

Answers: 2

continue

Business, 23.06.2019 01:50, angie249

Mart's boutique has sales of $820,000 and costs of $540,000. interest expense is $36,000 and depreciation is $59,000. the tax rate is 21 percent. what is the net income? $146,150 221,200 105,000 139,050

Answers: 3

continue

Business, 24.06.2019 03:30, atenagueroprivate

An increase in demand and a decrease in supply, will lead to a(n) in equilibrium quantity and a(n) in equilibrium price. a. increase; indeterminate change b. indeterminate change; increase c. indeterminate change; decrease d. decrease; decrease

Answers: 1

continue

You know the right answer?

[Can anyone please help me out on this one . . thanking you in advance] A couple purchased a home a...