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...
-
The Fm signal is applied to the system shown in Figure consisting of a high-pass RC filter and an envelope detector. Assume that (a) The resistance R is small compared with the reactance of the...
-
The surface of a catalytic slab is exposed to a concentration distribution \(c_{a o}(x)\). As material diffuses into the slab it reacts according to a first-order chemical reaction \((a ightarrow...
-
We are separating methanol and water in a staged distillation column at total reflux to determine Murphree efficiency. Pressure is \(101.3 \mathrm{kPa}\). The column has a 2.0 -in. head of liquid on...
-
The auditors wish to test the valuation of accounts receivable in the audit of Desert Enterprises of Bullhead City. The client has $500,000 of total recorded receivables, composed of 850 accounts....
-
Answer the last page of the picture, the CASE PROBLEM.
-
The complexity and uniqueness of the federal government makes it difficult to conduct a meaningful analysis of its financial condition. However, conducting a financial statement analysis does provide...
-
Explain qualitatively how the Fourier transform can be used to analyse the frequency components present in a time-varying signal. If a signal has a finite duration T, what implication does this have...
-
Exclusive contracts allow organizations to contract with physicians and medical groups to provide specific services to the organization.
-
Reducing the risks of malpractice can be accomplished by implementation of best practices, risk management, performance improvement activities, and peer review.
-
Employee handbooks and medical staff bylaws can be binding contracts between employer and employee, unless such documents provide legally acceptable disclaimers.
-
The right of an employer to terminate an employee can be limited through: Employment contract Collective bargaining agreement
-
A contract is a written or oral agreement that involves legally binding obligations between two or more parties. The purpose of a contract is to provide legal recourse should one or more of the...
-
Find a unit vector orthogonal to both a and b, where a = (-1,-1,-3) and b = (3,4,2). Give an exact answer. Provide your answer below:
-
"Standard-cost procedures are particularly applicable to process-costing situations." Do you agree? Why?
-
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.
-
Perfectly competitive firms are _________, who must accept the market price as determined by the forces of demand and supply.
-
Consumers believe that all firms in a perfectly competitive market sell _________ products.
-
In all types of market environments, firms will maximize profits at that output that maximizes the difference between _________ and _________, which is the same output level where _________ equals...
Study smarter with the SolutionInn App