TABLE 15-1 Amortization table (mortgage principal and interest per $1,000) INTEREST Term in years 3월% 5% 51% 64% 7% 7% 9일% 10% 10일% 6% 8% 9% 11% 10 9.89 10.61 10.86 11.11 11.36 11.62 11.88 12.14 12.40 12.67 12.94 13.22 13.50 13.78 12 8.52 9.25 9.51 9.76 10.02 10.29 10.56 10.83 11.11 11.39 11.67 11.96 12.25 12.54 15 7.15 7.91 8.18 8.44 8.72 8.99 9.28 9.56 9.85 10.15 10.45 10.75 11.06 11.37 17 6.52 7.29 7.56 7.84 8.12 8.40 8.69 8.99 9.29 9.59 9.90 10.22 10.54 10.86 20 5.80 6.60 6.88 7.17 7.46 7.76 8.06 8.37 8.68 9.00 9.33 9.66 9.99 10.33 22 5.44 6.20 6.51 6.82 7.13 7.44 7.75 8.07 8.39 8.72 9.05 9.39 9.73 10.08 25 5.01 5.85 6.15 6.45 6.76 7.07 7.39 7.72 8.06 8.40 8.74 9.09 9.45 9.81 30 4.50 5.37 5.68 6.00 6.33 6.66 7.00 7.34 7.69 8.05 8.41 8.78 9.15 9.53 35 3.99 5.05 5.38 5.71 6.05 6.39 6.75 7.11 7.47 7.84 8.22 8.60 8.99 9.37

Question

Complete the following table: (Use Table 15.1.) (Do not round intermediate calculations. Round your answers to the nearest cent.)

 
 
 
 
Selling price Down payment Amount mortgage Rate Years Monthly payment

First Payment Broken Down Into—

Interest & Principle

Balance at end of month
   
$241,000 $48,200   6.00% 15          
 
 
TABLE 15-1
Amortization table (mortgage principal and interest per $1,000)
INTEREST
Term
in years
3월%
5%
51%
64%
7%
7%
9일%
10%
10일%
6%
8%
9%
11%
10
9.89
10.61
10.86
11.11
11.36
11.62
11.88
12.14
12.40
12.67
12.94
13.22
13.50
13.78
12
8.52
9.25
9.51
9.76
10.02
10.29
10.56
10.83
11.11
11.39
11.67
11.96
12.25
12.54
15
7.15
7.91
8.18
8.44
8.72
8.99
9.28
9.56
9.85
10.15
10.45
10.75
11.06
11.37
17
6.52
7.29
7.56
7.84
8.12
8.40
8.69
8.99
9.29
9.59
9.90
10.22
10.54
10.86
20
5.80
6.60
6.88
7.17
7.46
7.76
8.06
8.37
8.68
9.00
9.33
9.66
9.99
10.33
22
5.44
6.20
6.51
6.82
7.13
7.44
7.75
8.07
8.39
8.72
9.05
9.39
9.73
10.08
25
5.01
5.85
6.15
6.45
6.76
7.07
7.39
7.72
8.06
8.40
8.74
9.09
9.45
9.81
30
4.50
5.37
5.68
6.00
6.33
6.66
7.00
7.34
7.69
8.05
8.41
8.78
9.15
9.53
35
3.99
5.05
5.38
5.71
6.05
6.39
6.75
7.11
7.47
7.84
8.22
8.60
8.99
9.37
View transcribed image text
Expand

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Finance

Corporate Finance

Related Finance Q&A

Find answers to questions asked by students like you.

Q: David Palmer identified the following bonds for investment: Bond A: A $1 million par, 10% annual cou...

A: Click to see the answer

Q: You have just received notification that you have won the $3 million first prize in the Centennial L...

A: Present value of $3 million price which is to be received 63 years from now at a rate of 10%

Q: Which of the following statements are true regarding the payback period of an investment? It does n...

A: Answer: The correct option is (4) All of the above.

Q: The Time Clock Co. is trying to decide which one of two projects it should accept. Both projects hav...

A:   PROJECT 1 PROJECT 2 Year  Cash flows Cash flows 1 61000 45000 2 61000 45000 3 61000 45000 ...

Q: You have taken out a 30-year loan of $55,000 with 6% interest (APR) compounded monthly and with mont...

A: An amount or asset borrowed by an entity from an individual or financial institution is known as a l...

