1 answer

Good evening, everyone , may someone answer this engineering economics question on excel spreadsheet? Some years...

Question:

Good evening, everyone , may someone answer this engineering economics question on excel spreadsheet?

Some years ago, Penny purchased the car of her dreams for $25,000 by paying 20% down at purchase time and taking a $20,000, 5-year, 6% per year, compounded monthly loan with 60 monthly payments of $386.66 each. She is examining her loan situation and would like to have some specific information. Help her obtain the following:

a) ) Verification of the current monthly payment amount.

b) Total amount she will pay over the 5 years.

c) ) Total interest she will pay over the 5 years and the percentage this represents of the original loan amount of $20,000.

d) ) After she missed payment #36 at the very end of the third year, according to the loan agreement, the interest rate increased from 6% to 10% per year, compounded monthly. Based on the remaining principal immediately after the late payment, determine the new monthly payment. Verify that this increased amount is necessary to pay off the loan at the increased rate.

e) ) Penny is now in her fourth year, has paid the increased payment for 12 payments, and wants to get rid of this loan completely. She wishes to know the remaining principal amount when payment #48 is due. There is no penalty for early repayment of principal.


Answers

annys oan amount potcmyecs S/ tj @cn ( forr. a) vaiGra bon ơt the cuST ent monthly Payment 786.13 To calrulateKe payment alaac) Total intaest penn bil pay ti Total ntee peny ntage ths inteest »epm 그/1996( re ankage thic inte.ert xpnacants o the digcta e) ramarofng principl a the Pajmant Kematnirg prineifal amount pentyhay to pry a Geth payment ninci Ramainig Phireiount p

.

Similar Solved Questions

1 answer
Closing entries are Multiple Choice Mode to record events that occurred during the period but have...
Closing entries are Multiple Choice Mode to record events that occurred during the period but have not yet been recorded O Made to transfer the balances of temporary accounts to retained earnings. O Made to transfer the balances of permanent accounts to retained earnings. O Optional O...
1 answer
Dr smith feels its appropriate to bill for inpatient service on the same day and dr...
dr smith feels its appropriate to bill for inpatient service on the same day and dr jones feels hw should be able to bill for inpatient servicws in the same day bwcsuse he performed the surgery who is correct and why...
1 answer
X X X X X X X X t-0.70 S X X X X X X...
X X X X X X X X t-0.70 S X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X Flux (T m^2) Magnetic flux as a function of time (s) i 2 3 4 5 6 8 9 10 11 12 (A) Induced current as a function of time (s) 2 3 4 5 6 8 9 10 11 12 Play Pause <...
1 answer
In a particular metal, the K-shell has an energy of -(24.0+A) keV, while the L-shell has...
In a particular metal, the K-shell has an energy of -(24.0+A) keV, while the L-shell has an energy of –(2.50+B) keV. Find the wavelength of the Ka (alpha) characteristic x-ray for this metal. Give your answer in picometers (pm)and with 3 significant figures. A: 1 B: 4 In the Bohr model for hyd...
1 answer
2. The table below relates to the labor force classification of a particular country. Use the...
2. The table below relates to the labor force classification of a particular country. Use the information to answer the questions that follows. Full-time employed 56 million Part-time employed 22 million Unemployed 12 million Not in the Labor Force 30 million Calculate the following: a. Labor Force ...
1 answer
What will happen if Canada’s Tax Rate grows higher than T*?
What will happen if Canada’s Tax Rate grows higher than T*?...
1 answer
Which of the following best approximates the frequency of the waveform shown in the figure below?...
Which of the following best approximates the frequency of the waveform shown in the figure below? 一 -1 Time (s) A plot of the displacement of an oscillating mass, attached to a spring as a function of time. 0.2 Hz 0.5 Hz O 1 Hz ● 2Hz 5 Hz...
1 answer
. What are the main transcription factors which are downstream of LAT?
. What are the main transcription factors which are downstream of LAT?...
1 answer
Personal After-Tax Yield Corporate bonds issued by Johnson Corporation currently yield 12%. Municipal bonds of equal...
Personal After-Tax Yield Corporate bonds issued by Johnson Corporation currently yield 12%. Municipal bonds of equal risk currently yield 6%. At what tax rate would an investor be indifferent between these two bonds? Round your answer to two decimal places. % Corporate After-Tax Yield The Shrieves C...
1 answer
Waldeplass of the hip, the nurse would for developmental dy 20. When for de to when...
Waldeplass of the hip, the nurse would for developmental dy 20. When for de to when she w Symmetrical gluteal folds Symmetrical leg length Ortolana elkar Characteristic mp kly to note which of the hosis, the nurse 27. While assessing a child with pylon following Regurgitation Steatorhea Projectile v...
1 answer
Please do it as early as possible. thank you Part 2. Drafting Letter Read the following...
please do it as early as possible. thank you Part 2. Drafting Letter Read the following onse study carefully, and develop a document as required. Plan the content according to the principles covered in in the course (c.g., main idea first). Draft your document and proofread the text in detail. Give...
1 answer
Question 1 (15 marks) Suppose that in a group of 100 boys and 100 girls there is a boy B, such th...
please answer all parts i give you good feedback Question 1 (15 marks) Suppose that in a group of 100 boys and 100 girls there is a boy B, such that B is second highest on every woman's preference list.Is possible that, in every stable matching, B ends up with the girl he likes le ast of all? If...
1 answer
Please answer both of the following questions: QUESTION 11 Which of the following is always TRUE...
Please answer both of the following questions: QUESTION 11 Which of the following is always TRUE for a perfectly competitive firm? O P = d = AVC O P= d = MR O MC = MR = AVC O AVC = ATC = P QUESTION 12 Suppose a perfectly competitive ukulele factory can produce 35 ukuleles at an output at which marg...
1 answer
Programming Project 3 See Dropbox for due date Project Outcomes: Develop a Java program that uses:...
Programming Project 3 See Dropbox for due date Project Outcomes: Develop a Java program that uses: Exception handling File Processing(text) Regular Expressions Prep Readings: Absolute Java, chapters 1 - 9 and Regular Expression in Java Project Overview: Create a Java program that allows a user to pi...
1 answer
Question Help Claim: Most adults would erase all of their personal information online if they could....
Question Help Claim: Most adults would erase all of their personal information online if they could. A software firm survey of 586 randomly selected adults showed that 57% of them would erase all of their personal information online if they could. Find the value of the test statistic The value of th...
1 answer
When chloroplasts are crushed and a suspension is made, they do not produce G3P even with...
When chloroplasts are crushed and a suspension is made, they do not produce G3P even with enough CO2 and H2O. Explain in detail please....
1 answer
(6) A ball is thrown directly upward from a height of 11 feet with an initial...
(6) A ball is thrown directly upward from a height of 11 feet with an initial velocity of 192 ft/s.The function (1) =-161° +1921 +11 gives the height of the ball in feet, 7 seconds after it has been thrown. Determine the time at which the ball reaches the maximum height and find the maximum heig...
1 answer
Please note when you see more then X it means I need more then one code,...
please note when you see more then X it means I need more then one code, IF YOU KNOW HOW TO FIND IT PLEASE ANSWER .       Emergency Department Note This 26-year-old pregnant female presented to the emergency department. At the time of admission she was experiencing crampy abdomin...
1 answer
Equals and Copy method activity Implement a Dog class with the following features: + Attributes: ...
Java Equals and Copy method activity Implement a Dog class with the following features: + Attributes: age, gender, weight + Method: constructor, copy constructor, equals (if same weight and gender), toString + A main method/driver that create an array of 5 Dog objects (obtain input from user), and t...