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

#### Similar Solved Questions

##### 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...
##### 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...
##### 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 <...
##### 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...
##### 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 ...
##### What will happen if Canada’s Tax Rate grows higher than T*?
What will happen if Canada’s Tax Rate grows higher than T*?...
##### 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...
##### . What are the main transcription factors which are downstream of LAT?
. What are the main transcription factors which are downstream of LAT?...
##### 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...
##### 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...
##### 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...
##### 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...
##### 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...
##### 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...
##### 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...