Question: Calculate the missing amounts in the amortization table which shows extra payments toward the principal made each month. Payment Beginning Monthly Towards Towards EndingExtra 100

Calculate the missing amounts in the amortization table which shows extra payments toward the principal made each month.

Payment Beginning Monthly Towards Towards EndingExtra 100 b 208,890.81 200 Number. Balance | Payment lnterest | Principal. Balance-I Payment 1210,000.00 1,628.13 1,225.00 403.13 a. 1,628.13 1,222.07 a. 3 208,890.81 1,628.13 4 208,381.21 1,628.13 1,215.56 125 207,918.64 d 5 207,918.64 1,628.13 1,212.86 415.27 C. 409.60 208,381.21 100 e. 100

Step by Step Solution

★★★★★

3.27 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a 210000 40313 100 20949687 b ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

790-L-A-L-S (1986).docx

120 KBs Word File

Students Have Also Explored These Related Linear Algebra Questions!

Examine this portion of an amortization table for an adjustable rate mortgage that had a 1 year initial rate period of 4.25% and increased to 5.25% after that period ended. Determine the missing...

Examine the loan amortization table for a $210,000, 15 year mortgage with an APR of 6%. The borrower paid an extra $100 each month towards the principal. Determine the missing amounts. Payment...

A taxpayer who pays 22% in taxes each year has these two accounts. Account 1: $10,000 is placed in a tax-deferred account that pays 5% interest compounded annually for 25 years. Account 2: $10,000 is...

Part 3, 4, and 5 I did add it check all the pictures. In this part of the lab you will examine the values associated with a 15 year mortgage. You will use the same purchase price, down payment, and...

Can I please get some help with an assignment? (Real Estate Principles; Mortgages) Both documents are attached. Thank you in advance Project 2 - Mortgages RE 3010, Excel Project Assigned: Due date:...

please solve using excel and show calculations for a positive review. You are planning to buy a house in Toronto that has a price of $1,500,000. One of the local banks has offered you a mortgage at a...

You are planning to buy a house in Toronto that has a price of $1,500.000. One of the local banks has offered you a mortgage at a quoted rate of 3% per year. Interest will be compounded semi-...

in a blance sheet please 23 24 25 27 28 29 30a 30b 2 / 6 inh 77.2% Sold another bike to a customer that lived in Illinois. No sales tax was charged. The customer did not have his/her wallet so you...

please answer using excel and show your work thank you. WINTER 2022 PROBLEM ONE (20 MARKS) You are planning to buy a house in Toronto that has a price of $1,500,000. One of the local banks has...

Part 1 1. Depreciation expense in the declining-balance method is calculated by the depreciation rate A. times book value at beginning of year. B. times accumulated depreciation at year end. C. plus...

Refer to the Rapp Hardware information in Exercise E26-19. Assume the project has no residual value. Compute the ARR for the investment. Round to two places. E26-21 Using the time value of money...

A 3-stroke cycle is executed in a closed system with 1 kg of air, and it consists of the following three processes: (1) Isentropic compression from 100 kPa, 300 K to 800 kPa, (2) p = constant during...

63. Absenteeism and Location. A sociologist was hired by a large city hospital to investigate the relationship between the number of unauthorized days that employees are absent per year and the...

Suppose that the good described in problem 3 became so popular that every consumer demanded one additional unit at every price. Illustrate this increase in market demand and identify the new...

Find the first 5 terms of the sequence, and then find S5. a. an = 1 / 2n log 1000n b. an = in, i = -1 c. an = ln (12 3 n)

For the sequence whose nth term is an = (1-)n (2n + 1), find a21.

Find the sum of the first 20 terms of the series 17 + 13 + 9 + g .

Review Later Excel Tables Which of the following are benefits of using an Excel Table? (Select THREE that apply) Column header filters Column header row freeze Row and column expansion for new data...

Pat is the manager of a real estate group that is part of a larger real estate company. Here are the total number of home sales from 2019 for all the agents at the entire company. 15 20 3 5 6 8 9 10...

BE10-15: Use the information presented for Ottawa Corporation in BE 10-14, but assume the machinery is sold for $ 5,200 instead of $10,500. Prepare journal entries to (a) update depreciation for 2013...