Post a New Question

Math/Excel

posted by .

I'm not sure what two excel functions to use that will give the correct answer and how to copy the information to each cell and the values stay the same.
2. A home loan is to be repaid by a series of equal monthly payments over many years. Prepare a worksheet to calculate the total of the interest paid over the duration of the repayment, using one or more Excel functions. Your results should be in the form of a two-dimensional table, with each yearly interest rate of 3.0%, 3.5%, 4.0%, 4.5%, and 5.0% shown in a separate row, and each loan payoff time of 15, 20, 25, and 30 years shown in a separate column. The total interest payment calculated in each table cell should correspond to the interest rate at the left of the row and the payoff time at the top of the column. The home loan amount of $150,000 should be located in a cell outside of the table that is referenced by the table formulas. The table formulas should make correct use of relative and absolute addresses so that copying any table cell to the entire table gives correct formulas in every cell. NOTE: For an interest rate of 4.0% and a payoff time of 20 years, the total interest payment is $68,152.92 (negative of the value given by the Excel functions), assuming each payment is made at the end of the month.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. BCIS

    You need to use the help section in your Excel program (press the F1 key and then use the search feature). If you need additional information about Excel, you can use your textbook or go to http://support.microsoft.com/search/, select …
  2. managerial economics

    my cubic equation is O=C+aL+bL^2+cL3 how can i get the excel to help me to do this equation.I need to do a regression analysis to estimate the firm's short-run production function. see tarha question dated july 2,2007 for all of the …
  3. math using excel

    how do i use excel to plot a graph then find x from the slope of a line?
  4. Excel

    The use of excel Excel is a very necessary tool for all businesses in today's job market. Excel makes it easy to organize, calculate, analyze and chart data. It can be used for both simple and concrete projects. Excels spreadsheets …
  5. MS Office Suite

    I am familiar with Excel 2007. I just got the news that I will be expected to use Excel 2010 instead. What are some of the differences between Excel 2007 and 2010?
  6. Excel & Math

    I'm not sure what two excel functions to use that will give the correct answer and how to copy the information to each cell and the values stay the same. 2. A home loan is to be repaid by a series of equal monthly payments over many …
  7. Excel formula help

    Formula to multiply the number in cell 4k times standard deviation of the numbers in cell z2 through z10 I don't understand cell z2 through z10 I have never had excel (4kxz2xz10) Please write this correctly
  8. Excel

    I have my employee schedule in a excel sheet. It is a weekly schedule that doesn't change week by week, but changes day by day within a week. Every Monday, Tuesday, etc. is the same schedule. In the file are days for Monday, Tuesday, …
  9. EXCEL 2010 (again)

    I am not allowed to use the AutoSum or AVERAGE functions to work out this problem. I need to find the average of a cell range. C3:C9 contains numbers (one cell contains zeros) the range adds up to 230. To find the average I need to …
  10. Math - Excel

    Hi, I need to write an Excel formula and I am trying to double check my work. We are asked to find the difference and relative difference for this account. So the values are: $10,000 $10,700 $11,400 $12,100 $12,800 $13,500 etc. The …

More Similar Questions

Post a New Question