Question: Create an amortization schedule for only the first 6 months of owning your own home in #8. How much in principal has been paid down

Create an amortization schedule for only the first 6 months of owning your own home in #8. How much in principal has been "paid down" in total over the first 6 months? How much in interest have you paid in total over the first 6 months? Compare this to the last 6 months and discuss. How much in total payments will be made over the life of the loan?

8. How much does your monthly loan payment (P+I only ignore taxes and insurance) increase if you can get a 15‐year loan for 3.70%? How much in total payments will be made over the life of the loan?

$922.3856 is the monthly payment for this mortgage

Step by Step Solution

★★★★★

3.38 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

interest rate annually 370 interest rate monthly 031 monthly payment 92238... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

6257bc9030de1_april14.xlsx

300 KBs Excel File

Students Have Also Explored These Related Finance Questions!

Create an amortization schedule for the first two months' payments on a mortgage of $487,700 with an interest rate of 6% and monthly payment of $2,926.20?

1. Construct an amortization schedule for a $1,000, 10% annual rate loan with 3 equal installments. 2. What is the annual interest expense for the borrower, and the annual interest income for the...

a. Set up an amortization schedule for a $25,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 10% compounded annually. b. What percentage of...

PLEASE ANSWER 6-10 and QUESTION 12 . READ ALL PHOTOS POSTED AND TYPE ANSWER TO THE QUESTION PLEASE . NEED HELP ASAP PERSONAL INFORMATION Antonne and LaKeisha met when they were both students at Clark...

For this assignment, you will financially plan the rest of your life. You will be able to make choices about certain aspects, but there are two unbreakable rules: Rule #1: You must always spend...

Alice J. and Bruce M. Jones are married taxpayers who file a joint return. Alices birthday is September 21, 1961, and Bruces is June 27, 1960. Bruce is the office manager for Ames Dental Clinic....

Group#ABC CorpAssignment1 (3) [Protected View] File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you wa i PROTECTED VIEW Be careful--files from the Internet can contain...

You recently met with your new clients, Laura and John Rockefeller. It was your first formal meeting; however, they requested that you combine the initial meeting with a data gathering session. The...

please create a balance sheet with the given data You learned that John is 30 years old, Laura is 29 years old and their daughter, Bessie, is 6 years old. John earns $135,000 per year as a manager at...

FINC 350 CASE STUDY/ PROJECT Overview This project requires you to apply the concepts learned in FINC 350 course. The course has equipped you with basic financial planning skills . For this project,...

Ravi found that he had made a loss of 10% while selling his smartphone. He also found that had he sold it for Rs. 100 more, he would have made a profit of 10%. The initial loss was what percentage of...

The Comfort-Zone Company installs heating, ventilation, and air conditioning in large buildings such as domed stadiums, military bases, airports, and high rises. Its contracts usually take two to...

Newal Dexolige Managed Accivats How to Olange a C - Mobile Deposil INE. IEBA Givk Acters Fidelity Overview id . Sales Support Mare - Horne - Your Germ General Pinancial Planning Prisciples,...

The upper and lower specification limits for a certain product are 7.3 lbs. and 7.0 lbs. actual data indicates that the product is currently running at an average of 7.465 lbs., with a standard...

The following information is given about options on the stock of a certain company. Briefly discuss. S 0 = 23 X = 20 r c = 0.09 T = 0.5 s 2 = 0.15 What value does the Black-Scholes-Merton model...

Choose the Incorrect statement OA. Propanoic anhydride is a symmetrical anhydride. O B. A reaction between amide and H20/ HO form a carboxylic acid. Acid anhydride is less reactive than acyl halide....

BarLey Inc. recently borrowed $125,000 from its bank at a simple interest rate of 12 percent. The loan is for one year and, according to the loan agreement, the interest should be added to the amount...

What is the annual percentage rate on a loan with a stated rate of 2.75 percent per quarter? 11.00 percent 11.09 percent 11.18 percent 11.27 percent 11.31 percent

BuyVerified Bybit Accounts-No.1The Best Website With KYC Verification!! In the rapidly evolving realm of cryptocurrency trading, having a verified account on sites such as Bybit is crucial. Imagine...

1. Create an amortization schedule in an Excel spreadsheet for a fixed-rate, fully amortizing mortgage loan using the information below: Cost of house: $475,000 Down payment: 20% Mortgage term: 30...

Company B constructed assembly line equipment for Company A. The construction finished, and the equipment was ready for use on January 1,2021. Company A paid for the equipment by issuing a note....

Create one workbook with three worksheets showing the loan / bond options. Annual Loan Create a sheet and name it "Annual Loan." Create a header for the page. Set up the assumptions ( loan amount,...

List and explain the steps you took to determine the type of lease for the Hanson Group. Determine how to record the lease by answering the questions from either Group I or Group II criteria in the...

I would like assistance with my coding C++ visual studio. Some terms are not defined properly and i am not sure how to fix it. INSTRUCTIONS:: MY PROGRAM::: AutoSave Off C++ Programming Functions and...

Loan Strategies An amortization schedule is a table that lists the principal and interest charges, and the remaining balance for each payment across the life of a loan. Lenders use this type of...