Prepare an amortization schedule for a five-year loan of $60,000. The interest rate is 9percent per year, and the loan calls for equal annual payments. (Do not roundintermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)PrincipalPaymentEndingBalanceTotalBeginningBalanceInterestYearPaymentPayment13.4How much total interest is paid over the life of the loan? (Do not round intermediatecalculations and round your answer to 2 decimal places, e.g., 32.16.)Total interest paid< Prev10 of 10Next

Using Excel PMT function to calculate the monthly payment, Loan Amortization Schedule is as under -

Prepare an amortization schedule for a five-year loan of $60,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Beginning Balance Principal Payment Ending Balance Total Interest Year Payment Payment 1 2 N 3 4

Prepare an amortization schedule for a five-year loan of $60,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Beginning Balance Principal Payment Ending Balance Total Interest Year Payment Payment 1 2 N 3 4

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

H3. The interest rate on a $6400 loan is 7% compounded semi-annually, and the loan is to be repaid by monthly payments of $155. Construct a partial amortization schedule showing the last 2 payments. Determine the total amount paid to settle the loan. Show work, not just the answer. Determine the total principal repaid. Determine the total amount of interest paid. Show work, not just the answer.
1. Suppose you borrow $16,000. The interest rate is 9%, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. Round your answers to the nearest cent. If your answer is zero, enter "0".
Prepare an amortization schedule for a three-year loan of $99,000. The interest rate is 10 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? (Leave no cells blank. Enter '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 2 3
Consider a 4-year amortizing loan. You borrow $2,400 initially and repay it in four equal annual year-end payments. a. If the interest rate is 10%, what is the annual payment? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Annual payment $ ✓Answer is complete and correct. Time b. Prepare an amortization schedule. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required. 1 2 3 4 Loan Balance (S) 2,400.00 2,400.00 757.13 1,882.87 x 1,314.03 688 Answer is complete but not entirely correct. Year-End Interest Due on Loan Balance (5) 240.00 188.29 131.40 68.83 Total Year- End Payment ($) 10 757.13 757.13 757.13 757.13 Amortization of Loan (S) 0 517.13 568.84 625.73 688.30
Prepare an amortization schedule for a five-year loan of $70,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Year 1 2 3 4 5 $ Beginning Balance 70,000.00 $ 58,421.11 X 45,800.12 X 32,043.24 x 16,094.24 x > Answer is complete but not entirely correct. Total Interest Payment Payment 17,996.47 $ 17,996.47✔ 17,996.47 ✔ 17,996.47 ✔ 17,996.47✔ Answer is complete and correct. 6,300.00 $ 5,257.90 X 4,122.01 X Total interest paid $ 19,982.35 2,884.90 X 1,444.43 x Principal Payment Ending Balance How much total interest is paid over the life of the loan? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. 11,696.47 $ $ 58,303.53 12,738.57✔ 57,261.43 X 13,874.46 X 56,125.54 X 15,111.57 X 54,888.43 X 16,552.04 X 53,447.96 X
Prepare an amortization schedule for a three-year loan of $93,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? (Leave no cells blank. Enter '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)
Suppose that you need an amount of money which equals to $10000000. It is possible to find it from bank A at an annual interest rate of 18% under 12 equal payment. If the first payment will be 1 month later the day you used the loan. Find the CF (Cash Flow), the equal payments and prepare the amortization table.
You are looking at a one-year loan of $10,000. The interest rate on a one-year loan is quoted as 13 percent plus 3 points. What is the EAR? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Effective annual rate Is your answer affected by the loan amount? O Affected 16.79 % Not affected
Suppose you borrow $14,000. The interest rate is 11%, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. Round your answers to the nearest cent. If your answer is zero, enter "0". Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ fill in the blank 60 $ fill in the blank 61 $ fill in the blank 62 $ fill in the blank 63 $ fill in the blank 64 2 $ fill in the blank 65 $ fill in the blank 66 $ fill in the blank 67 $ fill in the blank 68 $ fill in the blank 69 3 $ fill in the blank 70 $ fill in the blank 71 $ fill in the blank 72 $ fill in the blank 73 $ fill in the blank 74 4 $ fill in the blank 75 $ fill in the blank 76 $ fill in the blank 77 $ fill in the blank 78 $ fill in the blank 79
Find the amortization table for a $8,000 loan amortized in five annual payments if the interest rate is 4.3% per year compounded annually. (Round your answers to the nearest cent.) End ofPeriod RepaymentMade InterestCharged PaymentTowardPrincipal Outstanding principle 0 8,000 1 2 3 4 5
I need help with d. Basic ARM is made for $250,000 at an initial interest rate of 6 percent for 30 years with annual reset date. The borrower believes that the interest rate at the beginning of the year 2 will increase to 7 percent. a. Assuming that a fully amortizing loan is made, what will monthly payments be during year 1? PMT = $1498.88 b. Base on (a), what will the loan balance be at the end of year 1? FV = $246,929.97 c. Given that the interest rate is expected to be 7 percent at the beginning of year 2, what will monthly payments be during year 2? PMT = $1659.69 d. What will be the loan balance at the end of year 2?
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