Q: Binding arbitration means that Group of answer choices  the rules of the hearing will be strict in t...

A: Binding arbitration is critical to memorize since, rather than a case, it may be a common strategy o...

Q: Which of the following does not have to be shown for copyright protection to be granted? Group of an...

A: A durable medium is a tool that helps a person to store the information that can be used for future ...

Q: They decide to shop for furnishings for the new house.  They choose items that amount to $2400.00.  ...

A: Calculation of the total interest amount and total amount paid of both options are shown below: As ...

Q: Mary just turned 31 years old today and she is saving for her retirement. This is her plan. She will...

A: Click to see the answer

Q: A large electronic retailer is considering the purchase of software that will minimize shippingexpen...

A: Net present value (NPV) is a method for assessment of financial profitability of a project. NPV is c...

Q: The yield on a firms bond is 8.75% and your economist believes that the cost of common can be estima...

A: Cost of common is the needed rate of return for the common equity holders. It is a part of the WACC(...

Q: A project's terminal value is the ______.

A: A project's terminal value is the sum of the future values of the cash inflows compounded at the fir...

Q: How much should you invest into an account with 3.2% interest compounded quarterly if you want to re...

A: We need to use the concept of time value of money to solve the question. According to the concept of...

Q: Maggie’s Muffins Bakery generated $5 million in sales during 2019, and its year-end total assets wer...

A: We will use the formula for Additional Financing Needed (AFN), here, A0 = $2.5 million = $2,500,000 ...

Q: How Subordination Clause is used?

A: In order to regulate the importance of a credit in the occasion of nonpayment, a moneylender might r...

Q: You have just agreed to a forward trade that will be settled six months from now. When will the exch...

A: Forward rate is the rate at which the underlying asset is exchanged between two parties. This forwar...

Q: Illustration the mortgage for future advances?

A: The question is based on the concept of mortgage or security used for line of credit for future loan...

Q: You have taken out a 20-year loan of $72,000 with 3% interest (APR) compounded monthly and with mont...

A: Annual percentage rate (APR) is a rate that a person is paying annually after undertaking all the fe...

Q: Discuss the techniques that can be applied to obtain relevant and accurate cost estimates.

A: The question is based on the concept of cost estimation, which is one the most important parameter i...

Q: 20

A: Calculation of the terminal cash flow is shown below: Hence, the option third is correct.

Q: What is the future value of $5,000 deposited for four years compounded atan annual rate of 10 percen...

A: Annual Compounding       Interest rate  10.00%   Period (NPER)  4   Present Value 5000   P...

Q: I need help and i need the excel functions (answers by using excel)

A: Forecast for the Year 2020 is shown below: Note: There is no information regarding the changes in d...

Q: Consider the following cash flows for two mutually exclusive capital investment projects. The requir...

A: Mutually exclusive projects are a set of projects out of which only one project can be accepted. 

Q: You want to investment for retirement.  You inherited $50,000 in April 2020.  The Stock Market has l...

A: An investor should wait for the stock market to go down 10% more because investment in the stock mar...

Q: 13) A customer with unpaid balance for merchandise of $210.00 from the previous month has been payin...

A: Finance charge as per unpaid balance method is computed by multiplying the unpaid balance with the i...

Q: Explain Yields on Investment Annuities?

A: The question is based on the concept of calculation yield, which describes the  returns to the owner...

Q: XYZ corp borrowed $3,500 from a bank on May 16. The loan was discounted at 10% and was to be repaid ...

A: a) Computation:

Q: Valuation of a constant growth stock A stock is expected to pay a dividend of $2.75 the end of the y...

A: Here, The current stock price is 'P' Dividend at the end of the year is 'D1' The required return is ...

Q: Consider the following cash flows for two mutually exclusive capital investment projects. The requir...

A: Net Present Value (NPV) is the excess of present value of cash inflows over present value of cash ou...

Q: In what ways do investors quantify the risk levels between domestic and foreign securities?

A: Security is an investment that gives ownership to its owner who can gain profit by investing in such...

Q: A general partnership may be formed by Group of answer choices either oral or written agreement. ...

A: A general partnership is formed when two or more person agreed to share assets, profit share and fin...

Q: 14

A: The cash inflow for each year and cumulative cash flows is shown in below table: The above table sh...

Q: A couple purchasing a home budget $1800 per month for their loan payment. If they have $16,000 avail...

