subject
Business, 03.03.2020 07:30 brendonyuvan

Ilya is considering a loan with the terms below and needs to calculate what the monthly payment would be,
D
Period of
Repayment
(in months)
Annual Interest
Rate (in %)
Loan Amount
Monthly
Payment
$100,000
24
What should Ilya insert in cell E6 for Excel to automatically calculate the monthly payment?
=PMT(C5%/12,D5,B5)
=PMT(C5%,B5/12,05)
=PMT(D5, B5/12,C5%)
=PMT(B5,D5,C5%/12)

ansver
Answers: 1

Another question on Business

question
Business, 21.06.2019 21:00
Label each scenario with the term that best describes it. use the midpoint method when applicable. marcel duchamp was a famous artist prior to his death, and was known for his dada artwork, including works such as "soft toilet". all of his original sculptures and paintings go on sale. paul owns a tim horton's, a famous donut and coffee franchise. he is willing to sell as many maple glazed donuts as customers want at a price of $1.00 each, but he refuses to sell any donuts for any price lower than $1.00 . the price of facial tissues rises from $2.85 per box to $3.15 . as a result, p& g increases production from 15 million boxes to 25 million boxes of facial tissue. with the school semester starting for both high school and college, papermate chooses to increase production of pens from 38 million to 42 million after global prices of writing instruments increase from $1.90 a package to $2.10 a package. bright ideas increases its production of lightbulbs by 15% after a 400% increase in the price of fluorescent bulbs.labels: elastic supply; perfectly inelastic supply; perfectly elastic supply; inelastic supply; unit-elastic supply.
Answers: 2
question
Business, 21.06.2019 22:20
Steele bicycle manufacturing company currently produces the handlebars used in manufacturing its bicycles, which are high-quality racing bikes with limited sales. steele produces and sells only 10,000 bikes each year. due to the low volume of activity, steele is unable to obtain the economies of scale that larger producers achieve. for example, steele could buy the handlebars for $31 each: they cost $34 each to make. the following is a detailed breakdown of current production costs: after seeing these figures, steele's president remarked that it would be foolish for the company to continue to produce the handlebars at $34 each when it can buy them for $31 each. calculate the total relevant cost. do you agree with the president's conclusion?
Answers: 1
question
Business, 22.06.2019 08:30
Blank is the internal operation that arranges information resources to support business performance and outcomes
Answers: 2
question
Business, 22.06.2019 08:30
Hi inr 2002 class! i just uploaded a detailed study guide for this class. you can check-out a free preview by following the link below feel free to reach-out to me if you need a study buddy or have any questions. goodluck!
Answers: 1
You know the right answer?
Ilya is considering a loan with the terms below and needs to calculate what the monthly payment woul...
Questions
question
Mathematics, 08.01.2021 19:50
question
Social Studies, 08.01.2021 19:50
question
Mathematics, 08.01.2021 19:50
question
English, 08.01.2021 20:00
Questions on the website: 13722367