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 143 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
Great answer, keep it coming :)

jomama

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

« previous next »
 

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

The average older adult in the United States takes five prescription drugs per day. Half of these drugs contain a sedative. Alcohol should therefore be avoided by most senior citizens because of the dangerous interactions between alcohol and sedatives.

Did you know?

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

Did you know?

The average adult has about 21 square feet of skin.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

Men and women work the same number of hours a week, but men spend more time on paid work, and women ... Men and women work the same number of hours a week, but men spend more time on paid work, and women ...
Number and label designations for oxygen sensors. Bank 1 is the bank where cylinder number 1 is ... Number and label designations for oxygen sensors. Bank 1 is the bank where cylinder number 1 is ...
How to write any number in engineering notation How to write any number in engineering notation
How to calculate regular payments or deposits using the annuity formula (Question 1) How to calculate regular payments or deposits using the annuity formula (Question 1)
How to calculate RRSP using the annuity formula How to calculate RRSP using the annuity formula
An 8th grade class develops a linear model that predicts the number of cheerios (a small round ... An 8th grade class develops a linear model that predicts the number of cheerios (a small round ...
Video: Role of transport in a cell

For a complete list of videos, visit our video library