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 14:00
Bayside coatings company purchased waterproofing equipment on january 2, 20y4, for $190,000. the equipment was expected to have a useful life of four years and a residual value of $9,000. instructions: determine the amount of depreciation expense for the years ended december 31, 20y4, 20y5, 20y6, and 20y7, by (a) the straight-line method and (b) the double-declining-balance method. also determine the total depreciation expense for the four years by each method. depreciation expense year straight-line method double-declining-balance method 20y4 $ $ 20y5 20y6 20y7 total $
Answers: 3
question
Business, 22.06.2019 20:00
Later movers do not face: entrenched competitors. reduced uncertainty over technologies. high growth markets. lower market uncertainty.
Answers: 3
question
Business, 22.06.2019 23:30
The upper-level managers of synergy technology are meeting for the week to look at the long-term company goals and overall direction of the organization. the ceo has expressed her concern over the economy and has told her managers to look closely at the environment outside the organization before making decisions and to be future oriented. in this meeting, top managers of synergy are
Answers: 2
question
Business, 23.06.2019 01:30
Jodie lives in a developing nation where the local markets are underdeveloped in terms of domestic exposure. her country wants to boost these domestic industries in the face of heavy competition from foreign players in the market. which trade practice should jodie’s country adopt to shield its domestic industries from foreign players? jodie’s country should adopt to shield its domestic industries from foreign players. typing answer
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
English, 07.12.2020 01:00
question
Mathematics, 07.12.2020 01:00
question
Mathematics, 07.12.2020 01:00
question
Mathematics, 07.12.2020 01:00
question
English, 07.12.2020 01:00
question
Biology, 07.12.2020 01:00
Questions on the website: 13722363