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 184 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
Excellent

cpetit11

  • Member
  • Posts: 321
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

About 100 new prescription or over-the-counter drugs come into the U.S. market every year.

Did you know?

Patients should never assume they are being given the appropriate drugs. They should make sure they know which drugs are being prescribed, and always double-check that the drugs received match the prescription.

Did you know?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

Did you know?

The eye muscles are the most active muscles in the whole body. The external muscles that move the eyes are the strongest muscles in the human body for the job they have to do. They are 100 times more powerful than they need to be.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

History of the number of observed sunspots during the last 250 years, which shows the ~11-year solar History of the number of observed sunspots during the last 250 years, which shows the ~11-year solar
Young adulthood brings the greatest number of role transitions and highest levels of demands than ... Young adulthood brings the greatest number of role transitions and highest levels of demands than ...
Estimated number of new HIV infections per year over time period in Canada Estimated number of new HIV infections per year over time period in Canada
physics question number 5 - moving conductors physics question number 5 - moving conductors
No payments were made on a $2,598 loan during its three-year term. What was the annually ... No payments were made on a $2,598 loan during its three-year term. What was the annually ...
Number line for rounding Number line for rounding
Video: Chromosome structural organization/ Mechanisms for chromosome movement Animation

For a complete list of videos, visit our video library