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 126 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
:D TYSM

bassamabas

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

« previous next »
 

Did you know?

Congestive heart failure is a serious disorder that carries a reduced life expectancy. Heart failure is usually a chronic illness, and it may worsen with infection or other physical stressors.

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?

Stroke kills people from all ethnic backgrounds, but the people at highest risk for fatal strokes are: black men, black women, Asian men, white men, and white women.

Did you know?

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Did you know?

Russia has the highest death rate from cardiovascular disease followed by the Ukraine, Romania, Hungary, and Poland.

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.
The relationship between number of acres a Kipsigis man owns and the number of offspring he has duri The relationship between number of acres a Kipsigis man owns and the number of offspring he has duri
A ring link network reduces the number of wires it takes to interconnect all of the modules. A ring link network reduces the number of wires it takes to interconnect all of the modules.
How to calculate monthly mortgage payments at varying amortization periods (Question 1) How to calculate monthly mortgage payments at varying amortization periods (Question 1)
Number of Mutations Associated with Specific Forms of Cancer Number of Mutations Associated with Specific Forms of Cancer
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
Video: Carbohydrate digestion - mouth and stomach & pancreas and small intestine

For a complete list of videos, visit our video library