Need Help with Homework Assignment ASAP PLEASE!

robw13 · Oct 20, 2009

Hi,

Can anyone help me out with my Excel Homework Assignment asap Please? I don't get how to input the Formulas in the tables cause there's quite a few. Any help Very Much Appreciated....

Sorry to be Trouble...

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style>****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style> [FONT=&quot]Objectives: <o></o>[/FONT]

[FONT=&quot]Be introduced to the following Excel functions by creating a simple Loan Application Expert System:<o></o>[/FONT]

-[FONT=&quot] [/FONT][FONT=&quot]The IF function <o

></o

>[/FONT]
-[FONT=&quot] [/FONT][FONT=&quot]Both the vertical (VLOOKUP) and the horizontal lookup (HLOOKUP) function<o

></o

>[/FONT]
-[FONT=&quot] [/FONT][FONT=&quot]The PMT (Payment Function) to show the amount of a monthly payment based on the interest rate, loan amount, and length of the loan. <o

></o

>[/FONT]
-[FONT=&quot] [/FONT][FONT=&quot]A one-variable Data Table to show the monthly payment for different interest rates<o

></o

>[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Loan Application Rule:<o></o>[/FONT]
[FONT=&quot]If the applicant’s total number of points is equal to or exceeds 60, grant the loan. <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Eligibility is determined by the number of points the applicant accumulates in several risk categories, based on the following. <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Risk Category[/FONT][FONT=&quot] Points<o></o>[/FONT]
[FONT=&quot]<o> </o>[/FONT]
[FONT=&quot]Age<o></o>[/FONT]
[FONT=&quot]20 <= age < 25 0 <o

></o

>[/FONT]
[FONT=&quot]25 <= age < 60 10<o

></o

>[/FONT]
[FONT=&quot]60 <= age 2<o

></o

>[/FONT]
[FONT=&quot]The Age points must be calculated by entering an IF function.[/FONT]

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style> [FONT=&quot]Income (annual $) per household member:<o></o>[/FONT]
[FONT=&quot]income < 20,000 0<o

></o

>[/FONT]
[FONT=&quot]20,000 <= income < 40,000 10<o

></o

>[/FONT]
[FONT=&quot]40,000 <= income < 55,000 20<o

></o

>[/FONT]
[FONT=&quot]55,000 <= income < 75,000 30<o

></o

>[/FONT]
[FONT=&quot]75,000 <= income 40 <o

></o

>[/FONT]
[FONT=&quot]The Income points must be calculated by entering a VLOOKUP function.[/FONT][FONT=&quot]<o

></o

>[/FONT]

[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Employment at current workplace:[/FONT][FONT=&quot] (Use an IF function)<o></o>[/FONT]
[FONT=&quot]self-employed 15<o

></o

>[/FONT]
[FONT=&quot]less than 2 years 0<o

></o

>[/FONT]
[FONT=&quot]2 years or more 15<o

></o

>[/FONT]
[FONT=&quot]<o> </o>[/FONT]
[FONT=&quot]
[/FONT] [FONT=&quot]Net Worth<o></o>[/FONT]
[FONT=&quot]Net Worth < 35,000 0<o

></o

>[/FONT]
[FONT=&quot]35,000 <= Net Worth < 75,000 10<o

></o

>[/FONT]
[FONT=&quot]75,000 <= Net Worth < 100,000 20<o

></o

>[/FONT]
[FONT=&quot]Net Worth >= 100,000 30<o

></o

>[/FONT]
[FONT=&quot]The Net Worth points must be calculated by entering a HLOOKUP function.<o></o>[/FONT]

[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Loan Size[/FONT][FONT=&quot] (Excel Formula to calculate Loan Size deduction)<o></o>[/FONT]
[FONT=&quot]No points are deducted for a $10,000 loan. Henceforth, 2 points are deducted from the total score for each additional $10,000 of the requested loan. <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Loan Life[/FONT][FONT=&quot] (Excel Formula to calculate Loan Life deduction)<o></o>[/FONT]
[FONT=&quot]No points are deducted for the first 5 years of the loan’s life (years to repay the loan). Henceforth, 1 point is deducted for every 5 years. <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Note: The Loan Size or Loan Life formulas must work for ALL situations. This formula should be a simple IF (not nested) and a mathematical calculation.[/FONT]

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style> [FONT=&quot]Hint:<o></o>[/FONT]
[FONT=&quot]1.[FONT=&quot] [/FONT][/FONT][FONT=&quot]In the upper left portion of the worksheet, enter your name, section number, and assignment number.<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]2.[FONT=&quot] [/FONT][/FONT][FONT=&quot]Enter the following labels: (it does not matter where on the worksheet). The italicized phrase states whether you will input a value or a formula in the cell. Cells requiring formulas are also shaded.<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]

<table class="MsoNormalTable" style="border: medium none ; width: 389.95pt; margin-left: 4.65pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="520"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]Name, Section xxx<o

></o

>[/FONT]
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> <o> </o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> <o> </o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]Assignment 3<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> <o> </o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> <o> </o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> <o> </o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> <o> </o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]Loan Application<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> <o> </o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> <o> </o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> <o> </o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> <o> </o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]Value<o></o>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]Points<o></o>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> <o> </o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> <o> </o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]Age<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]Input <o></o>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; background: rgb(191, 191, 191) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]formula<o></o>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> --------<o></o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> IF function<o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]Income<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]Input[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; background: rgb(191, 191, 191) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]formula[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> --------<o></o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> VLOOKUP function<o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]Employment<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]Input[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; background: rgb(191, 191, 191) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]formula[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> --------<o></o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> IF function<o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]Net worth<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]Input[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; background: rgb(191, 191, 191) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]formula[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> --------<o></o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> HLOOKUP function<o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]Total<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; background: rgb(191, 191, 191) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]formula [/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> --------<o></o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> SUM function<o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]Adjustments<o></o>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> <o> </o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> <o> </o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]Loan Size<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]Input[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; background: rgb(191, 191, 191) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot] formula[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> --------<o></o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> Formula<o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]Loan Life<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]Input[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; background: rgb(191, 191, 191) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]formula[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> --------<o></o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> Formula <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 101.95pt; height: 12.75pt;" width="136" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 61.05pt; height: 12.75pt;" width="81" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> <o> </o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> <o> </o>
</td> </tr> <tr style="height: 12.75pt;"> <td colspan="2" style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 163pt; height: 12.75pt;" width="217" nowrap="nowrap" valign="bottom"> [FONT=&quot]Total Adjusted Points<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; background: rgb(191, 191, 191) none repeat scroll 0% 0%; width: 48pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]formula[/FONT][FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 37.45pt; height: 12.75pt;" width="50" valign="top"> --------<o></o>
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 141.5pt; height: 12.75pt;" width="189" valign="top"> Formula<o></o>
</td> </tr> </tbody></table>

[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]3.[FONT=&quot] [/FONT][/FONT][FONT=&quot]Add the following tables to your spreadsheet. Again, it does not matter where on the spreadsheet these are entered: <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]

