You are repaying a loan of ${A} by making payments at the end of every month for {B} years. Interest is {C}% compounded {D}. Solve for the missing value and complete the partial amortization table below. Do not use units, negative values, or comma separators (eg. use 10000 not $10,000). {A} $54,000 Missing variable: Partial amortization table: PAYMENT NUMBERAMOUNT PAID 0 1 2 3 ** *** {B} 5 *** INTEREST PAID *** *** {C} 2.55% *** *** PRINCIPAL REPAID PRINCIPAL BALANCE $54,000.00 ** {D} annually J*** OUTSTANDING *** *** ...

You are repaying a loan of ${A} by making payments at the end of every month for {B} years. Interest is {C}% compounded {D}. Solve for the missing value and complete the partial amortization table below. Do not use units, negative values, or comma separators (eg. use 10000 not $10,000). {A} $54,000 Missing variable: Partial amortization table: PAYMENT NUMBERAMOUNT PAID 0 1 2 3 * {B} 5 * INTEREST PAID * * {C} 2.55% * * PRINCIPAL REPAID PRINCIPAL BALANCE $54,000.00 {D} annually J* OUTSTANDING * *** ...

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Use aspreadsheet to create amortization schedules for the following five scenarios.What happens to the total interest paid under each scenario?a. Scenario 1:Loan amount: $1 millionAnnual rate: 5 percentTerm: 360 monthsPrepayment: $0b. Scenario 2: Same as 1, except annual rate is7 percentc. Scenario 3: Same as 1, except term is 180monthsd. Scenario 4: Same as 1, except prepayment is$250 per monthe. Scenario 5: Same as 1, except loan amount is$125,000
You are repaying a loan of ${A} by making payments at the end of every quarter for {B} years. Interest is {C} % compounded {D}. Solve for the missing value and complete the partial amortization table below. Do not use units, negative values, or comma separators (eg. use 10000 not $10,000). {A} $54,000 {B} 5 Missing variable: Partial amortization table: PAYMENT NUMBER 0 1 2 3 TOTAL AMOUNT PAID {c} 2.15% INTEREST PAID {D} semi- annually PRINCIPAL REPAID *** OUTSTANDING PRINCIPAL BALANCE $54,000.00 $0.00
Complete the following amortization chart by using Table 15.1. (Round your answers to the nearest cent.) Selling price of home Down payment Principal (loan) Rate of interest Years Payment per $1,000 Monthly mortgage payment $181,000 $50,000 $1,156.59 7.0% 35 I need help working this problem out. Please explain in detail.
complete the following amortization chart by using table 15.1. (round your answers to the nearest cent.): Selling price of home: 78,000 Down payment: 4,000 Principal (loan): ?? Rate of interest: 5.5% Years: 30 Payment per 1,000: ?? Monthly mortgage payment: ??
Use the following amortization chart: Selling priceof home Downpayment Principal(loan) Rate of interest Years Payment per$1,000 Monthly mortgage payment $ 95,000 $ 6,000 $ 89,000 6% 30 $ 6.00 $ 534.00 Assume the interest rate rises to 7.5%. What is the total cost of interest with the new interest rate? (Use Table 15.1.) (Do not round intermediate calculations. Round your final answer to the nearest cent.) Total Cost of Interest
You have taken out a $7,500,000 loan with a 4% interest rate, 30 year amortization and ten year term. What is the loan balance after the final loan payment? a. $0 b. $7,390,303 c. Cannot determine with information provided d. $5,908,797
Complete the following amortization chart by using Table 15.1. Note: Round your "Payment per $1,000" answer to 5 decimal places and other answers to the nearest cent. Selling price of home: $198,000 Down payment: $60,000 Principal (loan): 138,000 Rate of interest: 6.5% Years: 25 Payment per $1,000: ??? Monthly mortgage payment:???? TABLE 15.1 Amortization table (mortgage principal and interest per $1,000) Rate Interest Only 10 Year 15 Year 20 Year 25 Year 30 Year 40 Year 2.000 0.16667 9.20135 6.43509 5.05883 4.23854 3.69619 3.02826 2.125 0.17708 9.25743 6.49281 5.11825 4.29966 3.75902 3.09444 2.250 0.18750 9.31374 6.55085 5.17808 4.36131 3.82246 3.16142 2.375 0.19792 9.37026 6.60921 5.23834 4.42348 3.88653 3.22921 2.500 0.20833 9.42699 6.66789 5.29903 4.48617 3.95121 3.29778 2.625 0.21875 9.48394 6.72689 5.36014 4.54938 4.01651 3.36714 2.750 0.22917 9.54110 6.78622 5.42166 4.61311 4.08241 3.43728 2.875 0.23958 9.59848 6.84586 5.48361 4.67735 4.14892 3.50818 3.000…
For each of the following situations involving annulties, solve for the unknown. Assume that interest is compounded annually and that all annulty amounts are received at the end of each period. (/= Interest rate, and n = number of years) Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) 1. 2. 3. 4. 5. Present Value 248, 196 442,750 650,000 175,000 Annuity Amount $ 5,000 80,000 60,000 155,040 8% 11% 10% n = 5 4 10 4
Use the following amortization chart: Selling price of home Down payment $ 5,000 Rate of Monthly mortgage Principal (loan) $78,000 Payment per $1,000 $ 5.37 interest Years payment $ 83,000 5% 30 $418.86 Assume the interest rate rises to 6.5%. What is the total cost of interest with the new interest rate? (Use Table 15.1.) (Do not round intermediate calculations. Round your final answer to the nearest cent.) Total cost of interest TABLE 15-1 Amortization table (mortgage principal and interest per $1.000) INTEREST Term In years 31% 5% 51% 6% 6% 7% 7% 8% 81% 9% 10% 10% 11% 10 9.89 10.61 10.86 11.11 11.36 11.62 1.88 12.14 12.40 12.67 12.94 13.22 13.50 13.78 12 8.52 9.25 951 976 10.02 10.29 10,56 10.83 11.11 11.39 11.67 11.06 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 1137 17 6.52 7.29 P.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…
Use the following amortization chart: Selling price of home $ 99,000 Down payment $ 5,000 Principal (loan) $ 94,000 Total cost of interest Rate of interest 5.5% Years 30 Payment per $1,000 $ 5.6779 Monthly mortgage payment $ 533.72 What is the total cost of interest? Note: Do not round intermediate calculations. Round your answer to the nearest whole dollar.
Amortization (pymt){(1+r/n)^r*n/ r/n -1} = (pymt)(1+r/n) Investigate the effect of the term on simple interest amortized auto loans by finding the monthly payment and the total interest for a loan of $12,000 at 9 7/8% interest if the term is the following. (Round your answers to the nearest cent.) (a) three years payment $ total interest $ (b) four years payment $ total interest $ (c) five years payment $ total interest $
Use the following amortization chart: Selling price of home Down payment Principal (loan) Rate of interest Years Payment per $1,000 Monthly mortgage payment $ 95,000 $ 6,000 $ 89,000 6.0% 30 $ 5.9955 $ 533.60 What is the total cost of interest? Note: Do not round intermediate calculations. Round your answer to the nearest whole dollar. I know that the total cost of interest is NOT $135,280. Thats the answer I keep getting.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS