with monthly payments. What is the regular monthly payment amount and the balloon payment amount in each of the following cases: (a) Fully - amortizing, 30-year loan (b) 30- year amortization, 10-year balloon (c) 15-year amortization, 10-year balloon (d) What is

with monthly payments. What is the regular monthly payment amount and the balloon payment amount in each of the following cases: (a) Fully - amortizing, 30-year loan (b) 30- year amortization, 10-year balloon (c) 15-year amortization, 10-year balloon (d) What is

Name: None show steps to calculation!!: Consider a $5,000,000, 9%, constant
Uploaded: 2024-03-05T11:42:36.000Z
Channel: Bartleby
Description: None show steps to calculation!!: Consider a $5,000,000, 9%, constant payment mortgage (CPM)with monthly payments. What is the regular monthly payment amount and the balloonpayment amount in each of the following cases: (a) Fully amortizing, 30-year

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

Need Detailed answer with steps please 30. Considering the following information, what is the NPV if the borrower refinances the loan? Expected holding period: 3 years, Current loan balance: $100,000; Current loan interest: 7%; Current loan mortgage payment: $898.33; Remaining term on current mortgage: 15 years; New loan interest: 5.5%; New loan mortgage payment: $817.08; New loan term: 15 years; Cost of refinancing: $5,000. Assume that the opportunity cost is the interest rate on the new loan (5.5%). A. -$5,000.00 B. -$1,155.27 C. $3,844.73 D. $8,844.73
Use an amortization table (Use Spreadsheet application such as Excel) that determines the monthly mortgage payment based on interest rate of 35% and a principal of GHS1000,000 with a 15-year maturity and then for a 30-year maturity. Is the monthly payment for the 15-year maturity twice the amount for the 30-year maturity or less than twice the amount? Explain.
Give typing answer with explanation and conclusion If the annual payment mortgage constant for an amortizing loan is 10.6%, and the loan amount is $25,000,000, what is the annual payment?
Calculate the monthly mortgage payment for the following two scenarios. Create an amortization schedule for each also. A. $200,000 loan for 15 years at 3%.B. $400,000 loan for 30 years at 4%. solved with excel formulas in excel
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
assume a $175,000 mortgage loan and 10-year term. The lender is charging an annual interest rate of 6 percent and 4 discount points at origination. a. What is the monthly payment Assuming that it is based on an amortization period of 30 years? b. What will be the required balloon payment at the end of the tenth year? c. What is the effective borrowing cost on the loan if it is held to maturity? Give typing answer with explanation and conclusion
G. Find the interest rate (APR) on a 27-year mortgage with a initial loan amount of $358,000, if the monthly payment is $2229.45 Let's use references for input values; and be sure to annualize the rate! INPUTS: OUTPUT: Period Rate is APR Payment Loan amount
1. You have just obtained a commercial mortgage for $6.25M with a 5-year term, 25-year amortization period and 6.50% mortgage interest rate. (a) Construct an amortization table for the term of the loan assuming annual payments. What is the annual payment? What is the balance at maturity? (b) What is the e¤ective cost of borrowing if the borrower pays an origination fee of $30,000? (c) The borrower can repay the balance of the loan at any time prior to its maturity, but must pay a penalty of 5% of the outstanding balance. What is the cost of borrowing if the borrower pays an origination fee of $30,000 and pays off the remaining balance of the loan after making payments for 4 years?
1. Assuming the cost of mortgage is $400,000, and the owner of the house makes a down payment of $40,000, with 8% interest rate and 10 years repayment plan. a. calculate the total amount of loan, monthly rate, number of payment periods, monthly payment, total interest paid, and amount borrowed. b. With the aid of what PMT function in a one variable condition, calculate monthly payment, total amount payable, total interest payable for: 12 yrs, 16 yrs, 20 yrs ,25 yrs, 30 yrs, 35 yrs mortgage.
1. Let's assume that a loan of $100,000 with an annual interest rate of 6% over 30 years pays monthly payments of $500. a. Calculate the accumulation rate b. Calculate the payment rate . c. Answer : How will the balance of the principal be at the end of the loan in relation to the original amount of the loan? Less, equal or greater? Provide calculations.
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
The following loan is a simple interest amortized loan with monthly payments. $155000, 9 1/2%, 30 years(a) Find the monthly payment. (Give your answer to the nearest cent.)Payment $ (b) Find the total interest for the given simple interest amortized loan. (Give your answer to the nearest cent.)Total interest $