Answer to the question in excel provided template

 

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)
Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more