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, 22.06.2019 02:30
The cost of capital: introduction the cost of capital: introduction companies issue bonds, preferred stock, and common equity to aise capital to invest in capital budgeting projects. capital is』necessary factor of production and like any other factor, it has a cost. this cost is equal to the select the applicable security. the rates of return that investors require on bonds, preferred stocks, and common equity represent the costs of those securities to the firm. companies estimate the required returns on their securities, calculate a weighted average of the costs of their different types of capital, and use this average cost for capital budgeting purposes. required return on rate: when calculating om operations when the firm's primary financial objective is to select shareholder value. to do this, companies invest in projects that earnselect their cost of capital. so, the cost of capital is often referred to as the -select -select and accruals, which a se spontaneously we hted average cost of capital wa c our concern is with capital that must be provided by select- 쑤 interest-bearing debt preferred stock and common equity. capital budgeting projects are undertaken, are not included as part of total invested capital because they do not come directly from investors. which of the following would be included in the caculation of total invested capital? choose the response that is most correct a. notes payable b. taxes payable c retained earnings d. responses a and c would be included in the calculation of total invested capital. e. none of the above would be included in the cakulation of total invested capital.
Answers: 2
question
Business, 22.06.2019 13:50
The retained earnings account has a credit balance of $24,650 before closing entries are made. if total revenues for the period are $77,700, total expenses are $56,900, and dividends are $13,050, what is the ending balance in the retained earnings account after all closing entries are made?
Answers: 2
question
Business, 22.06.2019 14:10
When paul o’neill joined alcoa as ceo, he set a , that there would be zero workplace accidents. a lot of people in the organization thought this was impossible given how dangerous some aluminum-manufacturing jobs are, but alcoa’s safety record improved tremendously. as the board of governors of the american red cross considers planning, one option is to make strategic plans and then direct managers to align tactical and operational plans accordingly. another option is to have planning specialists managers across the organization make their own plans. why might this organization’s executives opt for the latter approach? check all that apply. (a) the environment is a dynamic one, and department and frontline managers can come up with more responsive plans than can central leadership. (b)resources will be better coordinated across the organization in support of the overall strategy.(c) senior leadership will have more control over the organization’s direction. (d)when managers come up with their own plans, they are likely to be more committed to following through on them.
Answers: 2
question
Business, 22.06.2019 16:50
Arestaurant that creates a new type of sandwich is using (blank) as a method of competition.
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
Chemistry, 13.01.2020 08:31
question
Mathematics, 13.01.2020 08:31
question
English, 13.01.2020 08:31
question
English, 13.01.2020 08:31
question
Mathematics, 13.01.2020 08:31
Questions on the website: 13722367