Question: please show excel functions begin{tabular}{l|l|} hline 1 & Loan amount hline 2 & Maturity (years) hline 3 & Annual interest rate hline

please show excel functions

$please show excel functions \begin{tabular}{l|l|} \hline 1 & Loan amount \\ \hline$

$2 & Maturity (years) \\ \hline 3 & Annual interest rate \\$

\begin{tabular}{l|l|} \hline 1 & Loan amount \\ \hline 2 & Maturity (years) \\ \hline 3 & Annual interest rate \\ \hline 4 & \\ 5 & \\ 6 & \\ 7 & \\ 8 & \\ 9 & \\ 10 \\ 11 & \\ 12 \\ 13 & \\ 14 \\ 15 \\ 16 \\ 17 \end{tabular} (9) You took a 6-year, $120,000 loan. The loan has equal principal payments. The loan carries a 6.5% annual interest rate and is paid back in annual payments. ( 6 points) a. Construct an amortization table for the loan. b. What is the outstanding balance of the loan after 3 years? c. What is the interest payment on the 4th installment

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Hi, I need help with my homework. My homework is about computer modelling in finance. This homework need to use Excel formula to calculate some data. I wish someone can help me, thank you! Problem 1...

\begin{tabular}{|l|l|l|} \hline Q11) Prepare the first row of a loan amortization schedule based on the & \\ following information. The loan amount is for $36,886.00 with an annual & \\ interest rate...

\begin{tabular}{|l|l|l|} \hline Q11) Prepare the first row of a loan amortization schedule based on the & & \\ following information. The loan amount is for $48,990.00 with an annual \\ interest rate...

Good evening, I need help figuring out these problems, and I need you show (the steps, math or calculations) how you got the answer. I only have 3 (tries or times) attempts to get each question...

please show excel functions used \begin{tabular}{|c|c|c|} \hline 4 & A & B \\ \hline 1 & \multicolumn{2}{|c|}{ COMPARING 4 SAVINGS PLANS } \\ \hline 2 & Savings amount & 1,000.00 \\ \hline 3 & & \\...

please show excel formulas in the models! H 1 Assignment 2 3 4 You are investing in a 250 unit student housing complex that you bought for $21,000,000 and plan to sell the property in 12 years. You...

question 12 :) please show excel functions 11. What is the draw (payment to the borrower) in a RAM for $200,000 at 4% interest and a maturity of 10 years? Answer $2,024.90 Loan Amount Periods Per...

On June 30, 2024, Georgia-Atlantic, Incorporated leased warehouse equipment from IC Leasing Corporation. The lease agreement calls for Georgia-Atlantic to make semiannual lease payments of $604,152...

The City of Bernard starts the year of 2020 with the following unrestricted amounts in its general fund: cash of $29,000 and investments of $85,250. In addition, it holds a small building bought on...

do an amortization schedule in a spreadsheet for a car loan, the amount is up to you. The annual interest rate on the loan is your choice as well do some research and use a rate that is typical in...

Omega Lawn Care Services is a small, family-owned business operating out of Rexdale, Ontario. The company has always charged a flat fee per hundred square feet of lawn service for its services. The...

Gaylord Gunnison (GG) died January 13, 2015, and his gross estate consisted of three propertiescash, land, and stock in a public company. The amount of cash on the date of his death was $2.9 million,...

Fig. 1E.22 shows a model aeroplane. It is powered by a wound elastic band. When it is released, it will fly for a short distance. What is the energy store in the elastic band? (a) elastic strain...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

1. Identify training needs for a group of entry-level workers in a fast food restaurant.

5. Because of the rapid growth of your technology company, the executive team has asked HR to develop an internal training program. The purpose of the program is to help employees recently promoted...

2. Why is evaluating training an important part of strategic training?