Excel Questions 13-16. Complete the amortization table provided in the Excel document posted in IvyLearn in the homework area by setting the appropriate values for a $100,000, 30-year mortgage at 6% interest and using Excel's autofill (drag) feature to fill in the cells to the end of the mortgage period. Use this to answer the following: How many months will it take to pay at least half of the principal?

Excel Questions 13-16. Complete the amortization table provided in the Excel document posted in IvyLearn in the homework area by setting the appropriate values for a $100,000, 30-year mortgage at 6% interest and using Excel's autofill (drag) feature to fill in the cells to the end of the mortgage period. Use this to answer the following: How many months will it take to pay at least half of the principal?

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter7: Using Consumer Loans

Section: Chapter Questions

Problem 6FPE

See similar textbooks

Similar questions

A customer takes out a loan of $130,000 on January 1, with a maturity date of 36 months, and an annual interest rate of 11%. If 6 months have passed since note establishment, what would be the recorded interest figure at that time? A. $7,150 B. $65,000 C. $14,300 D. $2,383
Everglades Consultants takes out a loan in the amount of $375,000 on April 1. The terms of the loan include a repayment of principal in eight, equal installments, paid annually from the April 1 date. The annual interest rate on the loan is 5%, recognized on December 31. (Round answers to the nearest cent, if needed.) A. Compute the interest recognized as of December 31 in year 1. B. Compute the principal due in year 1.
On January 1, 2018, King Inc. borrowed $150,000 and signed a 5-year, note payable with a 10% interest rate. Each annual payment is in the amount of $39,569 and payment is due each Dec. 31. What is the journal entry on Jan. 1 to record the cash received and on Dec. 31 to record the annual payment? (You will need to prepare the first row in the amortization table to determine the amounts.)
Using a spreadsheet program, create an amortization schedule for a 30-year mortgage of $500,000 at an annual interest rate of 4.24%. (a) In which month does the amount of principal in a monthly payment first exceed the amount of interest? _____ (b) How much interest is repaid for the term of the loan? (Round your answer to the nearest cent.) _____$ (c) If the loan amount was $750,000 instead of $500,000, would the month in which the amount of principal in a monthly payment first exceeded the amount of interest change?
Give typing answer with explanation and conclusion to all parts A mortgage balance of $30000 is to be repaid over a 10-year term by equal payments at 4.6 compounded semiannually At the request of the mortgagor, the payments were set at 425 (a) How many payments will the mortgagor have to make? (b) What is the size of the last payment? (c) Determine the difference between the total amount required to amortize the mortgage with the contractual monthly payments rounded to the nearest cent and the total actual amount paid.
Based on Exhibit 7-8, what would be the monthly mortgage payments for each of the following situations? (Round mortgage payment factors and final answers to 2 decimal places. Omit the "$" sign in your response.) a) A $123,000, 15-year loan at 6.0 percent APR compounded semi - annually b) A $165, 000, 25- year loan at 7.5 percent APR compounded semi- annually c) A $68, 000, 20-year loan at 7.5 percent APR compounded semi - annually.
Complete the following from the first three lines of an amortization schedule for the following loan:You borrow $ 165000 with an annual interest rate of 7.5% over 15 years Starting principal = $ 165000New balance after month 1 payment = New balance after month 2 payment = New balance after month 3 payment =
Prepare an amortization schedule for the first 3 payments (in $) of a $66,000 mortgage at 5% for 20 years. Use this table. (Round your answers to the nearest cent.) Payment Number Monthly Payment Monthly Interest Portion Used to Reduce Principal Loan Balance 0 $ 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ Table 14-1: Monthly Payments to Amortize Principal and Interest per $1,000 Financed Monthly Payments(Necessary to amortize a loan of $1,000) InterestRate (%) 5Years 10Years 15Years 20Years 25Years 30Years 35Years 40Years 3.50 18.19 9.89 7.15 5.80 5.01 4.49 4.13 3.87 3.75 18.30 10.01 7.27 5.93 5.14 4.63 4.28 4.03 4.00 18.42 10.12 7.40 6.06 5.28 4.77 4.43 4.18 4.25 18.53 10.24 7.52 6.19 5.42 4.92 4.58 4.34 4.50 18.64 10.36 7.65 6.33 5.56 5.07 4.73 4.50 4.75 18.76 10.48 7.78 6.46 5.70 5.22 4.89 4.66 5.00 18.87 10.61 7.91 6.60 5.85 5.37 5.05 4.82 5.25 18.99 10.73 8.04 6.74 5.99 5.52 5.21 4.99 5.50 19.10 10.85 8.17 6.88 6.14 5.68 5.37 5.16 5.75…
NEED FULLY CORRECT HANDWRITTEN SOLUTION FOR THIS...ASAP!!! A $180,000 mortgage amortized by monthly payments over 20 years is renewable after five years. (a) If interest is 5.02% compounded semi-annually, what is the size of each monthly payment? (b) Find the total interest paid during the first year. (c) Compute the interest included in the 35th payment. (d) If the mortgage is renewed after five years at 5.80% compounded semi-annually, what is the size of the monthly payment for the renewal period? (e) Construct a partial amortization schedule showing details of the first three payments for each of the two terms.
Make an amortization table to show the first two payments for the mortgage. Amount of mortgage Annual interest rate Years in mortgage Monthly payment $407,550 5.25% 35 $2122.29 Month Monthly payment Interest Principal End-of-month principal 1 $2122.29 $enter your response here $enter your response here $enter your response here 2 $2122.29 $enter your response here $enter your response here $enter your response here
Prepare an amortization schedule for the first 3 payments (in $) of a $62,000 mortgage at 5% for 20 years. Use this table. (Round your answers to the nearest cent.) Table 14-1: Monthly Payments to Amortize Principal and Interest per $1,000 Financed Monthly Payments(Necessary to amortize a loan of $1,000) InterestRate (%) 5Years 10Years 15Years 20Years 25Years 30Years 35Years 40Years 3.50 18.19 9.89 7.15 5.80 5.01 4.49 4.13 3.87 3.75 18.30 10.01 7.27 5.93 5.14 4.63 4.28 4.03 4.00 18.42 10.12 7.40 6.06 5.28 4.77 4.43 4.18 4.25 18.53 10.24 7.52 6.19 5.42 4.92 4.58 4.34 4.50 18.64 10.36 7.65 6.33 5.56 5.07 4.73 4.50 4.75 18.76 10.48 7.78 6.46 5.70 5.22 4.89 4.66 5.00 18.87 10.61 7.91 6.60 5.85 5.37 5.05 4.82 5.25 18.99 10.73 8.04 6.74 5.99 5.52 5.21 4.99 5.50 19.10 10.85 8.17 6.88 6.14 5.68 5.37 5.16 5.75 19.22 10.98 8.30 7.02 6.29 5.84 5.54 5.33 6.00 19.33 11.10 8.44 7.16 6.44 6.00 5.70 5.50 6.25 19.45 11.23 8.57 7.31 6.60 6.16 5.87 5.68 6.50 19.57 11.35…
A loan with the following terms is being made: Fixed rate, constant monthly payment. Closing date February 9th. Five percent interest rate. Prepaid interest due at closing. $105,000 mortgage loan amount. $1,850 loan discount points to be paid by the buyer or borrower to the lender. 25-year term, monthly payments, fully amortizing. Required: Calculate the APR for federal truth-in-lending purposes. (Do not round intermediate calculations. Round your final answer to the nearest one-quarter of a percent.) Important Note from Your Instructor: Do NOT round your final answer to the nearest one-quarter of a percent. This issue has been reported to MH, but it may not be in effect by the start of the term.