You have an outstanding student loan with required payments of $500 per month for the next 4 years. The interest rate on the loan is 9.0% 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 $500, or $700 in total each month. How long will it take you to pay off the loan? (Note: Be careful not to round any intermediate steps less than six decimal places.) You can pay off the loan in months. (Round to two decimal places.)

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 have an outstanding student loan with required payments of $600 per month for the next four…

A: PMT 1 = $600NPER 1 = 4 years or 4*12 = 48 monthsPMT 2 = $800Interest rate = 9% compounded monthly…

Q: Because you study at AUIS when you graduate, we expect you to earn $150 more a month than another…

A: Here, Earning per Month is $150 Annual Interest Rate (r) is 10% Compounding Period (m) is Semi…

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: are forecasting the amount of plane tickets. Based on your study, it is likely that airplane tickets…

A: The price of tickets increases with time and money required today would be the present value of…

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: After carefully going over your budget, you have determined you can afford to pay $854 per month…

A: Present Value of Ordinary Annuity refers to the concept which gives out the discounted or today's…

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 have some extra cash this month and you are considering putting it toward your car loan. Your…

A: Loan amount refers to the amount borrowed by the borrower from the lender at a specified rate of…

Q: If you deposit $300 at the end of every month in a savings account that pays a nominal APR of 5% per…

A: Compounding refers to phenomenon of calculating interest where interest is added to the principal…

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: You want to purchase a new car in 6 years and expect the car to cost $37,000. Your bank offers a…

A: The Future Value of an Ordinary Annuity refers to the concept which gives out the compounded or…

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: 3. Need help with finance homework. Assume a discount rate of 6.75%. You are planning to receive…

A: Discount rate (r) = 0.0675 Period (n) = 6 Years First payment (C) = $12,000 Growth rate (g) = 0.022…

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: You estimate that you will have $30,000 in student loans by the time you graduate. The interest rate…

A: Amount of the student loan =$30000The interest rate compounded monthly =5%Number of years of loan…

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: Suppose you have a student loan of ​$50,000 with an APR of 6​% for 30 years.   a. What are your…

A: Here,Loan Amount is $50,000APR is 6%Time Period is 30 years

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: To save up for your dream business, you committed to deposit P2,000, starting today, every month in…

A: Present value (PV)= P2,000 Interest rate (r)= 6% Number of period (n)= 5 Future value (FV)

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 would like to save for a car. You would like to have $20,000 saved in 5 years. You decide to…

A: Recurring deposit is an annuity where same amount is deposited with an institution over cardinal…

Q: Assume you graduate from university with a $40,000 student loan. If your interest rate is fixed at…

A: The present value of monthly payments over a 20-year period should be equal to the amount of the…

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: A student looking at a student loan of a size of $10,000, an interest rate of 9%, and a monthly…

A: A loan indicates a sum borrowed. To repay the loan, the borrower would pay the principal amount…

Q: ou need to take out a loan of $35,000 to start up your T-shirt business. You have two possibilities:…

A: Loans are paid by the equal monthly payments and these are fixed payments that carry the payment for…

Q: You decide that you need $47,000 in 3 years to make a down payment on a house. You plan to make…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

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

Cost of Credit

The cost of credit is an extra amount that the borrower has to pay besides the loan amount. These credit charges may vary from loan to loan. The cost of credit includes interest charges, maintenance charges, and arrangement charges. Some of the costs are mandatorily collected by the lender based on the loan amount and tenure of the loan. The cost of credit is also called finance charges of the credit.