A: Amount of loan which could be obtained would be the present value of all the payments made for repay...

Q: How much should you invest into an account with 3.2% interest compounded quarterly if you want to re...

A: Given that;Payment amount is $1000 Interest rate is 3.2%, as it is compounded quarterly, the rate we...

Q: Find the present value of an annuity of $3000 per year at the end of each of 8 years after being def...

A: The formula to calculate present value of deferred annuity is shown below: Here i is interest rate....

Q: A company is considering purchasing a $10,000 machine that will reduce pretax operating costs by $3,...

A: The computation of after-tax operating cash flow per year:

Q: Capital budgeting is the decision making process used in the acquisition of long term physical asset...

A: It is a decision making process which is used by the firm about the acquisition of long term physica...

Q: How do I work out this problem?   Calculate the monthly payment by table lookup and formula. (Answer...

A: Therefore, the monthly payment is $94.41.

Q: You're an industry analyst for the telecomm sector, and have been analyzing financial reports from t...

A: The computation of the table as follows:

Q: It is said of Gary Cohn, former chair of Goldman Sachs and advisor to the Trump presidency, that whi...

A: "Company G" is a leading investment banking and financial services company in the world. The reviews...

Q: Nike has sales of 36 billion in 2019. Suppose you expect its sales to grow at a rate of 5% forever. ...

A: The question is based on the concept of calculation of value of share based on free cash flow and di...

Q: They decide to shop for furnishings for the new house.  They choose items that amount to $2400.00.  ...

A: 1. Option 1 will have a smaller total finance charge that is $2,189. The calculation of the total fi...

Q: A project has the following costs: 1. Land owned by the company with a market value of $1,000,000 2....

A: Land owned by the company with a market value of $1,000,000 shall be included in the capital budgeti...

Q: A firm evaluates all of its projects by applying the IRR rule. The required return for the following...

A: IRR refers to internal rate of return. it is used to evaluate the attractiveness of a project. 

Q: Consider the following two mutually exclusive projects: Year                 Cashflow (a)           ...

A: Excel Formulas:

Q: 5 What is bond laddering?

A: The debt instrument issued to raise capital or funds is called a bond. It has a fixed interest rate ...

Q: Project K costs $51275, its expected net cash inflows are $13000 per year for 7 years, and its WACC ...

A: Net present value is present value of cash inflows minus present value of cash outflows. Present val...

Q: When deciding on a contract based on present value and a discount rate of 10%, what other factors mu...

A: The question is based on the concept of investment appraisal based on the idea of capital budgeting.

Q: Can someone give an example or scenario of the following: 1. Mean-Variance Analysis 2. Global minimu...

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub parts for y...

Q: What is the condition of security? Has it been reasonably well maintained or does it show the effect...

A: Security is a financial instrument, either equity or debt, which has some legal values. Securities p...

Transcribed Image Text

TABLE 15-1 Amortization table (mortgage principal and interest per $1,000) INTEREST Term in years 3월% 5% 51% 64% 7% 7% 9일% 10% 10일% 6% 8% 9% 11% 10 9.89 10.61 10.86 11.11 11.36 11.62 11.88 12.14 12.40 12.67 12.94 13.22 13.50 13.78 12 8.52 9.25 9.51 9.76 10.02 10.29 10.56 10.83 11.11 11.39 11.67 11.96 12.25 12.54 15 7.15 7.91 8.18 8.44 8.72 8.99 9.28 9.56 9.85 10.15 10.45 10.75 11.06 11.37 17 6.52 7.29 7.56 7.84 8.12 8.40 8.69 8.99 9.29 9.59 9.90 10.22 10.54 10.86 20 5.80 6.60 6.88 7.17 7.46 7.76 8.06 8.37 8.68 9.00 9.33 9.66 9.99 10.33 22 5.44 6.20 6.51 6.82 7.13 7.44 7.75 8.07 8.39 8.72 9.05 9.39 9.73 10.08 25 5.01 5.85 6.15 6.45 6.76 7.07 7.39 7.72 8.06 8.40 8.74 9.09 9.45 9.81 30 4.50 5.37 5.68 6.00 6.33 6.66 7.00 7.34 7.69 8.05 8.41 8.78 9.15 9.53 35 3.99 5.05 5.38 5.71 6.05 6.39 6.75 7.11 7.47 7.84 8.22 8.60 8.99 9.37