Required A Required BConstruct the amortization schedule for the first six payments. (Do not round intermediate calculations. Round your answersto 2 decimal places. (e.g., 32.16))Amortization Schedule for first 6 payments (months)MonthBeginning LoanBalance123456PaymentInterestPrincipalEnding LoanBalanceRequired ARequired > You plan to purchase a $290,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered toyou is 7.25 percent. You will make a down payment of 20 percent of the purchase price.a. Calculate your monthly payments on this mortgage.b. Construct the amortization schedule for the first six payments.Complete this question by entering your answers in the tabs below.Required A Required BCalculate your monthly payments on this mortgage. (Do not round intermediate calculations. Round your answer to 2 decimalplaces. (e.g., 32.16))Monthly paymentRequired B >

formula in the below table : Cell reference ABCDEFGH11 B C D E F G H 22 INTEREST RATE =7.25%/12…

Answered: Required A Required B Construct the…

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

Compound Interest In Exercises 71 and 72, youinvest $2500 in an account at interest rate r, compoundedcontinuously. Find the time required for the amount to(a) double and (b) triple.71. r = 0.025 72. r = 0.0375
A B E 2 Determine the maturity date and compute interest for each note. 3 Days to be used per year 360 days 4 Note Contract Date Principal Interest Rate Period of Note (Term) 6. 1 1-Mar $10,000 6% 60 days 7 2 15-May 15,000 8% 90 days 8 3 20-Oct 8,000 4% 45 days 9. 10 Required: 11 12 (Use cells A5 to F8 from the given information to complete this question.) 13 14 Note Contract Date Maturity Date Interest Expense 15 16 17 3 18
Please don't provide handwritten solution..
How do I get the beginning book value for the second year, third year and the fourth year??
can you please help me with this problem
Exercise 2: Directions: Analyze the given amortization procedures in the table below then fill in cach blank using the guide questions below the table. Problem: A salary loan amounting to P15,000 is to be paid annually for 4 years with an interest rate of 6% compounded annually. The annual amortization is P P4,328.87. PRINCIPAL Outstanding Balance Interest Regular Payment (R) Period Component of Component of Рауment Раyment P11,571.13 7,936.53 E 1. 2. 3. P4,328.87 P4,328.87 P4,328.87 P900 P694.27 P3,428.87 3,852.68 4,083.84 4 245.031 F Total G. H. Guide Questions: A. How much is the amount of the loan? (Outstanding balance at time 0) B. How much is the first regular annual payment? C. For the second payment, how much goes to pay the principal? D. For the third payment, how much goes to pay the interest? E. How much is the outstanding balance after the 3rd payment? F. How much should be the outstanding balance after the 4th or last payment? G. How much is the total amount of regular…
Use the amortization table to determine how much of the 8th payment is interest E Click the icon to view the amortization table. Amortization Table - X The interest amount af the Bth pnyment is S (Type an integer or a decimal.) Amortization Table Рауment Number Amount of Payment Interest Portion to Principal Principal at End of Period for Perlod $1000.00 $918.93 $86.07 $5.00 $81.07 $86.07 $4.59 $81.48 $837.46 $755.57 $86.07 S4.19 $81.88 $86.07 $3.78 $82.29 5673.28 $86.07 $3.37 $82.70 $590 58 S86.07 $86.07 $2.96 $83.12 $507 46 $423.93 $2.54 $83.53 $83.95 $86.07 $2.12 $339.08 $86.07 $1.70 $1.28 S84.37 $84.79 $255.61 10 $86.07 $170 82 $85.60 11 $86.07 S0.85 $85.22 12 S86.03 $0.43 S05.00 $0.00 Print Done
Power Solutions Ltd. issues a $15,000,000, five-year, 4.5% bond with semi-annual interest payments. Underwriting costs, paid up front, are $960,00O. The bond sells at par. Required: 1. How much cash does Power receive when the bond is issued? Power receives 2. What is the effective interest rate on the bond? (Round your answer to the nearest whole percentage.) Effective interest rate per annum
This needs to be done with the PMT functions, I can't figure out why the principal and interest don't add to the payment amount. I need help on 38 - 42. Thank you!
TABLE 14.2 Loan amortization table (monthly payment per $1,000 to pay principal and interest on installment loan) Terms in months 6 12 18 24 30 36 42 48 54 60 7.50% $ 170.34 86.76 58.92 45.00 36.66 31.11 27.15 24.18 21.88 20.04 8.00% $ 170.58 86.99 59.15 45.23 36.89 31.34 27.38 24.42 22.12 20.28 8.50% $ 170.83 87.22 59.37 45.46 37.12 31.57 27.62 24.65 22.36 20.52 9.00% $ 171.20 87.46 59.60 45.69 37.35 31.80 27.85 24.77 22.59 20.76 10.00% $ 171.56 87.92 60.06 46.14 37.81 32.27 28.32 25.36 23.07 21.25 10.50% $ 171.81 88.15 60.29 46.38 38.04 32.50 28.55 25.60 23.32 21.49 11.00% $ 172.05 88.38 60.52 46.61 38.28 32.74 28.79 25.85 23.56 21.74 11.50% $ 172.30 88.62 60.75 46.84 38.51 32.98 29.03 26.09 23.81 21.99 12.00% $ 172.55 88.85 60.98 47.07 38.75 33.21 29.28 26.33 24.06 22.24 12.50% $ 172.80 89.08 61.21 47.31 38.98 33.45 29.52 26.58 24.31 22.50 13.00% $ 173.04 89.32 61.45 47.54 39.22 33.69 29.76 26.83 24.56 22.75 13.50% $ 173.29 89.55 61.68 47.78 39.46 33.94 30.01 27.08 24.81 23.01…
File Home Insert Draw Page Layout Formulas Data Review View Help Editing Arial V 10 Merge Currency ... B8 fx A 1. Amortization schedule 2. 3. Loan amount to be repaid (PV) $30,000.00 Interest rate (r) 4. Length of loan (in years) 8.00% 6. 7. a. Setting up amortization table Formula 8. Calculation of loan payment #N/A 6. Repayment of Principal 10 Year Beginning Balance Payment Interest Remaining Balance 11 1 12 13 3 14 15 b. Calculating % of Payment Representing Interest and Principal for Each Year Payment % Representing Payment % Representing Principal Check: Total = 16 Year Interest 100% 17 1 18 19 20 21 Formulas = A Sheet1 Calculation Mode: Automatic Workbook Statistics LL 2 3

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