Reducing monthly loan payment, affordability of a montly loan and financing a long-term loan
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.)
I need to understand how to figure out a word problem to compare financing a car for 0% financing for 60 months or 2500 vs a 60 month 4 % interest rate.
Payments at 0 % are 16.67 per 1000 and payments at 4 % are $18.41 per $1000 financed. Need to know how to find out the range of new car prices for which the cash back options
After visiting several automobile dealerships, Richard selects the used car he wants. He likes its $10,000 price,but financing through the dealer is no bargain. He has $2,000 cash for a down payment, so he needs an $8,000 loan. In shopping at several banks for an installment loan, he learns that most interest on automobile loans
They currently have a 30 yr loan with an 8% annual interest rate. the original loan was for $250,000 but over three years the Taylors have reduced the loan balance to $243,200. A local bank ha offeref them a 15 yr loan with a 6.5% annual interest rate. the bank will charge a 1% fee of $2,432 (0.01x$243,200=$2,432) to prepare
DISCOUNT RATE IS: 10%
1) Buy car for $35,000. If bank will lend $30,000 (10% discount rate), what will annual payments be? Make 1st payment at end of year and make 5th and final payment at end of 5th year. SHOW IN EXCEL WITH "PAYMENT" FUNCTION
2) If payments were monthly, instead of annual, what would monthly car paym
5. You have decided to purchase a home. Congratulations! The home is valued at $200,000 and you seek a mortgage in the amount of $150,000. If you can get a 6% mortgage for 30 years what would be your monthly payment (assume monthly compounding)? What is the formula for this question?
Here is the problem
Delta , LLC, currently net leases its headquarters office building for $70,000 per month, and this lease has two years left to run. (Under a commercial fully net lease, the tenant pays for all maintenance, repairs, insurance and property taxes.) Delta considers the rent to be less than the current market
On 10/1/05, Astros Co lends $350,000 to the company batting practice pitcher at an annual interst rate of 7.2%. This act of graciousness will allow the batting practice pitcher to purchase a new spring training condominium. Terms of the loan require the batting practice pitcher to repay Astros Co with two hundred (200) equal m
