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 125 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

bulacsom

  • Member
  • Posts: 329
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

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

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

Signs and symptoms of a drug overdose include losing consciousness, fever or sweating, breathing problems, abnormal pulse, and changes in skin color.

Did you know?

Normal urine is sterile. It contains fluids, salts, and waste products. It is free of bacteria, viruses, and fungi.

Did you know?

Vampire bats have a natural anticoagulant in their saliva that permits continuous bleeding after they painlessly open a wound with their incisors. This capillary blood does not cause any significant blood loss to their victims.

A greater number of men than women hold full-time jobs, but the gap is closing because of an ... A greater number of men than women hold full-time jobs, but the gap is closing because of an ...
The distribution of cones and rods over the human retina. The figure illustrates the number of cones ... The distribution of cones and rods over the human retina. The figure illustrates the number of cones ...
How to calculate monthly payments at varying amortization periods (Question 2) How to calculate monthly payments at varying amortization periods (Question 2)
Bidirectional replication from several fixed origins (O) on a linear eukaryotic chromosome Bidirectional replication from several fixed origins (O) on a linear eukaryotic chromosome
Mayan Number Mayan Number
Relationship between the number of amino acid substitutions Relationship between the number of amino acid substitutions
Video: T cell receptors

For a complete list of videos, visit our video library