Question: QUESTION 12 2 points Save Answer When buying a home, if your down payment is less than 20% of the home's sale price you have

QUESTION 12 2 points Save Answer When buying a home, if your down payment is less than 20% of the home's sale price you have to pay private mortgate insurance (PMI). For this example, assume that the yearly fee for PMI is .78% of the original loan amount. Which formula should you use in cell B4 in order to calculate the monthly cost of PMI? B4 Home Sale Price: $46,000.00 2 Down Payment: $ 9,500.00 3 Loan Amount: 4 Monthly PMI 36,500.00 -IF(B2-20%"B1 ,0,(0.78%"B3/12) IF(B2>20%"B1) 0 ELSE (0.78%"B3/12 -IF(B2-20%"BI,"0","(0.7896"B3/12) :F(B2-20%"B1,"(0.7896"B3)/12","0")

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

QUESTION 12 1 points Save Answer Which of the following is a disadvantage of credit cards? Card perks Emergency use Allows for online shopping The finance charge that accrues on the account if not...

QUESTION 37 Y The price elasticity of demand for a rental home in Luxury Resorts in the summer is 1.40 and is 2.60 in the spring. If Luxury Resorts faces a constant marginal cost of $600 per home...

QUESTION 7 0.21428 points Save Answer Which of the following events would cause the aggregate demand curve to shift to the right, indicating an increase in aggregate demand? Consumers become more...

QUESTION 29 3.44 points Save Answer The following table illustrates hypothetical values of CPI for 2007-2013. What does CPI (2005=100) suggest? Year CPI (2005=100) 2007 106 2008 109 2013 115 CPI...

value of the house 879,000 (A) House-Shopping (1 point) Go through the online housing ads for the Seattle area or for the area in which you live. Choose an ad for a house for sale that you would like...

QUESTION 1 1 points Save Answer 2.50 2.00- 1.50 Quantity 20 Refer to the market graph shown above. A black market where the price is $2.00 could result from a price ceiling set at $1.50 O floor set...

Please help. QUESTION 5 10 points Save Answer Nia is looking to place a $100 bet on the Warriors vs. Lakers game. The Warriors have a 40% chance of winning the game. If the Warriors win Nia will...

When buying a home, if your down payment is less than 20% of the home's sale price you have to pay private mortgate insurance (PMI). For this example, assume that the yearly fee for PMI is .78% of...

QUESTION 5 1 points Save Answer An underwriter has determined its exposure for a household insurance policy and the risk factors associated with it. In order to assess the risk over time, the...

Demonstrate the elements of leadership and differentiate clearly between management and leadership. Define the function of control and explain how he can use this function when doing staff...

Consider these transactions: (a) Espinosa Restaurant accepted a Visa card in payment of a $100 lunch bill. The bank charges a 3% fee. What entry should Espinosa make? (b) Guthrie Company sold its...

Why are banker s acceptances so popular for international transactions?

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Question Is split dollar a useful compensation technique for a partner, proprietor, or shareholder employee of an S corporation?

Question Since FSA salary reductions eliminate Social Security taxes on the salary reduction, are Social Security benefits also affected?

Question What are the implications of the IRS position that an employer must be at risk with respect to health benefits in an FSA?