Problem 3 Create a table showing the payment of a mortgage of $216,000 month by month Create columns in excel Time (in years) Interest (for that month) Payment (always the same value) Payment against principal Remaining Principal The mortgage is to last 25 years, and the nominal interest rate is 9 27 (a) What is the monthly payment (b) What is the interest paid at the end of the 9th month (c) How much of the principal is paid down by the payment made at the end of the 22nd month (d) The first time that the portion of a monthly payment that is paying down the principal will be larger than the portion paying interest will occur at the end of month number Problem 3(a) Answer correct to 2 decimals Problem 3(b) Answer correct to 2 decimals Problem 3(c) Answer correct to 2 decimals Problem 3(d)

The Answer is in the image, click to view ...

Question: Problem #3: Create a table showing the payment of a mortgage of $216,000 month by month. Create columns in excel: - Time (in years) -

Problem #3:

Create a table showing the payment of a mortgage of $216,000 month by month. Create columns in excel: - Time (in years) - Interest (for that month) - Payment (always the same value) - Payment against principal - Remaining Principal The mortgage is to last 25 years, and the nominal interest rate is 9.27%

(a)	What is the monthly payment?

(b)	What is the interest paid at the end of the 9th month?

(c)	How much of the principal is paid down by the payment made at the end of the 22nd month?

(d)	The first time that the portion of a monthly payment that is paying down the principal will be larger than the portion paying interest will occur at the end of month number________?

Problem #3(a):

Answer correct to 2 decimals

Problem #3(b):

Answer correct to 2 decimals

Problem #3(c):

Answer correct to 2 decimals

Problem #3(d):

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

please show the excel reference Problem #3: Create a table showing the payment of a mortgage of $252,000 month by month. Create columns for: - Time (in years) - Interest (for that month) - Payment...

PLEASE DO IN EXCEL AND POST A PICTURE OF THE SHEET Problem #3: Create a table showing the payment of a mortgage of $138,000 month by month. Create columns for: - Time (in years) - Interest (for that...

all answered in microsoft excel thank you! Problem #3: Create a table showing the payment of a mortgage of $161,000 month by month. Create columns for: - Time (in years) - Interest (for that month) -...

use excel please Problem #3: Create a table showing the payment of a mortgage of $176,000 month by month. Create columns for: Time (in years) - Interest (for that month) - Payment (always the same...

please do excel and show me the formule in excel Problem #3: Create a table showing the payment of a mortgage of $250,000 month by month. Create columns for: Time (in years) Interest (for that month)...

Please post the code Problem #3: Create a table showing the payment of a mortgage of $298,000 month by month. Create columns for: - Time in years) - Interest (for that month) - Payment (always the...

Problem #3: Create a table showing the payment of a mortgage of $116,000 month by month. Create columns for: Time (in years) - Interest (for that month) Payment (always the same value) - Payment...

Problem \#3: Create a table showing the payment of a mortgage of $173,000 month by month. Create columns for: - Time (in years) - Interest (for that month) - Payment (always the same value) - Payment...

Problem #3: Create a table showing the payment of a mortgage of $146,000 month by month. Create columns for: Time (in years) - Interest (for that month) Payment (always the same value) - Payment...

Motivation is the set of forces that cause people to behave in certain ways-how? Managers use a variety of motivational strategies derived from the various theories of motivation. For you, which...

Write the journal entry (entries) to record the long term assets to the correct accounts Land, Land Improvements, and Building assets were financed on mortgage payable Furniture and Equipment were...

IN C# PLEASE.... Section 1 : Enter the comment with the section title as described above. You will create a two - dimensional string array of 4 4 elements named salesRegions. The first row of the...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

6. How do histories influence the process of identity formation?

4. What factors in your experience have led to the development of positive feelings about your own cultural heritage and background? What factors have led to negative feelings, if any?

3. How do you benefit or have been disenfranchised in the telling of certain histories? How do you take responsibility for the histories from which you benefit?