Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Answer to the question

18/10/2020 Client: felana45 Deadline: 2 Day

 


In our brief case study, we assume the Thomas and Jefferson families have identical mortgages (30-year term, fixed-rate 6% APR, and a loan amount of $175,000). The Thomas family will not pay extra but the Jeffersons will. Follow the steps below prior to your analysis.



  1. Using the Payment mini calculator of the Financial Toolboxes spreadsheet, calculate the mortgage payment (the same for both families). Do this on both the Thomas Financial ToolBoxes Sheet and the Jefferson Financial ToolBoxes sheet in cell C18. Do NOT type in cell C18. Fill in Cells C13 – C17 with the correct information. (15 points)

  2. Assume that the Thomas’s will make only the required mortgage payment. The Jeffersons, however, would like to pay off their loan early. They decide to make the equivalent of an extra payment each year by adding an extra 1/12 of the payment to the required amount. On the Jefferson Financial ToolBox sheet, in cell L5 find the amount that the Jeffersons will be paying extra (1/12*payment). In cell L6 find their new monthly payment with this extra amount. (10 points)

  3. The Thomas’s will take the full 30 years to pay off their loan, since they are making only the required payments. The Jefferson’s extra payment amount, on the other hand, will allow them to pay off their loan more rapidly. Use the Years mini financial calculator of the Jefferson Financial Toolbox spreadsheet to calculate the approximate number of years (nearest 10th) it would take the Jeffersons to pay off their loan in cell C18. Do NOT type in cell F10. Fill in Cells F5- F9 with the correct information. (15 points)

  4. For the Thomas Family: assume that they could afford to make the same extra payment as the Jeffersons, but instead they decide to put that money (#2 from above) into a  savings plan called an annuity.  Use the  Future  Value  mini  financial  calculator  of  the Thomas Financial Toolbox spreadsheet to calculate how much they will have in their savings plan at the end of 30 years at the various interest rates on the Analysis sheet. Your answers should be on the Analysis sheet. (15 points)

  5. For the Jefferson Family: assume that they save nothing until their loan is paid off, but then after their debt is paid, they start putting their full monthly payment and 1/12 (#2 from above) into a savings plan. The time in months they invest is equal to 360 months minus the number of years needed to pay off the loan (#3 from above) multiplied by 12. Use the Future Value mini financial calculator of the Jefferson Financial ToolBox sheet to calculate how much they will have in their savings plan at the various interest rates on the Analysis sheet. Your answers should be on the Analysis sheet. (15 points)


Questions (30 points):


You will answer these questions in the Textboxes on the Questions sheet in the Excel File. Scroll DOWN to see all of the textboxes.



  1. What generalizations can you make from the annuity amounts reflected in the analysis table above with regards to the different strategies taken by the families? That is, from a purely financial aspect of the calculations in your table what generalizations could you make regarding the two different strategies? (6 points)

  2. What assumptions may not necessarily be valid for a typical family regarding both the loan rate and savings plan rate? (6 points)

  3. Discuss some basic pros and cons to these two very different approaches the Thomas and Jefferson families made with their extra monthly payment. Consider various ideas such as possible changes in the family’s employment situation, market performance, tax deductions, etc. (6 points)

  4. Now that you have completed your analysis, comment on the merits of the advice you read from the two financial columnists. Note the dates of the advice columns. How might market performance figure into their advice they gave at that time? Why do you think Sharon Epperson’s advice at the end specifically calls attention to an assumption of whether you are “debt-free and maxing out your 401(k) and IRAs?” (6 points)

  5. If you were to pay extra principal on a mortgage, when is the best time to do it (early or later in the loan process) and why? (6 points)

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Essay Writing Help
University Coursework Help
Buy Coursework Help
Top Essay Tutor
Top Grade Essay
Top Writing Guru
Writer Writer Name Offer Chat
Essay Writing Help

ONLINE

Essay Writing Help

I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. I hold MBA (Strategic Management) (Finance and Marketing) & CPA.K (Accounting and Finance.)

$37 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$37 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$37 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$40 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

Working on this platform from a couple of time with exposure of dynamic writing skills gathered with years experience on different other websites.

$37 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$35 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Knowledge Gaps in Applying Evidence to Practice - Danny and sue puberty blues - Key to happiness rescue wi - Converting ng/dl to nmol/l - Grasslin time clock wiring diagram - Exercise a periodic inventory costing lo p - ?same-day 0833173182 MAKANYANE / NGWENYA ABORTION CLINIC // PILLS,,,, - Sample method statement for electrical works - Http crfb org stabilizethedebt - Their city used to be walled 7 little words - El parque de los adirondacks está en vermont. - Combinations and compositions of functions - Assignemnt-2 - Chapter 10 - Defining research with human subjects sbe id 491 - Mcwilliams wines v mcdonalds - The snake goddess sculpture belongs to which culture - For Essays Guru - - Fish tycoon 2 magic fish breeding chart pictures - Measuring the speed of light with a microwave oven - The magneto air gap is a precision measurement that's taken between the - Basic lessons in laboratory quality control bio rad pdf - Heat transfer over a flat plate - Standing soldiers kneeling slaves summary - Where is boxer eventually taken and what happens to him - How can eca webwatch be used as a resource - Apple and foxconn case study - 17th edition amendments free download - Describe gatsby the first time nick sees him - Griffith university admission requirements - Din rail panel board - Small essay - Nursing Information Management And Technology Discussion W3 - From the physics classroom's physics interactive worksheet answers - Young engineers australia national committee - Miller toy company manufactures a plastic swimming pool - How to determine which antacid is more effective - How to prove quadrilateral is a parallelogram - Model 2 color variations in moths in great britain answers - Brain and behavior garrett 3rd edition pdf - Determination of acetic acid content in vinegar - Type 1 diebetic - Love at 16 2004 - ASSIGNMENT4091420 - English essay - Starting out with visual basic 2012 - Cairns storm surge map - Osce physical exam checklist - Uncommon collegiate charter high school - Critical thinking game plan example - Choosemyplate gov myplate daily checklist input - Igrad credit card module - The saints and the roughnecks discussion questions - East leake academy uniform - Tesla stakeholders - Home depot debt to equity ratio - Pka on titration curve - Golf club catering tenders - Adja hair braiding lagrange ga - Capital resources used to make a car - Problemas con la calefaccion answers - Prince of prussia hotel - What is group think - African american odyssey 6th edition pdf - Atpl flight planning exam tips - Discussion - Uwa harvard style referencing - PICO and Literature Search - Managerial Finance Research Assignment - John scofield en route - George frisbie hoar on the chinese exclusion act answers - Nat helps to preserve ipv4 address space. true or false? - 978 1506362311 - 10 to the power of 4 - Murder in a nutshell the frances glessner lee story - How to use inside caliper - Edubooks.ametsoc.org - Promega annealing temperature calculator - Scriptural references to kinetic energy - What is the second thinksafe step - Act 5 scene 1 romeo and juliet - Electric field due to charged sphere - Karen millen south wharf - When should a defibrillator be attached to the casualty - Vaccines - How did nicholas gereffi died - Hand hygiene australia login - Sociocentric thinking definition - Longest book in the bible - Nutrition and hydration chapter 8 - 1.18 forces of nature post test - Jasper m 2003 beginning reflective practice cheltenham nelson thorn - Cp 1 cp tester course manual - The last dance encountering death and dying 9th edition pdf - Hyperbole in the lion the witch and the wardrobe - Risk assessment on Acme Enterprise - Peter lehmann princess moscato - Case analysis - What are seven consequences of inaccurate coding and incorrect billing - Like many renaissance composers josquin wrote two kinds of music