Thursday

April 17, 2014

April 17, 2014

Posted by **Angie** on Friday, September 7, 2012 at 2:32pm.

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.

**Related Questions**

math using excel - how do i use excel to plot a graph then find x from the slope...

MS Office Suite - I am familiar with Excel 2007. I just got the news that I will...

Excel & Math - I'm not sure what two excel functions to use that will give the ...

managerial economics - my cubic equation is O=C+aL+bL^2+cL3 how can i get the ...

Excel, Access, Word - When you link a worksheet and a chart in a business report...

Excel - The use of excel Excel is a very necessary tool for all businesses in ...

ecxel unit - Ms.Sue can you help me by explaining and telling the answeres. i ...

Data Analysis - You are a District sales manager and you are overloaded with ...

Excel - I have to create a payroll document for class using Excel and I am quite...

Excel - Want to create a worksheet that will help track your grades and. What ...