You have recently taken a position in a bank. Your first client would like assistance planning for a loan. You want to set up a detailed loan amortization table. Open the attached Excel file LoanAmortization.xlsx. This file contains a worksheet with a loan parameters area (i.e., input area), a summary area, and amortization table column labels. You will use this template to complete a detailed loan amortization table. You want to build in mechanisms to prevent formula errors if input data are missing and to hide zeros from displaying if your client takes out a shorter-term loan or pay it off early. However, you must keep formulas in place for a traditional 30-year loan. In addition, you will notice overpayments on the last payment if you pay extra toward the principal each month. To make the amortization table as flexible as possible and to avoid errors, you will create several nested IF functions.

Answers

Answer 1

Answer: The question can't be answered, because you haven't included the Excel file LoanAmortization.xlsx. (But I should still get the 5 points ... at least ... for READING the entire question. )

Related Questions

Arrange the systems of equations in order from least to greatest based on the number of solutions for each system.
111201:05:35Line CD passes through points C(3, 5) and D(6, 0). What is the equation of line CD in standard form?5x + 3y = 18O 5x - 3y = 30O 5x2y = 30O 5x + y = 18Save and ExitNextSubmitMark this and retum
If n is the average of three numbers x, 12, and 15, what is the value of x?
If you divide an inheritance of $45,600.00 among 22 heirs, each heir will receive A. $207.27. B. $2,072.73. C. $2,027.27. D. $2,073.72.
How do you do the work for $43 dinner; 18% gratuity

( 4,?)Is on the line y=2×+3. find the other half of the coordinate

Answers

(4, ?). Let ? = b

(4, b) on line y = 2x + 3

x =4, y = b.

y = 2x + 3

b = 2*4 + 3

b = 8 + 3

b = 11.

The other half of coordinate is 11.

You do y=2x(4)+3
that equals 11
so the coordinate is (4,11)

Mrs.Morales wrote a test with 15 questions covering spelling and vocabulary.spelling questions (x )are worth 5 points and vocabulary questions (y)are worth 10 points.the maximum number of points possible on the test is 100.

Answers

Here's our data:
15 questions total
Total number of points: 100
Spelling questions are worth 5 and represented by x
Vocab questions are worth 10 and represented by y
Therefore:
x+y=15
5x + 10y= 100

So:
x+y=15
x= 15-y

5x +10y =100
5(15 -y) +10y =100
75 -5y +10y =100
75 +5y = 100
5y=25
y=5

x +y=15
x+5=15
x=10
There are 10 spelling questions and 5 vocab questions

Coin is tossed and a number cube is rolled. What is the probability that the coin shows heads and the number cube shows 5?1/6
1/12
2/3
1/4

Answers

Hello,

1/2 * 1/6=1/12
===============

Which ratio is expressed as a unit rate?A $1.00/$1.00lb
B 1page /3min
C 16in./16sec
D 67miles/60min

Answers

Answer:

Option A.

Step-by-step explanation:

The question asked for a unit rate. This means that there should be no denominator higher than 1. Option A is the only one which have a denominator of 1.

20,600 at 8 % for 2 years

Answers

First you have to find 8% of 20,600, this would be the rate per year. Then multiply what you get by 2, to figure out how much it is for 2 years. The answer is 3,296. HOPE THIS HELPS!!

what is the actual question please
what are we suppose to find
if it growth or decay
20600(1+8)^2 then 1668600

36 divided by 12 step by step

Answers

36/12=3 as 12 goes into 36 3 times, hope this helps!

Other Questions

A contractor building an airport needs to know how far a water tower is away fromend of the runway. Using her diagram below can you determine how far away thewater tower is?

What is the 12th term in the sequence?an=−16+2n Enter your answer in the box.

Ryan has an eight-year loan for $6,000. He is being charged an interest rate of 5 percent, compounded annually. Calculate the total amount that he will pay.

The ratio of boys to girls in a school is 5:4. if there are 180 students, how many girls are there?