100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
Amortization Test Actual Questions And Correct Detailed Answers. $13.99
Add to cart
Quickly navigate to
Preview
  2.  
  3. AMORTIZATION
  4.  
  5. AMORTIZATION

Exam (elaborations)

Amortization Test Actual Questions And Correct Detailed Answers.
 0 purchase
  • Course
  • AMORTIZATION
  • Institution
  • AMORTIZATION

formula - correct answer A(n) ________ in Excel™ is a software instruction to the program to calculate the quantities in cells on the worksheet. Answers: formula square root argument matrix true - correct answer On...

[Show more]

Preview 3 out of 19  pages

Document information

  • October 11, 2024
  • 19
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

Written for

  • AMORTIZATION
  • AMORTIZATION

Seller

avatar-seller
RealGrades

Reviews received

Content preview

Amortization Test

formula - correct answer A(n) ________ in Excel™ is a software instruction to the
program to calculate the quantities in cells on the worksheet.

Answers:

formula

square root

argument

matrix



true - correct answer One helpful use of an amortization schedule as an automobile
owner is to know whether a trade-in allowance is satisfactory in the negotiation for another car before
the first loan is paid.

Answers:

True

False



Drag using the fill handle in the lower cell to the value of the maximum number of payments. - correct
answer To create automatically a column of sequential integers beginning with "1"
and ending with the number of payments of the loan, enter correct values (for example, 1, 2) in each of
the first and second cells at the top of the column. Then select both cells and _____________.

Answers:

Drag using the fill handle in the lower cell to the value of the maximum number of payments.

Use the PMT function and copy it to the next lower cell.

Just type in the values manually

Drag the top cell to the right.



Nper - correct answer In a constant payment loan calculation using PMT in Excel™,
_______ represents the number of payments required in the loan schedule.

Answers:

,Nper

log

per

ppmt



Multiply times the quantity -1 - correct answer When confronted with a negative
number in a loan calculation that is the result of an Excel™ and not a mathematical negative, the
correction can be achieved by the following procedure:

Answers:

Add $.02 to the payment amount.

Multiply times the quantity -1.

Divide by a quantity of 3.14159 (Pi).

Multiply by a value of 10.



No, because the payments are made more often and twelve payments are due in less time than a year.
There are 52 weeks in a year meaning 13 payments will be due under the proposed loan rather than 12
payments due under the current monthly contact. This will change the annual percentage rate unless
the payment amounts are recalculated. - correct answer Jimmy was talking with a
lender who also owns a pawn shop. Jimmy is having difficulty making the payments on a loan at the
bank with an 8% annual percentage interest rate. The payments on the loan are due monthly. The
lender at the pawn shop has offered to pay off the bank and to allow Jimmy to pay him payments equal
to the current payments, but the payments will be due every four weeks rather than monthly. Jimmy
asked if the annual interest rate would change from the bank's rate. The lender replied, "No, because
the payment amounts are the same, just due a bit more often." Is the lender's answer true?



Answers:

The annual percentage rate does not change if the number of payments change.

The answer is close enough between friends.

Yes, because there are just a few days involved. This is not enough of a difference to affect the annual
percentage rate.

No, because the payments are made more often and twelve payments are due in less time than a year.
There are 52 weeks in a year meaning 13 payments will be due under the proposed loan rather than 12
payments due under the current monthly contact. This will change the annual percentage rate unless
the payment amounts are recalculated.

, absolute - correct answer The mode of addressing used when copying a formula in
a cell to a distant cell, but the cell references as far as column and row remain unchanged, is called
_______ addressing.

Answers:

relative

postponed

intuitive

absolute



Most often this is just an Excel™ convention to show that the money is paid out. It is rarely a negative
number. - correct answer The answers to most PMT, IPMT, and PPMT function
problems has a minus sign (-) in front of it. What does this minus sign mean in the majority of cases?

Answers:

Most often this is just an Excel™ convention to show that the money is paid out. It is rarely a negative
number.

The answer is a negative number mathematically.

This is just a means of distinguishing the answer from the other verbiage.

You have the wrong answer.



integer - correct answer Cell addresses in Excel™ consist of a column identifier
placed in alphabetical order and a row identifier expressed as a(n) _______ in sequential order.

Answers:

decimal fraction

integer

financing factor

symbol



Divide the annual percentage rate by 4 - correct answer If given an annual
percentage rate that is numerically correct for a constant payment loan, the following procedure must
be done if the payments are to be made on a quarterly basis

Answers:

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller RealGrades. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $13.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69052 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling
$13.99
  • (0)
Add to cart
Added