1. Create an amortization schedule in an Excel spreadsheet for a fixed-rate, fully amortizing mortgage loan...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 years Nominal annual interest rate: 5.55% Type of mortgage: Fixed rate, conventional Payments: Monthly Discount points: 3 Ensure that there are columns for the month/payment number (i.e., 1, 2, 3....), beginning loan balance, payment amount, monthly interest amount, monthly principal amount, and ending loan principal balance for each month. In other words, there should be a separate line entry for each month over the life of the loan with all the requested information. Use the Excel TVM functions or mathematical formulas for all monthly cell entries, except for the month numbers. 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 years Nominal annual interest rate: 5.55% Type of mortgage: Fixed rate, conventional Payments: Monthly Discount points: 3 Ensure that there are columns for the month/payment number (i.e., 1, 2, 3....), beginning loan balance, payment amount, monthly interest amount, monthly principal amount, and ending loan principal balance for each month. In other words, there should be a separate line entry for each month over the life of the loan with all the requested information. Use the Excel TVM functions or mathematical formulas for all monthly cell entries, except for the month numbers.
Expert Answer:
Answer rating: 100% (QA)
Step 12 Help Mode Delay 1 To create an amortization schedule in Excel you can use th... View the full answer
Related Book For
Business Math
ISBN: 978-0133011203
10th edition
Authors: Cheryl Cleaves, Margie Hobbs, Jeffrey Noble
Posted Date:
Students also viewed these finance questions
-
This project requires you to create an amortization schedule for two types of loans, a fully amortizing constant payment mortgage (CPM) loan, and a constant amortizing (CAM) loan. In your report,...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Nadia Khalif is the office manager for the Conyers Law Offices in Dallas, Texas. The firm is planning to move its computer network into the cloud so that everyone working on a case can access...
-
The following are some examples of typical business transactions: 1. Purchased office equipment on credit. 2. The owner contributed capital. 3. Purchased office furniture for cash. 4. Received...
-
Accounting for zero coupon debt. When Time Warner Inc. announced its intention to borrow about $500 million by issuing 20-year zero coupon (single payment) notes, The Wall Street Journal reported the...
-
An insulated rigid 2-m 3 tank A contains carbon dioxide gas at 200C, 1MPa. An uninsulated rigid 1-m 3 tank B contains ethane, (C 2 H 6 ), gas at 200 kPa, room temperature 20C. The two tanks are...
-
The strongback \(B C\) is made of an A992 steel hollow circular section with an outer diameter of \(d_{o}=60 \mathrm{~mm}\) and inner diameter of \(d_{i}=40 \mathrm{~mm}\). Determine the maximum...
-
Comparison of Different Types of Accounting by Lessee and Lessor Part 1 Capital leases and operating leases are the two classifications of leases described in FASB pronouncements from the standpoint...
-
Let NI = ($100,000, $500,000) be a person's no insurance wealth bundle. The person has square root utility function: U(m) = m1/2. If the person is high risk her probability of loss is p = 0.20 and if...
-
The COVID-19 pandemic affected companies in the food industry in unique ways, particularly during 2020. Ruth's Hospitality Group (Ticker: RUTH) develops and operates fine dining restaurants under the...
-
How many meters below the surface of a pure water pool ( density = 1 0 0 0 kg / m 3 ) is the absolute pressure 5 . 0 times the atmospheric pressure above the water?
-
Warehouse capacity depends on how high goods can be stored. Space is also required for aisles, receiving & shipping docks, offices & order picking & assembly. What are some of the parts of warehouse...
-
EXECUTIVE SUMMARY You are a Business Analyst at Simcoe Skies, a regional airline with operations across Eastern Canada (note: this is a fictitious company). Simcoe Skies has received numerous...
-
Cruising Environmental Sustainability Assignment 10% As we have seen cruising can be very impactful on the environment on land and in water. The UNWTO addresses this in their Sustainability...
-
Fernando's Furniture Inc. sponsors a defined benefit pension plan for its employees. The plan's trustee reports the following information for calendar 2023: Defined benefit obligation, January...
-
Find and describe to us an example of a "cruel irony" of a recent climate disaster. In what ways is the situation unethical or a human rights violation?
-
A company currently (year 1) spends $4,834 on operating and maintenance costs per year. They expect these costs to increase by $4,230 per year for the next 11 years. What is the EUAC of these O&M...
-
Draw the appropriate control flow graph of the given pseudocode.Make sure to only use one number for blocks of code which are all sequential and when the first line is executed, all of those lines...
-
Department A uses 5,000 square feet of floor space, department B uses 2,500, department C uses 4,300, and department D uses 2,700. The total overhead is $8,200. Find each department's overhead based...
-
You invest in an ordinary annuity of $2,000 annually at 8% annual interest. What is the future value of the annuity at the end of five years? How much have you invested? How much interest has your...
-
A copy machine is marked up 82.2% based on the cost. Find the markup rate based on selling price. Round to the nearest tenth percent.
-
The following are methods used to evaluate public health data and scientifc evidence except a. Use of standard criteria by experts b. By combining the results of multiple scientifc studies that are...
-
Which industrial transducer does not require a power supply (selfgenerated signal)?
-
Nordson Co. of Amherst, Ohio, a maker of painting and glue equipment, exports nearly half its output. Customers value its reliability as a supplier. Because of an especially sharp run up in the value...
Study smarter with the SolutionInn App