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)

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 11:30

You've arrived at the pecan shellers conference—your first networking opportunity. naturally, you're feeling nervous, but to avoid seeming insecure or uncertain, you've decided to a. speak a little louder than you would normally. b. talk on your cell phone as you walk around. c. hold an empowered image of yourself in your mind. d. square your shoulders before entering the room.

Answers: 2

Answer

Business, 22.06.2019 14:30

Stella company sells only two products, product a and product b. product a product b total selling price $50 $30 variable cost per unit $20 $10 total fixed costs $2,110,000 stella sells two units of product a for each unit it sells of product b. stella faces a tax rate of 40%. stella desires a net afterminustax income of $54,000. the breakeven point in units would be

Answers: 3

Answer

Business, 22.06.2019 15:20

Sauer food company has decided to buy a new computer system with an expected life of three years. the cost is $440,000. the company can borrow $440,000 for three years at 14 percent annual interest or for one year at 12 percent annual interest. assume interest is paid in full at the end of each year. a. how much would sauer food company save in interest over the three-year life of the computer system if the one-year loan is utilized and the loan is rolled over (reborrowed) each year at the same 12 percent rate? compare this to the 14 percent three-year loan.

Answers: 3

Answer

Business, 23.06.2019 04:40

Aneighborhood home owners association suspects that the recent appraisal values of the houses in the neighborhood conducted by the county government for taxation purposes is too high. it hired a private company to appraise the values of ten houses in the neighborhood. the results, in thousands of dollars, are?

Answers: 1

Answer

You know the right answer?

Ilya is considering a loan with the terms below and needs to calculate what the monthly payment woul...

Questions

Business, 06.03.2020 22:19

Each visor requires a total of $4.00 in direct materials that includes an adjustable closure that the company purchases from a supplier at a cost of $...