You are thinking of buying a house for 5200,000. You intend to put 20% down...
50.1K
Verified Solution
Link Copied!
Question
Accounting
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)
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)
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.