Dan is considering borrowing $375,000 to purchase a new condo. Based on that information, answer the following questions. Show all work. Calculate the monthly payment needed to amortize an 8% fixed-rate 30-year mortgage loan. Calculate the monthly amortization payment if the loan in (a.) was for 15 years instead. In a few sentences, explain the effect of a smaller loan period. How does it influence the monthly payment and interest

Dan is considering borrowing $375,000 to purchase a new condo. Based on that information, answer the following questions. Show all work. Calculate the monthly payment needed to amortize an 8% fixed-rate 30-year mortgage loan. Calculate the monthly amortization payment if the loan in (a.) was for 15 years instead. In a few sentences, explain the effect of a smaller loan period. How does it influence the monthly payment and interest

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 27M

See similar textbooks

Similar questions

Dan is considering borrowing $489,000 to purchase a new condo. Based on that information, answer the following questions. Show all work. Calculate the monthly payment needed to amortize an 5.5% fixed-rate 30-year mortgage loan. Calculate the monthly amortization payment if the loan in (a.) was for 15 years instead. In a few sentences, explain the effect of a smaller loan period. How does it influence the monthly payment and interest?
You are assiting a newly hired employee. You begin explaning the process of utilizing excel to finance properties. Consider the following. A realator has a house on sale for $640,000. If possible you believe you can finance the home for $300,000 for 20 years at a 3% interest rate. What would the monthly principle and interest payment be for the acquird loan? Calculate using the PV funtion in excel. How would you caluclate this in Excel using the PV function? Rate: Nper: Pmt: FV: Type:
Sarah Maddox wants to buy a new car that will cost $15,000. She will make a down payment in the amount of $3,000. She would like to borrow the remainder from a bank at an interest rate of 8% compounded monthly. She agrees to make monthly payments for a period of two years in order to pay off the loan.Select the correct answer for each of the following questions:(a) What is the amount of the monthly payment (A)?1. A = $12,000 (A/P, 0.75%, 24).2. A = $12,000 (A/F, 0.66%, 24).3. A = $12,000 (A/P, 0.66%, 24).4. A = $12,000 (A/F, 9%, 2)/12. (b) Sarah has made 12 payments and wants to figure out the remaining balance immediately after the 12th payment. What is that remaining balance?1. B12 = 12A.2. B12 = A(P/A, 9%, 1)/12.3. B12 = A(P/A, 0.66%, 12).4. B12 = 10,000-12A.
Please show how to solve this in excel and please show the spreadsheet and formulas. Suppose that you have the following two loans with monthly payments in the table attached as Choice 1 and Choice 2. Assuming that there is no origination cost with the loans. If Robin pays off the loan in 15 years(180 months), what is the incremental cost of the $10,000 for loan 1 over loan 2?
The Becker family is getting a home loan to finance a $260,000 mortgage. While looking for a mortgage, they found two alternatives: Mortgage A 30-year loan with an interest rate of 3.611% and a monthly payment of $1,184. Mortgage B 15-year loan with an interest rate of 2.7% Recall: Calculate the total amount paid for Mortgage A. Calculate the total interest paid for Mortgage A. Calculate the monthly payment for Mortgage B. Calculate the total amount paid for Mortgage B. Calculate the total interest paid for Mortgage B. Write a two or more sentences giving the Becker family some advice about which mortgage to choose. Why might the Becker family not take your advice from part c)? Answer in one or two sentences.
Tim wants to borrow $400,000 from Bank of America on a 30-year mortgage at 6% interest rate. a. What would Tim's monthly payments be on his mortgage? b. Amortize the loan and determine: Interest expense for the first quarter of the loan. Cash flows for the first quarter of the loan. Loan balance at the end of the first quarter of the loan. Please show your calculations, part b is very important. If you are using the TVM chart, please state whether you used PVoA, FVoA, PVoSA, FVoSA.
Suppose you are buying your first condo for $190,000, and you will make a $10,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at 3.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be? You are not required to show calculations. However to receive credit you must provide the inputs used (N, PMT, FV, I/Y, PV) to solve. If you utilize a template, you can copy and paste the section used in the submission. $808.28 $853.18 $527.78
suppose that you decide to borrow $15,000 for a new car. you can select one of the following loans, each requiring regular monthly payments. Installment loan A: 3-year loan at 5.9% Installment loan B: 5-year loan at 6.4% a.- find the monthly payments and the total interest for loan A b.-find the monthly payments and the total interest for loan B c.- compare the two loans. which is more economical?
Suppose Mary Grace needs to borrow $8,900 for the purchase of a car and is considering two loan options. Loan A is a four-year loan at 7.6% interest while loan B is a seven-year loan at 7.9% interest.Determine the monthly payment required to repay Loan A and the total interest paid over the life of Loan A. Round solutions to the nearest cent, if necessary.The monthly payment for Loan A is $ .The total interest paid for Loan A is $ .Determine the monthly payment required to repay Loan B and the total interest paid over the life of Loan B. Round solutions to the nearest cent, if necessary.The monthly payment for Loan B is $ .The total interest paid for Loan B is $ .Determine the lower-cost option of the two loans. Loan A is the lower-cost option. Loan B is the lower cost option. Determine the amount of savings Mary Grace will experience if she chooses the lower-cost loan option.Savings = $ Hint: Related FormulaThe loan payment formula for fixed installment loans is given by the…
Suppose Lydia needs to borrow $24,200 for the purchase of a car and is considering two loan options. Loan A is a seven-year loan at 8.8% interest while loan B is a six-year loan at 8.3% interest.Determine the monthly payment required to repay Loan A and the total interest paid over the life of Loan A. Round solutions to the nearest cent, if necessary.The monthly payment for Loan A is $ Incorrect.The total interest paid for Loan A is $ Incorrect.Determine the monthly payment required to repay Loan B and the total interest paid over the life of Loan B. Round solutions to the nearest cent, if necessary.The monthly payment for Loan B is $ Incorrect.The total interest paid for Loan B is $ Incorrect.Determine the lower-cost option of the two loans. Loan A is the lower-cost option. Loan B is the lower cost option. Determine the amount of savings Lydia will experience if she chooses the lower-cost loan option.Savings = $
You need $20,000 to purchase a used car. Your wealthy uncle is willing to lend you the money as an amortized loan. He would like you to make annual payments for 6 years, with the first payment to be made one year from today. He requires a 7% annual return. What will be your annual loan payments? Do not round intermediate calculations. How much of your first payment will be applied to interest and to principal repayment? Do not round intermediate calculations. Round your answers to the nearest cent.
Suppose you purchase a car for a total price of $25,445, including taxes and license fee, and finance that amount for 4 years at an annual interest rate of 8%. Please provide step by step to find the monthly payment and what is the total amount of interest paid over the term of the loan? Thanks