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 156 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
Wow, this really help

milbourne11

  • Member
  • Posts: 322
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

Cutaneous mucormycosis is a rare fungal infection that has been fatal in at least 29% of cases, and in as many as 83% of cases, depending on the patient's health prior to infection. It has occurred often after natural disasters such as tornados, and early treatment is essential.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

How to calculate monthly payments at varying amortization periods (Question 3) How to calculate monthly payments at varying amortization periods (Question 3)
Drawings depicting mitosis in an animal cell with a diploid number of 4 Drawings depicting mitosis in an animal cell with a diploid number of 4
Calculate the number of grams of solute in 500.0 mL of 0.169 M KOH. Calculate the number of grams of solute in 500.0 mL of 0.169 M KOH.
The relationship between the number of stem cell divisions in the lifetime of a given tissue and the The relationship between the number of stem cell divisions in the lifetime of a given tissue and the
What is the minimum number of straight, continuous lines that are necessary to c What is the minimum number of straight, continuous lines that are necessary to c
Separation of variable number tandem repeat (VNTR) alleles after PCR amplification Separation of variable number tandem repeat (VNTR) alleles after PCR amplification
Video: Spermatogenesis Animation

For a complete list of videos, visit our video library