Assume that you are buying a car for $25,000 with a $4,000 down payment. You are
borrowing the rest from the bank at 5.5% annual interest compound monthly. Your
monthly payments are $400. Write and Excel formula to determine the number of
years it will take you to pay off this loan
Give this one a try later!
NPER(5.5%/12,-400-25500,-4000)/12
In a two variable data table, what do the first column first row contain
Give this one a try later!
Input cells
,How many different horses?
Give this one a try later!
6
Function to calculate periodic payments into or out of a financial transaction
Give this one a try later!
PMT
What are the two advantages of creating a constraints table in a worksheet that
included a Solver model?
Give this one a try later!
Record of constraints and a data-entry reference
Simple Interest
Give this one a try later!
Interest calculated based on original principal
, Compound Interest
Give this one a try later!
Interest calculated base on principal and previous interest earned
List and describe the difference and similarites between HTML and XML
Give this one a try later!
-HML is makeup language that creates web pages by embedding tags in
the document to describe the formatting
-XML is used to transfer information between different applications through
a languaga that defines the structure and rules for creating markup
elements
Explain how you must very the setup of a two-variable data table to run simulation vie
the table
Give this one a try later!
One set of input value must be a sequence of numbers representing the
number of iteration of the simulation
Write an Excel formula to determine the yearly interest rate being charged by the
bank on a $400,000 , 20 year mortgage. You make a monthly mortgage payment of
$3,400 and value of loan at the end of 20 years is 0. Interest in compounded monthly
borrowing the rest from the bank at 5.5% annual interest compound monthly. Your
monthly payments are $400. Write and Excel formula to determine the number of
years it will take you to pay off this loan
Give this one a try later!
NPER(5.5%/12,-400-25500,-4000)/12
In a two variable data table, what do the first column first row contain
Give this one a try later!
Input cells
,How many different horses?
Give this one a try later!
6
Function to calculate periodic payments into or out of a financial transaction
Give this one a try later!
PMT
What are the two advantages of creating a constraints table in a worksheet that
included a Solver model?
Give this one a try later!
Record of constraints and a data-entry reference
Simple Interest
Give this one a try later!
Interest calculated based on original principal
, Compound Interest
Give this one a try later!
Interest calculated base on principal and previous interest earned
List and describe the difference and similarites between HTML and XML
Give this one a try later!
-HML is makeup language that creates web pages by embedding tags in
the document to describe the formatting
-XML is used to transfer information between different applications through
a languaga that defines the structure and rules for creating markup
elements
Explain how you must very the setup of a two-variable data table to run simulation vie
the table
Give this one a try later!
One set of input value must be a sequence of numbers representing the
number of iteration of the simulation
Write an Excel formula to determine the yearly interest rate being charged by the
bank on a $400,000 , 20 year mortgage. You make a monthly mortgage payment of
$3,400 and value of loan at the end of 20 years is 0. Interest in compounded monthly
