performing what if analysis

i need help with this:
-in cell d3 enter a reference to the value in cell b7. format the cell to display the text string interest rate.

need help. i

Hi,

Can you please post a workbook that shows some sample data and what you are expecting as a result?

Kevin Webber is considering taking out a second mortgage for an addition on his home. He decides to use Excel to analyze several possibilities for the loan including the size of the loan, the interest rate, and the number of years required to pay back the loan. He wants your help in developing a two-variable data table and scenarios to examine how varying these factors affects the required monthly payment and the total cost of the loan. Complete the following
1. Open the Loan.xlxs workbook and save as Loan Table.xlxs.
2. In the Mortgage worksheet, define names for the values in the range B3:B8 based on the name values in the left column.
3. Enter Monthly Payment in cell D1. Enter Years in cell E2, and then merge and center the range E2:I2. Enter the values 10 through 30 in increments of 5 in the range E3:I3. Enter the values 4.5% through 6.0% in increments of 0.1% in the range D4:D19.
4. In cell D3, enter a reference to the value in cell B7. Format the cell to display the test string Interest Rate.
5. Create a two-variable data table in the range D3:I19 using cells B5 and B4 as the column and row input cells, respectively.
6. Format the resulting two-variable data table so that the result values appear as currency, and the row and column labels appear on a light yellow background. Add gridlines to the table.
7. Add scnearios to the worksheet to display all combinations of the loan assuming that the number of years required for payment is 30; the interest rate is 5.5%, 6% or 6.5%; and the amount of the loan is $200,000, $250,000 or $300,000. (HINT: THERE WILL BE NINE SCENARIOS)
8. Create a scenario summary report that displays the value of the monthly payment and total cost of the loan for each of the scenarios you created.
9. Format the scenario summary report that displays the value of the monthly payment and the total cost of the loan for each of the scenarios you created.
10. Save and close the workbook.

i'm stuck between step 4 and 5. i can't get the interest rate part. i know that we have to go to format cell--->custom, but all my #s are constant which is probably wrong.


thanks for your help!

mlew: thanks!!! you just scored me 7% assignment..