You have an outstanding student loan with required payments of $600 per month for the next four years. The interest rate on the loan is 9% APR​ (compounded monthly). Now that you realize your best investment is to prepay your student​ loan, you decide to prepay as much as you can each month. Looking at your​ budget, you can afford to pay an extra $200 a month in addition to your required monthly payments of $600​, or $800 in total each month. How long will it take you to pay off the​ loan? ​

Q: THE PICTURE IS THE EXCEL TEMPLATE YOU MUST FILL OUT Suppose that you borrowed $25,000 student loans…

A: Mortgage amortization:Mortgage amortization is a systematic financial process where a home loan is…

Q: You need to borrow $10,000 for six months. Interest rates are expected to drop from 7% to 5.5%…

A: Given values: Borrow amount = $ 10000 Time period = 6 months Interest rates drop from 7 to 5.5 %

Q: You are ready to buy a house and you have $75,000 for a down payment and closing costs. Closing…

A: Here, Amount for Down Payment and Closing Cost is $75,000 Closing Cost id 4.5% of Loan Value Annual…

Q: You have an outstanding student loan with required payments of $600 per month for the next 4 years.…

A: A loan refers to a contract between two parties where one party borrows money from the other party…

Q: You would like to save for a car. You would like to have $20,000 saved in 4 years. You decide to…

A: Future value required (FV) = $ 20,000 Annual interest rate = 6% Monthly interest rate (r) = 6%/12 =…

Q: How much must you put away at the end of each year

A: An Annuity is a series of payments of fixed amounts and at fixed intervals. These can be of two…

Q: Upstate University charges ​$15,000 a year in graduate tuition. Tuition rates are growing at 3.5​%…

A: Expected graduate tuition in 6 years = Current Charges * (1+growthrate)^no. of years  Where, current…

Q: ou have secured a loan from your bank for two years to build your home. The terms of the loan are…

A: Working Note #1 Calculation of loan amount after 2 year period: Loan amount after 2 year period=…

Q: A young married couple has carefully looked at their budget. After review, they can afford a monthly…

A: Present value of annuity.PV = A * wherePV = present value of annuity.A = periodic paymentsr =…

Q: You have a student loan of 40,000$ that you want to repay in 10 years. Interest rates are at 6% per…

A: Since an amount is paid annually over the loan period, it is a type of annuity. The present value of…

Q: You are considering two ways of financing a spring break vacation. You could put it on your credit…

A: Given: Particulars Rate Credit card rate 14.000% Interest rate 10.00%

Q: A new furniture set costs $ 2800. If you make a down payment of $ 300 and finance the rest at a rate…

A: Furniture cost = $2800 Down payment = $300 Loan amount (P) = $2800 - $300 = $2500 Monthly interest…

Q: You have some extra cash this month and you are considering putting it toward your car loan. Your…

A: The objective of this question is to determine how much time will be reduced from the car loan if an…

Q: A student looking at a student loan of a size of $10,000, an interest rate of 9%, and a monthly…

A: Loan: It represents the amount borrowed by the borrower from the lender. The borrower makes…

Q: Derek would like to save for a down payment on the purchase of a new SUV in 24 months. The targeted…

A: Down payment = $15,000Monthly interest rate = 0.875%Number of months = 24 months

Q: You look at your budget and decide that you can afford $290 per month for a car. What is the maximum…

A: Annuity payment (P) = $290 Monthly interest rate ( r ) = 0.25% (3%/12) Number of Periods (n) = 60…

Q: A young married couple has carefully looked at their budget. After review, they can afford a monthly…

A: A loan is repaid through fixed periodic payments (usually monthly).The value or the amount of loan…

Q: You have some extra cash this month and you are considering putting it toward your car loan. Your…

A: The objective of this question is to determine how much time will be reduced from the loan term if…

Q: You look at your budget and decide that you can afford $260 per month for a car. What is the maximum…

A: Compound = monthly = 12Monthly Payment = p = $260Interest Rate = r = 5 / 12%Time = t = 7 * 12 = 84

Q: You have some extra cash this month and you are considering putting it toward your car loan. Your…

A: The objective of this question is to determine how much time will be reduced from the loan term if…

Q: You are saving to buy a new car in two years.  You currently have $5000 in an account that pays 4%…

A: The FV of an investment refers to the combined worth of the cash flows of the investment at a…

Q: You have an outstanding student loan with required payments of $550 per month for the next 4 years.…

A: We need to first calculate total loan outstanding today by using PV function in excel, Thereafter…

Q: How much will you have saved at the end of 6 years? Find the interest.

A: A stream of equal cash flows paid or received periodically is termed as annuity. Annuity is either…

Q: You have some extra cash this month and you are considering putting it toward your car loan. Your…

A: Loans are financial arrangements in which a lender provides money, goods, or services to a borrower…

Q: You expect to enroll in a four-year medical school six years from today, and you are planning…

A:

Q: If you borrow $24398 with an annual rate of 9% compounded monthly and make a payment of $282 every…

A: Here we will use the concept of time value of money. As per the concept of time value of money the…

Q: You have a long-term goal of paying off your school loans in five years. You will graduate with a…

A:

Q: Suppose you are getting a loan from a bank to purchase a feed business. The interest rate on the…

A: The objective of the question is to calculate the annual payment for a loan of $1,000,000 at an…

Q: It is likely that plane tickets will increase 6.5% in each of the next three years. The cost of the…

A: The present value of the future money required considering the interest rate and period of the money…

Q: You are considering two ways of financing a spring break vacation. You could put it on your credit​…

A: The objective of the question is to determine which financing option has the lower interest rate.…

Q: A new furniture set costs $ 2100. If you make a down payment of $ 300 and finance the rest at a rate…

A: In this question the monthly payment is to be find for the loan. Loan can be calculated by deducting…

Q: Suppose you get paid every two weeks. You determine that you can afford to divert $80 from each…

A: We will use the concept of time value of money here. As per the concept of time value of money the…

Q: Beginning three months from now, you want to be able to withdraw $2,500 each quarter from your bank…

A: Data given: pmt= $2500 (each quarter) n=4 years nper=4 years *4=16 rate=0.5% (per quarter)…

Q: You are considering two ways of financing a spring break vacation. You could put it on your credit…

A: The modified rate of return for compounding interest into actual terms of time is called the…

Q: You invest $5 daily into an account earning 6% compounded daily. How much will be in the account…

A: FV stands for future value which is the concept that allocates the value to the asset grounded on…

Q: You want to be able to travel and your yearlong trip. During your trip your travel fund will earn…

A: A fund is a collection of money set aside for a specific purpose. A fund can be created for a…

Q: Suppose Bill purchases a car and he is going to finance $12,000 for 24 months at an APR of 5.1%…

A: compound = monthly = 12 Present Value = pv = $12,000 Time = t = 24  Interest rate = 5.1 / 12 =…

Q: You look at your budget and decide that you can afford $280 per month for a car. What is the maximum…

A: Maximum loan amount is calculated by present value of maximum monthly payments that the individual…