How to Add PMI to a mortgage calculator if the down payment is less than 20%

[realestateexcel]

Hi,

I am looking for some help. I am looking to have PMI automatically generate in the red PMI location if the loan amount is less than 20%


I think I would use an If function for this but I have not used excel in this capacity for 10 years and I am a little rusty.

In theroy what I am looking to have written is.
( If the percent sign in CellA1 is more than 20% you return 0. If the percent in cellA1 is below 20% you return .085 X (Loan amount cell A2)

		Down Payment	First Mortgage		Total	Stabilized	Custom
Amount		$125,000	$375,000
%		25%	75%
Rate			4.50%
Amortization			30
Principal			$6,050		$6,050	$6,050	$6,050
Interest			$16,751		$16,751	$16,751	$16,751
Total Debit Services		$22,801
Monthly debit services		$1,900		$22,801	$22,801	$22,801
PMI			PMI
Cash Flow					-$22,801	-$22,801	-$22,801
Principal Reduction				$6,050	$6,050	$6,050
Total Return					($16,751)	($16,751)	($16,751)

<colgroup><col span="8"></colgroup><tbody>
</tbody>

 

[Nine Zero]

maybe something like this

=IF(A1>20%,0,A2*.85)