Question: Please show all excel functions you use Create a table showing the payment of a mortgage of $161,000 month by month. Create columns for: -

Please show all excel functions you use

Please show all excel functions you use Create a table showing the

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) - Payment (always the same value) Payment against principal - Remaining Principal The mortgage is to last 22 years, and the nominal interest rate is 6.31% (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

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 show formulas used within Excel, thanks Create a table showing the payment of a mortgage of $300,000 month by month. Create columns for: - Time in years) - Interest (for that month) - Payment...

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)...

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

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...

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) -...

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) -...

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...

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

Critics have charged that compensation to top managers in the United States is simply too high and should be cut back. For example, focusing on large corporations, David Novak of fast food operator...

28. Write the following compound statements as equivalent simple statements. a) x=2 * x b) x=x+y- 2 c) sum = sum + num d) z-z*x+2*z e) y=y/(x+5) 29. What is printed by the following program? Suppose...

If someone is in the single tax bracket and is making $ 4 5 , 0 0 0 , how much is their tax rate going to be ? 2 4 % 1 2 % 1 0 % 3 2 %

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...