This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: 12. Use the IF function to determine YES or NO as to whether or not you can afford the payment amount you calculated in C7:F7. If the payment amount is less than $800, YES should appear, if not NO should appear. 13. In C11:C22, calculate the % of the Total Loans for each month. (Hint: To calculate the % of Total Loans, divide the loan amount for the month by the total loans. For example, for January: B11/B23. Remember to use an absolute cell reference for B23.) 14. In D11:D22, use the IF function to perform the following calculation for each month. If the loan amount is greater than $100,000.00 then you should multiply the loan amount * 2%. If the loan amount if not greater than $100,000.00 then nothing should appear in the cell. 15. Align text appropriately, apply shading, apply borders, merge and center text as noted above....
View Full
Document
 Fall '09
 Crews

Click to edit the document details