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

rleezy04

  • Member
  • Posts: 322
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Excessive alcohol use costs the country approximately $235 billion every year.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Did you know?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

Did you know?

Human kidneys will clean about 1 million gallons of blood in an average lifetime.

Flower part number is a characteristic difference between monocots and eudicots Flower part number is a characteristic difference between monocots and eudicots
Avogadro's number calculation Avogadro's number calculation
How to calculate mortgage payments (Question 2 of 2) How to calculate mortgage payments (Question 2 of 2)
Number 12 Number 12
Debt payments of $1610.00 due today, $725.00 due in 101 days and $670.00 due in 296 days ... Debt payments of $1610.00 due today, $725.00 due in 101 days and $670.00 due in 296 days ...
Find the equivalent replacement payments for the following scheduled payment. Find the equivalent replacement payments for the following scheduled payment.
Video: Role of transport in a cell

For a complete list of videos, visit our video library