7 Present work in ExcelConsider the following:Financed amount: $385,000Cost of funds: 7.25% (interest rate)30-year amortizationCalculate (round to nearestdollar):Annual payment amount (this ismonthly payment x 12 --- thenrounded to nearest dollar)Amount of 'Interest paid' during year 3(rounded to nearest dollar)Amount of 'Principal paid' during year3 (rounded to nearest dollar)

Loan Amortization: It describes a method of paying the amount of the loan by employing equal…

Answered: Calculate (round to nearest dollar):…

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

7 Present work in Excel Consider the following: Financed amount: $385,000 Cost of funds: 7.25% (interest rate) 30-year amortization Calculate (round to nearest dollar): Annual payment amount (this is monthly payment x 12 --- then rounded to nearest dollar) Amount of 'Interest paid' during year 3 (rounded to nearest dollar) Amount of 'Principal paid' during year 3 (rounded to nearest dollar)
Here is your assignment...Create Amortization schedule;1. Principal amount 350,000, interest 7%, terms3 years, monthly payment2. Principal amount 140,000, interest 6%, terms 4 years, payment : monthly
3) Payments of $2500 made at the beginning of each semiannual period for 15 years at 4% compounded semiannually Find the amount of each payment to be made into a sinking fund so that enough will be present to accumulate the following amount. Payments are made at the end of each period. The interest rate given is per period. Please show all workings step by step
Construct the amortization schedule for a $17,000.00 debt that is to be amortized in 10 equal semiannual payments at 6% interest per half-year on the unpaid balance. Fill out the amortization schedule below. Round all values to the nearest cent. Unpaid Balance Reduction Payment Number 0 1 2 Payment Interest $ $ $ $ $ $ Unpaid Balance $ $ WEEKER
3) Payments of $2500 made at the beginning of each semiannual period for 15 years at 4% compounded semiannually Find the amount of each payment to be made into a sinking fund so that enough will be present to accumulate the following amount. Payments are made at the end of each period. The interest rate given is per period. Please show all the workings.
Construct the amortization schedule for a $14,000.00 debt that is to be amortized in 10 equal semiannual payments at 6% interest per half-year on the unpaid balance. Fill out the amortization schedule below. Round all values to the nearest cent. Unpaid Payment Payment Interest Balance |Unpaid Balance Number Reduction 1 $ $ 2 $ $ EA
Manually calculate the compound amount and compound interest (in $) for the investment. Principal TimePeriod (years) NominalRate (%) InterestCompounded CompoundAmount CompoundInterest $3,000 2 10 annually
a. Complete an amortization schedule for a $33,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 9% compounded annually. Round all answers to the nearest cent BeginningRepaymentEndingYearBalancePayment nterestof Principal Balance 1$ fill in the blank 2$ fill in the blank 3$ fill in the blank 4$ fill in the blank 5$ fill in the blank 62$ fill in the blank 7$ fill in the blank 8$ fill in the blank 9$ fill in the blank 10$ fill in the blank 113$ fill in the blank 12$ fill in the blank 13$ fill in the blank 14$ fill in the blank 15$ fill in the blank 16b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all answers to two decimal places.% Interest % Principal Year 1:fill in the blank 17% fill in the blank 18% Year 2:fill in the blank 19% fill in the blank 20% Year 3:fill in the blank 21% fill in the blank 22%c. Why do these percentages change over…
Use the sinking fund formula shown to the right to determine the semiannual payments with 6% interest are compounded semiannually for 4 years to accumulate $17,000. p=Arn1+rnnt−1 The semiannual invested payment is $
Using Table 11-1, calculate the compound amount and compound interest (in $) for the investment. (Round your answers to the nearest cent.) Principal TimePeriod (years) NominalRate (%) InterestCompounded CompoundAmount CompoundInterest $23,000 12 5 annually
Using the sinking fund table, complete: Required Amount Needed Freq of Payment Years Interest Rate Payment Amount end of each period $40,000 Quarterly 7 8%
Solve by using the sinking fund or amortization formula. (Round your answer to the nearest cent.) Sinking fund payment (in $) Sinking Fund Payment $ Payment Frequency every 3 months Time Period (years) 6 Nominal Rate (%) 6.0 Interest Compounded quarterly Future Value (Objective) $9,000

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

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

Calculate (round to nearest dollar): Annual payment amount (this is monthly payment x 12 --- then rounded to nearest dollar) Amount of 'Interest paid' during year 3 (rounded to nearest dollar) Amount of 'Principal paid' during year 3 (rounded to nearest dollar)