Question: Use an Excel formula to check if C2 cell is a 'FHA' Loan. Then execute the following steps: A B D E FHA ARM Loan

 Use an Excel formula to check if C2 cell is a

Use an Excel formula to check if C2 cell is a 'FHA' Loan. Then execute the following steps:

A B D E FHA ARM Loan Information Type of Loan: Home Value Enter Loan Amount Here: Term (years) Starting interest rate Current rate after fixed term f Extra Cost E= $210,527 UFMIP $200,000 Loan Amount + UFMIP 30 78% Equity 2.7500% 3.3750% $0.00 INSTRUCTIONS: Use an Excel formula to check if C2 cell is a 'FHA Loan. Then execute the following steps: In cell E3 - If the 'Type of Loan' = FHA, multiply the value in C4 by 0.0175, if not return 0. In cell E4 - If the 'Type of Loan' = FHA, multiply the value in C4 by 1.0175, if it is not an FHA Loan, then return the value in C4. In cell E5 - If the 'Type of Loan' = FHA, multiply the value in C3 by .78, if not return 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 Finance Questions!