Question
You are thinking of buying a house for 5200,000. You intend to put 20% down and finance the rest with a 15-year, 6.81% mortgage. Which
You are thinking of buying a house for 5200,000. You intend to put 20% down and finance the rest with a 15-year, 6.81% mortgage. Which of the following Excel inputs will provide you with the correct answer, stated as a negative number- that is, the amount of your required monthly outflow? (Select the two that apply)
a.
=PMT(6.81%/12,180,160,000)
b.
=pmt(0681,15,200000)
c.
=pmt(.0681/12,15*12,160,000)
d.
=pmt(.0681,15,160000)
e.
=pmt(.0681/12 15 12.200000* 8)
f.
=Pmt(3.81/12.180,160000)
g.
=Pmt(6. 81%/12.15-12,2000000.2*200000
Oh.
=PMT(6.81%*12,15/12,200000*8)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started