realestateexcel
New Member
- Joined
- Apr 25, 2017
- Messages
- 3
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)
<colgroup><col span="8"></colgroup><tbody>
</tbody>
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>