<table class="MsoNormalTable" style="border: medium none ; width: 133.65pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="178"> <tbody><tr style="height: 12.75pt;"> <td colspan="2" style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 133.65pt; height: 12.75pt;" width="178" nowrap="nowrap" valign="top"> [FONT=&quot]Income Table[/FONT][FONT=&quot]<o></o>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 85.2pt; height: 12.75pt;" width="114" nowrap="nowrap" valign="top"> [FONT=&quot]0<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48.45pt; height: 12.75pt;" width="65" nowrap="nowrap" valign="top"> [FONT=&quot]0<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 85.2pt; height: 12.75pt;" width="114" nowrap="nowrap" valign="top"> [FONT=&quot]20000<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48.45pt; height: 12.75pt;" width="65" nowrap="nowrap" valign="top"> [FONT=&quot]10<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 85.2pt; height: 12.75pt;" width="114" nowrap="nowrap" valign="top"> [FONT=&quot]40000<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48.45pt; height: 12.75pt;" width="65" nowrap="nowrap" valign="top"> [FONT=&quot]20<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 85.2pt; height: 12.75pt;" width="114" nowrap="nowrap" valign="top"> [FONT=&quot]55000<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48.45pt; height: 12.75pt;" width="65" nowrap="nowrap" valign="top"> [FONT=&quot]30<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 85.2pt; height: 12.75pt;" width="114" nowrap="nowrap" valign="top"> [FONT=&quot]75000<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48.45pt; height: 12.75pt;" width="65" nowrap="nowrap" valign="top"> [FONT=&quot]40<o

