Computers and Technology, 03.07.2019 19:00 pito63

How to use cell references, to enter a formula in b6 to calculate monthly payments for the loan described in this worksheet. omit the optional arguements. use a negative value for the pv arguement

Answers: 1

Show answers

Answers

Answer from: andr8aa

Edit the formula in cell C2 so the references to cell B2 will update when the formula ... 2) Enter a formula in cell B4 using the VLOOKUP function to find the meaning ... 10) Using cell references, enter a formula in cell B6 to calculate monthly payments for the loan described in this worksheet. ... Omit the optional arguments.

Answer from: bxbysoso

PV (rate, nper, payment, vf, type)

Rate is the interest rate per period. For example, if you get a loan for a car with an annual interest rate of 10 percent and make monthly payments, the monthly interest rate will be 10% / 12 or 0.83%. In the formula I would write 10% / 12, 0.83% or 0.0083 as the rate.

Nper is the total number of payment periods in an annuity. For example, if you get a four-year loan to buy a car and make monthly payments, the loan will have 4 * 12 (or 48) periods. The formula will have 48 as nper argument.

Payment is the payment made in each period, which cannot vary during the annuity. Generally, the payment argument includes capital and interest, but does not include any other duties or taxes. For example, the monthly payments on a $ 10,000 four-year loan with an interest rate of 12 percent for the purchase of a car are $ 263.33. In the formula I would write -263.33 as the payment argument. If the payment argument is omitted, the vf argument must be included.

Vf is the future value or a cash balance that you want to achieve after making the last payment. If the argument vf is omitted, the value is assumed to be 0 (for example, the future value of a loan is 0). If you want to save $ 50,000 to pay for a special project in 18 years, $ 50,000 would be the future value. In this way, it is possible to make a conservative estimate at a certain interest rate and determine the amount to be saved each month. If the vf argument is omitted, the paid argument must be included.

Answer from: Quest

There is a little paper clip at the bottom of your screen and then you click then you pick the picture you want

Answer from: Quest

you, i'm trying to get a higher rank, this really ! : )

~kay

Another question on Computers and Technology

Computers and Technology, 22.06.2019 06:50

Type the correct answer in the box. spell all words correctly. which view of report creation allows you to customize the report before the database program creates it? creating a report in allows you to customize the report before the database program creates it. pl asap

Answers: 1

Answer

Computers and Technology, 23.06.2019 02:50

Define a class named movie. include private fields for the title,year, and name of the director. include three public functions withprototypes void movie: : settitle(cstring); , voidmovie: : setyear(int); , void movie: : setdirector(string); . includeanother function that displays all the information about a movie.write a main() function that declares a movie object namedmyfavoritemovie. set and display the object's fields.this is what i have but know its wrong since it will notcompile: #include#includeusing namespace std; //class declarationclass movie{private: string movietitle ; string movieyear; string directorname; public: void settitle(string title); void setyear(string year); void setdirector(string director); void displayinfo(); }; //class implementationvoid movie: : settitle(string title){ movietitle = title; cout< < "what is the title of themovie? "< > temp; myfavoritemovie.settitle(temp); cout< < "enter movie year"< > temp; myfavoritemovie.setyear(temp); cout< < "enter director'sname"< > temp; myfavoritemovie.setdirector(temp); //display all the data myfavoritemovie.displayinfo(); system("pause"); return 0; this code is not entirely mine someone on cramster edited my firstcode but then i try manipulating the new code and i still get acompile error message : \documents\visual studio 2008\projects\movie\movie\movie.cpp(46) : error c2679: binary '< < ' : no operator found which takes aright-hand operand of type 'std: : string' (or there is no acceptableconversion)c: \program files (x86)\microsoft visual studio9.0\vc\include\ostream(653): could be'std: : basic_ostream< _elem,_traits> & std: : operator< < > (std: : basic_ostream< _elem,_traits> & ,const char *)w

Answers: 1

Answer

Computers and Technology, 23.06.2019 07:00

What are three software programs for mobile computing?

Answers: 1

Answer

Computers and Technology, 23.06.2019 10:20

Suppose there is a relation r(a, b, c) with a b+-tree index with search keys (a, b).1. what is the worst-case cost of finding records satisfying 10 < a < 50 using this index, in terms of the number of records n1, retrieved and the height h of the tree? 2. what is the worst-case cost of finding records satisfying 10 < a < 50 and 5 < b < 10 using this index, in terms of the number of records n2 that satisfy this selection, as well as n1 and h defined above? 3. under what conditions on n1 and n2, would the index be an efficient way of finding records satisfying the condition from part (2)?

Answers: 1

Answer

You know the right answer?

How to use cell references, to enter a formula in b6 to calculate monthly payments for the loan desc...

Questions