Please provide your complete solutions to the given problems. You may use MS Excel for your solutions. 1. A loan is to be amortized for 4 years through equal payments of PhP48,532.49 at the end of every 6- month period. If the loan earns interest at 7% compounded semi-annually, create an amortization schedule and find: a. the present value of the loan b. the outstanding principal after 3 years c. the amount of principal already paid after 3 years (sum of the principal repayment column for the first 3 years) d. the total interest paid on this loan (sum of the interest column)

Please provide your complete solutions to the given problems. You may use MS Excel for your solutions. 1. A loan is to be amortized for 4 years through equal payments of PhP48,532.49 at the end of every 6- month period. If the loan earns interest at 7% compounded semi-annually, create an amortization schedule and find: a. the present value of the loan b. the outstanding principal after 3 years c. the amount of principal already paid after 3 years (sum of the principal repayment column for the first 3 years) d. the total interest paid on this loan (sum of the interest column)

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter4: Time Value Of Money

Section4.17: Amortized Loans

Problem 1ST

See similar textbooks

Similar questions

Prepare an amortization schedule for a five-year loan of $71,500. The interest rate is 7 percent per year, and the loan calls for equal annual payments. If you could show how to solve using a financial calculator that would be greatly apprectiated, thank you. YEAR BEGINNING BALANCE TOTAL PAYMENT INTEREST PAYMENT PRINCIPAL PAYMENT ENDING BALANCE 1 2 3 4 5
A loan of $5,000 with interest at 7.75% compounded annually is amortized by equal payments at the end of each year for five years. 1. Show your financial calculator inputs for the payment calculation. 2. Create a full amortization schedule for the loan. A template is available in the Test folder (underneath the link to our test. You can fill in the Word file template and attach below,
A fully amortizing CAM loan is made for $132,000 at 6 percent interest for 20 years. Required: a. What will be the payments and balances for the first six months? b. What would payments be for a CPM loan? c. If both loans were repaid at the end of year 5, would the lender earn a higher rate of interest on either loan? Complete this question by entering your answers in the tabs below. Required A Required B Required C What will be the payments and balances for the first six months? (Round your intermediate calculations and final answers to the 2 decimal places.) Month 1 Month 2 Month 3 Total Payment End Balance
You plan to borrow $25,000 at a 3.4% annual interest rate compounded annually. The terms require you to amortize the loan with 5 equal payments each made at the end of each year. You would like to construct an amortization schedule showing details of the payments. Answer the following questions, and choose the closest answer from the possible choices following each question: 1.To find the interest repaid in period 1 only in the financial calculator amortization worksheet, you enter P2 = 2.To find the interest repaid in period 1 only in the financial calculator amortization worksheet, you enter P1 = 3.How much total interest is repaid in periods 1 to 2?
Fill in an amortaization table for a loan of $9,300 to be paid back over 4 years, at an annual interest rate of 1.2% compounded semiannually. At each step, round your answers to the nearest cent and use these values to calculate the next. Payment Number Payment Amount Payment Amount to Interest Payment Amount to Debe Outstanding Pri 9300 2 3. 4 5. 6. 7. 8.
Develop a complete amortization table for a loan of $4500, to be paid back in 24 uniform monthly installments, based on an interest rate of 6%. The amortization table must include the Payment Number, Principal Owed (beginning of period), Interest Owed in Each Period, Total Owed (end of each period), Principal Paid in Each Payment, Uniform Monthly Payment Amount. You must also show the equations used to calculate each column of thetable. You are encouraged to use spreadsheets. The entire table must be shown.
Prepare the first row of a loan amortization schedule based on the following information. The loan amount is for $24,323.00 with an annual interest rate of 15.77%. The loan will be repaid over 7.0 years with monthly payments. Find Loan payment: Interest portion: Principle portion: Loan balance after first monthly payment:
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $180,000 for 3 years at 10% compounded annually Period Payment Interest Balance Reduction Unpaid Balance $180,000 1 24 24 24 3 $0.00
Suppose you borrowed Php 30,000 on a student loan at a rate of 8% and must repay it in three (3) equal installments at the end of each of the next three (3) years. d) What would your ending balance be after the first year? e) Complete the loan amortization table.
You have approached your bank for a 30 year mortage loan in the sum of $2,160,000. The bank has agreed to lend you the money at the annual rate of 6.32% a Caluate the montly repayment on this loan b Compute the interest payment for the first month of the loan based on the answer in a.
A basic ARM is made for $216,000 at an initial interest rate of 6 percent for 30 years with an annual reset date. The borrower believes that the interest rate at the beginning of year (BOY ) 2 will increase to 7 percent. Required: a. Assuming that a fully amortizing loan is made, what will the monthly payments be during year 1? b. Based on (a) what will the loan balance be at the end of year (EOY ) 1? c. Given that the interest rate is expected to be 7 percent at the beginning of year 2, what will the monthly payments be during year 2? d. What will be the loan balance at the EOY 2? e. What would be the monthly payments in year 1 if they are to be interest only?
solve You obtain a loan for Php. 1,500,000 payable in three equal annual installments of Php. 500,000 each. Each interest to be paid at 10% of the unpaid principal. Assuming an effective rate of 12%, compute for the present value of the loan as well as prepare a loan amortization table.