></o

>[/FONT]
</td> </tr> </tbody></table>

[FONT=&quot]<o

> </o

>[/FONT]

<table class="MsoNormalTable" style="border: medium none ; width: 192pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="256"> <tbody><tr style="height: 12.75pt;"> <td colspan="2" style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 96pt; height: 12.75pt;" width="128" nowrap="nowrap" valign="top"> [FONT=&quot]Net Worth<o></o>[/FONT]
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="top"> [FONT=&quot] <o

></o

>[/FONT]
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="top"> [FONT=&quot] <o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 18.7pt; height: 12.75pt;" width="25" nowrap="nowrap" valign="top"> [FONT=&quot]0<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 77.3pt; height: 12.75pt;" width="103" nowrap="nowrap" valign="top"> [FONT=&quot]35000<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="top"> [FONT=&quot]75000<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="top"> [FONT=&quot]100000<o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 18.7pt; height: 12.75pt;" width="25" nowrap="nowrap" valign="top"> [FONT=&quot]0<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 77.3pt; height: 12.75pt;" width="103" nowrap="nowrap" valign="top"> [FONT=&quot]10<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="top"> [FONT=&quot]20<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="top"> [FONT=&quot]30<o

></o

>[/FONT]
</td> </tr> </tbody></table>

[FONT=&quot]<o

> </o

>[/FONT]
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="Edit-Time-Data" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_editdata.mso"><link rel="themeData" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Crob13%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style> [FONT=&quot]1.[FONT=&quot] [/FONT][/FONT][FONT=&quot]After completing the labels and tables, the spreadsheet should look similar to the following: (not necessarily same columns and rows)<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]

[FONT=&quot]<!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o

referrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"/> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"/> <v:f eqn="sum @0 1 0"/> <v:f eqn="sum 0 0 @1"/> <v:f eqn="prod @2 1 2"/> <v:f eqn="prod @3 21600 pixelWidth"/> <v:f eqn="prod @3 21600 pixelHeight"/> <v:f eqn="sum @0 0 1"/> <v:f eqn="prod @6 1 2"/> <v:f eqn="prod @7 21600 pixelWidth"/> <v:f eqn="sum @8 21600 0"/> <v:f eqn="prod @7 21600 pixelHeight"/> <v:f eqn="sum @10 21600 0"/> </v:formulas> <v

ath o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/> <o:lock v:ext="edit" aspectratio="t"/> </v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:350.25pt; height:224.25pt'> <v:imagedata src="file:///C:\Users\rob13\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png" o:title="" cropbottom="25610f" cropright="18800f"/> </v:shape><![endif]-->

<o

></o

>[/FONT]

[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]2.[FONT=&quot] [/FONT][/FONT][FONT=&quot]Enter the correct formulas to calculate the points for each risk category (see formula hints section below). You can then test your calculations by entering values for the test applicants (provided below) and viewing the loan point calculation. <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]3.[FONT=&quot] [/FONT][/FONT][FONT=&quot]Spreadsheet with loan applicant information entered:<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]

