50.1K

Verified Solution

Link Copied!

The functions are to return TRUE do to a boolean function , not due to the word being TRUE.Please show your work. :)

Calculate "PMT OK?" (cell 112) using a Boolean formula that returns TRUE if the "PMT/Income" (cell E12) ratio is below 43%. Copy your formula down to complete the "PMT OK?" column. Calculate "Down OK?" (cell J12) using a boolean formula that returns TRUE if the "Down Payment" (cell F12) exceeds 10% of the "Loan Amount" (cell D12). Copy your formula down to complete the "Down OK?" column. Calculate "Score OK?" (cell K12) using the NOT function. Return TRUE if the Credit Score (cell C12) is not less than the Threshold Credit Score (cell F9). Copy your function down to complete the "Score OK?" column on the table. Be sure to appropriately use relative and absolute cell references. Calculate "Approved?" (cell L12) using the AND function. Return TRUE if "PMT OK?" (cell 112), "Down OK?" (cell J12), and "Score OK?" (cell K12) all evaluate as TRUE (notice there are no quotes around the word TRUE since it is a Boolean result and not text). Copy your function down to complete the "Approved?" column. Calculate "Discount?" (cell M12) using the OR function. Return TRUE if either "Savings Account?" (cell G12) or "AutoPay?" (cell H12) are listed as "YES". Copy your function down to complete the "Discount?" column. 2 3 4 5 6 7 8 Happy Homes Credit Union specializes in providing mortgage loans. The table below details information about a number of recent loan applications. The table lists the social security number and credit score of each applicant. It also details the amount of the loan requested, the ratio of the projected mortgage payment to the applicant's annual income, and the down payment the applicant plans to make on the loan. There are three criteria that must be satisfied for a loan to be approved. First, the projected monthly mortgage amount must be less than 43% of the applicant's monthly gross income. Second, the down payment amount must be 10% or more (at least 10%) of the loan amount. Finally, the applicant's credit score cannot be below a threshold level. Happy Homes offers a discounted interest rate to any customer who has a savings account with the credit union or is willing to have their mortgage payment paid automatically every month. The table lists whether the applicant currently has a savings account with the credit union or if they are willing to have the payment automatically deducted each month. Complete the "PMT OK?", "Down OK?", "Score OK?", "Approved?", and "Discount?" columns to determine if each loan application is approved and if the applicant qualifies for a discounted interest rate. 9 9 10 11 12 13 14 15 16 17 18 Applicant Credit Score 108-95-6833 658 427 78-9221 693 663-30-1549 689 965-75-9201 697 954 32 4100 718 950-50-7544 581 399-33-4698 704 486-66-2868 662 627-90-4115 567 444-96-4839 642 448-91-9215 633 829-61-8895 600 851-82-2783 697 318-52-7960 659 710 21 6006 620 Roolean Functions Loan Amount PMT/Income Down Payment Savings Account AutoPay? PMT OK? Down OK? Score OK? Approved? Discount? $337,000 37% $47,000 YES NO $256,300 43% $25,000 NO NO $392,700 37% $43,000 NO YES $278,600 43% $27,000 YES YES $347,100 37% $45,000 YES NO $297,900 35% $14,000 NO YES $281,700 36% $30,000 YES NO $369,700 38% $36,000 NO YES $302,600 41% $51,000 YES YES $212,200 37% $14,000 YES NO $237,700 40% $45,000 NO NO $244,600 39% $39,000 YES YES $390,900 39% $43,000 NO NO $330,700 39% $52,000 YES YES C260 700 1304 SA2000 NO 19 20 21 22 23 24 25 06 VES A K M 662 567 642 G NO YES YES NO H YES YES 633 600 697 659 638 NO NO YES NO YES NO NO 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 10 41 NO B 486 66 2868 627-90-4115 444-96 4839 448-91-9215 829-61-8895 851-82-2783 318-52-7960 718-31-6886 863-21-8561 516-14-4871 114-94-8347 325-95-5596 696-14-9890 292-25-3863 600-68-2551 169-92-2691 586-35-2423 263-76-3025 647-28-9552 740-99 2570 346-45 9618 114 80 5364 713-78-4199 636 714 635 730 730 715 595 676 601 676 D D $369,700 $302,600 $212,200 $237,700 $244,600 $390,900 $330,700 $269,700 $284,800 $384,200 $364,500 $224,100 $195,100 $217,500 $279,100 $307,200 $236,500 $340,400 $222,900 $368,000 $195,700 $400,300 $421,700 E 38% 41% 37% 40% 39% 39% 39% 42% 38% 38% 43% 40% 42% 38% 35% 38% 35% 39% 39% 35% 36% 38% 43% $36,000 $51,000 $14,000 $45,000 $39,000 $43,000 $52,000 $43,000 $31,000 $65,000 $21,000 $29,000 $13,000 $41,000 $27,000 $36,000 $37,000 $44,000 $37,000 $55,000 $25,000 $24,000 $29,000 YES NO YES YES YES NO NO YES YES NO NO YES YES NO NO NO YES NO NO 683 716 690 593 734 YES YES YES NO YES YES YLS YES YES YES YES YES NO Calculate "PMT OK?" (cell 112) using a Boolean formula that returns TRUE if the "PMT/Income" (cell E12) ratio is below 43%. Copy your formula down to complete the "PMT OK?" column. Calculate "Down OK?" (cell J12) using a boolean formula that returns TRUE if the "Down Payment" (cell F12) exceeds 10% of the "Loan Amount" (cell D12). Copy your formula down to complete the "Down OK?" column. Calculate "Score OK?" (cell K12) using the NOT function. Return TRUE if the Credit Score (cell C12) is not less than the Threshold Credit Score (cell F9). Copy your function down to complete the "Score OK?" column on the table. Be sure to appropriately use relative and absolute cell references. Calculate "Approved?" (cell L12) using the AND function. Return TRUE if "PMT OK?" (cell 112), "Down OK?" (cell J12), and "Score OK?" (cell K12) all evaluate as TRUE (notice there are no quotes around the word TRUE since it is a Boolean result and not text). Copy your function down to complete the "Approved?" column. Calculate "Discount?" (cell M12) using the OR function. Return TRUE if either "Savings Account?" (cell G12) or "AutoPay?" (cell H12) are listed as "YES". Copy your function down to complete the "Discount?" column. 2 3 4 5 6 7 8 Happy Homes Credit Union specializes in providing mortgage loans. The table below details information about a number of recent loan applications. The table lists the social security number and credit score of each applicant. It also details the amount of the loan requested, the ratio of the projected mortgage payment to the applicant's annual income, and the down payment the applicant plans to make on the loan. There are three criteria that must be satisfied for a loan to be approved. First, the projected monthly mortgage amount must be less than 43% of the applicant's monthly gross income. Second, the down payment amount must be 10% or more (at least 10%) of the loan amount. Finally, the applicant's credit score cannot be below a threshold level. Happy Homes offers a discounted interest rate to any customer who has a savings account with the credit union or is willing to have their mortgage payment paid automatically every month. The table lists whether the applicant currently has a savings account with the credit union or if they are willing to have the payment automatically deducted each month. Complete the "PMT OK?", "Down OK?", "Score OK?", "Approved?", and "Discount?" columns to determine if each loan application is approved and if the applicant qualifies for a discounted interest rate. 9 9 10 11 12 13 14 15 16 17 18 Applicant Credit Score 108-95-6833 658 427 78-9221 693 663-30-1549 689 965-75-9201 697 954 32 4100 718 950-50-7544 581 399-33-4698 704 486-66-2868 662 627-90-4115 567 444-96-4839 642 448-91-9215 633 829-61-8895 600 851-82-2783 697 318-52-7960 659 710 21 6006 620 Roolean Functions Loan Amount PMT/Income Down Payment Savings Account AutoPay? PMT OK? Down OK? Score OK? Approved? Discount? $337,000 37% $47,000 YES NO $256,300 43% $25,000 NO NO $392,700 37% $43,000 NO YES $278,600 43% $27,000 YES YES $347,100 37% $45,000 YES NO $297,900 35% $14,000 NO YES $281,700 36% $30,000 YES NO $369,700 38% $36,000 NO YES $302,600 41% $51,000 YES YES $212,200 37% $14,000 YES NO $237,700 40% $45,000 NO NO $244,600 39% $39,000 YES YES $390,900 39% $43,000 NO NO $330,700 39% $52,000 YES YES C260 700 1304 SA2000 NO 19 20 21 22 23 24 25 06 VES A K M 662 567 642 G NO YES YES NO H YES YES 633 600 697 659 638 NO NO YES NO YES NO NO 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 10 41 NO B 486 66 2868 627-90-4115 444-96 4839 448-91-9215 829-61-8895 851-82-2783 318-52-7960 718-31-6886 863-21-8561 516-14-4871 114-94-8347 325-95-5596 696-14-9890 292-25-3863 600-68-2551 169-92-2691 586-35-2423 263-76-3025 647-28-9552 740-99 2570 346-45 9618 114 80 5364 713-78-4199 636 714 635 730 730 715 595 676 601 676 D D $369,700 $302,600 $212,200 $237,700 $244,600 $390,900 $330,700 $269,700 $284,800 $384,200 $364,500 $224,100 $195,100 $217,500 $279,100 $307,200 $236,500 $340,400 $222,900 $368,000 $195,700 $400,300 $421,700 E 38% 41% 37% 40% 39% 39% 39% 42% 38% 38% 43% 40% 42% 38% 35% 38% 35% 39% 39% 35% 36% 38% 43% $36,000 $51,000 $14,000 $45,000 $39,000 $43,000 $52,000 $43,000 $31,000 $65,000 $21,000 $29,000 $13,000 $41,000 $27,000 $36,000 $37,000 $44,000 $37,000 $55,000 $25,000 $24,000 $29,000 YES NO YES YES YES NO NO YES YES NO NO YES YES NO NO NO YES NO NO 683 716 690 593 734 YES YES YES NO YES YES YLS YES YES YES YES YES NO

Answer & Explanation Solved by verified expert

See Answer