This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: An ordinary annuity is an annuity having no fixed number of payments but depending on an uncertain ... (Read 100 times)

imowrer

  • Hero Member
  • *****
  • Posts: 514
on: Jun 24, 2018
An ordinary annuity is an annuity having no fixed number of payments but depending on an uncertain event, such as life insurance payments ceasing at the death of the insured.
  Indicate whether the statement is true or false

Question 2

Jacob is using Excel to track the installment loan he used to buy a new boat. He has entered the purchase price in Cell B5, the interest rate in Cell B6, the down payment percent in Cell B7, and the years for the loan in Cell B8. Formulas will be entered to calculate amount financed in Cell B9, finance charge in Cell B10, and monthly payment in Cell B11. Jacob needs help to write the formula to determine the monthly payment. How would you explain to Jacob what he needs to calculate so that explanation can turn into an Excel formula? What is the formula?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

diesoon

  • Sr. Member
  • ****
  • Posts: 353
Reply #1 on: Jun 24, 2018
Answer to Question 1

FALSE

Answer to Question 2

Divide the amount to be repaid (amount financed plus finance charge) by the number of monthly payments (number of years times 12 months); =(B9+B10)/(B812)


imowrer

  • Member
  • Posts: 514
Reply 2 on: Jun 24, 2018
YES! Correct, THANKS for helping me on my review

bassamabas

  • Member
  • Posts: 294
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

There are over 65,000 known species of protozoa. About 10,000 species are parasitic.

Did you know?

More than 2,500 barbiturates have been synthesized. At the height of their popularity, about 50 were marketed for human use.

Did you know?

Eat fiber! A diet high in fiber can help lower cholesterol levels by as much as 10%.

Did you know?

Multiple experimental evidences have confirmed that at the molecular level, cancer is caused by lesions in cellular DNA.

Did you know?

Glaucoma is a leading cause of blindness. As of yet, there is no cure. Everyone is at risk, and there may be no warning signs. It is six to eight times more common in African Americans than in whites. The best and most effective way to detect glaucoma is to receive a dilated eye examination.

Relationship between the number of CAG repeats in a gene and the age of onset of Huntington disease. Relationship between the number of CAG repeats in a gene and the age of onset of Huntington disease.
Number of lower molar cusps is one of the features used to distinguish sundadonts from sinodonts. Number of lower molar cusps is one of the features used to distinguish sundadonts from sinodonts.
How to write any number in scientific notation How to write any number in scientific notation
Debt payments of $1610.00 due today, $725.00 due in 101 days and $670.00 due in 296 days ... Debt payments of $1610.00 due today, $725.00 due in 101 days and $670.00 due in 296 days ...
Number of Mutations Associated with Specific Forms of Cancer Number of Mutations Associated with Specific Forms of Cancer
Meiosis Halves the Chromosome Number Meiosis Halves the Chromosome Number
Video: Second Messengers in the Inositol-lipid Signaling Pathway

For a complete list of videos, visit our video library