[FONT=&quot]

<o

></o

>[/FONT]

[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Test Data:<o></o>[/FONT]
[FONT=&quot]Use the following test data to verify your formulas and calculations: (this data is what I will use to test your submitted worksheet). You will enter only the applicant information. The spreadsheet should calculate the points and whether to accept or decline the loan application. You will have only one worksheet and one place to enter the application data. When an applicant enters your office, you simply enter the information and have Excel do the calculations to determine if an applicant is eligible.<o

></o

>[/FONT]
[FONT=&quot]<o> </o>[/FONT]
[FONT=&quot]Applicant Test Data:<o

></o

>[/FONT]
[FONT=&quot]1.[FONT=&quot] [/FONT][/FONT][FONT=&quot]Applicant One: 21 years of age, income of $30,000, has been employed at current workplace for 3 years, and has a net worth of $35,000. This applicant is applying for a 15 year $30,000 loan. (Should calculate to 29 points and be declined)<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]2.[FONT=&quot] [/FONT][/FONT][FONT=&quot]Applicant Two: 45 years of age, income of $77,000, has been employed at current workplace for 10 years, and has a net worth of $76,000. This applicant is applying for a 15 year $100,000 loan. (Should calculate to 65 points and be granted)<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]3.[FONT=&quot] [/FONT][/FONT][FONT=&quot]Applicant Three: 62 years of age, income of $86,000, is not employed, and has a net worth of $100,000. This applicant is applying for a 10 year $40,000 loan. (Should calculate to 65 points and be granted)<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]

[FONT=&quot]<o

> </o

>[/FONT]

[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]PART B: Create a one-variable Data Table to show the monthly payments for various interest rates. <o></o>[/FONT]
[FONT=&quot]<o> </o>[/FONT]
[FONT=&quot]On the same worksheet, under the eligibility calculations we are going to add a one-variable Data Table to show the monthly payments at different interest rates for the loan requested. <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Data Tables are part of the “What-if” analysis tools in Excel. We can alter an input value in our formula to see different results. We are going to use the PMT function to determine the monthly payment for a loan and then create a one-variable data table to show monthly payments calculated for different interest rates. <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Enter the following data a few rows down from where you finished the eligibility portion of the sheet. <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]

<table class="MsoNormalTable" style="border: medium none ; width: 432.75pt; margin-left: 4.65pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="577"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 78pt; height: 12.75pt;" width="104" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 86.1pt; height: 12.75pt;" width="115" nowrap="nowrap" valign="bottom"> [FONT=&quot]Payments<o

></o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 172.65pt; height: 12.75pt;" width="230" valign="top"> [FONT=&quot]<o

> </o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 78pt; height: 12.75pt;" width="104" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; background: rgb(255, 255, 153) none repeat scroll 0% 0%; width: 86.1pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="115" nowrap="nowrap" valign="bottom">

[FONT=&quot]<o

> </o

>[/FONT]

</td> <td style="border: medium none ; padding: 0in 5.4pt; background: rgb(255, 255, 153) none repeat scroll 0% 0%; width: 172.65pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 12.75pt;" width="230" valign="top"> ß Enter the PMT function formula here<o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 78pt; height: 12.75pt;" width="104" nowrap="nowrap" valign="bottom"> [FONT=&quot] Interest<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom">

[FONT=&quot]5.25%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom">

[FONT=&quot]5.25%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 86.1pt; height: 12.75pt;" width="115" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 172.65pt; height: 12.75pt;" width="230" valign="top"> [FONT=&quot]<o

> </o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 78pt; height: 12.75pt;" width="104" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom">

[FONT=&quot]5.50%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 86.1pt; height: 12.75pt;" width="115" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 172.65pt; height: 12.75pt;" width="230" valign="top"> [FONT=&quot]<o

> </o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 78pt; height: 12.75pt;" width="104" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom">

