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

Flow chart for qualitative analysis of cations - Health Care Delivery Systems Case 3 - Me and you barry louis polisar ukulele chords - Mccormicks road general practice - Research - Inova fairfax human resources contact information - Mabel state high school - Ex16_xl_ch04_grader_cap_as mountain view realty 1.6 - Oil red o stain protocol - Difference between isometric and oblique projection - Volcano goddess crossword clue - Dan murphy's crystal skull vodka - Terrorism and bitcoin - Young Nyana - Mark wainwright analytical centre - Phet colorado balloons and static electricity - Ceb applications leadership council - Management PowerPoint - Discussion - NTC/302: Network Web Services - Discussion W3 - 50 ml graduated cylinder significant figures - A golf club exerts an average force of - Price and channel strategy mkt 571 - Athletic shoe once endorsed by paula abdul - Week 2 Assignment - Thomas jefferson elementary middle school - Skyline art editions a commercial printing service provides craftsmen who - Good country people online - Fluid friction apparatus experiments - Australian stained glass supplies catalogue - Global Societal Problem, Argument and Solution - On july 31 2012 mexico company paid - Denotation connotation exercises key - Constitution Comparison Worksheet - Nursing care plan for epididymitis - Verbal and nonverbal communication and listening skills paper - Curtin uni census date - Customer relationship management strategy a teaching case study - Building shared services at rr communications case study - Gold coast city council office - Principles of marketing class activities - English - Create a Lesson Plan - Bill nye solar system - List and define the five components of physical fitness - Network security proposal paper - The revised bloom's taxonomy implications for educating nurses - Australian curriculum achievement standards chart - 3 common hazards in tim hortons - Why did myles and katharine weiss leave zola levitt ministries - Elevated irt no mutations - Holes human anatomy and physiology edition access code - Functional Training Discussion - Refer to the diagram for a purely competitive producer. if product price is p3: - Managing Healthcare Organization - Alphabet annual report 2016 pdf - Kidney shortage inspires a radical idea organ sales - Best buy strategy analysis - Ch3cl polar or nonpolar - Discuss the importance of conducting a thorough literature review as it relates to the research process. Use a reference from scholarly literature or your text to support your primary response - Cow calf operation layout - Jorge luis borges the gospel according to mark - Post mortem care nursing responsibilities - Crank and slider vex instructions - Evolution by natural selection worksheet answer key pdf - Which theme from macbeth do these lines support - Week 2: Discussion: Data Visualization Workflow - Four Key Stages - Rotex hot water australia - Assume that expected inflation is based on the following: πet = θπt-1. if θ = 0, we know that - MBA 599 - UNITEDHEALTH GROUP PROJECT - Engineering drawing numbering system - 340 week 2 Replies - Authorization letter for psa - Westwood one minute addition and subtraction test - 400 word blog project soc350 - Aerobic respiration differs from anaerobic respiration - Theo 530 final exam answers - Discussion Post- Due today 10:00om ET - Anne bradstreet the author to her book - Times are a changing - Sherlock holmes inductive reasoning - Worksop caravan centre ltd - Coulomb's law experiment lab report conclusion - Original jurisdiction refers to - Bared to you excerpt chapter 9 - 2 - How to draw activity on arrow network diagram - Business ethics concepts and cases by manuel velasquez pdf - Line managers and reward - Different ways to write - What is othellos rank - A lead-tin alloy of composition 30 wt - Vce chem study design - Emulsification of fats in the duodenum is assisted by: - The outdoor furniture corporation manufactures two products - Hrp substrate western blot - Half wave rectifier experiment readings - Plant and animal cells powerpoint 5th grade - 741c op amp multisim - Powerpoint inserts text to the _________________________ of the insertion point