After graduation, you decide that you can pay $203.24 per month extra on your student loan ( standard monthly payment is 302.99), which has a balance of $50,000 and 20 years of monthly payments remaining. The annual interest rate on the loan is 4% How many years early will you be able to pay off the loan? Please answer in excel.

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 receive a 10-year subsidized student loan of $22,000 at an annual interest rate of 4.3%. What…

A: Using excel PMT function to calculate monthly payment.

Q: One year ago, your company purchased a machine used in manufacturing for $115,000. You have learned…

A: Net present value is the difference between the present value of cash inflows and present value of…

Q: f. To help you reach your $1,000 goal, your father offers to give you $400 in one year. You will get…

A: The future value of an amount is the value of the investment after certain time period when invested…

Q: Can you please help me work out this problem in detail?   Tony Ring wants to attend Northeast…

A: We need to use the concept of time value of money to solve the question. According to the concept of…

Q: Suppose you are starting a PhD program. The university has agreed to waive your tuition, cover all…

A: The objective of this question is to calculate the future value of a series of monthly deposits of…

Q: On january 1, 2010, you put 1000.00 in a savings account that pays 6(1)/(4)% interest, and you will…

A: The time value of money is a concept in finance that evaluates the worth of cash flows at any given…

Q: y, you graduated from high school. You are planning to go to UH starting 2 years from now after…

A: Amount required today will be the present value of future amount to be paid later based on the time…

Q: Stafford loans are the most popular formof student loan in the United States. The current interest…

A: A theory that helps to compute the present or future value of the cash flows is term as the TVM…

Q: Suppose you borrow money from your parents for college tuition on January​ 1, 2019. Your parents…

A: The cost of college tuition fees would be equal to the present value of all future payments.

Q: You plan to start grad school in 5 years (at the end of year 5) and will graduate 3 years after you…

A: There are two types of basic annuities, i.e., ordinary annuity and annuity due. An ordinary annuity…

Q: Assume the total cost of a university education will be $90,000 when your child enters university in…

A: Compound = Monthly = 12Future Value = fv = $90,000Time = t = 6 * 12 = 72Present Value = pv = $55,000

Q: Starting next year, you will need $5,000 annually for 4 years to complete your education. (One year…

A: An annuity is a method of fulfilling a financial goal for a specified period of time at a defined…

Q: Your uncle has said that if you agree to finish college he will give you equal payments of $3,500 at…

A: Present value is an estimate of the present value of future cash values ​​that may be received at a…

Q: After graduating from college and securing your first job in your field of study, you need to…

A: Car price = $92,500Down payment = 2%The amount of loan is

Q: A student graduates from college with 48000 in student loans with a 5.5% annual simple interest…

A: In the given question we require to calculate the amount of loan due after the first payment.…

Q: You estimate a college education will be $300,000 when your child enters college in 18 years. You…

A: The question is based on the calculation of required rate of return in future value of money…

Q: After starting your full - time job out of college, you decide to buy a new car for $85,000. Create…

A: Car cost = $85,000Number of payments = 84Discount rate = 6.5%To find: Amount owed after the 75th…

Q: A financial planning service offers a college savings program. The plan calls for you to make six…

A: The question is related to Return on Investment. The ROI is calculated with the help of following…

Q: A student graduates from college with $31,000 in student loans with a 5.6% annual simple interest…

A: Solution:- When an amount is borrowed, it can either be repaid as a lump sum payment or in equal…

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)Upon entering college, you purchase the car of your dreams for $26000. You pay $5200 down and…

A: Car value = $26,000Down payment = $5,200Finance value = $20,800Loan tenure = 4 years or 48…

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: When you graduate from college, you apply for and are offered a job that pays $1,900 per month. You…

A: Front end debt to income ratio shows the portion of net income before tax which is used to cover…

Q: After completing a bachelors degree, you have $15,000.00 in student loans to pay back at an interest…

A: Calculating the Monthly Payment on a Student LoanWe can calculate the monthly payment on the student…

Q: finish your engineering degree with $17,350 in student loans.  The interest rate on your loans is…

A: Loans are paid the monthly payments and these monthly payments are equal and fixed and these carry…

Q: Your parents are giving you $100 a month for four years while you are in college. At a 6% annual…

A: The objective of this question is to calculate the present value of a series of future payments,…

Q: Create an Amortization schedule-see amortization video. How much student debt will I bear by the…

A: The Loan amortization refers to the systematic equal payment of loan and interest spread over a…