[FONT=&quot]5.75%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 86.1pt; height: 12.75pt;" width="115" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 172.65pt; height: 12.75pt;" width="230" valign="top"> [FONT=&quot]<o

> </o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 78pt; height: 12.75pt;" width="104" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom">

[FONT=&quot]6.00%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 86.1pt; height: 12.75pt;" width="115" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 172.65pt; height: 12.75pt;" width="230" valign="top"> [FONT=&quot]<o

> </o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 78pt; height: 12.75pt;" width="104" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom">

[FONT=&quot]6.25%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 86.1pt; height: 12.75pt;" width="115" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 172.65pt; height: 12.75pt;" width="230" valign="top"> [FONT=&quot]<o

> </o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 78pt; height: 12.75pt;" width="104" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom">

[FONT=&quot]6.50%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 86.1pt; height: 12.75pt;" width="115" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 172.65pt; height: 12.75pt;" width="230" valign="top"> [FONT=&quot]<o

> </o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 78pt; height: 12.75pt;" width="104" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom">

[FONT=&quot]6.75%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 86.1pt; height: 12.75pt;" width="115" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 172.65pt; height: 12.75pt;" width="230" valign="top"> [FONT=&quot]<o

> </o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 78pt; height: 12.75pt;" width="104" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom">

[FONT=&quot]7.00%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 86.1pt; height: 12.75pt;" width="115" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 172.65pt; height: 12.75pt;" width="230" valign="top"> [FONT=&quot]<o

> </o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 78pt; height: 12.75pt;" width="104" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom">

[FONT=&quot]7.25%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 86.1pt; height: 12.75pt;" width="115" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 172.65pt; height: 12.75pt;" width="230" valign="top"> [FONT=&quot]<o

> </o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 78pt; height: 12.75pt;" width="104" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48pt; height: 12.75pt;" width="64" nowrap="nowrap" valign="bottom">

[FONT=&quot]7.50%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 86.1pt; height: 12.75pt;" width="115" nowrap="nowrap" valign="bottom"> [FONT=&quot]<o

> </o

>[/FONT]
</td> <td style="border: medium none ; padding: 0in 5.4pt; width: 172.65pt; height: 12.75pt;" width="230" valign="top"> [FONT=&quot]<o

> </o

>[/FONT]
</td> </tr> </tbody></table>

[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]In the blank cell below the Payments label, enter the PMT function to calculate the monthly payment for the requested loan. Remember to convert the interest rate to a monthly interest rate, and convert the loan life years to monthly payments. <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot] =PMT([/FONT][FONT=&quot]rate, nper, -pv)<o></o>[/FONT]
[FONT=&quot] [/FONT][FONT=&quot]<o

></o

>[/FONT]
[FONT=&quot]Refer to the Hints section below if you are not familiar with the payment formula. Use cell addresses rather than values for the arguments. For example, use B10 rather than 75,000 in the formula. These cell addresses should refer back to the cell addresses that hold the Loan Size value and the Loan Life value. <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Now, we want to create the data table to calculate the monthly payment for the interest rates in the column. Refer to the Hints section below to see how to create a one-variable Data Table.<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Once completed, the data table will look similar to this, the payment amounts are based on the loan amount and the loan life. This data table represents a Loan Size of $75,000 and a Loan Life of 10 years. The Payment column values are calculated by Excel using the Data Table function, these values are NOT input! Refer to the notes below for creating a one-variable Data Table. These payment calculations must be determined by a the Data Table, not by entering a PMT function in each cell. <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]

<table class="MsoNormalTable" style="border: medium none ; width: 274.9pt; border-collapse: collapse;" border="1" cellpadding="0" cellspacing="0" width="367"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 72.4pt; height: 12.75pt;" width="97" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 0.75in; height: 12.75pt;" width="72" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 1in; height: 12.75pt;" width="96" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 76.5pt; height: 12.75pt;" width="102" nowrap="nowrap" valign="bottom"> <!--[if gte vml 1]><v:shapetype id="_x0000_t202" coordsize="21600,21600" o:spt="202" path="m,l,21600r21600,l21600,xe"> <v:stroke joinstyle="miter"/> <v

