Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting For School Administrators Tools For School

Authors: Ronald E. Everett, Donald R. Johnson, Bernard W. Madden

3rd Edition

1610487710, 978-1610487719

More Books

Students also viewed these Accounting questions