Purchase Solution

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

Not what you're looking for?

Ask Custom Question

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.)

Attachments
Purchase this Solution
Solution Summary

You will find the answer to this puzzling question inside.

Purchase this Solution
Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Mortgages and Amortization

    a home loan is made for $165,000 at 6% annual interest, compounded monthly, for 30 years, What is the montly payment on this loan?

  • Inequalities Word Problem - Compare financing a car for 0% financing for 60 months or 2500 vs a 60 month 4 % interest rate.

    So each payment of the 0% loan is: x*16.67 each paymant for the 4% loan is (remember - you financed only x-2.5 in thousands): (x-2.5)*18.41 Both loans are for 60 months, thus we want the 4% loan montly payment to be less than the 0% montly

  • Credit Reports, Balances, and Scores

    What are the long term and short term effects of credit and debt? What are some ways you can manage personal debt? 1.

  • Working capital managements, financial planning, discounts, APR

    Also, if the company's needs for funds are seasonal or cyclical, it may not want to commit itself to long-term debt because prepayment penalties are generally built into long-term debt contracts. • Discuss the methods of short-term financing.

  • Home financing options

    378652 Home financing options For a home that is priced at $599,000.00 and a down payment of 20% $119,800. - Research 2 different financing options. 

  • Transaction Effects to Net Long-Term Financing (NLF)

    351234 Transaction Effects to Net Long-Term Financing (NLF) Indicate effect of following transactions on net long-term financing (NLF), working capital requirement (WCR), net short term financing (NSF), and net profit.

  • House purchase: compute settlement statement, amortization

    Borrowing remaining amount above down payment at a stated nominal loan rate of 6.5%. 30 year loan. I have to determine the total amount that I will need to borrow (everything but the down payment; do include origination fee as well.)

  • Leasing versus Buying

    You have the option of not making a down payment, you pay sales tax only on your monthly payments (in most states), and pay a money factor that is similar to the interest rate on a loan.

  • Creditworthiness

    426319 Personal financing: Calculate the total cost of a loan, use and abuse of credit Problem 1 Objectives: Calculate the total cost of a loan. Task: Respond to each of the scenarios below. Compute the answer showing your work.

  • Lease Vs Buy / Depreciation

    You have the option of not making a down payment, you pay sales tax only on your monthly payments (in most states), and pay a money factor that is similar to the interest rate on a loan.

View More Related Solutions