Recently you purchased a nice car for $52,000 on January 1, 2023. The dealer asked you...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Recently you purchased a nice car for $52,000 on January 1, 2023. The dealer asked you to pay $2000 down and offered you financing for the remaining. The condition of the financing was as follows: 1. Total period was 7 years. 2. Interest rate is 4.9% 3. Your payment should be at the end of each month. Required to calculate your monthly payments using the appropriate time value of money formula provided for you below. Do not use any other method such as Excel present value function as it would has zero value for this project. You must prepare the following schedule in Excel and fill in the numbers. Make sure DO NOT type the numbers and rather transfer the cells. #of Period in years # of period in months Interest rate per year Interest rate per month Principle of the loan Annuity (monthly payment) Time Value of Money Formulas: Please Note: again, for calculation of the Annuity, you must use the appropriate Time Value of Money Formula provided below: Schedule of Loan Amortization Fundamental Variables . . 7 . ? ? • Future Value of a single sum >> • Present Value of a single sum >> PV=FV (1+i). • ¡ - Interest rate per period (month) . n-Number of time periods (months) FV-Future value PV-Present value A - Annuity (mortgage) • • Future Value of an ordinary annuity >> Present Value of an ordinary annuity >> Present Value of an annuity due >> • • Present Value of perpetual Annuity >> FV= PV (1+i): FV₁. = A (((1+i)-1)/i)| PV = A((1-(1/(1+i):))/1)) PV = A (1+((1-1/(1+i)-¹)/1)) PVp.= A/i Schedule of payments Period 1/1/X1 1/30/X1 Total Payments Interest Principle ? Answer the following Questions: 1. Your total payment, including $2,000 down payments: 2. Your total payment excluding down payment: 3. Your total interest expense for the first year: 4. Your total interest Expense over a 7-year period: 5. Total cost of the car that you purchased: Balance $50,000 Recently you purchased a nice car for $52,000 on January 1, 2023. The dealer asked you to pay $2000 down and offered you financing for the remaining. The condition of the financing was as follows: 1. Total period was 7 years. 2. Interest rate is 4.9% 3. Your payment should be at the end of each month. Required to calculate your monthly payments using the appropriate time value of money formula provided for you below. Do not use any other method such as Excel present value function as it would has zero value for this project. You must prepare the following schedule in Excel and fill in the numbers. Make sure DO NOT type the numbers and rather transfer the cells. #of Period in years # of period in months Interest rate per year Interest rate per month Principle of the loan Annuity (monthly payment) Time Value of Money Formulas: Please Note: again, for calculation of the Annuity, you must use the appropriate Time Value of Money Formula provided below: Schedule of Loan Amortization Fundamental Variables . . 7 . ? ? • Future Value of a single sum >> • Present Value of a single sum >> PV=FV (1+i). • ¡ - Interest rate per period (month) . n-Number of time periods (months) FV-Future value PV-Present value A - Annuity (mortgage) • • Future Value of an ordinary annuity >> Present Value of an ordinary annuity >> Present Value of an annuity due >> • • Present Value of perpetual Annuity >> FV= PV (1+i): FV₁. = A (((1+i)-1)/i)| PV = A((1-(1/(1+i):))/1)) PV = A (1+((1-1/(1+i)-¹)/1)) PVp.= A/i Schedule of payments Period 1/1/X1 1/30/X1 Total Payments Interest Principle ? Answer the following Questions: 1. Your total payment, including $2,000 down payments: 2. Your total payment excluding down payment: 3. Your total interest expense for the first year: 4. Your total interest Expense over a 7-year period: 5. Total cost of the car that you purchased: Balance $50,000
Expert Answer:
Answer rating: 100% (QA)
Solution Here is the schedule of loan amortization with the calculat... View the full answer
Related Book For
Thomas Calculus Early Transcendentals
ISBN: 9780321884077
13th Edition
Authors: Joel R Hass, Christopher E Heil, Maurice D Weir
Posted Date:
Students also viewed these finance questions
-
Graph the equation f(x) = -4 by completing a table of values. 5 4 3 2 1 -5 -4 -3 -2 -] 1 2 3 4 -1 -2 -3 -4 -5- Clear All Draw:
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
A trainee in a medical lab will be released to work on her own when her results agree with those of an experienced worker at the 95% confidence level. Results for a blood urea nitrogen analysis are...
-
Using the most recent annual report of the company you have chosen to study and that you have accessed online at the company's website, examine the balance sheet and accompanying notes of your...
-
For this exercise, be careful to use only the definitions and not your intuitions that are familiar to you about the symbols \(\leq\) and \(
-
Politte Supply uses a sales journal, a purchases journal, a cash receipts journal, a cash disbursements journal, and a general journal. The following transactions occur in the month of April. Apr. 3...
-
Marie claims she can predict the sex of pregnant women's babies. She sees 1,000 women a year, and she always predicts a female. She charges $1,000 for a prediction, and she always predicts a female...
-
ABC Company adjusts its accounts at the end of each month. The following information is provided in order to prepare the adjusting entries at October 31: (1) A one-year bank loan of $360,000 at an...
-
Mr. John Manville owed Mr. Paul Glennon $10,000. John transferred his car worth $10,000. to satisfy the debt. Two months later John filed bankruptcy as an individual under Chapter 7. His total...
-
Try to make a comparison between new Online Payment Platform in Palestine: pay pal Jawwal Pay Meps you should compare services to individuals, business, banks, platform Component, advantages,...
-
A distillation column is separating \(100.0 \mathrm{kmol} / \mathrm{h}\) of a saturated vapor feed that is \(30.0 \mathrm{~mol} \%\) ethanol, \(25.0 \mathrm{~mol} \% \mathrm{i}\)-propanol, \(35.0...
-
Darting Around Company manufactures dartboards. Its standard cost information follows: Darting Around has the following actual results for the month of September: Required: Calculate the following...
-
Codys Collar Company makes custom leather pet collars. The company expects each collar to require 1.5 feet of leather and predicts leather will cost \($2.25\) per foot. Suppose Codys made 60 collars...
-
Write a program in the language of your choice, which takes an arbitrary function and table increment and writes a look-up table functional. The arbitrary function will have to be hard-coded into the...
-
Research the California Code of Civil Procedure Section 86, and list five types of cases that limited civil courts in California can hear. Your research can be completed by examining the California...
-
Editor Undo Clipboard Is Font Styles Ty Voice Should choose machine A as it has the lower equivalent annual cost. Question 2 The management of Tumble Manufacturing is considering replacing one of its...
-
Federated Shipping, a competing overnight delivery service, informs the customer in Problem 65 that they would ship the 5-pound package for $29.95 and the 20-pound package for $59.20. (A) If...
-
Use a theorem of Pappus to find the centroid of the given triangle. Use the fact that the volume of a cone of radius r and height h is V = 1/3 r 2 h. (0, 0) (a, c) (a, b)
-
The derivative of (x) = x 2 is zero at x = 0, but is not a constant function. Doesnt this contradict the corollary of the Mean Value Theorem that says that functions with zero derivatives are...
-
Use lHpitals rule to find the limit. lim xiln x x - 1 sin TTX
-
Identify organizations in your area that fit each business market category: producer, reseller, government, and institutional. Explain your classifications.
-
Barajas Printing Corp. uses a job order cost system. The following data summa- Prepare entries for manufacrize the operations related to the first quarter's production. turing costs. (SO 2, 3, 4. 5)...
-
Purchases by businesses may be described as new-task, modified rebuy, or straight rebuy. Categorize the following purchase decisions and explain your choices. a. Bob has purchased toothpicks from...
Study smarter with the SolutionInn App