1. Exercise One: Jessica decides to take a $25,000 to help her cover her tuition expenses.The tenor of the loan is 10 years, and the interest rate is 6.75%. Repayments will bemade on a monthly frequency. Based on the aforementioned information, and thematerial covered in class, (a) use the PMT function in Excel to find the fixed totalpayment, (b) verify your answer from (a) by programming the present value annuityformula as shown in class, (c) create an amortization schedule for this loan, (d) create abar chart showing the Fixed Total Payment, Interest Paid, and Principal Paid.

The syntax of the PMT function is: PMT (rate, nper, pv) Where rate is the interest rate. Here it…

Answered: he loan is 10 y onthly frequen

Business

Finance

he loan is 10 y onthly frequen

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 1E

See similar textbooks

Similar questions

Angela's bank gave her a 2-year add-on interest loan for $6,120 to pay for new equipment for her antiques restoration business. The annual interest rate is 8.28%. How much interest will she pay? What are her monthly payments? Question content area bottom Part 1 She will pay $enter your response here in interest on the loan. (Round to the nearest cent.) Part 2 Her monthly payments are $enter your response here. (Round to the nearest cent.)
THE PICTURE IS THE EXCEL TEMPLATE YOU MUST FILL OUT Suppose that you borrowed $25,000 student loans from Sallie Mae to attend UM - Dearborn. Once you graduate, you are required to start paying your loan and interest. The APR for your loan is 5.54%. Each month you will have to make interest payment and principal repayment. Suppose that you can choose the following two repayment plans: Standard repayment plan: if you choose this plan, you will have to pay off your loan in 10 years with the same amount of payment each month. Fixed extended repayment plan: if you choose this plan, you will be allowed to pay off your loan in 25 years with the same amount of payment each month. 1. Please use Excel to work on the following questions: How much should you pay each month for these two plans? • Set up the loan amortization tables for these two plans. How much interest will you pay in total when you pay off your loan for these two plans? • Amortization Schedule for your Student Loan (Standard…
a)Upon entering college, you purchase the car of your dreams for $26000. You pay $5200 down and finance the balance for 4 years at 7% compounded monthly. Your monthly payments are $498.09. Set up the spreadsheet to display the outstanding balance for each month for 4 years. As a checkpoint, you should get $16931.98 just after your 10th payment. How much is still owed on the loan just after 30 payments.$ Find the size of the last payment. $ How much interest in total did you spend on the car? $ (b) If you decided to get a 3 year loan instead of a 4 year loan the payments will be $642.25. What will be the total saving in interest from getting a three year loan instead of a 4 year loan?(Note: you do not need a spreadsheet to answer this question.) $ (c) If you decided to get a 5 year loan, the payments will be $411.87. Determine the total amount of interest that will be paid on a 5 year loan $
After completing a bachelors degree, you have $15,000.00 in student loans to pay back at an interest rate of 2.25% for 6 years. Follow the steps to show work used to calculate the monthly payment on this loan. Enter the values needed for the LEFT and RIGHT sides of the amortization formula. LOOK AT YOUR FORMULA SHEET. Be sure to use parentheses as shown in class and * to show multiplication: LHS: RHS: pymt. Hint Hint Now simplify the expressions from above and enter the final values for both sides below, keeping at least 6 decimal places: = pymt. Finish your calculation of the payment and enter your result, rounded to the nearest penny, in the table below. Then use the information to complete missing values in the table. SEE THE VIDEO BELOW IF YOU NEED HELP WITH THE TABLE (Round to the nearest cent) Month Monthly Payment Interest on Prior Balance Principle Outstanding Balance 1 2 3 Question Help: Video
Consider a student loan of $10,000 at a fixed APR of 6% for 4 years. a. Calculate the monthly payment. b. Determine the total amount paid over the term of the loan. c. Of the total amount paid, what percentage is paid toward the principal and what percentage is paid for interest. a. The monthly payment is $. (Do not round until the final answer. Then round to the nearest cent as needed.)
For TVM calculator: Write each known variable’s value as it appears in the calculator and use a question mark for the missing variable. Then, in the space provided write the missing variable’s value, as it appears in the calculator. Finally, write your final answer in context, with units, as a complete sentence. Patricia deposits $1,000 into an account that earns 4.9% compounded monthly and plans to make monthly payments of $170 into the account. How long must she invest until she has $35,000? N=? I= 4.9 PV=1,000 PMT=170 FV= 35,000 P/Y=12 C/Y=12 Missing Variable Value __________________ Context Sentence:
For TVM calculator: Write each known variable’s value as it appears in the calculator and use a question mark for the missing variable. Then, in the space provided write the missing variable’s value, as it appears in the calculator. Finally, write your final answer in context, with units, as a complete sentence. Herman is looking to invest $5,000 in an account that earns 3.7% annual interest compounded semi-annually. If Herman plans to regularly deposit semi-annual payments of $1,575 into the account, how much is the account worth after 30 years? N=60 I= 3.7 PV=5000 PMT= 1575 FV= ? P/Y=2 C/Y=2 Missing Variable Value __________________ Context Sentence:
For the given student loan, find the interest that accrues in a 30-day month, then find the total amount of interest that will accrue before regular payments begin, again using 30-day months. $6400 at 7.9% interest; student graduates 3 years and 9 months after loan is acquired; payments deferred for 6 months after graduation. Part: 0 / 2 Part 1 of 2 The interest that accrues in a 30-day month is $ places, if necessary. Round to two decimal X oo → K
After starting your full-time job out of college, you decide to buy a new car for $85,000. Create a complete amortization table in excel for this car loan: You make 84 equal end-of-month payments. The discount rate is 6.5 percent compounded quarterly. How much would you owe after the 75 th payment? Please show both regualr and formula format of the spreadsheet.
2. Say you purchase a computer for $1300 at 7% interest and want to have it paid off in 48 months. Use the simple interest formula. a) Calculate the monthly payment necessary to pay off the principal and the interest. b) Calculate the APR. Write out the formula first to show your work.
Suppose you borrow money from your parents for college tuition on January 1, 2019. Your parents require four annual payments of $30,000 each, with the first payment due on January 1, 2023. They are charging you 5% annual interest. What is the cost of college tuition? (Use spreadsheet software or a financial calculator to calculate your answer. Round intermediary calculations to two decimal places and round your final answer to the nearest dollar.) Question content area bottom Part 1 A$91,894 B.$111,697 C.$120,000 D.$88,475
Suppose you want to have $600,000 for retirement in 25 years. Your account earns 4% interest. How muc would you need to deposit in the account each month? Submit Question /course/showcalendar.php?cid=179278 Search