answersLogoWhite

0

How do you solve this excel exercise?

User Avatar

Theoc

Lvl 1
13y ago
Updated: 8/20/2019

here is the exercise:

A bank makes an announcement for an HP Compaq notebook with the following offer:

Repayment in 36 monthly installments of USD 57

or Repayment in 24 monthly installments of USD 82.

What is Cash Value of this Notebook? (PV)

I need to use functions to get the annual rate and the present value, functions such as (=rate ; =pmt ; etc,...)

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

How do you solve the transportation problem?

You can use the Excel plugin 'Solver' tp to solve transportation problems which will then be available under Tools menu in Excel


How can use the expression in exercise 7 to solve?

my answer was 53


How do you do a math problem on Microsoft Word?

With Microsoft Excel, you can solve math problems (basic and scientific) and use and create graphs. If you have Word, than you should have Excel.


How do you solve formulas?

A formula is a statement. It's not a problem or an exercise to which a solution is needed.


How can you solve a formula?

A formula is a statement. It's not a problem or an exercise to which a solution is needed.


How do you do exercise 4.9.7 on codehs?

Give us the problem, and we'll help you solve it.


What are the Possible Remedies with Microsoft Excel?

It depends on what you are trying to solve. There are many thousands of remedies to various problems using MS Excel. Maybe you should use a word other than "remedies" for this question.


Is an experiment an example of an exercise or problem?

it is a problem because an exercise is something that you do to get good practice with it, while a problem is more like a puzzle that you need to solve.


What is Microsoft Office Excal 2007?

It ia a update of Microsoft Excel 2003. A spreadsheet program that will also create graphs and solve equations


How do you solve noyce foundation tri-triangles math problem?

These questions are meant to be used as a school-wide exercise. Your teacher should explain the solution after everyone has had a chance to solve it.


How can exercise help your self-esteem and self-image?

Because if you are around other people when performing the exercise, that is an excellent opportunity to interact and enjoy friendly contact with others; if you should excel or attain high scores during the exercise, that would indeed be a boost to your self-image and self-esteem.


How do you put in a statistical formula in a excel?

Excel has a category of functions that deal with statistics. There are a large amount of functions in that category. Some are very simple, like the AVERAGE function and some are much more specialised and complex. Those functions cover a wide range of statistical areas and can be used to solve many statistical problems. Dealing with statistics is a large area of what Excel does.