ath gradientshapeok="t" o:connecttype="rect"/> </v:shapetype><v:shape id="_x0000_s1027" type="#_x0000_t202" style='position:absolute; margin-left:103.2pt;margin-top:4.1pt;width:115.2pt;height:38.3pt;z-index:-2; mso-position-horizontal-relative:text;mso-position-vertical-relative:text; mso-width-relative:margin;mso-height-relative:margin' wrapcoords="-83 -460 -83 21140 21683 21140 21683 -460 -83 -460"> <v:textbox style='mso-next-textbox:#_x0000_s1027'/> </v:shape><![endif]--> <table cellpadding="0" cellspacing="0"> <tbody><tr> <td style="border: 0.75pt solid black; background: white none repeat scroll 0% 0%; vertical-align: top; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous;" bgcolor="white" width="159" height="58"> <table cellpadding="0" cellspacing="0" width="100%"> <tbody><tr> <td> [FONT=&quot]These cells will make-up the Data Table<o

></o

>[/FONT]

</td> </tr> </tbody></table>  </td> </tr> </tbody></table> [FONT=&quot]Payment<o></o>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 72.4pt; height: 12.75pt;" width="97" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 0.75in; height: 12.75pt;" width="72" nowrap="nowrap" valign="bottom">

[FONT=&quot]<o

></o

>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1in; height: 12.75pt;" width="96" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 76.5pt; height: 12.75pt;" width="102" nowrap="nowrap" valign="bottom"> <!--[if gte vml 1]><v:shapetype id="_x0000_t32" coordsize="21600,21600" o:spt="32" o

ned="t" path="m,l21600,21600e" filled="f"> <v

ath arrowok="t" fillok="f" o:connecttype="none"/> <o:lock v:ext="edit" shapetype="t"/> </v:shapetype><v:shape id="_x0000_s1028" type="#_x0000_t32" style='position:absolute; margin-left:78.4pt;margin-top:10pt;width:24.8pt;height:11.25pt;flip:x; z-index:3;mso-position-horizontal-relative:text; mso-position-vertical-relative:text' o:connectortype="straight"> <v:stroke endarrow="block"/> </v:shape><![endif]-->

[FONT=&quot] $ 804.69 <o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 72.4pt; height: 12.75pt;" width="97" nowrap="nowrap" valign="bottom"> [FONT=&quot]Interest<o></o>[/FONT]
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 0.75in; height: 12.75pt;" width="72" nowrap="nowrap" valign="bottom">

[FONT=&quot]5.25%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1in; height: 12.75pt;" width="96" nowrap="nowrap" valign="bottom">

[FONT=&quot]5.25%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 76.5pt; height: 12.75pt;" width="102" nowrap="nowrap" valign="bottom"> [FONT=&quot] $ 804.69 <o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 72.4pt; height: 12.75pt;" width="97" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 0.75in; height: 12.75pt;" width="72" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1in; height: 12.75pt;" width="96" nowrap="nowrap" valign="bottom">

[FONT=&quot]5.50%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 76.5pt; height: 12.75pt;" width="102" nowrap="nowrap" valign="bottom"> [FONT=&quot] $ 813.95 <o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 72.4pt; height: 12.75pt;" width="97" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 0.75in; height: 12.75pt;" width="72" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1in; height: 12.75pt;" width="96" nowrap="nowrap" valign="bottom">

[FONT=&quot]5.75%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 76.5pt; height: 12.75pt;" width="102" nowrap="nowrap" valign="bottom"> [FONT=&quot] $ 823.27 <o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 72.4pt; height: 12.75pt;" width="97" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 0.75in; height: 12.75pt;" width="72" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1in; height: 12.75pt;" width="96" nowrap="nowrap" valign="bottom">

