Purchase Solution

# Reducing monthly loan payment, affordability of a montly loan and financing a long-term loan

Not what you're looking for?

Instruction:

** Review the attached document **

- Recreate the last spreadsheet shown in the attached document.
- The formulas for the cells E10, E11, and E13 are shown in the last spreadsheet in the attached document.

Note:

- The PMT() function displays the Monthly Loan Payment amount as a negative value, not as a positive value as shown in the attached document, so you will need to use a negative \$1000 (-1000) as your target value for the following problem.

Problem:

-Once you have recreated the spreadsheet, use Excel's Goal Seek tool to answer the following three questions.
-What interest rate will reduce the monthly loan payment to \$1,000? (Make a note of the new value for the loan amount (cell E6). Undo the result of the goal-seeking analysis to return to the original values shown in the last spreadsheet in the attached document. Record the resulting value in cell B15.)
- What loan amount can you afford if you can only make a monthly loan payment of \$1,000? (Make a note of the new value for the loan amount (cell E6). Undo the result of the goal-seeking analysis to return to the original values shown in the last spreadsheet in the attached document. Record the resulting value in cell B16.)
- How many years would you have to finance the loan to make the monthly loan payment be \$1,000? (Record the resulting value in cell B17 and return the saved file.)

##### Solution Summary

You will find the answer to this puzzling question inside.

##### Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

##### IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

##### SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

##### Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.