Friday

April 18, 2014

April 18, 2014

Posted by **Angie** on Wednesday, September 12, 2012 at 3:22pm.

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, Access, Word - When you link a worksheet and a chart in a business report...

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

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

Data Analysis Excel - Why would you exchange information between Excel and some ...

Computer Applications - An Excel workbook can contain more than one workshet. ...

excel Buget - I am trying to get a formula for excel I have merchandis Amount ...

engineering physihcs - I need to create an Excel chart showing world oil ...

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