[FONT=&quot]6.00%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 76.5pt; height: 12.75pt;" width="102" nowrap="nowrap" valign="bottom"> [FONT=&quot] $ 832.65 <o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 72.4pt; height: 12.75pt;" width="97" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 0.75in; height: 12.75pt;" width="72" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1in; height: 12.75pt;" width="96" nowrap="nowrap" valign="bottom">

[FONT=&quot]6.25%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 76.5pt; height: 12.75pt;" width="102" nowrap="nowrap" valign="bottom"> [FONT=&quot] $ 842.10 <o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 72.4pt; height: 12.75pt;" width="97" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 0.75in; height: 12.75pt;" width="72" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1in; height: 12.75pt;" width="96" nowrap="nowrap" valign="bottom">

[FONT=&quot]6.50%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 76.5pt; height: 12.75pt;" width="102" nowrap="nowrap" valign="bottom"> [FONT=&quot] $ 851.61 <o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 72.4pt; height: 12.75pt;" width="97" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 0.75in; height: 12.75pt;" width="72" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1in; height: 12.75pt;" width="96" nowrap="nowrap" valign="bottom">

[FONT=&quot]6.75%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 76.5pt; height: 12.75pt;" width="102" nowrap="nowrap" valign="bottom"> [FONT=&quot] $ 861.18 <o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 72.4pt; height: 12.75pt;" width="97" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 0.75in; height: 12.75pt;" width="72" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1in; height: 12.75pt;" width="96" nowrap="nowrap" valign="bottom">

[FONT=&quot]7.00%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 76.5pt; height: 12.75pt;" width="102" nowrap="nowrap" valign="bottom"> [FONT=&quot] $ 870.81 <o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 72.4pt; height: 12.75pt;" width="97" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 0.75in; height: 12.75pt;" width="72" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1in; height: 12.75pt;" width="96" nowrap="nowrap" valign="bottom">

[FONT=&quot]7.25%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 76.5pt; height: 12.75pt;" width="102" nowrap="nowrap" valign="bottom"> [FONT=&quot] $ 880.51 <o

></o

>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 72.4pt; height: 12.75pt;" width="97" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 0.75in; height: 12.75pt;" width="72" nowrap="nowrap" valign="bottom">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 1in; height: 12.75pt;" width="96" nowrap="nowrap" valign="bottom">

[FONT=&quot]7.50%<o

></o

>[/FONT]

</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 76.5pt; height: 12.75pt;" width="102" nowrap="nowrap" valign="bottom"> [FONT=&quot] $ 890.26 <o

></o

>[/FONT]
</td> </tr> </tbody></table>

[FONT=&quot] <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Re-enter the test data to see how the payments change based on the loan size and loan life. You need to only enter the applicant information.<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Example spreadsheet with loan application and one-variable Data Table calculations:<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]

[FONT=&quot]

<o></o>[/FONT]

tusharm · Oct 21, 2009

(1) You may want to take another look at your original post. It requires some cleanup.

(2) What have you done so far and where are you stuck?

robw13 · Oct 21, 2009

I need help with the formulas. I don't understand how use them with the homework, it's kinda confusing.

Sal Paradise · Oct 21, 2009

If you explain what you have, and where you're having trouble, then people can help. If you show us what you've done (use an HTML maker like the one in my signature), it will help us know what ranges to use and how you're doing.

If, on the other hand, you've done nothing and just want the answer, that doesn't make me so anxious to help.

Need Help with Homework Assignment ASAP PLEASE!

robw13

New Member

Excel Facts

tusharm

MrExcel MVP

robw13

New Member

Sal Paradise

Well-known Member

Similar threads

Forum statistics

Share this page

Need Help with Homework Assignment ASAP PLEASE!

robw13

New Member

Excel Facts

tusharm

MrExcel MVP

robw13

New Member

Sal Paradise

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock